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.