Google Sheets Automation Workflows
3,636 ready-made Google Sheets workflows for n8n, Make, Zapier, Activepieces, and Pipedream. Spreadsheet-driven automations: logging, reporting, syncing rows to and from every tool in your stack.
Conversational Lead Capture with Gemini 2.0, Flash AI, and Google Sheets
## AI Lead Capture System - Complete Setup Guide ## Prerequisites - n8n instance (cloud or self-hosted) - Google AI Studio account (free tier available) - Google account for Sheets integration - Website with chat widget capability ## Phase 1: Core Infrastructure Setup **Step 1: Set Up Google AI Studio** - Go to Google AI Studio - Create an account or sign in with Google - Navigate to Get API Key - Create a new API key for your project - Copy and securely store the API key - Free tier limits: 15 requests/minute, 1 million tokens/month **Step 2: Configure Google Sheets** - Create a new Google Sheet for lead storage - Add column headers (exact names): - Full Name - Company Name - Email Address - Phone Number - Project Intent/Needs - Project Timeline - Budget Range - Preferred Communication Channel - How they heard about DAEX AI - Copy the Google Sheet ID from URL (between /d/ and /edit) - Ensure the sheet is accessible to your Google account **Step 3: Import n8n Workflow** - Open your n8n instance - Create a new workflow - Click ... menu → Import from JSON - Paste the provided workflow JSON - Workflow will appear with all nodes connected ## Phase 2: Credential Configuration **Step 4: Set Up Google Gemini API** - In n8n, go to Credentials → Add Credential - Search for Google PaLM API - Enter your API key from Step 1 - Test connection - Link to the Google Gemini Chat Model node **Step 5: Configure Google Sheets Access** - Go to Credentials → Add Credential - Select Google Sheets OAuth2 API - Follow OAuth flow to authorize your Google account - Test connection with your sheet - Link to the Google Sheets node ## Phase 3: Workflow Customization **Step 6: Update Company Information** - Open the AI Agent node - In the system message, replace all mentions of: - Company name and description - Service offerings and specializations - FAQ knowledge base - Typical project timelines and pricing ranges - Adjust conversation tone to match your brand voice **Step 7: Configure Lead Qualification Fields** - In the AI Agent system message, modify the required information list: - Add/remove qualification questions - Adjust budget ranges for your services - Customize timeline options - Update communication channel preferences - In Google Sheets node, update column mappings if you changed fields **Step 8: Set Up Sheet Integration** - Open Google Sheets node - Click on Document ID dropdown - Select your lead capture sheet - Verify all column mappings match your sheet headers - Test with sample data ## Phase 4: Website Integration **Step 9: Get Webhook URL** - Open Webhook node in n8n - Copy the webhook URL (starts with your n8n domain) - Note: URL format is https://your-n8n-domain.com/webhook/[unique-id] **Step 10: Connect Your Chat Widget** Choose your integration method: Option A: Direct JavaScript Integration ```javascript // Add to your website function sendMessage(message, sessionId) { fetch(YOUR_WEBHOOK_URL, { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ message: message, sessionId: sessionId || 'visitor-' + Date.now() }) }) .then(response => response.json()) .then(data => { // Display AI response in your chat widget displayMessage(data.message); }); } ``` Option B: Chat Platform Webhook - Open your chat platform settings (Intercom, Crisp, etc.) - Find the webhook/integration section - Add webhook URL pointing to your n8n endpoint - Configure to send message and session data Option C: Zapier/Make.com Integration - Create a new Zap/Scenario - Trigger: New chat message from your platform - Action: HTTP POST to your n8n webhook - Map message content and session ID ## Phase 5: Testing & Optimization **Step 11: Test Complete Flow** - Send a test message through your chat widget - Verify AI responds appropriately - Check conversation context is maintained - Confirm lead data appears in Google Sheets - Test with various conversation scenarios **Step 12: Monitor Performance** - Check n8n execution logs for errors - Monitor Google Sheets for data quality - Review conversation logs for improvement opportunities - Track response times and conversion rates **Step 13: Fine-tune Conversations** - Analyze real conversation logs - Update system prompts based on common questions - Add new FAQ knowledge to the AI agent - Adjust qualification questions based on lead quality - Optimize for your specific customer patterns ## Phase 6: Advanced Features (Optional) **Step 14: Add Lead Scoring** - Create a new column in Google Sheets for Lead Score - Update AI agent to calculate scores based on: - Budget range (higher budget = higher score) - Timeline urgency (sooner = higher score) - Project complexity (complex = higher score) - Add conditional formatting in Google Sheets to highlight high-value leads **Step 15: Set Up Notifications** - Add an email notification node after Google Sheets - Configure to send alerts for high-priority leads - Include lead details and conversation summary - Set up different notification rules for different lead scores **Step 16: Analytics Dashboard** - Connect Google Sheets to Google Data Studio
n8n$9.99Automate Daily Competitor Analysis with SerpAPI, Google Sheets, and Airtable
This workflow automates the process of gathering competitor information for companies listed in Google Sheets using SerpAPI, and logs the results in both Google Sheets and Airtable. It runs on a daily schedule, ensuring up-to-date insights without manual intervention.
n8n$9.99Automate Invoice Payment Reminders Using Google Sheets and Gmail
Streamline your invoicing process by automatically sending payment reminders for due or overdue invoices using Google Sheets and Gmail.
n8n$4.99Extract Business Email Addresses Using SerpApi and ScrapingBee from Google Sheets
# Lead Enrichment & Email Discovery from Google Sheets ## What this workflow does This template automates the enrichment of business leads from a Google Sheet by: * Triggering when a row is activated * Searching for company information with Serper.dev * Generating and validating potential contact pages * Scraping company pages with ScrapingBee * Extracting emails and updating the sheet * Marking rows as finished --- ## Prerequisites * Google Sheet with columns: `business type`, `city`, `state`, `activate` * **Copy the ready-to-use template:** [Sheet Template](https://docs.google.com/spreadsheets/d/1222vBxE2UBb1MK2xDMoQSd5WHQ7mA5Ew-W6vBgfCJs/edit?usp=sharing) * Google Sheets API credentials (from Google Cloud) * Serper.dev API key (free tier available) * ScrapingBee API key (free tier available) --- ## Inputs * **Google Sheet row:** Must include `business type`, `city`, `state`, `activate` * **Set Information Node:** `country`, `country_code`, `language`, `result_count` (can also be provided via columns in the sheet) --- ## Outputs * **Google Sheet update:** Company names, URLs, found email addresses (comma-separated if multiple), and status updates (`Running`, `Missing information`, `Finished`) --- ## Configuration Required * Connect Google Sheets node with your Google Cloud credentials * Add your Serper.dev API key to the HTTP Request node * Add your ScrapingBee API key to the scraping node * Adjust search and filtering options as needed --- ## How to customize the workflow * **Send `country`, `country_code`, and `result_count` from the sheet:** Add these as columns in your sheet and update the workflow to read their values dynamically, making your search fully configurable per row. * **Add more blacklist terms:** Update the code node with additional company names or keywords you want to exclude from the search results. * **Extract more contact details:** Modify the email extraction code to find other contact info (like phone numbers or social profiles) if needed.
n8n$14.99Generate Language Learning Flashcards with GPT-4, Telegram, and Google Sheets for Anki
## How it works - Use Telegram to send in new phrases (`flashcard front`) - You can also manually input phrases in the workflow itself - ChatGPT generates a provided phrase description (in English, but you can change it) including multiple meanings & generates examples of using the phrase in a sample sentence (`flashcard back`) ## Steps to setup - Provide your Telegram bot API key (optional) - Provide your OpenAI key - Provide Google Sheets credentials ## How to import flashcards from Google Sheets into Anki - Use the Google Sheets to Anki add-on: [1871608121](https://ankiweb.net/shared/info/1871608121) - In Anki, simply click `Sync Decks` and you're done :) Enjoy
n8n$9.99Automate Sentiment Analysis for Product Reviews with Google Sheets and OpenAI
Automatically analyze and classify product reviews by sentiment using Google Sheets and OpenAI, streamlining feedback management and enhancing customer insights.
n8n$4.99Generate SWOT Analysis Reports with OpenAI, Google Sheets & API Template PDF Export
### SWOT Analysis Generator that Produces PDF Reports In n8n Want to skip the manual work and instantly generate SWOT analyses for your business plans, investor decks, or strategy docs? This workflow lets you automate the entire SWOT (Strengths, Weaknesses, Opportunities, Threats) process—using AI and no-code tools! Whether you're using this for yourself or creating documents for clients, this workflow will save you hours of time and help identify the key components of growing any business. #### Tools We'll Be Using: - **OpenAI API**: Powers AI-driven extraction and generation of SWOT sections, introductions, conclusions, and more. - **n8n**: The no-code automation platform that orchestrates this workflow. - **Google Sheets**: Stores your company data and report outputs (download the provided SWOT Analysis template and fill it out). - **APItemplate.io**: Converts HTML reports into downloadable, multi-page PDFs. - **DeepSeek API** *(optional)*: An alternative to OpenAI for specific reasoning tasks. - **Gmail OAuth2**: Sends the final report via email. If you're building a business, doing client work, or just want faster strategic planning—this will save you HOURS. --- ### How It Works This n8n workflow transforms structured company data from a Google Sheet into a fully formatted, investor-grade SWOT report in both HTML and PDF formats. Here's the process in a few high-level steps: 1. **Load Data**: Pulls company information from the Company Info Input tab in the SWOT Analysis Google Sheet. 2. **AI Analysis**: Uses AI (via OpenAI or DeepSeek) to categorize data into Strengths, Weaknesses, Opportunities, and Threats, and generates detailed narrative sections for each. 3. **Create Report Sections**: Produces a strategic introduction, conclusion, table of contents, and title page using AI. 4. **Format and Combine**: Converts all sections into styled HTML and merges them into a single document. 5. **Generate PDF**: Converts the HTML into a polished, multi-page PDF using APItemplate.io. 6. **Save and Share**: Saves the report back to Google Sheets and emails the PDF to a specified recipient. The result is a professional, investor-ready SWOT report with minimal manual effort, ready for sharing or review. --- ### Setup Steps Setting up this workflow typically takes **15-30 minutes**, depending on your familiarity with the tools. Here's what you'll need to do: - **Configure Credentials**: Set up API keys and OAuth2 credentials for Google Sheets, OpenAI, APItemplate.io, Gmail, and optionally DeepSeek. - **Prepare Your Google Sheet**: Download the provided SWOT Analysis template, fill out the Company Info Input tab with your company data, and ensure it's accessible. - **Import the Workflow**: Copy the workflow JSON into your n8n instance and connect your credentials. **Detailed instructions** for each step, including credential setup and customization options, are available in the sticky notes within the workflow. Refer to these for step-by-step guidance. --- ### Benefits - **Efficiency**: Automates the entire SWOT report generation process, saving hours of manual work. - **Professional Output**: Delivers fully styled HTML and PDF reports with headings, paragraphs, and custom layouts. - **AI-Driven Insights**: Ensures clarity and relevance in every section through targeted AI analysis. - **Seamless Sharing**: Automatically saves reports to Google Sheets and emails them to stakeholders. This workflow is perfect for entrepreneurs, consultants, or strategists looking to streamline their SWOT analysis process and deliver high-quality, professional reports effortlessly.
n8n$24.99Automate Zillow Property Data Collection with Bright Data and Google Sheets
This workflow automates the extraction of Zillow property listings based on location and category using the Bright Data API, and stores the data in Google Sheets for easy access and analysis.
n8n$14.99Automate Lead Management from Fluentform to Google Sheets
Streamline the process of exporting leads and newsletter signups from Fluentform into Google Sheets, ensuring organized and up-to-date data management.
n8n$9.99Generate Personalized Cold Outreach Icebreakers with GPT-4 and Google Sheets
## Automated Personalized Email Icebreakers This workflow automates creating personalized email icebreakers. It reads leads from a Google Sheet, scrapes their company website, uses OpenAI to analyze the data and craft a unique opening line, and then saves that icebreaker back into the original sheet. ## How It Works - **Fetch Lead**: The workflow starts, loops through your leads, and pulls one from your Google Sheet. - **Scrape & Summarize**: It scrapes the lead's company website and uses a fast OpenAI model to summarize the key points about the company and the person. - **Generate Icebreaker**: This summary is then sent to a more powerful OpenAI model, which follows specific instructions to write a short, personalized icebreaker. - **Update Sheet**: The new icebreaker is saved back into the correct lead's row in your Google Sheet, using their email to match the record. --- ## Requirements - An n8n instance. - An OpenAI API key with available credits. - A Google account with a Sheet for your leads. - The Google Sheet must have columns for lead data (e.g., `Email`, `Website`, `Company Name`) and an empty column named `icebreaker`. - The `Email` column must be unique for each lead. --- ## Setup Instructions 1. **Add Credentials**: In n8n, add your OpenAI API key and connect your Google account via the **Credentials** menu. 2. **Configure Google Sheets Nodes**: Select each of the two Google Sheets nodes (`Client data` and `Add icebreaker to sheet`). In each, choose your credential, select your spreadsheet and the specific sheet name, and ensure the column mapping is correct. 3. **Configure OpenAI Nodes**: Select both OpenAI nodes (`Summarizing prospect data` and `Creating icebreaker`) and choose your OpenAI credential from the dropdown. 4. **Verify Update Node**: On the final `Add icebreaker to sheet` node, ensure the **Operation** is set to `Append Or Update` and the **Matching Columns** field is set to `Email`. --- ## Customization Options - **Trigger**: Change the manual start to an automatic trigger, like when a new row is added to the sheet or on a daily schedule (Cron). - **AI Prompt**: Modify the prompt in the Creating icebreaker node to change the tone, style, or length of the output. - **AI Model**: Experiment with different OpenAI models (like `gpt-4`) for a different balance of cost, speed, and quality. - **Data Source**: Replace Google Sheets with a CRM like HubSpot or a database like Postgres.
n8n$9.99Automate Company Data Enrichment from ZoomInfo to Google Sheets
This workflow enriches company domain lists with detailed business information from ZoomInfo, organizing the data in Google Sheets for sales and research purposes.
n8n$14.99Automate Image Background Removal and Log Results in Google Sheets
Streamline your image processing workflow by automatically removing backgrounds using AI and logging the results in Google Sheets for easy tracking.
n8n$14.99Automate Restaurant Orders with AI Recommendations via Google Sheets and Telegram
Streamline restaurant order processing by automatically triggering workflows on new orders, extracting data from Google Sheets, using Gemini AI for dish recommendations, and sending personalized suggestions through Telegram.
n8n$14.99Automate Server Uptime Monitoring with Google Sheets and Email Alerts
This workflow automates server uptime monitoring by pinging servers listed in a Google Sheet every minute. It logs server status and sends email alerts if any server is down, ensuring you stay informed about server health without manual checks.
n8n$4.99Automate SEO Metrics Collection with Moz API and Google Sheets
This n8n workflow automates the collection of SEO metrics such as Domain Authority (DA) and Page Authority (PA) using the Moz API, storing the results in Google Sheets for seamless tracking and analysis.
n8n$9.99Automate Video Publishing Across Multiple Social Platforms from Google Sheets
This workflow automates the distribution of video content from Google Sheets to various social media platforms using the Blotato API. It efficiently manages video uploads and posts across Instagram, Facebook, LinkedIn, TikTok, YouTube, Threads, Twitter, Bluesky, and Pinterest, including AI-generated images for Pinterest.
n8n$14.99Automate Vendor Risk Evaluation with AI and Google Sheets
Streamline the vendor onboarding process by automating risk evaluation, documentation, and alerts using AI and Google Sheets.
n8n$4.99Automate AWS EC2 Instance Launch from Google Sheets
This n8n workflow automates the process of launching AWS EC2 instances based on data specified in a Google Sheets document. It extracts instance details, validates inputs, launches the instance via AWS API, updates the sheet with instance information, and sends confirmation emails.
n8n$4.99Automate CV Processing from Google Drive to Google Sheets with Slack Notifications
Streamline your recruitment process by automatically extracting and organizing candidate information from resumes in Google Drive, updating Google Sheets, and notifying your team via Slack.
n8n$14.99Automate Gmail Metadata Extraction to Google Sheets
Automatically extract and store metadata from new Gmail emails into Google Sheets for efficient record-keeping and workflow automation.
n8n$4.99Automate YouTube Video Summarization with Google Sheets and AI
Effortlessly convert YouTube videos into concise summaries using Google Sheets, Supadata.ai, and DeepSeek AI. Ideal for content creators, researchers, and educators.
n8n$9.99Track Student Arrival with iOS Automation, Google Sheets & Email Alerts
This workflow automates **real-time student tracking** using **iOS Shortcuts and geolocation data**, notifying both **teachers and parents** based on geofenced logic. ## What This Workflow Does - Receives student **location updates via webhook** (iOS Shortcuts) - Detects if the student has **arrived at school** - Logs arrival data to Google Sheets - **Sends email alerts** to teachers and/or parents based on location ## Workflow Steps | Step | Description | | --------------------------- | -------------------------------------------------------- | | **Location Update Webhook** | Triggered via iOS Shortcut when student location updates | | **Process Location Data** | Extracts coordinates and metadata | | **Student Arrived?** | Checks if student entered school zone | | **Log School Arrival** | Adds arrival data to Google Sheet | | **At School?** | Double-checks geofence condition before notifying | | **Notify Teacher** | Sends email if student is confirmed at school | | **Notify Parent** | Sends email to parent (can vary based on geofence logic) | | **Success Response** | Returns a 200 response to the triggering device | ## How the Logic Works 1. The student's phone runs a shortcut when near school. 2. Sends coordinates to webhook. 3. Workflow compares coordinates with predefined geofence (e.g., radius around school). 4. If inside school zone: * Log arrival * Notify teacher and/or parent 5. Else: * Optionally notify parent only ## iOS Shortcut Sample (Trigger Setup) - **Automation Trigger**: Arrive at Location (e.g., School) - **Action**: Run Shortcut → Make Web Request (POST) **POST URL:** ``` https://your-n8n-instance.com/webhook/location-update ``` **Body Example:** ```json { "student_id": "SU042", "student_name": "Anaya Joshi", "lat": 19.0760, "lng": 72.8777, "timestamp": "2025-08-06T08:05:00" } ``` ## Google Sheets Logging | Student ID | Name | Date | Time | Status | | ---------- | ----------- | ---------- | ----- | ------- | | SU042 | Anaya Joshi | 2025-08-06 | 08:05 | Arrived | ## Setup Requirements - **n8n Instance** with webhook support - **Google Sheet** with appropriate columns - **iOS Shortcut** setup on student device - **Teacher and Parent Email Addresses** configured in workflow
n8n$9.99Automate Raw Materials Inventory Management with Google Sheets and Supabase
Streamline your raw materials inventory management by automating stock updates, approvals, and low stock alerts using Google Sheets, Supabase, and Gmail integrations in n8n.
n8n$19.99Automate Viral YouTube Video Analysis and Export to Google Sheets
Effortlessly analyze YouTube videos for viral potential by evaluating engagement metrics and export the results to Google Sheets for easy review and sharing.
n8n$14.99
More integrations
Custom AI Systems & Services
Our team of experienced AI builders will help build custom AI systems, workflows, and solutions.
Request Custom Work