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!