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

Best answer

Can a Zap process each line of a new google sheet?

  • 2 August 2022
  • 7 replies
  • 421 views
S
Badge

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!

icon

Best answer by SUN staff 3 August 2022, 02:34

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

7 replies

robschmidt
Userlevel 7
Badge +9

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

Outliant.com | Zapier Expert
PaulDavidson
Userlevel 3
Badge +3

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.

Troy Tessalone
Userlevel 7
Badge +14

Hi @SUN staff 

Good question.

Check out this related help topic:

 

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

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. 

 
 

christina.d
Userlevel 7
Badge +9

So many awesome suggestions here! 😍 

S
Badge

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. 

Troy Tessalone
Userlevel 7
Badge +14

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

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