Collect customer comments, score the tone with AI, and store everything in Google Sheets in real time. Great for support and product teams that want quick insight into how customers feel without reading every line. You get an instant log you can filter and chart for trends.

The flow starts with a simple web form that asks for name, topic, and feedback. The text is sent to an AI step that classifies sentiment using a clear prompt. A merge step then joins the form details with the AI result so each entry has both the message and the sentiment label. A Google Sheets action appends a new row with category, sentiment, timestamp, entered by, and customer name. The form shows a friendly confirmation after submit, so users know their input is saved.

Setup is light. You only need a Google Sheets account and an OpenAI API key. Map the fields to a sheet that has the same column headers and share it with the connected Google account. Expect faster triage of feedback, cleaner data for reporting, and less manual tagging. Use it for product reviews, post service follow ups, or internal beta notes where quick sentiment checks matter.

• Web form trigger collects name, category, and feedback text
• OpenAI classifies the sentiment of each comment using a clear prompt
• Merge step combines the AI result with the original form data
• Google Sheets append adds category, sentiment, timestamp, entered by, and customer name to a new row
• Confirmation message tells users their response was recorded
• Timestamp capture supports reporting and trend analysis

• Reduce manual tagging from 1 hour per 100 comments to 5 minutes
• Automate up to 90 percent of sentiment labeling
• Improve data quality by 30 percent with consistent fields
• Handle 10 times more feedback entries without extra staff
• Connect AI and Google Sheets seamlessly 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 will need accounts with Google Sheets and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. Open the Form Trigger node and review the fields for Name, What is your feedback about, and Your feedback. Save your changes.
4. In Google Sheets, create a spreadsheet with headers: Category, Sentiment, Timestamp, Entered by, and Customer Name. Share the sheet with the Google account you will connect in n8n.
5. Connect Google Sheets: double click the Google Sheets node, choose Credential to connect with, click Create new credential, then follow the on screen steps to sign in and approve access.
6. Set the Document ID and Sheet name in the Google Sheets node. Confirm the field mappings line up with your column headers.
7. Connect OpenAI: double click the OpenAI node, choose Credential to connect with, click Create new credential, paste your OpenAI API key from the API page, and add your Organization ID if your account requires it.
8. Review the OpenAI prompt for sentiment classification. Keep it as is or adjust wording if you want specific labels like Positive, Neutral, or Negative.
9. Test the form: click Execute on the form node or open the public form URL. Submit a sample with a short comment.
10. Check the Merge node output in n8n to confirm the sentiment text appears along with the original form fields.
11. Open your Google Sheet and confirm a new row was added with category, sentiment, timestamp, entered by, and customer name.
12. Activate the workflow and share the form link with your team or customers.
13. Troubleshooting: if no row appears, verify the sheet ID and sharing permissions. If OpenAI fails, check your API key and usage limits. If columns do not match, update the Google Sheets node mapping to your header names.