Skip to main content

I am using a google apps script that sends data from one worksheet to another and adds the rows to the new sheet.  Zapier isn’t picking that up as a new spreadsheet row… I guess because I’m not manually typing it in?  Any thoughts on how to solve this problem?  I’ve tried the script, a query on a different sheet and etc.  It’s not firing.

Hi @BarrelRace.com 

The Google Sheets trigger is marked "instant" but it still takes a few minutes to trigger

The triggers for Google Sheets are unique among Zapier triggers. When there is a trigger event in the spreadsheet, Zapier gets a notification webhook from Google about this. After that, Zapier sends Google Sheets a request for new data, so it uses both the polling and instant trigger methods. This process takes about 3 minutes overall.

While not being "instant", these triggers are faster than regular polling ones, as they don't depend on the polling interval of the plan your account uses.


I know it’s not instant and I’m not in a rush, but it’s not firing at all no matter how long I wait.  It doesn’t show ANY movement when the script sends the new rows to the google sheet.  It works when I manually type though.


Hi @BarrelRace.com 

I’d try opening a ticket with Zapier Support for confirmation/guidance: https://zapier.com/app/get-help

 

Alternative is to use an operational database app such as Airtable: https://zapier.com/apps/airtable/integrations