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.

I need help with creating a zap that will gather information from many google spreadsheets.

 

I have 45 spreadsheets that all have the same structure. There are new rows being added to each of spreadshhet. I need to extract data from each new row, send it to mailchimp and after that do an update in column X in that spreadsheet.

Right now i have 45 seaprate zaps that are triggered on new rows. The number of spreadsheets will soon grow to around 300 and i want to have a single zap where i can jsut add new spreadsheets.

 

Is there an existing solution for that?

 

Thanks in advance!

Hi @feldmanilya 

Look into using Airtable, which is a relational database app.

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

You can create 1 View per filter criteria.

The idea would be to have a field that indicates the “Group”, aka which GSheet it would have been on to help segment.

Much more dynamic way to manage data and automations.

Terms & Conditions