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.

[GUIDE] Steps for How to Create a Looping Zap with GSheets and Webhooks

  • 24 November 2021
  • 4 replies
  • 1613 views
Troy Tessalone
Userlevel 7
Badge +14

[Guide] How to Create Looping Zap Steps with GSheets and Webhooks

 

Zap Steps

  1. Trigger: Webhook - Catch Hook
    1. Used to trigger this looping Zap
  2. Action: GSheets - Lookup Row
    1. Used to find an existing row for a preset value (e.g. DONE = No)
  3. Action: Filter
    1. Used to check if a GSheets row was found
  4. Action: [app] - [event]
    1. (optional) Used to take action in another app
    2. Can add additional action steps as needed
  5. Action: GSheets - Update Row
    1. Map the Row ID number from step 2
    2. Used to updated the GSheets row found in step 2 (e.g. DONE = Yes)
  6. Action: Webhook - POST
    1. Used to trigger the Zap again
    2. POST to the webhook URL from the Zap trigger in step 1
    3. Include a Timestamp as a parameter to make the request unique
      1. https://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field

 

RESOURCES

Webhooks: https://zapier.com/apps/webhook/help

GSheets: https://zapier.com/apps/google-sheets/help

Filter: https://zapier.com/apps/filter/help

 

Tips and Inspiration contributed by: Troy Tessalone - Automation Ace

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

4 replies

smccarthy956
Badge

I think I found a way to do this but I need to update all the rows on the spreadsheet. There is a UPDATE MULTIPLE ROWS for Google Sheets but it requires a ROW NUMBER at the end. How do you tell the update all rows to actually update all rows? 

Is there a way you can put something in the ROW NUMBER field to tell it to update all rows? 

1 Attachment
Troy Tessalone
Userlevel 7
Badge +14

Hi @smccarthy956 

The Zap action for GSheets Update Row(s) works with Line Items.

Help article about using line items in Zaps: https://help.zapier.com/hc/en-us/articles/8496277737997-Use-line-items-in-Zaps

 

Is there a way you can put something in the ROW NUMBER field to tell it to update all rows? 

No.

Perhaps look into using the GSheets API.

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

Hi Troy,

thx for the guide.
I don’t understand how to preset a value in Step 2. I can only chose values from previouse actions/triggers. In this case that would be the Webhook trigger with no Data available.

 

 

Troy Tessalone
Userlevel 7
Badge +14

Hi @Niklas 

Whatever app is triggering the Zap step 1 webhook, would need to provide the values as part of the data payload, which can then be used in the Zap filter step.

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

Reply


Terms & Conditions