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 Google Places Data Collection and Storage in Google Sheets
Streamline your lead generation by automatically scraping Google Places data using Dumpling AI and storing it in Google Sheets. Ideal for marketers and SEO professionals seeking efficient data collection.
n8n$4.99AI Sales Agent for Telegram with Google Sheets Integration
Automate your sales process using a Telegram bot and sync with Google Sheets for efficient order management.
n8n$19.99Automate Cal.com Meeting Attendee Management with Google Sheets, Beehiiv, and Telegram Notifications
Streamline your meeting attendee management by automatically logging details in Google Sheets, subscribing attendees to Beehiiv, and receiving Telegram notifications.
n8n$9.99Automate Personalized Birthday Emails with Google Sheets and AI
This workflow automates the sending of personalized birthday emails using data from Google Sheets, AI-generated messages, and Gmail. Ideal for maintaining meaningful connections in educational, business, or personal settings.
n8n$4.99Automate AI Image Generation and Upload with Google Sheets and Drive
Streamline the creation of AI-generated images from prompts in Google Sheets, automatically upload them to Google Drive, and log the results back into the sheet.
n8n$14.99Extract Email Addresses from Websites with EmailListVerify API and Google Sheets
## How to Scrape Emails from Websites This workflow will: - Try to find emails by scraping the website via HTTP request. - If no result is found, it will use the [EmailListVerify email finder API](https://emaillistverify.com/email-finder-api) to guess an email address. Scraping email via HTTP request is a cost-effective way to find email addresses, so it can save you a few bucks to use it before calling any email finder API. ## Who is it for This workflow will help you transform a list of websites into a list of leads with email addresses. This is a handy workflow for any lead generation specialist. Pay attention that this workflow will usually return only generic emails like contact@. Those generic emails are useful when you target small businesses; the owner usually monitors those emails. However, I don't advise this workflow to target enterprise customers. ## Requirements In order to use this workflow, you will need: - To copy [this Google sheet template](https://docs.google.com/spreadsheets/d/1VOFM8UeWHhJbtBM7SRca6vsVJlRUXzX71kjJ8n2jUY/edit?gid=1538095319#gid=1538095319). - Get an API key for [EmailListVerify](https://emaillistverify.com/). You then need to edit the setup of the 3 stages highlighted with a yellow sticky note, and you will be good to go.
n8n$14.99Automate WordPress Blog Creation from Google Sheets with ChatGPT Enhancements
Streamline your content creation process by automatically generating WordPress blog posts using data from Google Sheets, enhanced with ChatGPT completions.
Make$4.99Automate Company Data Enrichment from Google Sheets Using OpenAI and ScrapingBee
Enhance your company's data by automatically enriching it from Google Sheets using OpenAI's AI capabilities and ScrapingBee's web scraping technology.
n8n$9.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 Restaurant Feedback Collection with Google Sheets and Email
This workflow automates the collection of restaurant customer feedback by sending personalized email forms and storing responses in Google Sheets, enabling systematic insights gathering and service improvement.
n8n$4.99Automatically Store Retell Call Transcripts in Google Sheets, Airtable, or Notion
This workflow captures and stores Retell call transcripts and analyses in Google Sheets, Airtable, or Notion upon receiving a 'call_analyzed' webhook event. It is ideal for users who need to maintain a structured record of call data.
n8n$9.99Automate Job Tracking from Y Combinator to Google Sheets
Automatically scrape and store the latest job listings from Y Combinator's Jobs page into Google Sheets every 6 hours using n8n and Scrapeless.
n8n$9.99Automate Expense Tracking from LINE Messages to Google Sheets Using GPT-4
This workflow automates the process of logging expenses from LINE messages into Google Sheets using GPT-4. It handles both text and image inputs, extracting relevant data and ensuring no duplicate entries.
n8n$14.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.99Automate Trustpilot Review Scraping to Google Sheets and CSV for HelpfulCrowd
This workflow automates the process of scraping Trustpilot reviews for a specified business and saving them into Google Sheets. It also formats the data for compatibility with HelpfulCrowd.
n8n$9.99Automate Daily MLB Matchup Analysis with Google Sheets and Telegram
This workflow automates the analysis of daily MLB pitcher vs. batter matchups, integrating data from MLB's API into Google Sheets and sending top matchups to Telegram.
n8n$9.99Automate Patient Vitals Monitoring and Alerts with Philips IntelliVue and Google Sheets
This workflow automates the monitoring of patient vitals using Philips IntelliVue devices, categorizes conditions based on severity, and sends alerts to healthcare staff. It also logs data to Google Sheets for record-keeping and analysis, ensuring timely updates every 30 seconds.
n8n$4.99Automate Company Name Cleaning for Cold Emails Using AI and Google Sheets
Enhance your cold email campaigns by automatically cleaning and standardizing company names in Google Sheets using AI. This workflow removes unnecessary suffixes and taglines to improve personalization and engagement.
n8n$9.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 Multilingual YouTube Metadata Translation with AI and Google Sheets
Streamline the process of translating YouTube video metadata into multiple languages using AI, and manage it all through Google Sheets. This workflow automates the detection of new videos, translates their metadata, and updates it directly on YouTube, saving time and expanding your global reach.
n8n$14.99Manage Personal Expenses with Webhooks and Google Sheets Automated Tracker
- How it works: This system functions by receiving expenses via webhook POS. It validates the data, stores it in Google Sheets, and, daily at 8 PM, generates and sends financial summaries. Automatic categorization simplifies the organization of expenses. - Set up steps: Setup involves creating the Google Sheet, configuring the webhook, and defining the categorization rules. The process is quick and intuitive, taking about 10-15 minutes for the system to be ready to receive your expenses.
n8n$9.99Payment Processing and Order Tracking with YooKassa and Google Sheets
# Accept YooKassa payments and log transactions in Google Sheets ## Summary This workflow allows you to accept online payments via **YooKassa** and log both orders and transactions in **Google Sheets** - all without writing a single line of code. It supports full payment flow: product selection, payment initiation, webhook processing, refund updates, and payment status checks. --- ## Who is this for? This template is ideal for: * Online stores with simple checkout flows * Sellers of digital products or info-courses * Entrepreneurs using Telegram bots or web forms * Anyone needing quick payment integration with Google Sheets tracking --- ## What problem does this workflow solve? Setting up online payments usually requires backend infrastructure. This no-code solution automates the entire payment flow: * Handles product listing and price retrieval * Initiates payments with email and return URL * Listens for `payment.succeeded` and `refund.succeeded` events * Records every action into structured Google Sheets --- ## What this workflow does ### 1. **GET /products** Returns a sorted list of products from a Google Sheet (`products`). ### 2. **POST /payment** * Validates required fields (`product_id`, `email`, `return_url`) * Checks email format * Fetches product data from `products` * Generates a unique idempotence key * Sends a request to YooKassa API * Saves the order into the `orders` sheet * Returns a payment confirmation link ### 3. **POST /yoomoney** Webhook to process payment/refund events: * On `payment.succeeded`, adds entry to `transactions` * On `refund.succeeded`, updates transaction status ### 4. **GET /status/:id** Returns real-time payment status from YooKassa --- ## Setup 1. **Connect credentials:** * Google Sheets (OAuth2) * YooKassa (Basic Auth using `shopId` and `secretKey`) 2. **Update the following Google Sheets:** * `products`: should contain `product_id`, `title`, `price` * `orders`: for saving confirmed purchases * `transactions`: for logging all successful or refunded payments 3. **Test endpoints using any HTTP client**: Example payload for `/payment`: ```json { "product_id": "abc123", "email": "user@example.com", "return_url": "https://your.site/success" } ``` --- ## How to customize this workflow * Add delivery logic (e.g., email with product link after successful payment) * Replace Google Sheets with a database (e.g., PostgreSQL) * Connect Telegram or other messengers for post-payment notifications * Add promo codes, discounts, or subscriptions logic --- ## Use cases * Simple online checkouts * Telegram bots selling access * Educational product sales * MVP e-commerce flows * Donation or membership payments --- ## Notes * Includes Sticky Notes for sections * Includes error handling and validation * No custom code needed except for UUID generation
n8n$24.99Automate Weekly Competitor Content Summaries with AI and Google Sheets
Streamline your competitive analysis by automating the collection, filtering, and summarization of competitor content using AI and Google Sheets. This workflow provides a weekly digest of relevant articles directly to your inbox.
n8n$14.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.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