Send a ChatGPT email reply and save responses to Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: OpenAI (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 40 nodes and runs on Gmail events (plus 1 other trigger). Along the way it connects Gmail and Google Sheets.
How it runs
Trigger: On Gmail events (plus 1 other trigger).
- Identify trigger # (Edit Fields (Set)): sets or maps fields
- Identify trigger # (Edit Fields (Set)): sets or maps fields
- Configure (Edit Fields (Set)): sets or maps fields
- Determine which trigger ran (Switch): routes items into 2 branches
- Only continue for specific emails (If): checks a condition and branches into true / false
- Generate UUID (Crypto): hashes or encrypts values
- Thanks for your response! (HTML): parses or builds HTML
- Extract message content (advanced) (Code): runs custom JavaScript code
- Show HTML page (Respond to Webhook): sends the response back to the webhook caller
- Is text within token limit? (If): checks a condition and branches into true / false
…plus 20 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- OpenAI (legacy) in Generate reply: replace with OpenAI node (AI section).
- Also check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll).
| Removed in 3.0 | Replace with |
|---|---|
| OpenAI (legacy) Generate reply | OpenAI node (AI section) |
Nodes used (13)
- OpenAI
n8n-nodes-base.openAi - Gmail Trigger
n8n-nodes-base.gmailTrigger - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Gmail
n8n-nodes-base.gmail - Crypto
n8n-nodes-base.crypto - HTML
n8n-nodes-base.html - Code
n8n-nodes-base.code - No Operation, do nothing
n8n-nodes-base.noOp - Google Sheets
n8n-nodes-base.googleSheets - Webhook
n8n-nodes-base.webhook - Respond to Webhook
n8n-nodes-base.respondToWebhook - Switch
n8n-nodes-base.switch
From the author
This workflow sends a OpenAI GPT reply when an email is received from specific email recipients. It then saves the initial email and the GPT response to an automatically generated Google spreadsheet. Subsequent GPT responses will be added to the same…