Skip to main content
Question

Google sheet integration with botsify story creation issue

  • October 29, 2020
  • 2 replies
  • 30 views

I am trying to integrate Google sheet with Botsify using zapier. it fetches a new row manually when zapier is edited and saved. Zapier is not automatically triggered when a new row is added into the google sheet. 

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

2 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • October 29, 2020

Zapier GSheet app help articles: https://zapier.com/apps/google-sheets/help

 

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.


jesse
Forum|alt.badge.img+9
  • Architect
  • January 7, 2021

Hey @afgcat! Were you able to get your Zap to trigger? We’d love to hear about how you solved this, if so, and lend a hand, if not. Let us know!