Who is this for Product managers, customer success teams, and small business owners who collect feedback via Google Forms and want automated sentiment analysis without manual review. Ideal for teams processing 10-100+ responses weekly. What this workflow does This workflow reads new Google Forms responses from a linked Google Sheets spreadsheet, sends them to Gemini AI for sentiment analysis and topic categorization, then writes results back to the sheet, logs weekly insights in a Notion databas

Who is this for Product managers, customer success teams, and small business owners who collect feedback via Google Forms and want automated sentiment analysis without manual review. Ideal for teams processing 10-100+ responses weekly. What this workflow does This workflow reads new Google Forms responses from a linked Google Sheets spreadsheet, sends them to Gemini AI for sentiment analysis and topic categorization, then writes results back to the sheet, logs weekly insights in a Notion database, and emails an HTML summary report to your team. Each response gets a sentiment label (positive, neutral, negative), a 1-10 score, a category tag, and a key theme extraction. How to set up 1. Create a Google Form and link responses to a Google Sheet. Add four columns to the sheet: Processed, Sentiment, Category, Score. 2. Connect your Google Sheets OAuth2 credential and select the responses sheet. 3. Connect your Google Gemini API credential (requires a Google AI Studio API key). 4. Create a Notion database with columns: Date, Total Responses, Positive Rate, Top Themes, Recommendation. Connect your Notion API credential. 5. Connect your Gmail OAuth2 credential and set the recipient email address. 6. Activate the workflow. Requirements - Google Sheets OAuth2 credentials (linked to a Google Form) - Google Gemini API key (Google AI Studio) - Notion API integration token - Gmail OAuth2 credentials How to customize - Change the schedule trigger interval for more or less frequent analysis runs. - Edit the AI prompt in the Analyze feedback node to add custom categories relevant to your product. - Modify the email HTML template in the Parse results node to match your branding. - Add a Slack notification node after the email for real-time team alerts.
Download the workflow JSON file after purchase.
Open n8n → click the menu → Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.