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.
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 on the interval you set, such as every 15 minutes.
JavaScript lists new messages over IMAP and maps subject, sender, date, and a short snippet. Put the IMAP host, username, and password in that node.
Google Sheets writes a row per message, including the message id so later runs can skip repeats.
Add a schedule trigger and pick how often the mailbox should be checked.
Add a JavaScript node. Put the IMAP host, port, username, and password there. List recent messages from the folder you care about, such as INBOX.
Add a Google Sheets connection. Use a sheet with columns for message id, date, from, subject, and snippet.
Search the sheet by message id before you append. Add a row only when that id is new. Run once and confirm the first messages land in the sheet.
FAQ
More templates
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.
This template takes a message that Chrome sends to Mailhook, maps subject, recipient, and body in JavaScript, and delivers it with Gmail. Copy the Mailhook address and send or forward the Chrome email there. Connect Gmail. Put Gmail access on the Gmail connection.
