Sending multiple emails from Google Sheets based on trigger values

Question

Hi everyone!I’m trying to build a Zap that sends 1 of 4 different emails based on the value in the “Trigger” column (E1, E2, E3, or E4) from a Google Sheet.I’ve set it up using Paths (as shown in the attached image), and each email is configured correctly. However, I’m running into two main issues:	The Zap only sends an email for one row, even though there are multiple rows with valid trigger values.			When I manually edit the Google Sheet, the Zap doesn’t detect the change and doesn’t send anything.	I’m currently using the “New or Updated Spreadsheet Row” trigger.Any idea what I might be doing wrong? Or should I be using a different trigger setup?Thanks in advance for any tips 🙌(Attaching screenshots of the setup and spreadsheet)

Troy Tessalone · Answer

Hi ​@Sebastiao_uflHere’s a different approach to consider:Use Airtable instead of GSheetsAirtable has native automationsAirtable Automation has a native integration with GmailCheck your Zap Runs history for activity and errors/issues:https://zapier.com/app/history/Post screenshots showing how your Zap trigger step is configured to give us more context.Check if you are using the correct Zap trigger based on where your GSheet is located in GDrive. (e.g. in a Team Drive)Help links for using the apps:GSheets:https://zapier.com/apps/google-sheets/integrations#helpGmail:https://zapier.com/apps/gmail/integrations#helpPaths:https://zapier.com/apps/paths/integrations#help

Sending multiple emails from Google Sheets based on trigger values

2 replies

Useful links

Useful links

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded