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 meyerfireView original