Skip to main content
Best answer

Create Email and Send to Recipient Named in Google Sheets Cell


I have data going to a Google Sheet spreadsheet, including one cell which has an email address.

When the Sheets data changes, I would like to create an email and send it to the email address listed in that cell.

When I do Sheets-to-Gmail Zap, I cannot identify the specific cell that contains the email address in the Gmail “to” zap.

How do I go about accomplishing this?

Best answer by meyerfire

Thanks! I just figured out what the issue was - I had many blank cells, which was limiting the triggers I could use for the zap.

 

Once I reorganized the Google Sheets Spreadsheet correctly, and had all cells with information, the trigger options opened up and I was able to use an email trigger input as the “to” line for the zap.

 

Thanks!

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @meyerfire 

Try using this trigger: GSheets New/Updated Row

Check out this help article: https://zapier.com/help/doc/common-problems-with-google-sheets-on-zapier#new-or-updated-spreadsheet-row-trigger-behavior


  • Author
  • Beginner
  • 1 reply
  • Answer
  • April 19, 2021

Thanks! I just figured out what the issue was - I had many blank cells, which was limiting the triggers I could use for the zap.

 

Once I reorganized the Google Sheets Spreadsheet correctly, and had all cells with information, the trigger options opened up and I was able to use an email trigger input as the “to” line for the zap.

 

Thanks!


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7454 replies
  • June 16, 2021

Hey @meyerfire,

Great work on getting this sorted, and thank you for sharing your solution with the Community! :)