Workflow to send email from Google Spreadsheet Trigger is Error

Questions
1

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?

Screenshoot_1506_090524
Screenshoot_1506_0905241920×827 93.1 KB

Screenshoot_1507_090524
Screenshoot_1507_0905241920×827 85.4 KB

Thanks,
Aldo

2

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:
3

Hi, thanks for your reply @n8n,

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

Thanks,
Aldo

4

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

image
image911×517 65.2 KB

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

5

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