Best answer

Zap Only Working in Test Mode?

  • 27 November 2020
  • 2 replies
  • 53 views

Hey guys, just created a Zap to pull from a Google Sheet and send to Omnisend as a new subscriber whenever a new spreadsheet row is added.

I have this made for another Sheet and it works flawlessly. When I test this one, it is able to send the information and create a new subscriber, but when I try to do it organically, it will not send the information from Sheets to Omnisend.

Any ideas?

icon

Best answer by Troy Tessalone 27 November 2020, 18:19

Check these help articles: https://zapier.com/apps/google-sheets/help

  1. Is the Zap ON?
  2. Is the Zap triggering?
  3. Is the Zap triggering but resulting in an error?

Check the Zapier Task History: https://zapier.com/app/history/

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

The new and updated spreadsheet row triggers for Google Sheets are unique in that when there is a trigger event in the spreadsheet, Zapier gets a notification webhook from the Google about this following that notification, Zapier sends Google Sheet a request asking for new data. After this, the trigger works using the normal polling mechanism and these new or updated rows returned will trigger the Zap. This process takes about 3 minutes overall so although the Google Sheets trigger is marked "instant" it really is a hybrid of both webhook and polling techniques. While being slower than any other "instant" trigger, it's still faster than all polling triggers which would take 5 or 15 minutes.

View original

2 replies

Userlevel 7
Badge +10

Check these help articles: https://zapier.com/apps/google-sheets/help

  1. Is the Zap ON?
  2. Is the Zap triggering?
  3. Is the Zap triggering but resulting in an error?

Check the Zapier Task History: https://zapier.com/app/history/

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

The new and updated spreadsheet row triggers for Google Sheets are unique in that when there is a trigger event in the spreadsheet, Zapier gets a notification webhook from the Google about this following that notification, Zapier sends Google Sheet a request asking for new data. After this, the trigger works using the normal polling mechanism and these new or updated rows returned will trigger the Zap. This process takes about 3 minutes overall so although the Google Sheets trigger is marked "instant" it really is a hybrid of both webhook and polling techniques. While being slower than any other "instant" trigger, it's still faster than all polling triggers which would take 5 or 15 minutes.

Check these help articles: https://zapier.com/apps/google-sheets/help

  1. Is the Zap ON?
  2. Is the Zap triggering?
  3. Is the Zap triggering but resulting in an error?

Check the Zapier Task History: https://zapier.com/app/history/

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

The new and updated spreadsheet row triggers for Google Sheets are unique in that when there is a trigger event in the spreadsheet, Zapier gets a notification webhook from the Google about this following that notification, Zapier sends Google Sheet a request asking for new data. After this, the trigger works using the normal polling mechanism and these new or updated rows returned will trigger the Zap. This process takes about 3 minutes overall so although the Google Sheets trigger is marked "instant" it really is a hybrid of both webhook and polling techniques. While being slower than any other "instant" trigger, it's still faster than all polling triggers which would take 5 or 15 minutes.


Thanks, this was the issue. Looks like I wasn’t waiting the 15 minutes for it to send, just upgraded the account and zaps are triggering after 2 minutes and that’s perfect.

Appreciate the help.

Reply