Handle email replies faster with AI and keep clean records in Google Sheets. When a message hits your Gmail inbox, a clear reply is written with OpenAI and sent back to the sender. Each thread gets saved to a sheet, and a feedback link lets people rate the reply so you can improve results over time.

Two event paths run the work. The Gmail trigger checks the inbox every minute, filters who should get an automated reply, and parses the email body. A token limit check stops very long emails so you avoid broken outputs. OpenAI writes the response using your set token size. Gmail sends an HTML reply that includes a unique feedback link. On click, a webhook captures the rating, shows a thank you page, and writes the feedback to the same Google Sheet. The sheet is created if missing, and its ID is stored in static data for reuse. A UUID links each email, reply, and feedback.

Setup is simple. Connect Gmail, Google Sheets, and OpenAI. In the Configure node, set recipients, token sizes, and sheet names. Expect faster first replies, a single source of truth for messages, and a steady loop of feedback you can use to tune prompts or training later. It fits support inboxes, common question handling, and triage at scale.

• Gmail event trigger checks the inbox every minute and starts the flow on new emails
• Recipient allowlist controls who gets an automated reply, with a star option to allow all
• Advanced email parsing extracts clean message text before sending to the AI
• Token limit guard stops very long inputs and guides you to adjust token sizes
• OpenAI reply with adjustable max tokens for consistent and safe outputs
• HTML email template sends a clear response and includes a unique feedback link
• Webhook captures feedback and shows a thank you page to confirm submission
• Google Sheets auto creates the spreadsheet and appends rows for each exchange
• Static data stores spreadsheet IDs and a UUID links email, reply, and feedback

• Reduce first reply time from hours to under 1 minute
• Automate up to 80% of common email questions
• Log 100% of emails, replies, and feedback in one sheet
• Cut copy and paste errors by over 90%
• Scale to 10 times more emails without extra staff
• Connect Gmail, OpenAI, and Google Sheets in one flow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Gmail, Google Sheets and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, open the On email received node and the Send reply node, choose Create new credential, then connect your Google account for Gmail OAuth2. Allow read and send access.
4. Open any Google Sheets node like Create spreadsheet, choose Create new credential, and connect your Google account for Google Sheets OAuth2. Confirm access to create and edit spreadsheets.
5. Create an OpenAI API key in your OpenAI account. In n8n, open the Generate reply node, choose Create new credential, and paste the API key. Save the credential.
6. Open the Configure node. Set spreadsheetName and worksheetName. Set recipients to a list of emails or use a star to allow all. Adjust maxTokenSize and replyTokenSize if needed.
7. For a first run, leave spreadsheetId and worksheetId empty to let the flow create the sheet and store IDs. After it runs once, copy the created IDs into the Configure node to make the setup stable.
8. Click Execute workflow once, or send a test email to the connected Gmail inbox from an allowed recipient. Check that an AI reply is sent and a row is written to the sheet.
9. Open the email and click the feedback link. Confirm the thank you page appears and that the feedback row is recorded in Google Sheets.
10. If emails are too long and replies do not send, increase maxTokenSize or trim quoted threads. If replies seem cut off, raise replyTokenSize. If the sheet columns are missing, run once to create headers.
11. Review the Google Sheet to confirm email body, AI reply, UUID, and feedback are all stored in the same row group.