What is your goal?I want to auto send to recipient emails that are in cell R4 (GOOGLE SHEETS)
What is the problem?I don t know how to do this, I spent over few hours on this…
What have you tried so far?I tried SPLIT but I do something wrong or I dont know
Screenshots: scenario setup, module configuration, errorsHi, could you elaborate on the following points?
I think you forgot to attach the screenshot of the error.
Do I understand correctly that you’re only updating R4 with one new email address at a time (not the whole column R)?
How is your spreadsheet set up? Is everything you’re trying to put into the email in the same row (row 4) in the spreadsheet (email address, subject, HTML body)?
Could you share a screenshot of the webhook output?
Hello,
Please show us your webhooks’ output structure.
You are mentioning Google Sheets but there is no module in your scenario - please add more details and describe your process. Especially how your data is structured.
Hello,
It looks like you are trying to put the recipients value from the Webhook directly into the To Email Address field. However, Microsoft will not split those values automatically it will just take a single value.
You will either need to send the recipients emails from the Webhook as an array of emails using an Array Iterator or turn Map ON for the To field and use the Split function to map the reciepients.
I hope this can give you some more direction.
Hi @Niccin112 ,
To troubleshoot this, we need a bit more clarity. From the screenshot, I can only see a Webhook and an Outlook Email module—there is no Google Sheets module, so it’s unclear how the email addresses from cell R4 are being fetched.
Please share a bit more detail about how you’re currently fetching the emails from cell R4 and what exactly isn’t working, so we can better understand the issue and help troubleshoot it.
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
