How do I get and then loop through all rows in a Google Sheet in Zapier?

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

Hi ​@ldrury,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.

Wow! Thank you for confirming that Troy’s resolution got the Zap running. This will significantly help our Community members to have as a reference for the same issue.