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.
Extract Business Leads from Google Maps with Dumpling AI to Google Sheets
### Who is this for? This workflow is built for marketers, sales teams, agencies, virtual assistants, and anyone who regularly researches or contacts local businesses. It's ideal for building lead lists, tracking competitors, or creating location-specific outreach campaigns. --- ### What problem is this workflow solving? Instead of manually searching Google Maps and copying business info into spreadsheets, this automation pulls structured business data (e.g., restaurants, gyms, service providers) and logs it directly into Google Sheets. It saves hours of work and ensures cleaner, more usable data. --- ### What this workflow does The workflow takes a Google Maps search query (like best restaurants in New York) and sends it to Dumpling AI. It returns a list of places including their name, address, website, phone number, rating, and more. Each result is split into a row and automatically added to a Google Sheet. --- ### Setup 1. **Dumpling AI** - Sign up at [Dumpling AI](https://www.dumplingai.com/) - Generate your API key - In the HTTP Request node, select `Header Auth` and paste your key in the Authorization field. 2. **Google Sheets** - Create a sheet with tab name `Leads` - Add the following column headers to row 1: `Name`, `Address`, `Phone number`, `Website`, `Rating`, `Price Level`, `Type`, `Booking Link`, `Position` - Connect your Google Sheets account and link this sheet in the node. 3. **Customize the Query** - In the HTTP node, replace the query string (e.g., `best+restaurants+in+New+York`) with your own search term. 4. **Run It** - Use the manual trigger to test - Optionally swap in a Schedule or Webhook node to run it automatically. --- ### How to customize this workflow to your needs - Change the search query to target different cities or business types - Use filters to only save leads with a minimum rating or price level - Add GPS to summarize listings or qualify leads - Swap Google Sheets for Airtable or a CRM system for deeper integration.
n8n$4.99Automate Invoice Creation and Payment Reminders with Google Sheets
This n8n workflow automates the process of generating invoices and sending payment reminders. It integrates with Google Sheets to manage client data and uses email notifications to ensure timely payments.
n8n$14.99Automate Invoice Data Extraction from Google Drive to Google Sheets Using PDF.co
This workflow automates the extraction of invoice data from PDF files stored in Google Drive, parses them using PDF.co's AI Invoice Parser, and appends the extracted data to a Google Sheet.
n8n$9.99Automate Company Research and Lead Enrichment with AI and Google Sheets
Enhance your sales and marketing efforts by automating company research and lead enrichment using AI. This workflow extracts critical company data from the web and updates your Google Sheets, saving you time and effort.
n8n$14.99Automate Marketing Performance Reports with Google Sheets and Outlook
This n8n workflow automates the process of generating marketing performance reports by retrieving data from Google Sheets, calculating key metrics, and sending formatted HTML reports via Outlook. Ideal for marketing teams seeking efficient, regular reporting.
n8n$9.99Automate Content Posting to Twitter and Meta Threads with Google Sheets
This workflow automates the posting of content optimized for Twitter and Meta Threads using Google Sheets and the Late API, ensuring character limits are respected for each platform.
n8n$14.99Automate Lead Outreach with Google Sheets and Gmail in n8n
Automatically fetch new leads from Google Sheets, send personalized emails via Gmail, and update lead status to 'Contacted' every 60 minutes using n8n.
n8n$4.99Track Expenses from Telegram to Google Sheets with GPT-4.1 Mini
# Telegram Expense Tracker to Google Sheets with GPT-4.1 [.jpg)](https://www.youtube.com/watch?v=DsSs1EF1lQg) > A lightweight automation that lets users log daily expenses via a Telegram bot and instantly saves them into Google Sheets—perfect for anyone looking to manage spending on the go with AI-powered structure and ease. ## ☀ Who's it for This workflow is for anyone who wants to log their daily expenses by simply chatting with a Telegram bot. Ideal for: - Individuals who want a quick way to track spending - Freelancers who log receipts and purchases on the go - Teams or small business owners who want lightweight expense capture ## ℹ How it works / What it does 1. **User sends a text message on Telegram** describing an expense _(e.g., “Bought coffee for 50k at Highlands”)_ 2. **Message format is validated** - If the message is **text**, it proceeds to GPT-4.1 Mini for processing. - If it's **not text** (e.g., image or file), the bot sends a fallback message. 3. **OpenAI GPT-4.1 Mini parses the message** and returns: - `relevant`: true/false - `expense_record`: structured fields (date, amount, currency, category, description, source) - `message`: a friendly confirmation or fallback 4. **If valid**: - The bot replies with a fun acknowledgment - The data is saved to a connected Google Sheet 5. **If invalid**: - A fallback message is sent to encourage proper input ## ⚙ How to set up ### 1. Telegram Bot Setup - Create a bot using [BotFather](https://t.me/botfather) on Telegram - Copy the bot token and paste it into the `Telegram Trigger` node ### 2. Google Sheet Setup - Create a Google Sheet with these columns: ``` Date | Amount | Currency | Category | Description | SourceMessage ``` - Share the sheet with your n8n service account email ### 3. OpenAI Configuration - Connect the `OpenAI Chat Model` node using your OpenAI API key - Use GPT-4.1 Mini as the model - Apply a system prompt that extracts structured JSON with: - `relevant`, `expense_record`, and `message` ### 4. Add Parser - Use the `Structured Output Parser` node to safely parse the JSON response ### 5. Conditional Logic Nodes - `Is text message?` - Checks if the message is in text format - `Supported scenario?` - Checks if `relevant = true` in the LLM response ### 6. Final Actions - **If relevant**: - Send confirmation via Telegram - Append row to Google Sheet - **If not relevant**: - Send fallback message via Telegram ## 📌 Requirements - Telegram bot token - OpenAI GPT-4.1 Mini API access - n8n instance (self-hosted or cloud) - Google Sheet with access granted to n8n - Basic understanding of n8n node configuration ## © How to customize the workflow | Feature | How to Customize | |---------|------------------| | Add multi-currency support | Update system prompt to detect and extract different currencies | | Add more categories | Modify the list of categories in the system prompt | | Track multiple users | Add `username` or `chat ID` column to the Google Sheet | | Trigger alerts | Add Slack, Email, or Telegram alerts for specific expense types | | Weekly summaries | Use a cron node + Google Sheet query + Telegram message | | Visual dashboards | Connect the sheet to Looker Studio or Google Data Studio | Built with Telegram + GPT-4.1 Mini + Google Sheets + n8n
n8n$14.99Automate Healthcare Claims Processing with Google Drive, VLM Run, and Google Sheets
Streamline the processing of healthcare claims by automatically extracting data from documents in Google Drive and appending it to Google Sheets using VLM Run's AI capabilities.
n8n$4.99Beginner Data Analysis: Merge, Filter & Summarize in Google Sheets with GPT-4o
This beginner-friendly n8n workflow teaches essential data manipulation techniques using Google Sheets and AI. You'll learn how to: - Merge two datasets by a shared column (`Channel`) - Filter rows based on performance metrics (`Clicks`, `Spend`) - Branch logic into `Great` vs. `Poor` outcomes - Summarize results by team leader - Use an OpenAI-powered agent to generate a written analysis highlighting the best and worst performers Perfect for marketers, analysts, or anyone learning how to clean, transform, and interpret data inside n8n. Includes: - Sample Google Sheet to copy - Setup instructions for Google Sheets & OpenAI - AI summary powered by `GPT-4-mini` ### Questions or Feedback? Feel free to reach out - I'm happy to help! **Robert Breen** Founder, Ynteractive 📧 [robert@ynteractive.com](mailto:robert@ynteractive.com) 🔗 [YouTube: YnteractiveTraining](https://www.youtube.com/@ynteractivetraining) 🔗 [LinkedIn: linkedin.com/in/robertbreen](https://www.linkedin.com/in/robertbreen)
n8n$14.99Generate Marketing Reports from Google Sheets with GPT-4 Insights and PDF.co
This workflow pulls **marketing data from Google Sheets**, aggregates spend by channel, generates an **AI-written summary**, and outputs a formatted **PDF report** using a custom HTML template on **PDF.co**. --- ## Setup Instructions ### 1. Prepare Your Google Sheet - Copy this template into your Google Drive: [Sample Marketing Data](https://docs.google.com/spreadsheets/d/1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4/edit?gid=365710158#gid=365710158) - Add or update your marketing spend data in rows 2-100. #### Connect Google Sheets in n8n 1. Go to **n8n → Credentials → New → Google Sheets (OAuth2)** 2. Log in with your Google account and grant access 3. Select the **Spreadsheet ID** and **Worksheet** in the workflow --- ### 2. Set Up PDF.co for PDF Reports 1. Create a free account at [PDF.co](https://pdf.co/) 2. In **PDF.co Dashboard → HTML to PDF Templates**, create a new **Mustache template** - Paste the HTML provided at the bottom of this description - Save, and note your **Template ID** 3. In **n8n → Credentials → New → PDF.co API**, paste your **API Key** and save 4. In the workflow, select your **PDF.co credential** in the `Create PDF` node 5. Replace the `templateId` with your Template ID --- ## How It Works - **Google Sheets Node**: Pulls marketing spend data - **Summarize Nodes**: Aggregate total spend and spend per channel - **OpenAI Node**: Writes a daily summary of marketing performance - **Code Node**: Converts aggregated data into the correct shape for the PDF template - **PDF.co Node**: Generates a final, formatted **PDF report** --- ## Contact Need help customizing this (e.g., filtering by campaign, sending reports by email, or formatting your PDF)? - ✉ **robert@ynteractive.com** - 🔗 **[Robert Breen](https://www.linkedin.com/in/robert-breen-29429625/)** - 🌐 **[ynteractive.com](https://ynteractive.com)** --- ## ➤ HTML Template (for PDF.co) > Paste this into a new **HTML Template** on [PDF.co](https://pdf.co/) and reference its Template ID in your workflow. ```html <!DOCTYPE html> <html> <head> <meta charset="utf-8" /> <title>Invoice {{invoiceNumber}}</title> <style> body { font-family: Arial, Helvetica, sans-serif; margin: 36px; color: #222; } .header { display: flex; justify-content: space-between; align-items: center; } .brand { max-height: 56px; } h1 { margin: 12px 0 4px; font-size: 22px; } .meta { font-size: 12px; color: #555; } .two-col { display: flex; gap: 24px; margin-top: 16px; } .box { flex: 1; border: 1px solid #ddd; padding: 12px; border-radius: 6px; } .label { font-size: 11px; color: #666; text-transform: uppercase; letter-spacing: .02em; } table { width: 100%; border-collapse: collapse; margin-top: 16px; } th, td { border-bottom: 1px solid #eee; padding: 10px 8px; font-size: 13px; } th { background: #fafafa; text-align: left; } tfoot td { border-top: 2px solid #ddd; font-size: 13px; } .right { text-align: right; } .totals td { padding: 6px 8px; } .grand { font-weight: 700; font-size: 14px; } .notes { margin-top: 18px; font-size: 12px; color: #444; } </style> </head> <body> <div> <div> <h1>Invoice {{invoiceNumber}}</h1> <div>Date: {{invoiceDate}} | Due: {{dueDate}}</div> </div> {{#company.logoUrl}} <img src="{{company.logoUrl}}" alt="Logo" /> {{/company.logoUrl}} </div> <div> <div> <div>From</div> <div><strong>{{company.name}}</strong></div> <div>{{company.address}}</div> <div>{{company.phone}}</div> <div>{{company.email}}</div> </div> <div> <div>Bill to</div> <div><strong>{{billTo.name}}</strong></div> <div>{{billTo.address}}</div> <div>{{billTo.email}}</div> </div> </div> <table> <thead> <tr> <th>#</th> <th>Description</th> <th>Qty</th> <th>Unit Price</th> <th>Line Total</th> </tr> </thead> <tbody> {{#items}} <tr> <td>{{line}}</td> <td>{{description}}</td> <td>{{qty}}</td> <td>{{unitPriceFmt}}</td> <td>{{lineTotalFmt}}</td> </tr> {{/items}} </tbody> <tfoot> <tr> <td colspan="4">Subtotal</td> <td>{{subtotalFmt}}</td> </tr> <tr> <td colspan="4">Tax ({{taxRatePct}})</td> <td>{{taxAmountFmt}}</td> </tr> <tr> <td colspan="4">Discount</td> <td>-{{discountFmt}}</td> </tr> <tr> <td colspan="4">Total</td> <td>{{totalFmt}}</td> </tr> </tfoot> </table> <div> <strong>Notes:</strong> {{notes}}<br /> <strong>Terms:</strong> {{terms}} </div> </body> </html> ```
n8n$9.99Automate Multi-Platform Video Publishing via Google Sheets and Blotato
Streamline your video distribution by automatically publishing content to nine social media platforms using Google Sheets and Blotato's API.
n8n$9.99Automatically Log Telegram Messages to Google Sheets
Capture and store every new message from a specified Telegram chat or channel into a Google Sheets spreadsheet as a new row, ensuring you never miss any important information.
Make$2.99Competitor Price Monitoring with Web Scraping, Google Sheets & Telegram
## How it works Download the Google sheet here and replace this with the Google Sheets node: [Google Sheet](https://www.dropbox.com/scl/fi/zaif45nt9uzgz8mrhht9n/competitor_price_drop_automation.xlsx?rlkey=4vj3wz6gqp16dc2hh9hw5o49z&st=i23h513p&dl=1), upload to Google Sheets and replace in the Google Sheets node. - Scheduled trigger: Runs once a day at 8 AM (server time). - Fetch product list: Reads your "master" sheet (product_url + last known price) from Google Sheets. - Loop with delay: Iterates over each row (product) one at a time, inserting a short pause (20 s) between HTTP requests to avoid blocking. - Scrape current price: Loads each product_url, extracts the current price via a simple CSS selector. - Compare & normalize: Compares the newly scraped price against the "last_price" from your sheet, calculates percentage change, and tags items where price_changed == true. **On price change:** - Send alert: Formats a Telegram message ("Price Drop" or "Price Hike") and pushes it to your configured chat. - Log history: Appends a new row to a separate "price_tracking" tab with timestamp, old price, new price, and % change. - Update master sheet: After a 1 min pause, writes the updated current_price back to your "master" sheet so future runs use it as the new baseline. ## Set up step 1. Google Sheets credentials (~5 min) 2. Create a Google Sheets OAuth credential in n8n. 3. Copy your sheets ID and ensure you have two tabs: 4. product_data (columns: product_url, price) 5. price_tracking (columns: timestamp, product_url, last_price, current_price, price_diff_pct, price_changed) 6. Paste the sheet ID into both Google Sheets nodes ("Read" and "Append/Update"). 7. Telegram credentials (~5 min) 8. Create a Telegram Bot token via BotFather. 9. Copy your chat_id (for your target group or personal chat). 10. Add those credentials to n8n and drop them into the "Telegram" node. ## Workflow parameters (~5 min) - Verify the schedule in the Schedule Trigger node is set to 08:00 (or adjust to your preferred run time). - In the Loop Over Items node, confirm "Batch Size" is 1 (to process one URL at a time). - Adjust the Delay to avoid Request Blocking node if your site requires a longer pause (default is 20 s). - In the Parse Data From the HTML Page node, double-check the CSS selector matches how prices appear on your target site. - Once credentials are in place and your sheet tabs match the expected column names, the flow should be ready to activate. Total setup time is under 15 minutes—detailed notes are embedded as sticky comments throughout the workflow to help you tweak selectors, change timeouts, or adjust sheet names without digging into code.
n8n$14.99Automate Personalized Cold Emails with Google Sheets and Google Gemini
Streamline your cold outreach by integrating Google Sheets with Google Gemini to automatically generate personalized emails. Enhance engagement and response rates with AI-driven email content tailored to each lead.
n8n$4.99Automate Task Creation from Google Sheets to Monday.com with Status Updates
This workflow automates the process of creating tasks in Monday.com from new entries in Google Sheets and updates the sheet once tasks are added.
n8n$4.99Automate Business Email Responses Using ChatGPT and Google Sheets
Streamline your business communication by automating email responses with the power of ChatGPT and Google Sheets. This workflow categorizes incoming emails and drafts personalized responses, saving time and enhancing customer interaction.
Make$4.99Automate Glassdoor Job Searches with Bright Data and Google Sheets Integration
Streamline your job search process by automatically scraping Glassdoor job listings using Bright Data and storing the results in Google Sheets for easy analysis.
n8n$9.99Automate Task Management with Telegram, Google Sheets, and AI-Powered Reminders
This n8n workflow automates task management by integrating Telegram for user interaction, Google Sheets for data storage, and AI for processing commands and sending daily reminders.
n8n$14.99Automate News Scraping and Storage with AI and Google Sheets
Streamline the process of collecting and storing news articles using AI-powered scraping and Google Sheets integration for efficient analysis and tracking.
n8n$4.99Automate Website Sitemap and Visual Tree Creation with Firecrawl and Google Sheets
This workflow automates the generation of comprehensive sitemaps and visual tree structures from website URLs, organizing them in Google Sheets for easy analysis and further processing.
n8n$4.99Automate Preventive Maintenance Invites with Google Sheets and Gmail
Streamline your preventive maintenance scheduling by automatically sending personalized calendar invites from Google Sheets data via Gmail.
n8n$4.99Automated Customer Support Chatbot for Webshops Using GPT-4 and Google Sheets
This workflow automates customer and sales support for webshops using a chatbot powered by GPT-4 and Google Sheets. It efficiently handles customer queries, checks product availability, places orders, and updates stock levels.
n8n$4.99AI-Enhanced Google Sheets Management with Natural Language Commands
Leverage AI to manage Google Sheets with natural language commands, enabling efficient data operations like reading, updating, and creating sheets.
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