I need to build a notification system that remind people inside my organization to complete a Form. I build this system and it's not working, but I don't know why.
Question
Failed to create a send email in Gmail: The value in the "To" field is invalid
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Good question.
Make sure to review the field description.
Multiple emails must be comma separated.
hi
Do you have any idea?
+14- Zapier Orchestrator & Solution Partner
Depends on how the data is returned from the GSheet Lookup Step.
Can you post a screenshot of those results?
This is how zapier retrieves my data.
Then it puts it all together as you saw in the last image.
+14- Zapier Orchestrator & Solution Partner
You can try using this Zap action: Formatter > Utilities> Line-Item to Text
This should flatten and concatenate the returned emails.
NOTE: Make sure all the returned rows from the GSheet have a valid email address in a valid email format.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.