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.

  • Home
  • Get Help
  • How Do I
  • How can I create a single "super Zap" to pull events from monthly tabs in Google Sheet?
Question

How can I create a single "super Zap" to pull events from monthly tabs in Google Sheet?

  • 17 January 2024
  • 4 replies
  • 28 views
L

We use a shared Google sheet, and each month we add a tab/sheet to the one file — one tab for each month. 

I’ve created a Zap that pulls new events from new rows in Tab 1, and places them in a calendar app. That’s fine. 

My question is: what happens as we add tabs for Feb, March, April… etc into December? 

Do I need to create a new Zap for each new tab? Can I make one “super Zap” for all 12 months? 

 

Also for bonus points: How do I trigger Zapier to pull in the existing rows, not just new rows created after the Zap was published? 

thanks!

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

4 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @LeeBee 

I’d recommend using Airtable instead of GSheets.

Airtable has Views which are segments of data. (sort, filter, group, show/hide fields, reorder fields)

 

The concept would be to put all the data into 1 Table.

Depending on your data, you would have a field for year and a field for month, OR those 2 fields could be derived via a Formula type field from a Date type field.

You could then create a View to show data grouped by Year/Month, or multiple Views (with data filtered per Year/Month).

This would allow the 1 Zap to be dynamic for all years/months.

And depending on the calendar app you are using, Airtable also has Automations which a native integration with GCal.

 

 

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

@LeeBee 

How do I trigger Zapier to pull in the existing rows, not just new rows created after the Zap was published? 

Existing rows would need to match the Zap trigger conditions. (e.g. GSheets Updated Row, Airtable New/Updated Row - limited to records a View)

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

I’d recommend using Airtable instead of GSheets.

 

Thank you @Troy Tessalone , however I don’t get to choose the source for the scheduling platform. I’m stuck with Sheets. 

 

Troy Tessalone
Userlevel 7
Badge +14

@LeeBee 

If you are trying to use different worksheets in a spreadsheet then you will need to use separate Zaps to trigger from those, or go with some advanced GSheet formulas to get the data into 1 MAIN worksheet.

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