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.

Best answer

Rookie needs help integrating Google Calendar with Google Sheets

  • 23 September 2020
  • 4 replies
  • 65 views
M

Good day all, 

I am new to Zapier and must admit that I’m struggling to understand how Zapier works, particularly in the Google Sheets/Calendar integrations.

 

I’ll explain what I’m hoping for, and I would be exceedingly grateful for anyone that can help me understand how to set this up. 

 

Our business is custom manufacturing of some exceptionally complex products with equally complex schedules. We use Google Calendar to schedule nearly all of them. 

We have about 10 Google Calendars that are shared by the whole team, and some calendars that are shared only by certain groups of us. Some are “individual person only” calendars. 

 

We very much need to get away from trying to view and edit all these calendars using the Google Calendar web interface, it’s killing us. It’s so tedious. Sometimes we need to enter 5-10 tasks and we can only do “death by a thousand clicks” entering them into the Calendar Web Interface one at a time.

 

I am trying to find a way for my team to be able to access ALL of these calendars via one shared Spreadsheet.

  • Create new Calendar entries in Google Sheets that automatically update when entered. 
     
  • Automatically add to the Spreadsheet any new Calendar entries that are made via the Google Calendar web interface. 
     
  • I want Tasks that are dragged-and-dropped onto different dates on the Calendar web interface to update their information within the Google Spreadsheet. 
     
  • I want to be able to view each Calendar within the Spreadsheet, hopefully with each Calendar being given it’s own tab at the bottom of the screen.
     
  • Calendar Entries would be in rows. Each new row of information is a new Calendar entry. 


    So what is possible here?
icon

Best answer by adamsmartschan 23 September 2020, 21:55

View original

4 replies

adamsmartschan
Userlevel 5
Badge +6

@Matt M -

If we make this a job for Airtable, rather than Google Sheets, I think this (or darn close to all of it) would be possible. Google just made their own version with Tables, but it’s not on Zapier yet. Plenty of UI-focused advantages over Google Sheets; it’s made for this type of thing.

Happy to hop on a quick call if you want to run through what could work here. This is a number of zaps – at least three – plus some automation work within Airtable. But the platforms are flexible enough that we can make it happen ;)

M

If this can work with Google Sheets, that will be a win for everyone here on our team. I have no experience with Airtable, so I looked it up and it’s a pretty impressive system, so I have no bias against it. It’s just that everyone here has immediate access to Google Sheets and knows how to use it.

adamsmartschan
Userlevel 5
Badge +6

Gotcha!

Most of this would be possible. The one major exception I can see is “I want to be able to view each Calendar within the Spreadsheet, hopefully with each Calendar being given it’s own tab at the bottom of the screen.” Google Sheets zaps are meant to work with a specific spreadsheet, not an entire workbook. Airtable uses “views” for this, with the data centralized and parsed out. Sheets actually segregates the data. So you’d need to set up a lot of zaps to get this part moving in Sheets.

M

Ok. So to make sure I’m understanding you, basically every calendar would need to have it’s own Google Sheet document and it’s own Zap(s), correct? 
 

Or is there a way of doing all of the calendars within the same Sheets document?

 

 

 

Reply


Terms & Conditions