I’m trying to set up an automated email in Gmail from Google Sheets. I successfully set up the Google Sheets Webhook, and it provides data to the Make Google Sheets-Watch Changes Module.
However, the parameter ‘to’ in the subsequent email is never loading. Only if I add an ifempty with an alternative email, it sends an email, but without content. For some reason, in the Gmail Settings I can’t see the sample content from the Google Sheets. Maybe a setup error?
Could you please let me know which Google Sheets trigger you’re using?
A quick tip: Try deleting any empty rows from the sheet as this might help resolve the issue.
I switched from the Google Sheets Webhook to the built-in webhook from Make. Now everything is getting captured smoothly and the scenarios are executed as intended.
I’ve run into this with Gmail modules too — sometimes when using Sheets triggers, the field mapping doesn’t resolve correctly if sample data isn’t populated. Switching to Make’s built-in webhook, like you did, is a good solution. Another tip: make sure there are no empty cells or formatting issues in your Sheet. Using Array Aggregator sometimes helps with passing clean values.
