AutomationMart
Home/Browse/Analyze Google Forms feedback with Gemini AI and send weekly reports
n8n

Analyze Google Forms feedback with Gemini AI and send weekly reports

n8nn8n9 modulesv1.0
GmailSlackNotionGoogle SheetsGemini

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
Analyze Google Forms feedback with Gemini AI and send weekly reports workflow diagram

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.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

Develop a dynamic brand strategy with the help of ChatGPT’s AI analysis, integrated with Notion’s organizational tools. This setup enables you to map out and adjust your strategy with precision and ease. Estimated number of ChatGPT tokens used by this template: 4,000 tokens for prompts and 1,000 tokens for a completion. What are tokens and how to count them?

Free

Scrap prices from any page with HTML/CSS, Cloud Vision and MonkeyLearn

This template helps you perform data mining on on a website at regular intervals. First, a screenshot of the url is taken via HTML/CSS. Then, the screenshot's text is recognized with Google Cloud Vision (OCR) and the price is automatically extracted with a MonkeyLearn machine learning model. Eventually, the result is stored in Google Sheets.

Free

Track daily brand mentions from Hacker News to Slack with GPT-4o-mini sentiment analysis

Description Monitor daily brand visibility and reputation with an automated AI-powered mention tracker. 🔍🤖 This workflow checks Hacker News every morning for new stories matching your brand keyword, classifies each mention’s sentiment and urgency using GPT-4o-mini, and delivers a clean daily summary to Slack. If no mentions are found, the workflow sends a simple “no mentions today” update instead—ensuring your team is always informed without manual monitoring. Perfect for reputation tracking, co

Free

BrowserAct Capterra Alternative Finder

This template automates software-alternative research using Capterra. The user sends a product name through Telegram, and the scenario identifies the intent using Make AI Toolkit. BrowserAct then visits the Capterra product page, enters the product name, opens the corresponding result, scrolls to the alternatives section, and extracts structured data from both “Top Alternatives” and “All Alternatives.” The scraped information includes product titles, pricing, free-trial options, satisfaction sco

Free

The title is very good, clearly conveying the template's purpose while mentioning key technologies

How it works - Collects articles from your preferred RSS feeds. - Rates and tags each article using an AI model (e.g., QWEN 14B-s4), filtering for relevance and quality. - Summarizes high-rated articles with a language model (e.g., Gemma3 4B) for quick, digestible reading. - Checks for duplicates to avoid sending the same article twice. - Formats and sends the top articles as an HTML newsletter via Gmail, using OAuth2 authentication. - Stores records in a Postgres database, tracking which a

Free

Extract and process healthcare claims with VLM Run, Google Drive and Sheets

Automatically process healthcare claims into structured Google Sheets entries with VLM Run extraction What this workflow does Monitors Google Drive for new files in a target folder Downloads the file inside n8n for processing Sends the file to VLM Run for AI transcription or analysis Fetches extra details from the healthcare.claims-processing domain as JSON Appends normalized fields to a Google Sheet as a new row Setup Prerequisites: Google account, VLM Run API creden

Free

Send personalized LinkedIn connection requests with Google Sheets and Unipile

Send personalized LinkedIn connection requests automatically using n8n, Google Sheets, and Unipile — with built-in safety limits, duplicate prevention, and full invitation tracking. --- Scale your LinkedIn outreach without manually sending a single connection request. This workflow reads your leads from a Google Sheet, filters out already-contacted prospects, and sends each one a personalized connection note via LinkedIn — automatically, on a schedule, and safely within LinkedIn's limits. Built

Free

Generate Twitter content in personal style with OpenAI & Supabase RAG

Self-Learning X Content Engine (Creator RAG Booster) Learn your voice. Generate posts that sound like you — not AI. 🧩 Overview This n8n workflow builds a personal RAG (Retrieval-Augmented Generation) system for creators. It learns from your own past posts and generates new tweets, replies, and image prompts in your tone. ⚙️ How it works Step 1 — Ingest - Use the “Add to KB” Form to upload your past posts or notes. - Text + metadata (topic, style) are stored in Supabase as vectors. Step 2 — Gene

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free