This template runs on a schedule, reads your client birthday sheet in Google Sheets, and keeps the rows whose birthday is today.
JavaScript builds a short personalized message from name and any extra columns you map. Gmail sends each one. Connect Google Sheets and Gmail, then point the sheet at columns for name, email, and birthday.
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
The scenario starts each morning on the cadence you set.
Google Sheets returns name, email, and birthday for each row.
JavaScript keeps rows whose birthday month and day match today and writes a short message for each person.
Gmail sends the personalized birthday email from the connected mailbox.
Add a Google Sheets connection with access to the spreadsheet that lists name, email, and birthday.
Add a Gmail connection for the mailbox that should send the greetings.
Add a schedule for each morning. On Google Sheets, get values from the birthday worksheet.
In JavaScript, compare month and day to today, then map name and message into Gmail send email. Test with a row whose birthday is today.
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.
