Collect customer feedback, score its sentiment with AI, and save everything into a single Google Sheet. Ideal for support and product teams that need quick insights and a simple place to review feedback. The result is a clean list that is easy to sort, filter, and share.

A form collects the customer name, the topic of the feedback, and the message. The text is sent to OpenAI to classify the sentiment using a clear prompt. A merge step combines the original form data with the AI result. The Google Sheets node then appends a new row with category, sentiment, timestamp, entered by, and customer name. Teams can track trends, spot urgent issues, and plan follow ups without manual copy and paste.

Setup is simple. Connect a Google account for Sheets and add your OpenAI API key. Use the sample sheet or copy its headers into your own sheet, then publish the form and submit a test. Expect faster response cycles, less data entry, and better visibility of customer mood. Great for post purchase feedback, support follow up, and product release surveys.

• Public form collects Name, Category, and Feedback with a confirmation message after submit.
• OpenAI node classifies sentiment from the feedback text using a simple prompt.
• Merge node combines the AI result with the original form fields so all data stays together.
• Google Sheets append adds a new row with category, sentiment, timestamp, entered by, and customer name.
• Column mapping aligns fields to the sheet headers for clean, consistent records.

• Reduce manual logging from 60 minutes a day to 5 minutes
• Improve data quality by up to 90 percent by removing copy paste
• Shorten customer response time from days to hours
• Handle 10 times more feedback without extra staff
• Connect OpenAI and Google Sheets in one flow for unified tracking

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 Google Sheets and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. Open the Form Trigger node. Review the form title, description, and fields. Keep Name required, keep Category as a dropdown, and keep Your feedback as a long text field.
4. Double click the OpenAI node. In the 'Credential to connect with' dropdown, click 'Create new credential', then follow the on screen instructions to integrate that service. Paste your OpenAI API key from the OpenAI account API page. Add your organization ID if your account requires it. Save and test the credential.
5. Double click the Google Sheets node. In the 'Credential to connect with' dropdown, click 'Create new credential', then follow the on screen instructions to integrate that service. Sign in to your Google account and grant access to Google Sheets. Name the credential clearly, then save and test.
6. In the Google Sheets node, replace the document ID with your own sheet. Confirm the sheet name points to Sheet1 or your chosen tab. Ensure headers match the mapped columns: Category, Sentiment, Timestamp, Entered by, Customer Name.
7. If you use the sample sheet, make a copy to your Google Drive and confirm you can edit it. Update the node to reference your copy.
8. Check the Merge node is set to combine and multiplex so it receives items from both the Form Trigger and the OpenAI node.
9. Click Execute node on the Form Trigger to open the public form URL. Submit a test entry. Confirm you see the success message.
10. Open your Google Sheet and verify a new row appears with the right fields and the AI sentiment text. If nothing appears, recheck the sheet ID, tab name, and column headers.
11. Troubleshooting: If OpenAI returns an error, verify your API key and that your account has credit. If the sheet write fails, ensure your Google credential is connected and the sheet is not protected. If the sentiment lands in the wrong column, align header names to the node mapping and try again.