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 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.

Best answer

How to create a NEW event in Google Calendar when adding a row in Google Sheet?

P

I want to connect a google Sheet and a Google Calendar, such that when I add a new Row to the Sheet, it creates a new Event on the calendar using the data from that new row.

I set up a Zap that I thought wold do this. “New Sheet Row” triggers “New Calendar Event.” When I was creating the Zap, it asked me to enter data for an event, which I figured was some sort of sample. 

Every time I add a Row to the Sheet, it pulls that sample data to create an Event. So it is just creating the same Event over an over when new Rows are created, ignoring the actual data from the Sheet.

Did I do it wrong? Is this how it is supposed work? Is there a way to accomplish what I want? Thanks!

icon

Best answer by christina.d 6 June 2022, 23:04

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

5 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @PowerZap 

Good question.

Please post screenshots with how your Zap steps are configured in order for us to have more context.

Make sure you are mapping variables between Zap steps using the ‘custom’ option: https://zapier.com/help/create/basics/set-up-your-zap-action#set-up-your-action

Try turning your Zap ON and test live, then check your Zap Runs to see the DATA IN/OUT for each Zap step: https://zapier.com/app/history/

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

Thanks! Well, I thought I had it a minute ago-- I had not realized that in Set Up Action I could select data columns instead of just entering text in fields. I put Event details into a single row before setting up the action again, and selected the columns that had the right data. When I finished setting the Zap up, it did create an Event using the data from the first row in the columns I had selected. 

However, if I add a new row with new data to the sheet, it does not create an event on the calendar. Also, if I edit data in the fields on the first row, it does not update the event. Is there something I need to do to make the zap… zap? I have waited a while, refreshed, etc. Screenshots below. 

 

Troy Tessalone
Userlevel 7
Badge +14

@PowerZap

Might be best to review the available help articles for how to use GSheets in Zaps: https://zapier.com/apps/google-sheets/help

Zaps work while turned ON for new data going forward.

You can check your Zap Runs to see the DATA IN/OUT for each Zap step to help you troubleshoot: https://zapier.com/app/history/

GSheets Zaps take a few minutes to trigger.

You’ll need 2 different Zaps to handle the new VS updated GSheet rows.

You’ll likely want to add a Zap step that saves the GCal Event ID back on the GSheet in a new column so that can be used for updating the GCal Events using the New/Updated trigger.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
jesse
Userlevel 7
Badge +9

Hey @PowerZap! I just wanted to check in here to see how things were going! Were you able to check out Troy’s suggestions and make the edits you needed to get things working? Let us know - we want to make sure you’re good to go here!

christina.d
Userlevel 7
Badge +9

Hey there, @PowerZap! I can see you were able to reach out to support who mentioned:

I took a look at the logs for your Zap and I was able to identify the three times the same 'Potsdam Summer Festival' event was created in your Google Calendar. These logs were tests, so the Google Calendar step was tested three times, resulting in three of the same events being created in the Calendar.
 
Luckily, it doesn't look like you're encountering this issue now that the Zap is on as each of your three runs are of separate events. You can view these in your Zap History: https://zapier.com/app/history/
 

 

I’ll also pop some of Troy’s troubleshooting steps below just in case it’s useful to anyone following along!

 

Might be best to review the available help articles for how to use GSheets in Zaps: https://zapier.com/apps/google-sheets/help

Zaps work while turned ON for new data going forward.

You can check your Zap Runs to see the DATA IN/OUT for each Zap step to help you troubleshoot: https://zapier.com/app/history/

GSheets Zaps take a few minutes to trigger.

You’ll need 2 different Zaps to handle the new VS updated GSheet rows.

You’ll likely want to add a Zap step that saves the GCal Event ID back on the GSheet in a new column so that can be used for updating the GCal Events using the New/Updated trigger.


Welcome to the Community! 🎉

Terms & Conditions