How to set up auto-emails to clients using Zapier and Google Sheets: "Recipient address required" error

You’re storing your email addresses in column A, so you need to map this field from your Google Sheet into the "To" field of the email step in your Zap. Field mapping allows Zapier to dynamically pull data from previous steps—in this case, the email address from your Google Sheet—so that each new row triggers an email to the correct recipient.

Here’s what to do:

1. In the "To" field of your email step, click inside the box and select the column from your Google Sheet that contains the email addresses (Column A: "Email Addresses"). You can either hit the / on your keyboard or hit the + symbol at the right in the dialog box. Then select Column A

2. Make sure your Google Sheets trigger is set to "New Spreadsheet Row" and that your test data includes at least one row with a valid email address.

Let me know if you need further troubleshooting!

The problem is that I can’t get Zapier to refresh (the refresh button in the top-right corner of the edit box doesn’t do anything for me)...can’t get it to refresh the email address that I’ve put in Column A, titled New Client Email Addresses. The email address I’m pointing to with the yellow arrow is no longer in the Google Sheets (I deleted it and added a different email address, and apparently this broke the whole Zap). So basically, how can I get Zapier to: (a) update/refresh with the current info that’s in Sheets, instead of still referring to an email address that has since been deleted from the column, and (b) how can I get the Zap to just pull any new email address that is added to the row. This seems like it should be simple, but it’s not working. In the screenshot, I tried many times to click just the column “New Client Email Address,” but it won’t let me do that. If I have to also have a value (an email address) in row 2, as well.

What you’re creating is the template that Zapier will use for all future runs once you publish the Zap. The data Zapier is using comes from testing your Trigger step. So, if you need to refresh the data, you can go back to the Google Sheets step (called the trigger), go to the test panel, and select Find New Records which should pull in your updated data. Then you can come and map that data into the To field in the Gmail step. You will then be able to test your email, and if that works, publish the Zap. Then the Zap will automatically run for new email addresses going forward

Why does it say “no data” here? I have entered a name in that column, but Zapier isn’t seeing it? I’m running into this problem where I get the Zap to work fine during testing, but then after I publish, and I go and enter a new Spreadsheet row with the email address in Column A (“Reference Check Email Address”) and the person’s name in Column B (“Name of Applicant”) nothing happens. I asked ChatGPT for help and it suggested this filter step, where both conditions have to exist (i.e. something in column A and something in column B in the same row), and when I test it, Zapier says the email was sent. But then when I ;publish, it stops working for new rows. Thanks.

I think I’ve got it now. Thanks man.

Wow! Thank you for confirming that your resolution got the Zap running. Do you mind sharing how you tackle this issue? This will significantly help our Community members to have as a reference for the same issue.