Create Zendesk Tickets from Gmail and Slack, with Google Sheets Tracking

This n8n workflow automates the creation of Zendesk support tickets from new emails in Gmail and new messages in Slack, while also maintaining a consolidated log of all created tickets in a Google Sheet. This ensures no customer request or internal issue goes unnoticed, providing a centralized system for tracking and managing support requests.

What it does

1. Monitors Gmail: The workflow listens for new emails in a specified Gmail inbox.
2. Monitors Slack: Simultaneously, it listens for new messages in a designated Slack channel.
3. Processes Incoming Data: For both Gmail and Slack, it extracts relevant information such as the sender, subject/message, and content.
4. Transforms Data (Code Node): A Code node normalizes the incoming data from both sources into a consistent format suitable for Zendesk and Google Sheets.
5. Creates Zendesk Ticket: It creates a new ticket in Zendesk using the extracted and transformed information.
6. Logs to Google Sheets: It adds a new row to a specified Google Sheet, recording details of the newly created Zendesk ticket.
7. Conditional Routing (If Node): Although not explicitly connected in the provided JSON, a disconnected "If" node suggests potential for future conditional logic (e.g., routing based on content, sender, etc.).
8. Merges Data (Merge Node): A disconnected "Merge" node suggests potential for combining data streams from different sources or at different stages of the workflow.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Account: A running instance of n8n.
• Gmail Account: With credentials configured in n8n to allow the Gmail Trigger node to monitor emails.
• Slack Account: With credentials configured in n8n to allow the Slack Trigger node to monitor messages and the Slack node to potentially send notifications.
• Zendesk Account: With credentials configured in n8n to allow the Zendesk node to create tickets.
• Google Sheets Account: With credentials configured in n8n to allow the Google Sheets node to write data. You will need a specific spreadsheet and sheet name for logging.

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • For the Gmail Trigger node, set up your Google OAuth2 credentials.
   • For the Slack Trigger and Slack nodes, set up your Slack API Token credentials.
   • For the Zendesk node, configure your Zendesk API Token or OAuth2 credentials.
   • For the Google Sheets node, set up your Google OAuth2 credentials.
3. Customize Nodes:
   • Gmail Trigger: Specify the email address or query to monitor for new emails.
   • Slack Trigger: Specify the Slack channel to monitor for new messages.
   • Code: Review and adjust the JavaScript code within the Code node to correctly parse and format data from Gmail and Slack into the desired structure for Zendesk and Google Sheets.
   • Zendesk: Configure the ticket fields (e.g., subject, description, requester email) using expressions that reference the output of the Code node.
   • Google Sheets: Specify the Spreadsheet ID and Sheet Name where ticket details should be logged. Map the columns in your sheet to the data output from the Code node.
4. Activate the Workflow: Once all credentials are set and nodes are configured, activate the workflow.

This workflow provides a robust foundation for centralizing your support request management. You can further enhance it by utilizing the disconnected If and Merge nodes for more complex routing, data aggregation, or conditional processing based on your specific needs.