Skip to main content
Question

No data for Google Sheets to Gmail Action

  • 29 August 2022
  • 2 replies
  • 59 views

I am setting up a action to send a new email when a new or updated row is added to a spreadsheet. On the sheet I have a column for email addresses, name, date, etc.. In the action setup for sending the message in Gmail I select the email option for the β€œto” (recipient) from my sheet, but it displays as β€œemail - no data”. Any suggestions are greatly appreciated!

Β 

I have double check and the correct sheet/worksheet/trigger is linked to the action.

Hi @rlongΒ ,

Β 

please screenshot the step (including the test results from the Trigger step) so we can help you better


Hi @rlongΒ ,

If when mapping the field Email you see β€œNo data”, could you double-check if the test sample that’s being used in the Zap has an email?

You can alsoΒ try pulling in new test samples and select one that you’re sure contains the email value, before re-mapping the field:Β https://zapier.com/help/create/basics/change-the-test-data-in-your-zap-trigger

Let us know if you’re able to figure it out 😊