Question

Fire Zap when Google Sheets row updates from Google apps script

  • 12 November 2021
  • 3 replies
  • 157 views

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.


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +14

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.

Userlevel 7
Badge +14

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