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.