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 have a list of invitees for an event in a Google Sheet. I want to loop through each row and send an email invite to each person (one on every row). I can’t figure out how to do this easily. I’m sure there is a way.

Thanks!

Hi ​@ldrury 

Give this a try…

 

Use Zapier Tables instead of GSheets: https://zapier.com/apps/zapier-tables/integrations#triggers-and-actions

You can import your GSheet to a Zapier Table.

Add a field to use as a control to trigger the automation. (e.g. Status)

Steps

  1. Trigger: Zapier Tables - Updated Record
    1. Select the field to watch for updates
  2. Action: Filter
    1. Check to make sure the Status, Email, and other fields exists that will be used in the email template
  3. Action: Gmail - Send Email
    1. Map variables from Zap step 1
  4. Action: Zapier Tables - Update Record
    1. Update the Status to Sent

 

You can bulk update the records to change a field value, thus triggering the Zap to run.

 

OR

 

Use Airtable instead of GSheets: https://zapier.com/apps/airtable/integrations#triggers-and-actions

You can import your GSheet to Airtable.

Airtable has native automations.

Airtable Automations have a native integration with Gmail.

You can add a checkbox field to trigger the automation to run for each record.

Help with Airtable Automations: https://support.airtable.com/docs/getting-started-with-airtable-automations

Reply


Terms & Conditions