I’m stuck trying to connect a private Notion Meal Cards database (Search Database Items) to Gmail (Send an email) in Make.
When I run the full scenario (Notion → Gmail), the “To” field fails — Gmail doesn’t read the Notion email property for recipient.
When I test the model in Gmail by itself, it sends an email when I input an email manually in the field (though the card / message is empty since Notion isn’t in the flow).
If I type an email manually in the “To” field, the scenario shows as successful, but nothing ever arrives in the inbox. No error is thrown, but no message is delivered.
The Notion module itself is fine — it returns the expected data bundles with the properties (Servings, Tags, Ingredients, Recipient, etc.).
So the main blocker: Gmail doesn’t seem to accept the Notion recipient field, and even with a hard-coded “To,” nothing actually gets sent when running the scenario once.
I’ve burned through ~3 days on this (10+ hours each day), so I’d really appreciate expert advice from anyone who has run into the same disconnect with Gmail + Notion.
Hello @Mo_Sallam and Welcome to the Make Community!
Are you able to provide additional screenshots of the output of Notion and the input to Gmail and how you’ve got those set up? This doesn’t sounds like a Notion + Gmail problem, it sounds like just a mapping issue, but we’ll get a better idea if we can get those details.
You can try disabling the Map option on the To field then fill in the recipient name and email.
Since you have Map enabled on the “To” field, that’s more appropriate for unknown number of recipients and you would need to supply an array compatible with that field.
Between Notion and Gmail, you can try adding an iterator on recipients followed by an Array Aggregator. On the Aggregator there’s a dropdown box for data structure, from there select something along the lines of Gmail:To then fill in the blanks. For that Data Structure selection to be available the Gmail module must be connect to the Array Aggregator (Array Aggregator comes first).
