Update my Appsheet app once google sheet data is changed/updated by a Google Apps Script

[Cents]

Hello, everyone,

AppSheet is a game-changer for my small business, and I am very happy with it. I’m wondering if there is a way to update my app once rows are updated by a script in my Google Sheets. I enter specific information in a form, and once it reaches the sheet, the script reads specific columns and outputs data into other columns. However, it sometimes takes up to 10 minutes for the changes to appear on AppSheet.

I’ve noticed that if I submit a form and then immediately submit another one, the data from the first form entry is updated correctly.

I’ve heard about the AppSheet Events extensions, but it doesn’t seem to do anything for me. I’m not sure if I’m using it correctly.

Thanks!

[Suvrutt_Gurjar]

You may want to consider running the Google Apps Script  (GAS) "through" AppSheet automation.

Call Apps Script from an automation - AppSheet Help

In that case you could read back the return values from the GAS

Use return values from Apps Script tasks - AppSheet Help

With the above implementation, mostly the values should read in app without delay.

[Trevwiller]

Agreed seems like adding this to an automation run based on an add. You could even save time on the GAS by passing the key through to it for the row it needs to process. or all the data needed to be processed separately from the app in a stand alone script. Then the data passed back to the bot to be placed on the row. Would give the fastest user feedback as the change happens in the app.

[MultiTech]

Did you know you can add your google form as a table into your app - which can then be used as a data source itself, and you can directly kick off automations from the form save event?