This template watches Gmail for a new message, extracts company and email in JavaScript, appends a Google Sheets row, and sends a Slack message.
Skip personal domains so the sheet stays business-only. Connect Gmail, Google Sheets, and Slack. Point the Gmail trigger at the inbox or label that holds leads.
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 when a new email arrives in the Gmail inbox or label you choose.
JavaScript reads company and email, skips personal domains, and drops addresses already in the sheet.
Google Sheets adds company and email in the worksheet you choose.
Slack posts the new lead in the channel you set so the team can follow up.
Add a Gmail connection. Watch new email on the inbox or label that should feed leads.
Add a Google Sheets connection. Use a worksheet with columns for date, company, and email.
Add a Slack connection with access to the channel that should get lead alerts.
In JavaScript, return company and email and skip personal domains. Add a Sheets row, then send a Slack channel message. Send a test lead email and confirm the row and the Slack post.
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.
