This template watches Gmail for a new message, maps sender, subject, and body in JavaScript, creates a Zendesk ticket, and appends a log row in Google Sheets.
Use it so support mail becomes a ticket and a searchable log in one run. Connect Gmail, Zendesk, and Google Sheets. Point the Gmail trigger at the inbox or label you use for support.
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 sender, subject, and body for the ticket and the sheet row.
Zendesk opens a ticket from those fields so the team can work the request.
Google Sheets appends ticket id, subject, sender, and status in the worksheet you choose.
Add a Gmail connection. Watch new email on the inbox or label that should become tickets.
Add a Zendesk connection with your domain and API token. Create a ticket from sender, subject, and body.
Add a Google Sheets connection. Use a worksheet with columns for date, sender, subject, ticket id, and status.
In JavaScript, return stable field names. Create the Zendesk ticket, then add a single Sheets row. Send a test message and confirm the ticket and the row.
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.
