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 Airbnb Listing Scraping and Storage in Google Sheets
This n8n workflow automates the process of scraping Airbnb listings from a specified location and storing the data in Google Sheets. It handles pagination to gather listings from multiple pages, extracts detailed property information, and formats the data for easy analysis.
n8n$14.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 Lead Qualification and Routing from Typeform to HubSpot, Google Sheets, and Airtable
Streamline your lead management by automatically qualifying and routing leads from Typeform to HubSpot, Google Sheets, and Airtable based on budget and source. Enhance efficiency with automated follow-ups and acknowledgments.
n8n$9.99Automate Lead Email Verification with Google Sheets and Hunter.io
Automatically validate lead email addresses stored in Google Sheets using Hunter.io, ensuring your outreach lists remain accurate and up-to-date.
n8n$9.99Automate Notifications for New Google Sheets Entries Every 45 Minutes
This workflow checks Google Sheets for new data every 45 minutes and sends a notification to Mattermost if new entries are found.
n8n$4.99Automate AI-Enhanced FAQ Generation from Google Sheets
This n8n workflow automates the creation of comprehensive FAQ content by leveraging AI to enhance data from Google Sheets. It generates detailed Q&A documents for various services and organizes them in Google Drive.
n8n$24.99Automate YouTube Video Statistics Collection to Google Sheets
Efficiently gather YouTube video statistics such as views, likes, and comments, and store them in Google Sheets for analysis and reporting.
n8n$9.99Automate Restaurant Food Waste Forecasting with AI and Google Sheets
This n8n workflow automates daily forecasting of restaurant sales and raw material needs using AI, helping to minimize food waste and optimize inventory. Forecasts are stored in Google Sheets and emailed to staff for review.
n8n$14.99Automate Document Summarization from Google Drive to Google Sheets
Efficiently manage new Google Docs by automatically summarizing their content and storing the summaries in Google Sheets. This workflow enhances productivity by streamlining document processing and organization.
n8n$9.99Automate Creative Asset Management with AI Analysis and Google Sheets
Streamline the management of creative assets by automating analysis, organization, and compliance checks using ScrapeGraphAI and Google Sheets.
n8n$9.99Automate B2B Lead Enrichment and Outreach with Telegram and Google Sheets
This n8n workflow transforms your Telegram bot into a powerful B2B lead enrichment and outreach tool, leveraging Explorium MCP and OpenAI GPT-4 for enriched profiles and personalized email sequences.
n8n$14.99Automated AI-Driven WhatsApp Support Bot with Google Sheets Ticketing
This n8n workflow creates an intelligent, multi-channel support bot that leverages AI to provide customer service via WhatsApp and a website widget, while automatically generating support tickets in Google Sheets.
n8n$24.99Automate Blog Creation and Publishing with Gemini AI, Google Sheets, and GitHub
This n8n workflow automates the generation and publication of technical blog posts using topics from Google Sheets. It utilizes Gemini AI for content creation, commits the content to a GitHub repository, and updates a Jekyll-powered blog, streamlining the entire process.
n8n$14.99Automate Meal Nutrient Logging from Telegram to Google Sheets via AI
Streamline your nutrition tracking by automating meal data logging from Telegram to Google Sheets using AI for transcription and analysis.
n8n$14.99Automate SSL Certificate Monitoring and Alerts with Google Sheets
This workflow automates the monitoring of SSL certificate expiry dates using Google Sheets and sends timely alerts via email and messaging platforms to prevent security risks.
n8n$14.99Automate WhatsApp Sales with AI and Google Sheets Integration
Transform your WhatsApp channel into an AI-driven sales assistant that integrates with Google Sheets for product data and sends purchase notifications via Gmail.
n8n$9.99Track Amazon Product Prices with ScrapeOps API & Google Sheets Alerts
# Amazon Product Price Tracker This workflow automatically monitors Amazon product prices, tracks price changes, and sends alerts when significant price fluctuations occur. Built with ScrapeOps structured data API, it provides a reliable, maintenance-free solution for price tracking without worrying about anti-bot measures or complex selectors. ## What This Workflow Does - Monitors multiple Amazon products simultaneously using their ASINs - Calculates both absolute and percentage price changes - Sends customizable email alerts when prices cross defined thresholds - Maintains a historical record of all price data for trend analysis - Updates a Google Sheets with the latest price information ## Prerequisites - A ScrapeOps API key (register at https://scrapeops.io) - Google account for Google Sheets integration - SMTP email configuration for alerts ## Setup Instructions 1. **Spreadsheet Setup** - Make a copy of the template spreadsheet: https://docs.google.com/spreadsheets/d/1hRv-BXrpN6rkIU65WorttNHt-IPWas_An0sF4Of39U - Add your Amazon product ASINs in the Products to Monitor sheet - Set your desired alert thresholds for price increases/decreases 2. **Workflow Configuration** - Add your ScrapeOps API key to the Setup node - Update the spreadsheet URL in the Setup node with YOUR copy - Configure your email settings for notifications - Adjust the schedule frequency as needed (default: hourly) ## How It Works The workflow reads product ASINs from your Google Sheet, fetches current pricing data via ScrapeOps Amazon Product API, calculates price changes, updates your spreadsheet, and sends alerts when price movements exceed your defined thresholds. Unlike traditional web scrapers that break when websites change, this solution uses ScrapeOps reliable API that handles all the complexity of Amazon data extraction, ensuring consistent results without maintenance. ## Additional Notes - This workflow is ideal for deal hunters, price comparison services, and e-commerce analytics - The alerting system can be extended to additional channels like Slack or Telegram - ScrapeOps handles all anti-bot measures, proxy management, and parsing complexities
n8n$14.99"Blog Image SEO & Size Auditor with Ghost and Google Sheets"
**Tags**: Ghost CMS, SEO Audit, Image Optimization, Alt Text, Google Sheets, Automation ### Context Hi! I'm Samir - a Supply Chain Engineer and Data Scientist based in Paris, and founder of [LogiGreen Consulting](https://logi-green.com). I help companies and content creators use automation and analytics to **improve visibility**, **enhance performance**, and **reduce manual work**. > Let's use n8n to automate SEO audits to increase your traffic! For business inquiries, feel free to connect on [LinkedIn](https://www.linkedin.com/in/samir-saci) ### Who is this template for? This workflow is perfect for **bloggers, marketers, or content teams** using **Ghost CMS** who want to: - Extract and review **all images** from articles - Detect missing or short **alt texts** - Check image **file size** and **filename SEO compliance** - Push the audit results into a **Google Sheet**  ### How does it work? This n8n workflow extracts all blog posts from Ghost CMS, scans the HTML to collect all embedded images, then evaluates each image for: - Presence and length of `alt text` - File size in kilobytes - Filename SEO quality (e.g., lowercase, hyphenated, no special chars) All findings are written to Google Sheets for **further analysis** or **manual cleanup**. ### Workflow Steps: 1. Trigger the workflow manually or on schedule 2. Extract blog post content from Ghost CMS 3. Parse all `<img>` tags with `src` and `alt` attributes 4. Store image metadata in a Google Sheet (step 1) 5. Download each image using HTTP request 6. Extract file size, extension, and filename SEO flag 7. Update the audit sheet with size and format insights  ### What do I need to get started? This workflow requires: - A **Ghost Content API key** - A **Google Sheet** (to log audit results) - No AI or external APIs required - works fully with built-in nodes ### Next Steps Follow the sticky notes inside the workflow to: - Plug in your Ghost blog credentials - Select or create a Google Sheet - Run the audit and start improving your SEO! This template was built using n8n v1.93.0 Submitted: June 8, 2025
n8n$9.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.99Live Airport Delay Dashboard with FlightStats, Google Sheets, & Slack Alerts
# Live Airport Delay Dashboard with FlightStats & Team Alerts ## Description - Automates live monitoring of airport delays using FlightStats API. - Stores and displays delay data, with Slack alerts for severe delays to operations/sales teams. ## Essential Information - Runs on a scheduled trigger (e.g., hourly or daily). - Fetches real-time delay data from FlightStats API. - Stores data in Google Sheets and alerts teams via Slack for severe delays. ## System Architecture - **Delay Monitoring Pipeline**: - **Set Schedule**: Triggers the workflow hourly or daily via Cron. - **FlightStats API**: Retrieves live airport delay data. - **Data Management Flow**: - **Set Output Data**: Prepares data for storage or display. - **Merge API Data**: Combines and processes delay data. - **Alert and Display**: - **Send Response via Slack**: Alerts ops/sales for severe delays. - **No Action for Minor Delays**: Skips minor delays with no action. ## Implementation Guide - Import the workflow JSON into n8n. - Configure Cron node for desired schedule (e.g., every 1 hr). - Set up FlightStats API credentials and endpoint (e.g., https://api.flightstats.com). - Configure Google Sheets or Notion for data storage/display. - Test with a sample API call and verify Slack alerts. - Adjust delay severity thresholds as needed. ## Technical Dependencies - Cron service for scheduling. - FlightStats API for real-time delay data. - Google Sheets API or Notion API for data storage/display. - Slack API for team notifications. - n8n for workflow automation. ## Database & Sheet Structure - **Delay Tracking Sheet** (e.g., AirportDelays): - Columns: `airport_code`, `delay_status`, `delay_minutes`, `timestamp`, `alert_sent` - Example: `JFK`, `Severe`, `120`, `2025-07-29 20:28:00Z`, `Yes` ## Customization Possibilities - Adjust Cron schedule for different frequencies (e.g., every 30 min). - Modify FlightStats API parameters to track specific airports. - Customize Slack alert messages in the `Send Response via Slack` node. - Integrate with a dashboard tool (e.g., Google Data Studio) for live display. - Add email alerts for additional notification channels.
n8n$4.99Extract Pay Slip Data with LINE Chatbot and Geminio to Google Sheets
## Workflow Overview: Extracting text from an image using AI is worthwhile because it requires no code. It incorporates the Google Gemini 2.0 Flash model for important text extraction from images. If you code without AI, you have to use multiple conditions and may cause a lot of bugs, but with Google Gemini, you don't need any coding, and if the Pay Slip is different, Gemini will extract it automatically. ## Workflow Description: 1. The user uses the Line Messaging API to send a Pay Slip image or message to the chatbot. Create a Line Business ID from here: [Line Business](https://account.line.biz/login). 2. Classify the message as either an image or text. 3. If the message is a Pay Slip image, it will be processed using Gemini 2.0 Flash EXP and extract important information and respond in JSON format without coding by using the following prompt: Analyze the image and then return in JSON Response that has the only following values: **Status, From, To, Date, Amount**.  To get the Google AI Studio API Key, you can find it from the following link: [Google AI Studio API Key](https://aistudio.google.com/apikey). 4. Create Google Sheets which include the fields **(Status, From, To, Date, Amount)** that we have created related to the AI prompt [Google Sheets](http://docs.google.com/spreadsheets) as the following example:  5. If the message is text, it will process using the Gemini 2.0 Flash EXP model as the AI Assistant; else if the message is an image, it will extract the important fields, then reply to the user and insert into Google Sheets. ## Key Features: * **Extract text from image with No Code** - Without N8N, we have to write code to extract text from an image, but with N8N and Google Gemini 2.0 Flash EXP together, we don't need to code, and it will process all slip vendors or other document vendors. * **Multipurpose Chatbot** - This chatbot accepts both text and image, so we don't have to create many chatbot accounts. * **Reduce human error** - This workflow lets any officer verify document status when the job ends. **Note:** You can change the information by changing your prompt and also Google Sheets Column names relatively.
n8n$14.99Automate Post-Interview Feedback Reminders via Google Sheets, Slack, and Gmail
Streamline your post-interview feedback process by automatically sending reminders through Slack or Gmail based on data from Google Sheets. This workflow ensures timely follow-ups and reduces manual tracking.
n8n$9.99Automated Email Assistant for Suppliers Using OpenAI and Google Sheets
## Automated Email Assistant for Busy Professionals This assistant is designed for people who don't have time to write and send emails to suppliers. With just one request, it drafts and sends clear, professional messages automatically. ## How It Works The user makes a request (e.g., "Send an email to my fruit supplier asking for a quote on 1 crate of mangoes."). ## Workflow: 1. The AI agent searches for the supplier in a Google Sheets database. 2. It automatically drafts the email using OpenAI (with the tone and style you define). 3. It sends the email using your Gmail account connected through n8n. ## This assistant uses: - Google Sheets to manage your suppliers (name and email). - OpenAI to generate clear, natural messages. - MCP (client-server logic) to handle request processing. - Gmail as the sending channel for automated emails. ## Setup Instructions 1. Create a Google Sheets document with the supplier name and email, like this: | Supplier name | Email | |---------------|-------| | Proveedor de frutas Alvarez | fruteriaalvarez@alvarez.com | 2. Connect your Google Sheets and Gmail accounts within n8n. 3. Add your OpenAI API key. Test the automation by chatting with the integrated assistant. It will generate and send the email automatically to the indicated supplier. ## Requirements - OpenAI API key to generate email content. - Gmail account connected via OAuth2. - Google Sheets document with your supplier database. - n8n instance (cloud or self-hosted). ## Customization Adjust the OpenAI prompt to make the email tone more formal, casual, or technical. Add custom fields to your supplier sheet (location, notes, special conditions). Replace Google Sheets with a real database like Supabase or PostgreSQL for greater scalability.
n8n$9.99Automate Multi-Step Email Campaigns with Gmail and Google Sheets
Streamline your email marketing by automating multi-step campaigns using n8n, Gmail, and Google Sheets. This workflow sends initial and follow-up emails based on recipient responses, ensuring efficient communication management.
n8n$24.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