agent-image-lead-qualification-assistant
Gmail to Zendesk Ticket Automation with Google Sheets Logging
Description Turn incoming Gmail messages into Zendesk tickets and keep a synchronized log in Google Sheets. Uses Gmail as the trigger, creates Zendesk...
screenshot-daily-task-reminder-bot
Created by:
Rahul Joshi
Last Updated:

June 15th 2025

Agent Details:
n8n
OpenAI
general
Google Sheets
Zendesk
Sticky Note
Description
Description Turn incoming Gmail messages into Zendesk tickets and keep a synchronized log in Google Sheets. Uses Gmail as the trigger, creates Zendesk tickets, and appends or updates a central sheet for tracking. Gain a clean, auditable pipeline from inbox to support queue. โœจ What This Template Does Fetches new emails via Gmail Trigger. โœ‰๏ธ Normalizes Gmail payload for consistent fields. ๐Ÿงน Creates a Zendesk ticket from the email content. ๐ŸŽซ Formats data for Sheets and appends or updates a row. ๐Ÿ“Š Executes helper sub-workflows and writes logs for traceability. ๐Ÿ”๐Ÿงพ Key Benefits Converts emails to actionable support tickets automatically. โšก Maintains a single source of truth in Google Sheets. ๐Ÿ“’ Reduces manual triage and data entry. ๐Ÿ•’ Improves accountability with structured logs. โœ… Features Gmail Trigger for real-time intake. โฑ๏ธ Normalize Gmail Data for consistent fields. ๐Ÿงฉ Create Zendesk Ticket (create: ticket). ๐ŸŽŸ๏ธ Format Sheet Data for clean columns. ๐Ÿงฑ Log to Google Sheets with appendOrUpdate. ๐Ÿ”„ Execute workflow (sub-workflow) steps for modularity. ๐Ÿงฉ Requirements n8n instance (cloud or self-hosted). ๐Ÿ› ๏ธ Gmail credentials configured in n8n (with read access to the monitored inbox). โœ‰๏ธ Zendesk credentials (API token or OAuth) with permission to create tickets. ๐Ÿ” Google Sheets credentials with access to the target spreadsheet for append/update. ๐Ÿ“Š Access to any sub-workflows referenced by the Execute workflow nodes. ๐Ÿ” Target Audience IT support and helpdesk teams managing email-based requests. ๐Ÿ–ฅ๏ธ Ops teams needing auditable intake logs. ๐Ÿงพ Agencies and service providers converting client emails to tickets. ๐Ÿค Small teams standardizing email-to-ticket flows. ๐Ÿง‘โ€๐Ÿ’ผ Step-by-Step Setup Instructions Connect Gmail, Zendesk, and Google Sheets in n8n Credentials. ๐Ÿ”‘ Set the Gmail Trigger to watch the desired label/inbox. ๐Ÿ“จ Map Zendesk fields (description) from normalized Gmail data. ๐Ÿงญ Point the Google Sheets node to your spreadsheet and confirm appendOrUpdate mode. ๐Ÿ“„ Assign credentials to all nodes, including any Execute workflow steps. ๐Ÿ” Run once to test end-to-end; then activate the workflow. โœ…

Build Dynamic AI Agents

Join a community of growing Agentic AI Developers.