Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I seem to have it working to create the event but it is not updating when the row is updated. I believe I have an error in the way I have set-up the update event zap - maybe in the event field as I understand there needs to be an eventid but I am not sure how to configure this. 

Please see screenshots.

Hi @Shawn_L 

Good question.

What error are you encountering? (screenshots)

Make sure all the required field are populated for each Zap step.

I’m not getting any error message and it’s not showing that it is even attempting the zap under Zap history. 

@Shawn_L 

Make sure your GSheet is configured correctly to work with Zaps.

 

Zaps work while turned ON for new data going forward.

 

Help articles for using each app in Zaps:

 

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.

@Shawn_L 

As an alternative, check out Airtable.

Airtable has Automations.

Airtable Automations have native integrations with GCal.

 

airtables isn’t an option unfortunately because sheets pulls the data directly from shopify.  I know the instant isn’t really instant with google sheets, however it has been quite a while and still nothing.  It took only a few min to create a new event but I just can’t get the update event to work.  
there is a mandatory field under update called “event”.  Is that supposed to be set to id? And if so is id automatically generated from the calendar or should it be a column in the spreadsheet.  I have a feeling this is where it is breaking. 

@Shawn_L 

Yes, this is correct, the Event expects the Event ID.

 

Zap step 2 will find or create a GCal Event, which will always return an Event ID.

 

If the Zap is not triggering then that’s an issue with GSheets, and possibly how the GSheet is configure, how the GSheet data is being updated.

 

Did you review the available help articles for using GSheets in Zaps?

https://zapier.com/apps/google-sheets/help

Terms & Conditions