Google Sheets Automation Workflows
3,632 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 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.99Auto-Generate Product Comparison Pages with OpenAI & Google Sheets
## Auto-generate product comparison pages that help users buy faster This workflow creates detailed X vs Y product comparison pages designed to help readers make faster, more confident purchase decisions - all with zero manual writing. --- ### How it works - Triggered manually or via Google Sheets row - Takes two product names as input (e.g., "Notion vs Evernote") - Uses AI to generate: - A compelling title and meta description - Clear feature-by-feature comparison - Use-case-based recommendations - An FAQ section tailored to user pain points - Saves each section into a Google Sheet for review or publishing - Final output can be exported to your CMS or website builder (like Dorik, Webflow, etc.) --- ### Set up steps - You'll need OpenAI and Google Sheets credentials - Takes **10-15 minutes** to plug in your keys and connect the sheet - Adjust prompts to match your brand tone or SEO goals You can easily expand this to generate pricing tables, testimonials, or even localized versions using the same structure. --- Ideal for SaaS companies, affiliate marketers, or content teams who want to scale up comparison content - without spending hours writing.
n8n$24.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 Daily Task Reminders with Google Sheets and Gmail
Streamline your team's productivity by automatically sending personalized task reminders via email for tasks due today using Google Sheets and Gmail.
n8n$4.99Automate Personalized Icebreakers Using Google Sheets and AI
Streamline your cold outreach by generating personalized icebreakers using Google Sheets, web scraping, and AI. Ideal for sales teams and agencies aiming to enhance engagement with tailored messages.
n8n$9.99Automate LINE Chatbot Responses with Google Sheets and Google Gemini AI
This workflow automates AI-assisted replies for LINE Official Account messages, using Google Sheets to store and reference chat history, ensuring contextual and personalized interactions.
n8n$14.99Automate Instagram Comment Responses with Google Sheets and CRM Integration
This n8n workflow automates the response to Instagram comments using predefined messages stored in Google Sheets, while logging interactions for CRM purposes.
n8n$9.99Automate Daily Sales Insights and Team Notifications with Google Sheets and Gemini AI
Streamline your daily sales reporting by automating data collection, analysis, and team notifications using Google Sheets, Gemini AI, and various communication tools.
n8n$9.99Monitor OpenAI Token Usage and AI Agent Metrics in Google Sheets
Automatically track and log token usage and costs from AI agents into Google Sheets for enhanced observability and billing transparency.
n8n$9.99Effortlessly Sync New Google Sheets Subscribers to MailerLite with Duplicate Prevention
Automate the process of syncing new subscribers from Google Sheets to MailerLite while preventing duplicates, ensuring your email lists remain clean and accurate.
n8n$9.99Automate YouTube Video Optimization with Google Sheets and DeepSeek AI
Enhance your YouTube channel's visibility by automating video title and description optimization using Google Sheets and DeepSeek AI. This workflow streamlines the process of managing video data and generating SEO-friendly content.
n8n$9.99Generate Business Leads with OpenStreetMap Data and Save to Google Sheets
## Who is this template for? This n8n lead generation workflow template is designed for business owners, marketers, sales professionals, and entrepreneurs who need to generate targeted business leads without paying for expensive APIs or third-party services. The template leverages the free Overpass API (powered by OpenStreetMap data) to gather comprehensive business information for any industry in almost any region worldwide. Perfect for: - Small businesses looking to expand their customer base - Real estate agents seeking potential clients - Marketing agencies needing targeted lead lists - Entrepreneurs researching potential markets - Sales teams building prospect databases You can watch the video tutorial here: https://youtu.be/6WVfAIXdwsE ## How it works This n8n lead generation template provides a powerful solution using n8n core nodes and the free OpenStreetMap Overpass API, allowing you to generate thousands of business leads with comprehensive contact information: ### Data Collection Process **1. Define Your Queries** - Create a list of search queries combining keywords (like real estate, dentist, etc.) with target locations - Use both inner areas (specific cities) and outer areas (broader regions) to precisely target your search **2. Iterative Query Execution** - The workflow processes each query in sequence, preventing API timeout issues - Each query triggers a sub-workflow that handles the data extraction process **3. Data Extraction via OpenStreetMaps Overpass API** - Searches for businesses matching your keywords in name, description, and relevant OpenStreetMap tags - Collects comprehensive business data including names, addresses, and contact details from the OpenStreetMap database - Searches using both regular expressions and exact tag matching for optimal n8n lead generation results **4. Website Scraping for Additional Information** - For businesses with websites but missing email addresses, the workflow visits their homepage - Extracts email addresses using regular expressions for more complete contact information - Filters out irrelevant emails using configurable patterns **5. Data Cleaning and Organization** - Removes duplicate contact information and standardizes data format - Filters results based on your specific requirements for contact details - Saves all extracted data to Google Sheets for easy access and management ## Setup **1. Configure Your Queries:** - Open the Run Workflow node and input your list of queries - Format queries with outer area, inner area, and keyword (e.g., California, Los Angeles, real estate) **2. Optimize Targeting:** - After initial runs, identify the specific tags used by your target industry - Update the HTTP Request node with these specific tags to improve result quality - Common tags include office, shop, and amenity with industry-specific values **3. Configure Data Filters:** - Customize the filter node to keep only results meeting your specific requirements - Adjust the email filtering regex to remove irrelevant email addresses **4. Set up Google Sheets Integration:** - Configure the Google Sheets node to save results to your preferred spreadsheet - Authorize the connection to your Google account **5. Run the Workflow:** - Start the workflow and watch as your Google Sheet fills with comprehensive business leads - The template automatically handles pagination and rate limiting to prevent API timeouts The resulting leads include comprehensive contact information such as: - Business names - Complete addresses (street, city, postal code) - Phone numbers - Email addresses (both from API and website scraping) - Website URLs - Social media accounts - Opening hours - And more!
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.99Automate QuickBooks Customer and Estimate Creation from Google Sheets
Streamline your sales process by automatically creating new customers and estimates in QuickBooks from Google Sheets entries. This workflow reduces manual data entry, minimizes errors, and keeps your financial records current.
n8n$14.99Extract Invoice Data from PDFs with AI - Google Sheets Email Alerts
Built by Setidure Technologies This smart n8n automation extracts invoice details from PDF files uploaded to Google Drive using AI, logs them to a Google Sheet, and notifies the billing team via email - all without manual intervention. Note: This workflow requires a self-hosted n8n instance with LangChain, LLM, and Google integrations configured. **What This Workflow Does** - Monitors a Google Drive folder for new invoice uploads - Extracts text and parses key invoice details using LLM via LangChain - Logs extracted data into a Google Sheet (Invoice Database) - Generates a summary email using GP-4O-MINI (Greenie) - Sends the email to the billing team via Gmail **Prerequisites** - A Google Drive folder to monitor for PDF uploads - A Google Sheet named Invoice Database with the following columns: - Invoice Number, Client Name, Client Email, Client Address, Client Phone, Invoice Date, Due Date, Total Amount - Service account or OAuth credentials for: - Google Drive - Google Sheets - Gmail - LangChain + Ollama integration for LLM responses **Step-by-Step Setup Instructions** 1. Clone this workflow into your self-hosted n8n instance 2. Set up credentials: - Google Drive (for folder trigger) - Google Sheets (for data logging) - Gmail (for sending email) - Ollama (local LLM) or any connected LangChain provider 3. Configure the trigger node to watch your specific Invoice Uploads folder 4. Update the Google Sheet node with your Invoice Database sheet URL and column mapping 5. Test with a sample invoice to validate the AI extraction and email generation **Workflow Steps** ## Step 1: Trigger on New File in Google Drive Node Name: Watch for New Invoices Type: Google Drive Trigger Event: fileCreated Triggers when a new PDF file is uploaded to a designated folder ## Step 2: Download the Uploaded File Node Name: Download Invoice PDF Type: Download Binary Downloads the invoice file from Google Drive ## Step 3: Extract Raw Text from PDF Node Name: Extract PDF Text Type: Extract from File Extracts unstructured text content from the downloaded PDF ## Step 4: Parse Invoice Fields Using AI Node Name: Parse Invoice Data with LLM Type: LangChain Agent LLM is prompted to extract: - Invoice Number - Client Name, Email, Address, Phone - Invoice Date, Due Date, Total Amount Fields not found are skipped ## Step 5: Log Extracted Data to Google Sheet Node Name: Log to Invoice Database Type: Google Sheets Appends a new row with the extracted fields to the Invoice Database spreadsheet ## Step 6: Create Email Notification via LLM Node Name: Generate Billing Email Summary Type: LangChain Agent (GP-4O-MINI) Prompt instructs AI to: - Act as "Greenie" from Green Grass Corp - Inform billing that a new invoice was processed - Confirm logging into the Invoice Database ## Step 7: Send the Email to Billing Team Node Name: Email Billing Team Type: Gmail Send To: billing@example.com Subject and body injected from LLM output ## Step 8: End Workflow Gracefully Node Name: End Type: No Operation Used to cleanly terminate the flow ## Example Output (Email) Subject: New Invoice Logged - Client: ABC Corp Hi Billing Team, A new invoice has been received and processed automatically. The following details have been extracted and logged into the Invoice Database: - Invoice Number: INV-1024 - Client: ABC Corp - Amount: $1,450 - Due Date: July 15, 2025 Please review the [Invoice Database](https://docs.google.com/spreadsheets/d/14FtgVUjy0tw4EQOB28wuCYOe6CELtt3Ujn-GsuDWY/edit?gid=0#gid=0) for full details. Regards, Greenie Green Grass Corp
n8n$9.99Automate Background Removal for WooCommerce Product Images Using Google Sheets and BackgroundCut API
Streamline your eCommerce operations by automatically removing backgrounds from WooCommerce product images using the BackgroundCut API, updating images in WooCommerce and Google Sheets efficiently.
n8n$9.99Scrape Google Maps Leads to Google Sheets via Apify
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. ## Scrape Google Maps leads to Google Sheets via Apify ## Who's it for This workflow is ideal for marketers, sales professionals, and solo entrepreneurs who want to collect local leads based on Google Maps search terms. For example, restaurants in North Holland. ## What it does This workflow uses an Apify actor to scrape business details from Google Maps and automatically appends them to a Google Sheet with the following fields: - Business name - Street - Postal code - City - Website - Phone number ## How it works 1. The workflow starts with a manual trigger (you can replace it with any other trigger). 2. The Google Maps Scraper Apify actor is launched. 3. A short wait ensures the actor completes the task (you can increase the wait time for more extensive outputs). 4. The resulting dataset is retrieved from Apify. 5. Data is mapped and added into a connected Google Sheet. ## How to set up Step 1: Configure the “Run Apify scraper” node - Go to the Google Maps Scraper actor on Apify. - Create a new task with your search term. - Find your actor from the list. Step 2: Edit the “Find your last run” node - Select the correct actor (Google Maps Scraper) from the dropdown in this node. Step 3: Fetch the dataset - In the “Get the data from Apify” node, use {{$json.defaultDatasetId}} to dynamically pull the correct dataset. Step 4: Connect your Google Sheet - Link your Google account and select the desired spreadsheet and tab (for example, Leads). - Make sure the column headers match the data fields. Current column headers: - Title - Street - Postcode - City - Website - Phone If you have any questions, feel free to reach out to info@ai-amigos.com
n8n$4.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 Blog Creation with AI and Google Sheets Integration
This n8n workflow automates the end-to-end process of generating, evaluating, and publishing SEO-friendly blog content using AI and Google Sheets. Ideal for marketing teams and content creators aiming to streamline their content pipeline.
n8n$9.99Sync New Google Sheets Rows to Notion Database
Automatically create Notion database entries for each new row added to your Google Sheets, ensuring seamless data synchronization.
MakeFreeAutomate Weekly Restaurant Forecasting with Google Sheets and Gemini AI
This n8n workflow automates the weekly forecasting of restaurant sales and inventory needs using historical data from Google Sheets and AI predictions from Google Gemini. The forecast is emailed to stakeholders for improved planning and waste reduction.
n8n$14.99Automate TikTok Profile and Transcript Extraction to Google Sheets
Streamline the process of monitoring TikTok profiles and extracting video transcripts by automating data collection and storage in Google Sheets using Dumpling AI.
n8n$4.99Automated SEC Form D Filings Tracker with Google Sheets Integration
## Description This workflow automatically monitors and tracks SEC Form D filings (private placement offerings) by fetching data from the SEC EDGAR database every 10 minutes during business hours and saving new filings to Google Sheets for analysis and tracking. ## Who's it for - **Venture capitalists** tracking private funding rounds and market activity - **Investment analysts** researching private placement trends and opportunities - **Financial researchers** collecting data on private securities offerings - **Business development teams** identifying potential partnership or acquisition targets - **Compliance professionals** monitoring regulatory filings in their industry ## How it works The workflow connects to the SEC EDGAR RSS feed to fetch the latest Form D filings, parses the XML data, extracts key information including CIK numbers and filing links, filters out duplicates from previous runs, and automatically saves new filings to a Google Sheets document for easy analysis and tracking. ## What it does 1. **Automated scheduling** - Runs every 10 minutes during business hours (6 AM - 9 PM, Monday-Friday) 2. **Fetches SEC data** - Retrieves the 40 most recent Form D filings from SEC EDGAR RSS feed 3. **Parses filing data** - Converts XML to structured data and extracts CIK numbers, titles, and links 4. **Filters duplicates** - Only processes new filings that haven't been seen in previous executions 5. **Saves to sheets** - Appends new filing data to Google Sheets with proper formatting ## Requirements - **Google Sheets API access** with OAuth2 credentials configured - **Google Sheets document** - Make a copy of [this template sheet](https://docs.google.com/spreadsheets/d/1VoGfVpk1mMrqKIc5hsO7peYuLx0SwhsbW7uUeYJCmrU/edit?usp=sharing) - **n8n instance** running continuously for scheduled execution ## How to set up 1. **Copy the template Google Sheet** from the link above to your Google Drive 2. **Configure Google Sheets OAuth2** authentication in n8n credentials 3. **Update the Google Sheets document ID** in the Save to SEC Data Sheet node to point to your copied sheet 4. **Customize the User-Agent header** in the HTTP Request node with your contact information (required by SEC) 5. **Activate the workflow** - The schedule trigger will start monitoring automatically 6. **Test manually** by replacing the Schedule Trigger with a Manual Trigger for initial testing ## How to customize the workflow - **Schedule frequency**: Modify the cron expression in the Schedule Trigger (default: every 10 minutes) - **Business hours**: Adjust the time range (default: 6 AM - 9 PM EST) - **Working days**: Change from Monday-Friday to include weekends if needed - **Filing count**: Modify the SEC URL to fetch more than 40 filings (change `count=40` parameter) - **Form types**: Update the URL to track different SEC forms (change `type=D` to other form types) - **Output format**: Customize the Google Sheets column mapping to include additional fields - **Notifications**: Add Slack, email, or webhook nodes to get alerts for new filings ## Output data includes - **CIK Number** - Central Index Key for the filing company - **Company Title** - Name of the company making the filing - **Form Type** - Type of SEC form (Form D for private placements) - **HTML Filing Link** - Link to view the filing in SEC EDGAR system - **XML Filing Link** - Direct link to the raw text version of the filing - **Updated Date** - When the filing was submitted to SEC ## Key features - **Duplicate prevention** - Built-in deduplication ensures no filing is processed twice - **Business hours scheduling** - Respects SEC server load by running only during business hours - **SEC compliance** - Includes proper User-Agent header as required by SEC guidelines - **Automatic link generation** - Creates both HTML and XML links for easy access to filings - **CIK extraction** - Automatically extracts company CIK numbers from filing titles **Note**: This workflow is designed for monitoring public SEC filings and complies with SEC EDGAR access guidelines. The User-Agent header must be updated with your contact information before use.
n8n$9.99Enrich LinkedIn Profiles from Google Sheets via RapidAPI
### LinkedIn Profile Enrichment Workflow #### Who is this for? This workflow is ideal for recruiters, sales professionals, and marketing teams who need to enrich LinkedIn profiles with additional data for lead generation, talent sourcing, or market research. #### What problem is this workflow solving? Manually gathering detailed LinkedIn profile information can be time-consuming and prone to errors. This workflow automates the process of enriching profile data from LinkedIn, saving time and ensuring accuracy. #### What this workflow does 1. **Input**: Reads LinkedIn profile URLs from a Google Sheet. 2. **Validation**: Filters out already enriched profiles to avoid redundant processing. 3. **Data Enrichment**: Uses RapidAPI's Fresh LinkedIn Profile Data API to retrieve detailed profile information. 4. **Output**: Updates the Google Sheet with enriched profile data, appending new information efficiently. #### Setup 1. **Google Sheet**: Create a sheet with a column named `linkedin_url` and populate it with the profile URLs to enrich. 2. **RapidAPI Account**: Sign up at [RapidAPI](https://rapidapi.com) and subscribe to the Fresh LinkedIn Profile Data API. 3. **API Integration**: Replace the `x-rapidapi-key` and `x-rapidapi-host` values with your credentials from RapidAPI. 4. **Run the Workflow**: Trigger the workflow and monitor the updates to your Google Sheet. #### How to customize this workflow * **Filter Criteria**: Modify the filter step to include additional conditions for processing profiles. * **API Configuration**: Adjust API parameters to retrieve specific fields or extend usage. * **Output Format**: Customize how the enriched data is appended to the Google Sheet (e.g., format, column mappings). * **Error Handling**: Add steps to handle API rate limits or missing data for smoother automation. This workflow streamlines LinkedIn profile enrichment, making it faster and more effective for data-driven decision-making.
n8n$9.99
More integrations
Need a custom Google Sheets workflow?
Our automation experts build tailored Google Sheets integrations for your exact stack.
Request a Custom Workflow