About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Question

Google Calendar to Google Sheets

  • 20 October 2020
  • 7 replies
  • 108 views
T
Userlevel 1

I’m new to zapier and I love it, in concept.  I was able to get it to do one important function which is to update a google shees with a new event added to google calendar. I love seeing new events auto populate into my spreadsheet.

However, I’m going in circles trying to get it to do some other things I’m hoping it will help me with.

I need it also to update a google sheet row when an event in google calendar is changed

and I need it to delete a google sheet row when an event is cancelled.

I have a feeling I’m doing something wrong in the row field but I’ve tried every option and It’s still not working.  

If anyone could help with their Zapertise I would be very grateful.

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

7 replies

Troy Tessalone
Userlevel 7
Badge +14

Please provide screenshots of your Zap step configurations.

Action: GSheets - Lookup Row

Triggers/Actions/Searches available for the apps:

GCal: https://zapier.com/apps/google-calendar/integrations#triggers-and-actions

GSheets: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
T
Userlevel 1

Thanks Troy

 

 

AndrewJDavison_Luhhu
Userlevel 7
Badge +10

Hi @ThePuliceDept 
Just checking in to see if you still need help with this? 

We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
T
Userlevel 1

Thanks for checking in. I have it working mostly, though not consistently. The biggest challenge is with calendar changes. Zapier can’t find the correct row to make the change so I have to manually go in and make the changes.

AndrewJDavison_Luhhu
Userlevel 7
Badge +10

@ThePuliceDept 

You might want to consider a zap that triggers when the event is created and adds the Gcal event ID to the Google Sheet - giving you a search key you can use to record changes.

We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
T
Userlevel 1

Thanks. I tried that but again the zap failed to find the row and make the change. It just added a new row again. I love the idea of zaps but the lack of customer service makes it hard to advocate its use company wide.

AndrewJDavison_Luhhu
Userlevel 7
Badge +10

Hi @ThePuliceDept - have you been touch with support yet. They run 24/7 and will definitely help guide you through this. You can open a ticket here: https://zapier.com/app/contact-us

In terms of trying to get help here. Can you show us screenshots of how the various steps of your zap are setup?

We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
Terms & Conditions