Send a ChatGPT email reply and save responses to Google Sheets
n8n template #1898Summary
Use templateThis 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 spreadsheet. Additionally, when feedback is given for any of the GPT responses, it will be recorded to the spreasheet, which can then be used later to fine-tune the GPT model. Prerequisites OpenAI credentials Google credentials How it works This workflow is essentially a two-in-one workflow. It triggers off from two different nodes and have very different functionality from each trigger. The flow triggered from On email received node is as follo
How to set it up
- Open template #1898 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
- Create 4 credentials under Credentials → Add credential: Google Sheets, Crypto, Gmail, OpenAI. Then open each of those nodes and pick the credential.
- Check the model in the OpenAI node. The template may point at a model your account can't use; swap it for one you have access to.
- Click Execute workflow and step through each node's output to confirm the data looks right.
- Toggle the workflow to Active so its trigger runs on its own.
Hand off to your agent
Prompt
Help me set up the n8n workflow "Send a ChatGPT email reply and save responses to Google Sheets" (https://n8n.io/workflows/1898). It uses: Google Sheets, Crypto, Gmail, Code, OpenAI, HTML. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.
Paste into Claude Code and it will do the rest.
Apps and nodes
Questions
Yes. n8n Team published it free on n8n.io as a verified creator, and it has 17K views. It runs on n8n Cloud or a self-hosted n8n instance.
Google Sheets, Crypto, Gmail, OpenAI. The other 2 nodes are built into n8n.
Similar workflows
NameViews
- Explore n8n Nodes in a Visual Reference Library5,197
- AI Timesheet Generator with Gmail, Calendar & GitHub to Google Sheets20K
- Daily Podcast Summary15K
- Realtime Notion Todoist 2-way sync with Redis8,614
- Automate SEO blog creation + social media with GPT-4, Perplexity and WordPress5,798
- Create LinkedIn Contributions with AI and Notify Users On Slack5,090
- Webpage Change Detection & Alerts with Google Suite and Hash Tracking2,582
- ✨🤖Automate Multi-Platform Social Media Content Creation with AI205K