Workflow to send email from Google Spreadsheet Trigger is Error

[aldodkris]

Hi guys,

I need your help. I want to build a workflow that sends an email using my SMTP credentials when new data (row) is added to my spreadsheet.

But, when I test it, I always get an error that tells me, " No recipients defined." Could you please help me with this issue?

Thanks,
Aldo

[n8n]

It looks like your topic is missing some important information. Could you provide the following if applicable.

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[aldodkris]

Hi, thanks for your reply @n8n,

Actually, I’m not using a seld hosted n8n.

Thanks,
Aldo

[barn4k]

hello @aldodkris

That’s because you have the first row in data that is actually a header row and should not be present in the output

Try to set the option “First Data Row” to 3. Maybe you header is a two-rows long

[Gustavo_Dambiski]

I had the same issue. I changed from “Row added” to “Row added or updated” and then it started working.