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. โ