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.
Automate Reddit Lead Generation with AI and Google Sheets Integration
This n8n workflow identifies high-quality business leads from Reddit by analyzing posts in targeted subreddits, leveraging AI for insights, and storing results in Google Sheets.
n8n$14.99Automate Sentiment Analysis of Google Sheets Feedback with ChatGPT
Automatically analyze customer feedback stored in Google Sheets using ChatGPT to determine sentiment, enhancing your data insights with AI.
Make$3.99Automate Instagram Comment Responses with Google Sheets & CRM
Monitors Instagram comments via Graph API, sends keyword-based auto-responses from Google Sheets, and logs interactions for CRM tracking. Saves time on social engagement while nurturing leads.
n8n$24.99Automate Company Data Enrichment in Google Sheets Using Explorium MCP
This n8n workflow automatically enriches company data in Google Sheets by integrating with Explorium MCP. It updates your spreadsheet with firmographic details like business ID, NAICS code, employee range, and revenue range.
n8n$9.99Automate Business Card Digitization and Enrichment with OCR and Google Sheets
This n8n workflow automates the digitization of business cards using Typhoon OCR, enriches the extracted data, and saves it to Google Sheets or a CRM. It supports both Thai and English cards and can optionally send greeting emails.
n8n$14.99Automate UX Interview Transcription and Analysis with OpenAI and Google Sheets
Streamline the process of analyzing UX interviews by automatically transcribing audio files with OpenAI and exporting the insights to Google Sheets.
n8n$9.99Automate SEO Meta Tag Optimization with Google Sheets and Google Gemini
This workflow automates the process of optimizing SEO meta titles and descriptions directly from Google Sheets using Google Gemini. It ensures that meta tags are concise and meet SEO standards.
n8n$9.99Sync Monday.com Updates to Google Sheets Automatically
Automatically sync updated items from Monday.com to Google Sheets by creating new rows or updating existing ones every 15 minutes.
Make$3.99Analyze Hacker News for Business Insights Using AI and Google Sheets
This n8n workflow monitors top Hacker News posts to identify business-related pain points using AI, and logs results into Google Sheets for further analysis.
n8n$14.99Automate Meeting Minutes Distribution via Google Sheets and Gmail
Streamline your meeting minutes distribution by automatically sending summaries via Gmail from notes stored in Google Sheets.
n8n$4.99Automate Revenue Forecasting with Stripe, OpenAI, and Google Sheets
Leverage AI to transform Stripe sales data into actionable 3-month revenue forecasts, stored in Google Sheets and Supabase.
n8n$14.99Automate LinkedIn Content Creation from Reddit Discussions Using GPT-4 and Google Sheets
This workflow is designed for marketers and content strategists to transform Reddit discussions into LinkedIn post ideas. It leverages GPT-4 to extract insights and generates content ideas, which are then organized in Google Sheets for easy access.
n8n$14.99Automate SEO Keyword Analysis with RapidAPI and Log to Google Sheets
## **Automated Keyword Analysis and Google Sheets Logging** Automate keyword research with n8n and log essential SEO data like search volume, trends, competition, and keyword difficulty directly into Google Sheets. Simplify your SEO efforts with real-time insights. ## Node-by-Node Explanation ### 1. **On form submission (Trigger)** - **Purpose:** Triggers the workflow when a user submits the form with country and keyword as inputs. - **Explanation:** This node initiates the process by accepting user input from the form and passing it to the next node for analysis. ### 2. **Keyword Analysis (HTTP Request)** - **Purpose:** Sends a request to an external SEO API to analyze the provided keyword, fetching data like search volume, trends, and competition. - **Explanation:** This node calls the [**Keyword Research Tool API**](https://rapidapi.com/skdeveloper/api/keyword-research-tool3) with the country and keyword inputs from the form, retrieving essential keyword data for further processing. ### 3. **Re-format output (Code)** - **Purpose:** Processes and reformats the API response into a structured format suitable for logging into Google Sheets. - **Explanation:** Extracts and organizes the keyword data (e.g., competition, CPC, search volume) into a format that can be easily mapped to Google Sheets columns. ### 4. **Google Sheets (Append)** - **Purpose:** Appends the reformatted keyword data into the specified Google Sheets document. - **Explanation:** Logs the fetched keyword insights into a Google Sheets document, allowing for continuous tracking and analysis. --- ## **Benefits of This Workflow** - **Automated Keyword Research:** Eliminates manual keyword research by automating the entire process using the [**Keyword Research Tool API**](https://rapidapi.com/skdeveloper/api/keyword-research-tool3). - **Real-time Data Tracking:** Fetches up-to-date SEO metrics from the [**Keyword Research Tool API**](https://rapidapi.com/skdeveloper/api/keyword-research-tool3) and logs them directly into Google Sheets for easy access and analysis. - **Efficient Workflow:** Saves time by integrating multiple tools (form, SEO API, Google Sheets) into one seamless process. - **SEO Insights:** Provides detailed insights like search volume, trends, competition, and keyword difficulty, aiding in strategic decision-making with the help of the [**Keyword Research Tool API**](https://rapidapi.com/skdeveloper/api/keyword-research-tool3). --- ## **Use Case** This workflow is ideal for digital marketers, SEO professionals, and content creators who need to analyze keyword performance and track essential SEO metrics efficiently. It automates the process of keyword research by calling the [**Keyword Research Tool API**](https://rapidapi.com/skdeveloper/api/keyword-research-tool3), fetching relevant data, and logging it into Google Sheets. This makes it easier to monitor and optimize SEO strategies in real-time.
n8n$9.99Automate Go4Clients DRIP Campaigns for New Google Sheets Entries
Trigger a Go4Clients DRIP campaign, including calls, SMS, and emails, whenever a new row is added to a Google Sheets spreadsheet. This automation facilitates immediate engagement with potential customers, enhancing sales opportunities.
Make$2.99Automate Google Maps Data Extraction to Google Sheets and Excel
Streamline the process of gathering business data from Google Maps using SerpAPI and export it directly to Google Sheets and Excel. Ideal for marketers and researchers needing efficient data collection.
n8n$9.99Automate Shipment Tracking and Customer Notifications via Google Sheets and WhatsApp
This workflow automates the tracking of shipments using Delhivery and DHL APIs, updates Google Sheets, and sends notifications to customers via WhatsApp and email when shipment statuses change.
n8n$9.99Automate Jura Coffee Machine Usage Logging with Webhook and Google Sheets
Automatically log coffee usage from your Jura E8 espresso machine using a webhook and Google Sheets. This workflow captures data via Bluetooth and appends it to a Google Sheet for easy tracking and analysis.
n8n$9.99Automate Address Geocoding with Google Sheets and Google Maps API
Effortlessly convert addresses into latitude and longitude coordinates using Google Sheets and the Google Maps API, ideal for applications like delivery routing and market analysis.
n8n$4.99Lead Enrichment Pipeline: Leadfeeder to Apollo to Google Sheets
## What This Does This automation creates a seamless daily pipeline that: - **Pulls** yesterday's website visitors from Leadfeeder - **Enriches** company data using Apollo.io's powerful database - **Delivers** enriched leads to your Google Sheets with smart deduplication - **Alerts** your team via Telegram when something needs attention  ## Why Automate Your Lead Enrichment? **Reclaim Your Time** Stop the copy-paste busywork. **Never Miss a Hot Lead** Automatically captures yesterday's visitors and enriches. **Enable Faster Outreach** Enriched records mean your SDRs can reach out the same day with full context - faster follow-up leads to higher conversion rates. **API-Friendly Design** Built-in pagination, rate limiting (40s delay), and smart stop logic prevent API throttling and account issues. ## Perfect For These Teams **Growth Marketers** Maintain a daily pipeline of enriched accounts for targeted campaigns and ABM strategies. **Sales Ops & SDR Managers** Ensure your reps start each day with high-quality, enriched leads in a shared workspace. **Data & BI Teams** Create a lightweight source-of-truth for lead activity without building complex EL pipelines. ## Workflow Overview ``` Daily Trigger (9 AM) → Fetch Account → Generate Pages → Retrieve Leads → Enrich with Apollo → Update Google Sheets → Send Alerts ``` **Trigger** Runs automatically every day at 9:00 AM server time **Process Flow** 1. Fetch your Leadfeeder Account ID 2. Generate smart pagination (up to 50 pages with safety cap) 3. Retrieve yesterday's leads in batches of 100 4. Split and process individual records 5. Enrich each company using Apollo's database 6. Append or update rows in Google Sheets with deduplication **Smart Logic** - Pre-generates page sequences with safety limits - Stops automatically when pages return <100 results - Normalizes website URLs and handles Apollo field fallbacks - Implements intelligent rate limiting to respect API limits **Output** - Clean, enriched data in your Google Sheets - Telegram alerts for any workflow errors - Automatic deduplication using ID matching ## Quick Setup Guide ### 1. Import & Configure Import the JSON workflow file to your n8n instance ### 2. Add Your Credentials Set up these integrations in n8n: - **Leadfeeder**: HTTP Header Auth with Bearer token - **Apollo**: HTTP Header Auth with API key - **Google Sheets**: OAuth2 with edit permissions - **Telegram**: Bot Token + Chat ID for alerts ### 3. Update Sheet Configuration - Replace `documentId` with your Google Sheets URL or from list - Set correct `sheetName` (gid) in Google Sheets nodes - Verify column mapping matches your sheet structure ### 5. Test Your Setup Run a test with yesterday's date to confirm: - Leads are retrieved from Leadfeeder - Apollo enrichment populates correctly - Rows append/update in Google Sheets - Telegram alerts work for errors ## Level Up Your Automation ### CRM Integration Push enriched leads directly into HubSpot, Salesforce, or Pipedrive for automatic sequences and follow-up campaigns. ### Daily Intelligence Reports Add Slack or email summaries highlighting high-value accounts by revenue, employee count, or industry vertical. ### Smart Routing Route leads to specific team members based on company size, industry, or geographic location. ## Data Flow Structure Each lead goes through this enrichment pipeline: 1. **Raw Lead**: Company name, website, visit data from Leadfeeder 2. **Apollo Enrichment**: Industry, size, revenue, contact info, social profiles 3. **Sheet Update**: Merged data with smart deduplication and timestamp tracking ## Support **Created by:** [Khaisa Studio](https://khaisa.studio) **Support:** [Contact for Custom Work](https://khaisa.studio/pages/contact) **Category:** Sales Automation, Lead Generation, Data Enrichment **Tags:** `lead-generation`, `leadfeeder`, `apollo`, `google-sheets`, `lead-enrichment`, `sales-automation`
n8n$14.99Automate LinkedIn Company Profile Scraping to Google Sheets
This workflow automates the process of scraping LinkedIn company profiles and storing the data in Google Sheets. It captures comprehensive company information, employee details, and related profiles.
Make$2.99Capture and Store Website Screenshots from Google Sheets to Drive Using Dumpling AI
## ➤ What this workflow does This workflow captures a full-page screenshot of any website added to a Google Sheet and automatically uploads the screenshot to a designated Google Drive folder. It uses Dumpling AI's screenshot API to generate the image and manages file storage through Google Drive. --- ## ☀ Who is this for This is ideal for: - Marketers and outreach teams capturing snapshots of client or lead websites - Lead generation specialists tracking landing page visuals - Researchers or analysts who need to archive website visuals from URLs - Anyone looking to automate website screenshot collection at scale --- ## “ Requirements - A **Google Sheet** with a column labeled `Website` where URLs will be added - **Dumpling AI** API access for screenshot capture - A connected **Google Drive** account with an accessible folder to store screenshots --- ## ℹ How to set up 1. Replace the Google Sheet and folder IDs in the workflow with your own. 2. Connect your Dumpling AI and Google credentials in n8n. 3. Make sure your sheet contains a `Website` column with valid URLs. 4. Activate the workflow to begin watching for new entries. --- ## ❁ How it works (Workflow Steps) 1. **Watch New Row in Google Sheets**: Triggers when a new row is added to the sheet. 2. **Request Screenshot from Dumpling AI**: Sends the website URL to Dumpling AI and gets a screenshot URL. 3. **Download Screenshot**: Fetches the image file from the returned URL. 4. **Upload Screenshot to Google Drive**: Uploads the file to a selected folder in Google Drive. --- ## ⠏ Customization Ideas - Add timestamped filenames using the current date or domain name - Append the Google Drive URL back to the same row in the sheet for easy access - Extend the workflow to send Slack or email notifications when screenshots are saved - Add filters to validate URLs before sending them to Dumpling AI
n8n$4.99Automate Google Sheets Duplication and Data Enrichment
This workflow automates the process of duplicating Google Sheets and enriching data by transferring content from a master spreadsheet to a newly created one. It ensures consistent formatting and structure across multiple sheets.
n8n$9.99Alert on Equipment Health Issues with Google Sheets and MS Teams Integration
# Advanced Equipment Health Monitor with MS Teams Integration (n8n | API | Google Sheets | MS Teams) This n8n workflow automatically monitors equipment health by fetching real-time metrics like temperature, voltage, and operational status. If any of these parameters cross critical thresholds, an alert is instantly sent to a Microsoft Teams channel and the event is logged in Google Sheets. The workflow runs every 15 minutes by default. ## Quick Implementation Steps 1. **Import the workflow JSON** into your n8n instance. 2. **Open the Set Config node** and update: - API endpoint - Teams webhook URL - Threshold values - Google Sheet ID 3. **Activate the workflow** to start receiving alerts every 15 minutes. ## Who's It For - Renewable energy site operators (solar, wind) - Plant maintenance and operations teams - Remote infrastructure monitoring services - IoT-integrated energy platforms - Enterprise environments using Microsoft Teams ## Requirements | Tool | Purpose | |------|---------| | n8n Instance | To run and schedule automation | | HTTP API | Access to your equipment or IoT platform health API | | Microsoft Teams | Incoming Webhook URL configured | | Google Sheets | Logging and analytics | | SMTP (optional) | For email-based alternatives or expansions | ## What It Does - **Runs every 15 minutes** to check the latest equipment metrics. - **Compares values** (temperature, voltage, status) against configured thresholds. - **Triggers a Microsoft Teams message** when a threshold is breached. - **Appends the alert data** to a Google Sheet for logging and review. ## Workflow Components - **Set Node:** Configures thresholds, endpoints, webhook URL, and Sheet ID. - **Cron Node:** Triggers the check every 15 minutes. - **HTTP Request Node:** Pulls data from your equipment health monitoring API. - **IF Node:** Evaluates if conditions are within or outside defined limits. - **MS Teams Alert Node:** Sends structured alerts using a Teams incoming webhook. - **Google Sheets Node:** Logs alert details for recordkeeping and analytics. ## How To Set Up - Step-by-Step 1. **Import Workflow:** - In n8n, click **Import** and upload the provided `.json` file. 2. **Update Configurations:** - Open the **Set Config** node. - Replace the placeholder values: - `apiEndpoint`: URL to fetch equipment data. - `teamsWebhookUrl`: Your MS Teams channel webhook. - `temperatureThreshold`: Example = 80 - `voltageThreshold`: Example = 400 - `googleSheetId`: Google Sheet ID (must be shared with n8n service account). 3. **Check Webhook Integration:** - Ensure your MS Teams webhook is properly authorized and points to a live channel. 4. **Run & Monitor:** - Enable the workflow and view logs/alerts. - Adjust thresholds as needed. ## How To Customize | Customization | How | |---------------|-----| | Add more parameters (humidity, pressure) | Extend the HTTP + IF node conditions | | Change alert frequency | Edit the Cron node | | Use Slack or Email instead of Teams | Replace MS Teams node with Slack or Email node | | Add PDF Report Generation | Use HTML to PDF node and email the report | | Export to Database | Add a PostgreSQL or MySQL node instead of Google Sheets | ## Add-ons (Advanced) | Add-on | Description | |--------|-------------| | Auto-ticketing | Auto-create issues in Jira, Trello or ClickUp for serious faults | | Dashboard Sync | Send real-time logs to BigQuery or InfluxDB | | Predictive Alerts | Use machine learning APIs to flag anomalies | | Daily Digest | Compile all incidents into a daily summary email or Teams post | | Mobile Alert | Integrate Twilio for SMS alerts or WhatsApp notifications | ## Example Use Cases 1. Monitor solar inverter health for overheating or voltage drops. 2. Alert field engineers via Teams when a wind turbine sensor fails. 3. Log and visualize hardware issues for weekly analytics. 4. Automate SLA compliance tracking through timely notifications. 5. Ensure distributed infrastructure (e.g., substations) are always in operational range. ## Troubleshooting Guide | Issue | Possible Cause | Solution | |-------|----------------|----------| | No Teams alert | Incorrect webhook URL or formatting | Recheck the Teams webhook and payload | | Workflow not triggering | Cron node misconfigured | Ensure it's set to run every 15 mins and workflow is active | | Google Sheet not updating | Sheet ID is wrong or not shared | Share Sheet with your n8n Google service account | | No data from API | Endpoint URL is down or wrong | Test the endpoint manually with Postman or browser | --- ## Need Assistance? Need help tailoring this to your exact equipment type or expanding the workflow? Contact WeblineIndia - Expert automation partners for renewable energy, infrastructure, and enterprise workflows.
n8n$4.99Automate Website Funnel Analysis with AI and Google Sheets
This workflow automates the analysis of website conversion funnels using AI and data scraping tools, providing insights into optimization opportunities and user journey performance.
n8n$9.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