This template runs on a daily schedule, reads email, name, and message columns from Google Sheets, and sends each row through Gmail.
JavaScript drops empty rows and trims addresses so blank cells do not bounce. Connect Gmail and Google Sheets, then point the sheet read at the worksheet that holds recipients and copy.
Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.
Full pricing — how CPU seconds work →Workflow preview
A schedule starts the scenario at the time you set (08:00 in the default copy).
Google Sheets loads recipient emails, names, and message fields from the worksheet you choose.
A JavaScript node trims emails, skips blanks, and builds one payload per recipient. An iterator sends one Gmail message per valid row.
Gmail uses subject and body from the sheet, or a fixed template plus merge fields.
Add a Gmail OAuth connection with permission to send.
Add a Google Sheets connection. Point the sheet read at the tab that holds email, name, subject, and body.
Add a JavaScript node, an iterator, then send email with Gmail. Map To, Subject, and Body from each row.
Run daily. Send a test to yourself before enabling the full list.
FAQ
More templates
This template runs on a schedule, connects to your mailbox over IMAP from a JavaScript node, and appends each new message as a Google Sheets row. Put the IMAP host, username, and password in that JavaScript node. Connect Google Sheets and keep a message id on the row so later runs skip mail you already logged.
This template logs Harvest time from Outlook meetings. A schedule starts each run. JavaScript calls Microsoft Graph calendarView for the window you set and turns start and end into hours. Put the Graph token in that JavaScript node. Harvest creates a time entry with the event title as notes. Connect Harvest and pick the project and task those hours should land on.
This template watches Microsoft Outlook for new mail, cleans the body in JavaScript, asks ChatGPT for a reply, and sends that reply from Outlook. Connect Microsoft Outlook with permission to read and send mail. ChatGPT is a Latenode AI step, so you do not paste an OpenAI key. This uses Outlook mail, not calendar.
