Analyze Google Forms feedback with Gemini AI and send weekly reports
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
At a glance
Analyze Google Forms feedback with Gemini AI and send weekly reports is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Slack, Notion, Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Slack, Notion, Google Sheets, Gemini
- Modules
- 9
- Price
- Free
- Version
- v1.0

About this workflow
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.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Create a Brand Strategy with ChatGPT and Notion
Scrap prices from any page with HTML/CSS, Cloud Vision and MonkeyLearn
Track daily brand mentions from Hacker News to Slack with GPT-4o-mini sentiment analysis
BrowserAct Capterra Alternative Finder
The title is very good, clearly conveying the template's purpose while mentioning key technologies
Extract and process healthcare claims with VLM Run, Google Drive and Sheets
Send personalized LinkedIn connection requests with Google Sheets and Unipile
Generate Twitter content in personal style with OpenAI & Supabase RAG
Reviews
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.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you