Place the Google Sheet Chart onto Appsheet app

For those who may add more fravour to your appsheet app with chart image.

Set up is super simple.

Basically, create the chart as usual in your google sheet and publish chart as Image. Get the public URL link to it.

Go to appsheet and create VC (Virtual Column) and push that URL and save as image type.

That s it, dead simple.

Seems we are able to publish Google sheet chart as interactive HTML site, meaning once Appsheet iframe view come and play, we are able to place interactive chart rather than static image chart. Should be a fun.

10 Likes

Hi @tsuji_koichi yes that’s cool.
We could use it also for PDF Reports, without the need of SNAPSHOT() function.

But as I remember you will have to click on REFRESH in Google Sheets, if there was any change.
Meaning: The image does not represent the latest data.

There are integrations for Zapier and Integromat to update the Chart. But this is working only with Google Slides…

1 Like

@Fabian is correct. It’s not updating dynamically.

2 Likes

Yeah, seems to be image cache and its intervals.

1 Like

Now all the stuffs are working on Google Platform, largely to say under Google Business Application Platform! Appreciate if you could have few words to new colleagues from Google to make this integartion happen! thank you, Aleksi.

1 Like

I am sharing a workaround to be able to get updated image google-sheet-chart in Appsheet, result is as below picture, data was updated through Appsheet and in about 5 minutes or so (after sync) the chart-image get updated:

I’ve tested using my device and also in the editor.

To see a live update of the chart, a link is being provided which will get an instant update. In browser, when click the hyperlink it will show something like this:

Test the-link-here.

This workaround is with following steps of changing the URL:

  1. For the embeded image-chart: need to add to the URL of the published chart image with
    image&update=&NOW(), sample as below:
"https://docs.google.com/spreadsheets/d/e/2PACX-1vSaTE8IT7Z4bj_8FhrgSX5CpKruu-Qzln5_PLOQBHC7LateshFRJB4f_7Z-S70_wtO7hZzI0Jxc0rJX/pubchart?oid=1933246888&format=image&update="&NOW()
  1. For the hyperlink, adjusting based on a Medium-post:
Step 2.1. Copy the chart and move to a new dedicated sheet
Step 2.2. Following the Medium-post, Change the "edit#" with "htmlembed/sheet?"

So the final upadated URL will be as sample below:

"https://docs.google.com/spreadsheets/d/1B3cx1d5VI-Yf4npuDyUnbNXGmpp85XSF1codvTY9IxA/htmlembed/sheet?gid=2105918318"

as shown with the above.

5 Likes

Hi @Heru

Thank you for sharing the tricks.

Yes, I referer to read the same Medium post, but could not find a way to refresh instantly.
Passing additional params of &update=&NOW() at the end of url could do the magics, which I didnt know!

Thanks you for sharing again.

I will test with my sample app.

Currently only able to place static image as chart to Appsheet. Your trick to place url link to open the chart will browser will give the richer experieces with chart, as they are “interactive” chart. Hopefully, new Appsheet iframe will be capable of handling such URL to embed interactive chart inside appsheet. :grinning:

1 Like

People in other community for no-code app platform seems to be talking about the same stuffs…

But their dev is promising they will do introduce some tricks to update chart “automatically”. Why not with Appsheet?

Not sure what sort of tricks or mechanisum they are introducing, but kinds of “aggressive cache”? just igonre the default cache and refresh the source data real-time?

@TDhers

Any thought, master?

1 Like

It seems they are doing “something”, at least in the formal document they have “guarantee” every hour of image chart update.

2 Likes

Appsheet auto update every 30 mins.
Google Sheet published Chart URL seems to refresh cache once every 5 mins. based on that, appsheet view with google chart will be freshed every 30 min without explicitly syncing app?

I will test and see…

But all the problems could be solved all at once by Appsheet iframe?

1 Like

Testing result was almost as expected.

  • Open the app.
  • Change the data directly on the spreadsheet, assuming other app user update the existing rows
  • At this point of time, nothing happen.
  • Wait for 30 mins, leaving app opened on browser.
  • Data was update by Auto Refresh of Appsheet.
  • The Google Chart image was also updated.

But still not realtime update. :cry:

2 Likes

Yes, I have tested this also with handphone, the Google chart image was also updating without refreshing the app. If we press the sync, it will update in 5 minutes, and sometime less than that.

I believed that the real-time update is through iframing of the “htmlembed” as above.

I wonder if someone can test the “htmlembed” work-around inside the currently being developed Appsheet iframe?

3 Likes

I couldn’t tell by the video but I assume you had to add another data table with only 1 column. When you clicked the “+” action button you submitted a form when then resulted in the view showing the virtual column? Can you walk us through this part?

Thanks @tsuji_koichi I really appreciate your work

1 Like