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 Business Lead Extraction from Google Maps to Google Sheets
This n8n workflow automates the extraction of business leads from Google Maps using RapidAPI and stores the data in Google Sheets. It is ideal for lead generation, market research, and competitive analysis, ensuring efficient data collection with duplicate prevention.
n8n$14.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.99Generate Marketing Reports from Google Sheets with GP-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 LinkedIn Content Creation and Publishing with AI and Google Sheets
Streamline your LinkedIn content strategy by automating post creation, image generation, and publishing with AI and Google Sheets.
n8n$14.99Extract 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 Customer Feedback Analysis with Forms, AI, Google Sheets, and WhatsApp
# Automate Customer Feedback Analysis with Google Sheets, WhatsApp, and Email ## Introduction: Drowning in Data, Starving for Insight? **Imagine this:** Your team launches a new feature. Feedback starts pouring in through emails, support tickets, social media mentions, and survey responses. You know gold is buried in there, but manually reading, tagging, and summarizing hundreds, maybe thousands, of comments? It takes days, maybe weeks. By the time you have a clear picture, the moment might have passed. Sounds exhausting, right? What if you could have an AI assistant tirelessly working 24/7, instantly analyzing every piece of feedback the moment it arrives? This isn't science fiction anymore. AI-powered automation can transform this slow, manual chore into a real-time insight engine, giving you the pulse of your customer base almost instantly. Let's explore how. ## What's the Goal? Understanding the Workflow Objective The core challenge is transforming raw, unstructured customer feedback into actionable intelligence quickly and efficiently. **The Problem:** - **Manual Overload:** Sifting through vast amounts of feedback manually is incredibly time-consuming and prone to human error or bias. - **Delayed Insights:** The lag between receiving feedback and understanding it means missed opportunities and slow responses to critical issues. - **Inconsistent Analysis:** Different team members might interpret or categorize feedback differently, leading to unreliable trend spotting. **The AI Solution:** - **Automated Data Collection:** Connects directly to feedback sources (surveys, social media, review sites, helpdesks). - **AI-Powered Analysis:** Uses Large Language Models (LLMs) like GPT-4 or Claude to analyze sentiment, extract key topics, and summarize comments. - **Intelligent Categorization:** Automatically tags feedback based on predefined or dynamically identified themes (e.g., bug report, feature request, pricing issue). - **Real-time Reporting:** Pushes structured insights into dashboards, databases, or triggers notifications for immediate awareness. **Outcome:** You move from reactive problem-solving based on stale data to proactive, strategic decisions driven by a near real-time understanding of customer sentiment and needs. ## Why Does It Matter? Achieving 100X Productivity and Efficiency Look, automating feedback isn't just about saving time; it's about scaling your ability to listen and respond smarter, not harder. When you leverage AI, the gains aren't incremental - they're exponential. Here's why this is a game changer: - **Blazing Speed:** Analyze feedback 100x Faster (or more!) than manual methods. Insights appear in minutes or hours, not days or weeks. - **Unhuman Scalability:** Process virtually unlimited volumes of feedback without needing to scale your human team proportionally. AI doesn't get tired or bored. - **Consistent Accuracy:** AI applies analysis rules consistently, reducing human bias and ensuring reliable categorization and sentiment scoring over time. - **Proactive Trend Spotting:** Identify emerging issues or popular requests much earlier by analyzing aggregated data automatically. Spot patterns humans might miss. - **Free Up Your Team:** Let your talented team focus on acting on insights - improving products, fixing issues, engaging customers - instead of drowning in data entry. ## How It Works: AI Automation Step by Step Getting this set up is more straightforward than you might think, especially with tools like n8n acting as the central hub. ## Automated Feedback Triggering **CRM/Website Event Node** - Trigger feedback requests after: - Purchases (eCommerce) - Support ticket resolution - Feature usage (SaaS) **Time-Based Node** - Schedule recurring NPS surveys - Customer health check-ups **Chat App Node (WhatsApp/Telegram/Messenger)** - Send conversational feedback prompts: - How was your recent experience with [specific interaction]? ## Multi-Channel Feedback Collection **Email Node (SendGrid/Mailchimp)** - Send personalized feedback requests - Embed 1-5 rating widgets **SMS Node (Twilio)** - Short mobile surveys: - Reply 1-5: How satisfied with your purchase? **Webhook Node** - Capture in-app feedback - Process chatbot responses **Social Media Node** - Monitor Twitter/Facebook, Instagram mentions - Analyze comments for unsolicited feedback ## AI-Powered Real-Time Analysis **OpenAI/ChatGPT Node (Sentiment Analysis)** - **Prompt:** Analyze sentiment (positive/neutral/negative) and key themes from: [customer feedback] - Output fields: - Sentiment score (1-5) - Urgency flag (high/medium/low) - Key topics (billing, support, product, etc.) **Translation Node (Optional)** - Convert multilingual feedback into a consistent language ## Instant AI Response System **Conditional Node (Routing Logic)** - Positive feedback → Send thank-you + referral ask - Neutral feedback → Follow-up question for details - Negative feedback → Escalate to the human team
n8n$9.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 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 Resume Screening with AI: From Gmail to Google Sheets
Streamline your HR process by automatically screening resumes received via Gmail and evaluating them using AI, with results logged in Google Sheets.
n8n$14.99Track Expenses from Telegram to Google Sheets with GP-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.99Automated Mattermost Notifications from Google Sheets Data
The Automated Mattermost Notifications workflow streamlines the communication process by sending scheduled notifications to a Mattermost channel based on data stored in Google Sheets. This automation ensures that team members are consistently upda...
n8n$5.05Automate 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.99Automate TikTok Post Scraping by Keywords with Bright Data and Google Sheets
This workflow automates the process of scraping TikTok posts based on specific keywords using the Bright Data API and stores the extracted data in Google Sheets for easy analysis and monitoring.
n8n$9.99Automate Receipt Processing with Google Vision OCR and Telegram to Google Sheets
Streamline your financial reporting by automatically extracting and organizing receipt data using Google Vision OCR and Telegram, with results saved to Google Sheets.
n8n$19.99Automate AI-Driven Interviews with n8n and Google Sheets
Leverage n8n to automate interviews using AI agents and multi-page forms, capturing responses in Google Sheets for analysis.
n8n$19.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 Brazilian Company Data Enrichment with CNPJ API and Google Sheets
Enhance your Brazilian business databases by automatically fetching and updating CNPJ information from the MinhaReceita.org API into Google Sheets. Ideal for data analysts and sales teams needing comprehensive company data at scale.
n8n$9.99Automate Web Data Extraction Using Vision-Based AI with Google Sheets and ScrapingBee
Streamline your web scraping tasks with a vision-based AI agent that integrates with Google Sheets and ScrapingBee, enabling efficient data extraction from webpages.
n8n$14.99Automate PDF Document Creation and Distribution with Google Sheets and Gmail
This workflow automates the creation and distribution of personalized business documents in PDF format using data from Google Sheets. It integrates with CraftMyPDF for document generation, Google Drive for storage, and Gmail for email distribution.
n8n$9.99Automate Calorie Logging from Food Images to Google Sheets via LINE and OpenAI
This workflow enables LINE users to send food images or text to a LINE bot, which then analyzes the images using OpenAI's Vision model to estimate calories and logs the results into Google Sheets.
n8n$14.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.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.99Generate Accessible Alt Text with Claude AI from Google Sheets to WordPress
# AI-powered alt text generation from Google Sheets to WordPress media ## Who's it for WordPress site owners, content managers, and accessibility advocates who need to efficiently add alt text descriptions to multiple images for better SEO and web accessibility compliance. ## What it does This workflow automates the process of generating and updating alt text for WordPress media files using AI analysis. It reads image URLs from a Google Sheet, analyzes each image with Claude AI to generate accessibility-compliant descriptions, updates the sheet with the generated alt text, and automatically applies the descriptions to the corresponding WordPress media files. The workflow includes error handling to skip unsupported media formats and continue processing. ## How it works - Input: Provide a Google Sheets URL containing image URLs and WordPress media IDs - Authentication: Retrieves WordPress credentials from a separate sheet and generates Base64 authentication - Processing: Loops through each image URL in the sheet - AI Analysis: Claude AI analyzes each image and generates concise, accessible alt text (max 125 characters) - Error Handling: Automatically skips unsupported media formats and continues with the next item - Update Sheet: Writes the generated alt text back to the Google Sheet - WordPress Update: Updates the WordPress media library with the new alt text via REST API ## Requirements - Google Sheets with image URLs and WordPress media IDs - WordPress site with Application Passwords enabled - Claude AI (Anthropic) API credentials - WordPress admin credentials stored in Google Sheets - Export Media URLs WordPress plugin for generating the media list ## How to set up ### Step 1: Export your WordPress media URLs - Install the Export Media URLs plugin on your WordPress site - Go to the plugin settings and check both ID and URL columns for export (these are mandatory for the workflow) - Export your media list to get the required data ### Step 2: Configure WordPress Application Passwords - Go to WordPress Admin → Users → Your Profile - Scroll down to the Application Passwords section - Enter application name (e.g., n8n API) - Click Add New Application Password - Copy the generated password immediately (it won't be shown again) ### Step 3: Set up Google Sheets [Duplicate this Google Sheets template](https://docs.google.com/spreadsheets/d/1BKGQRx_xDiuh3QD3ACOOJomsWFuPBjCHYMQX8UzBE/edit?usp=sharing) to get the correct structure. The template includes two sheets: Sheet 1: Export media - Paste your exported media data with columns: - ID (WordPress media ID) - URL (image URL) - Alt text (will be populated by the workflow) Sheet 2: Infos client - Add your WordPress credentials: - Admin Name: Your WordPress username - KEY: The application password you generated - Domain: Your site URL without https:// (format: example.com) ### Step 4: Configure API credentials - Add your Anthropic API credentials to the Claude node - Connect your Google Sheets account to the Google Sheets nodes ## How to customize - Language: The Claude prompt is in French - modify it in the Analyze image node for other languages - Alt text length: Adjust the 125-character limit in the Claude prompt - Batch processing: Change the batch size in the Split in Batches node - Error handling: The workflow automatically handles unsupported formats, but you can modify the error handling logic - Authentication: Customize for different WordPress authentication methods This workflow is perfect for managing accessibility compliance across large WordPress media libraries while maintaining consistent, AI-generated descriptions. It's built to be resilient and will continue processing even when encountering unsupported media formats.
n8n$9.99AI-Powered Information Monitoring with OpenAI, Google Sheets, Jina AI, and Slack
**Check Legal Regulations**: This workflow involves scraping, so ensure you comply with the legal regulations in your country before getting started. Better safe than sorry! ## Purpose This workflow enables **automated and AI-driven topic monitoring**, delivering **concise article summaries** directly to a **Slack channel** in a structured and easy-to-read format. It allows users to stay informed on specific topics of interest effortlessly, without manually checking multiple sources, ensuring a **time-efficient and focused** monitoring experience. **To get started, copy the Google Sheets template required for this workflow from [here](https://docs.google.com/spreadsheets/d/1F2FzWt9FMkA5V5i9d_hBJRahLDvxs3DQBOLkLYowXbY).** ## Target Audience This workflow is designed for: - **Industry professionals** looking to track key developments in their field. - **Research teams** who need up-to-date insights on specific topics. - **Companies** aiming to keep their teams informed with relevant content. ## How It Works 1. **Trigger:** A **Scheduler** initiates the workflow at regular intervals (default: every hour). 2. **Data Retrieval:** - RSS feeds are fetched using the **RSS Read** node. - Previously monitored articles are checked in **Google Sheets** to avoid duplicates. 3. **Content Processing:** - The article relevance is assessed using **OpenAI (GPT-4-mini)**. - Relevant articles are scraped using **Jina AI** to extract content. - Summaries are generated and formatted for Slack. 4. **Output:** - Summaries are posted to the specified Slack channel. - Article metadata is stored in **Google Sheets** for tracking. ## Key APIs and Nodes Used - **Scheduler Node:** Triggers the workflow periodically. - **RSS Read:** Fetches the latest articles from defined RSS feeds. - **Google Sheets:** Stores monitored articles and manages feed URLs. - **OpenAI API (GPT-4-mini):** Classifies article relevance and generates summaries. - **Jina AI API:** Extracts the full content of relevant articles. - **Slack API:** Posts formatted messages to Slack channels. --- This workflow provides an **efficient and intelligent way** to stay informed about your topics of interest, directly within Slack.
n8n$24.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