How to Automate Gmail Replies and Feedback Tracking?
Description
Handle inbound emails without manual typing. New emails trigger an AI reply and save the full exchange into Google Sheets. A feedback link lets people rate the reply, so you can learn and improve over time.
The flow starts with Gmail receiving a message. It parses the body, checks token limits, and uses OpenAI to draft a reply with a size cap. The reply goes back through Gmail with a feedback link that calls an n8n webhook and shows a thank you page. All details are logged to Google Sheets, including the email, the AI response, a unique ID, and any feedback. If a sheet does not exist, it creates one and stores its ID so future runs update the same sheet.
Setup is simple. Connect Gmail, Google Sheets, and OpenAI in n8n. Pick who should get replies with the recipients setting. You can leave the sheet fields empty for a first run to auto create the sheet, then store the IDs for future runs. Expect faster response times, a clean record of every exchange, and quick feedback you can use to tune messages for support teams and inbox managers.
Tools Required
What this workflow does?
- Gmail trigger checks for new emails and filters allowed recipients
- Advanced parser extracts clean message text from raw email content
- Token limit check prevents oversized inputs from breaking replies
- OpenAI generates a reply with a set max token size
- Gmail sends an HTML reply that includes a unique feedback link
- Webhook captures feedback and shows a thank you HTML page
- Google Sheets creates a sheet if missing and logs each exchange
- Global storage keeps the sheet ID so future runs update the same file
- UUID links each reply to the exact feedback record
- Safety paths skip sending if the reply is not complete or sender is blocked
What are the benefits?
- Reduce manual email replies from 60 minutes a day to 5 minutes
- Automate up to 80 percent of repetitive responses
- Keep a single source of truth for every email and reply in Google Sheets
- Capture real user feedback on replies to guide message tuning
- Handle higher email volume without adding staff
How to set this up?
- 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.
- You'll need accounts with Gmail, Google Sheets and OpenAI. See the Tools Required section above for links to create accounts with these services.
- In the n8n credentials manager, open the Gmail trigger node and the send email node. In the Credential to connect with dropdown, click Create new credential and follow the on screen steps to sign in with your Google account.
- Open the Google Sheets nodes. In the Credential to connect with dropdown, click Create new credential and connect your Google account so the workflow can create and update spreadsheets.
- Open the OpenAI node. Create a new credential and paste your API key from the OpenAI account API page. Name the credential clearly so you can reuse it later.
- Open the Configure node. Set recipients to a comma separated list of emails or use * to reply to all senders. Adjust maxTokenSize and replyTokenSize to match your model limits.
- If you want the workflow to auto create a sheet, leave spreadsheetId and worksheetId empty and set spreadsheetName and worksheetName. Run once to create and store these IDs.
- Send a test email to the Gmail inbox. Confirm the flow generates a reply, sends it back, and writes a new row to the Google Sheet.
- Click the feedback link in the reply. Verify you see the thank you page and that the feedback value appears in the same row in Google Sheets.
- If the email is too long and no reply is sent, increase replyTokenSize or trim the input text. Check the Is text within token limit path and the related sticky note for guidance.
- If no rows appear, confirm the Google Sheets credential has access to your drive and that the sheet name matches the Configure values. If the sheet ID in static data is stale, duplicate the workflow to reset stored IDs.
- Review the Only continue for specific emails filter. Update the recipients list if a sender should not receive automated replies.
Need help or want to customize this?
Ask in the Free Futurise Community.
Similar Templates
These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.
