Ok I have a google sheet set up with the following columns:
first name, email, message - so that another person can update the spreadsheet to change the messages each week
this is how i set up my scenario
sheets retrieves the first row
iterator to get name
iterator to get email
iterator to get message
send gmail - use value for email, body use iterator value for name, message
my issue that it does not put in the email value and it does not cycle through the rows (or so I think because I can’t get past the email issue).
It would be the equivalent of a transfer in Zapier but I am not sure how to do the equivalent in MAKE.
thanks for your assistance in advance
Lisa
I have also tried google sheets - get range value
tools - multiple variables
repeater - numbered for the number of rows in the sheet i want to send an email for
gmail - i put the variable for email in the TO, Body has variable name, message
read google sheets which has the info for first name, email address, message body
then I thought that i had to have them as variables so that it could cycle through the amount of times that it will be needed which could change on a weekly basis so I would prefer not to have a number and rather that it stops on a blank line
is flow control so that it cycles the correct number of times
is creation of the actual email. I currently get an error that : Missing value of required parameter ‘to’.
So the history is that someone else is going to keep the original spreadsheet up-to-date with regards to adding and removing people as well as updating the message.
