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.

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

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!

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.

 

 

@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)

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. 

 

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

Terms & Conditions