Hi everyone!
I’d like to ask for your help with something. I have a Google Sheets spreadsheet, and I’d like to set up a workflow in n8n so that whenever a new row is added, an email is automatically sent.
How can I set this up?
Thanks in advance for your help!
Google Sheet Tiger
Send a message
Hi @megyo2
Check this.
Looking at your screenshots , your config is already fine, Row Added is set and the expressions match your columns, so the JSON above is only a reference. The likely issue is how polling triggers work: they run only when the workflow is Active, and Fetch Test Event does not poll, so nothing on the canvas will send an email. The first poll after activation also just records a baseline and fires nothing, so activate, wait a minute, then add a row and check the Executions list.
Two smaller things: Email Type is HTML but your message uses plain line breaks, so the two lines will run together, switch it to Text or add <br>. And your Subject is still the placeholder subject.
Hi @megyo2
That is the fix. Once the emails start arriving, the Idõbélyeg column will come through as a number like 45904.51 rather than a date, because the trigger returns Google’s serial date format by default, counting days from 30 December 1899.
In the trigger, select Add option, choose DateTime Render, and set it to Formatted String. It only shows while Trigger On is Row Added, which yours already is. Dates then arrive as text in your sheet’s locale format.
hi @megyo2
you need to activate workflow and wait minimum 1 minute.
