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.

Hey all, 

I have a zap that is triggered by a new Gravity Forms entry. It takes the entry and searches Salesforce to see if the person exists (by email), then goes through a series of other steps. 

 

Every couple weeks, I get a google sheet of names that need to go through the same process. Is there a way to take a google sheet and run it through that same zap (or a modified version) where each row is a record?

 

I’ve thought of using the gsheet trigger (new spreadsheet in a Drive) but I’m not sure how to structure the zap so that it goes through the spreadsheet row by row. 

 

Any ideas on how to solve this (whether by using gsheet trigger or some other approach?)

 

Thanks!

Hi @SUN staff 

Zapier has a feature called Transfer, you can find it here: https://zapier.com/transfer

You can use that to go over all the rows in a google sheet and do action based on the rows.

Alternatively if you want to run it automatically in a Zap, you can use Google Sheet - Find Many Rows with loop by Zapier. It is however bit advanced and only works with up to 20 rows

Hey there @SUN staff 

Just to add to the great suggestions above from @robschmidt 

If Looping by Zapier looks a bit daunting, you can also use a more simple Zap from Google Sheets to achieve this, We have a guide for that here: 

This wouldn't be as automatic but would avoid the limitation of only working for up to 20 rows.

Hi @SUN staff 

Good question.

Check out this related help topic:

 

One more option that works on a scheduler.. but could me modified to trigger when a new file is added to Drive or emailed to Zapier. 

 
 

So many awesome suggestions here! 😍 

Thanks all, really appreciate the responses.
 

I ended up creating a Zap that triggers on a new Gsheet row. I’ll just paste the rows into the specific gsheet which processed multiple rows in my testing. 

@SUN staff 

Beware of flood protection if you are pasting data in bulk...

 

Flood protection and held items

 

If you have a large number of items (100+) that trigger a Zap at once, Zapier holds them for you and sends you an email requesting your confirmation. This helps to prevent a large number of actions from running by mistake and protects your task limit.

Terms & Conditions