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.
Automate YouTube Comment Sentiment Analysis with Google Sheets and AI
This n8n workflow automates the extraction and sentiment analysis of YouTube video comments using Google Sheets and AI, providing insights into audience sentiment.
n8n$14.99Automate Deep Research Markdown Reports with AI and Google Sheets
This workflow automates the creation of comprehensive research reports in Markdown format, leveraging AI for topic generation and avily for source collection, and saves the results in Google Sheets.
n8n$19.99Automate Gmail Email Sending Using Google Sheets Data
Streamline your email communication by automatically sending personalized emails via Gmail using data from Google Sheets. This workflow ensures efficiency, accuracy, and real-time updates.
n8n$9.99Lead Nurturing Automation with Google Sheets and AI
The Lead Nurturing Workflow is designed to streamline the process of engaging new leads who fill out forms on your website. By leveraging Google Sheets as a data source and utilizing AI to generate personalized email responses, this workflow ensur...
n8n$19.99Compare Different LLM Responses Side-by-Side with Google Sheets
This workflow allows you to **easily evaluate and compare the outputs of two language models (LLMs)** before choosing one for production. In the chat interface, both model outputs are shown side by side. Their responses are also logged into a Google Sheet, where they can be evaluated manually or automatically using a more advanced model. ### Use Case You're developing an AI agent, and since LLMs are non-deterministic, you want to determine which one performs best for your specific use case. This template is designed to help you compare them effectively. ### How It Works - The user sends a message to the chat interface. - The input is duplicated and sent to two different LLMs. - Each model processes the same prompt independently, using its own memory context. - Their answers, along with the user input and previous context, are logged to Google Sheets. - You can review, compare, and evaluate the model outputs manually (or automate it later). - In the chat, both responses are also shown one after the other for direct comparison. ### How to Use It - Copy this [Google Sheets template](https://docs.google.com/spreadsheets/d/1grO5jxm05kJ7if9wBIOozjkqW27i8tRedrheLRrpxf4/) (File > Make a Copy). - Set up your **System Prompt** and **Tools** in the **AI Agent** node to suit your use case. - Start chatting! Each message will trigger both models and log their responses to the spreadsheet. Note: This version is set up for two models. If you want to compare more, you'll need to extend the workflow logic and update the sheet. ### About Models You can use **OpenRouter** or **Vertex AI** to test models across providers. If you're using a node for a specific provider, like OpenAI, you can compare different models from that provider (e.g., `gpt-4.1` vs `gpt-4.1-mini`). ### Evaluation in Google Sheets This is ideal for teams, allowing non-technical stakeholders (not just data scientists) to evaluate responses based on real-world needs. Advanced users can automate this evaluation using a more capable model (like `o3` from **OpenAI**), but note that this will increase token usage and cost. ### Token Considerations Since **each input is processed by two different models**, the workflow will consume more tokens overall. Keep an eye on usage, especially if working with longer prompts or running multiple evaluations, as this can impact cost.
n8n$14.99Automate Sentiment Analysis of Customer Reviews in Google Sheets
Automatically analyze the sentiment of customer reviews added to a Google Sheet and update the sheet with the sentiment results. This workflow helps in quickly identifying customer satisfaction trends and prioritizing follow-ups.
n8n$4.99Drive-To-Store Lead Generation (with Coupon) with Google Sheets & SuiteCRM
Drive-to-Store is a multi-channel marketing strategy that includes both the web and the physical context, with the aim of increasing the number of customers and sales in physical stores. This strategy guides potential customers from the online world to the physical point of sale through the provision of a coupon that can be spent in the store or on an e-commerce site. The basic idea is to have a landing page with a form and a series of unique coupons to assign to leads as a reward for filling out the form. This workflow is ideal for businesses looking to automate lead generation and management, especially when integrating with CRM systems like SuiteCRM and using Google Sheets for data tracking. ### **How It Works** 1. **Form Submission**: - The workflow starts with the **On form submission** node, which triggers when a user submits a form on a landing page. The form collects the user's name, surname, email, and phone number. 2. **Form Data Processing**: - The **Form Fields** node extracts and sets the form data (name, surname, email, and phone) for use in subsequent steps. 3. **Duplicate Lead Check**: - The **Duplicate Lead?** node checks if the submitted email already exists in a Google Sheets document. If the email is found, the workflow responds with a duplicate lead message (**Respond KO** node) and stops further processing. 4. **Coupon Retrieval**: - If the email is not a duplicate, the **Get Coupon** node retrieves a coupon code from the Google Sheets document based on the lead's email. 5. **Lead Creation in SuiteCRM**: - The **Create Lead SuiteCRM** node creates a new lead in SuiteCRM using the form data and the retrieved coupon code. The lead includes: - First name, last name, email, phone number, and coupon code. 6. **Google Sheets Update**: - The **Update Sheet** node updates the Google Sheets document with the newly created lead's details, including: - Name, surname, email, phone, coupon code, lead ID, and the current date and time. 7. **Response to Webhook**: - The **Respond OK** node sends a success response back to the webhook, indicating that the lead was created successfully. --- ### **Set Up Steps** 1. **Configure Form Trigger**: - Set up the **On form submission** node to collect user data (name, surname, email, and phone) via a web form. 2. **Set Up Google Sheets Integration**: - Configure the **Duplicate Lead?**, **Get Coupon**, and **Update Sheet** nodes to interact with the Google Sheets document. Ensure the document contains columns for email, coupon, lead ID, and other relevant fields. 3. **Set Up SuiteCRM Authentication**: - Configure the **Token SuiteCRM** node with the appropriate client credentials (client ID and client secret) to obtain an access token from SuiteCRM. 4. **Set Up Lead Creation in SuiteCRM**: - Configure the **Create Lead SuiteCRM** node to send a POST request to SuiteCRM's API to create a new lead. Include the form data and coupon code in the request body. 5. **Set Up Webhook Responses**: - Configure the **Respond OK** and **Respond KO** nodes to send appropriate JSON responses back to the webhook based on whether the lead was created or if it was a duplicate. 6. **Test the Workflow**: - Submit a test form to ensure the workflow correctly checks for duplicates, retrieves a coupon, creates a lead in SuiteCRM, and updates the Google Sheets document. 7. **Activate the Workflow**: - Once tested, activate the workflow to automate the process of handling form submissions and lead creation. --- ### **Key Features** - **Duplicate Lead Check**: Prevents duplicate leads by checking if the email already exists in the Google Sheets document. - **Coupon Assignment**: Retrieves a coupon code from Google Sheets and assigns it to the new lead. - **SuiteCRM Integration**: Automatically creates a new lead in SuiteCRM with the form data and coupon code. - **Data Logging**: Logs all lead details in a Google Sheets document for tracking and analysis. - **Webhook Responses**: Provides immediate feedback on whether the lead was created successfully or if it was a duplicate.
n8n$14.99Automate Negative PR Monitoring on Reddit with AI and Google Sheets
This workflow automates the monitoring of brand reputation by scanning Reddit for negative sentiment, filtering relevant posts, and logging them into Google Sheets for tracking.
n8n$9.99Extract Data from Trip Receipts with GPT-4.1-mini, Google Sheets & Email Notifications
# Automated Expense Reporting Workflow With GPT-4.1-mini ## ☀ Who's it for This workflow is designed for employees who need to submit expense claims for business trips. It automates the process of extracting data from receipts/invoices, logging it to a Google Sheet, and notifying the finance team via email. Ideal users: - Employees submitting business trip expense claims - HR or Admins reviewing travel-related reimbursements - Finance teams responsible for processing claims ## ℹ How it works / What it does 1. **Employee submits a form** with trip information (name, department, purpose, dates) and uploads one or more receipts/invoices (PDF). 2. **Uploaded files are saved to Google Drive** for record-keeping. 3. Each PDF is passed to a **DocClaim Assistant agent**, which uses GPT-4.0 and a structured parser to extract structured invoice data. 4. The data is **transformed and formatted** into a standard JSON structure. 5. Two parallel paths are followed: - Invoice records are appended to a **Google Sheet** for centralized tracking. - A detailed **HTML email** summarizing the trip and expenses is generated and sent to the **finance department** for claim processing. ## ✅ How to set up 1. **Create a form** to capture: - Employee Name - Department - Trip Purpose - From Date / To Date - Receipt/Invoice File Upload (multiple PDFs) 2. **Configure file upload node** to store files in a specific Google Drive folder. 3. **Set up DocClaim Agent** using: - GPT-4.0 or any LLM with document analysis capability - Output parser for standardizing extracted receipt data (e.g., vendor, total, tax, date) 4. **Transform extracted data** into a structured claim record (Code Node). 5. **Path 1**: Save records to a Google Sheet (one row per expense). 6. **Path 2**: - Format the employee + claim data into a dynamic **HTML email** - Use `Send Email` node to notify the finance department (e.g., `finance@yourcompany.com`) ## 📋 Requirements - n8n running with access to: - Google Drive API (for file uploads) - Google Sheets API (for logging expenses) - Email node (SMTP or Gmail for sending) - GPT-4.0 or equivalent LLM with document parsing ability - PDF invoices with clear formatting - Shared Google Sheet for claim tracking - Optional: Shared inbox for finance team ## © How to customize the workflow - **Add approval steps**: route the email to a manager before finance - **Attach original PDFs**: include uploaded files in the email as attachments - **Localize for other languages**: adapt form labels, email content, or parser prompts - **Sync to ERP or accounting system**: replace Google Sheet with QuickBooks, Xero, etc. - **Set limits/validation**: enforce max claim per trip or required fields before submission - **Auto-tag expenses**: add categories (e.g., travel, accommodation) for better reporting
n8n$14.99Automate Business Data Enrichment for Company Domains with Perplexity AI and Google Sheets
This workflow automates the enrichment of company domain lists with detailed business information using Perplexity AI, storing results in Google Sheets for streamlined analysis.
n8n$9.99Automate Bank Slip Data Extraction from LINE to Google Sheets
Streamline your financial record-keeping by automatically extracting transaction details from bank slip images received via LINE and saving them to Google Sheets using SpaceOCR.
n8n$9.99Sequential Google Sheets Data Processing with Execution Control
Ensure reliable and sequential data processing from Google Sheets by preventing simultaneous workflow executions in n8n.
n8n$9.99Create Instagram posts from filtered Google Sheets rows and update the sheet with post details
A ready-to-use Make workflow that connects Google-sheets, Instagram-business. Create Instagram posts from filtered Google Sheets rows and update the sheet with post details. Customize and deploy in minutes.
Make$3.99AI Video Generator: 4x Cheaper than Veo3 via Google Sheets & Fal.AI
Generate 5-second AI videos from Google Sheets using Fal.AI's Kling 2.1. Input ideas, aspect ratio, and sound preference; get video links back in the sheet automatically.
n8n$24.99Enrich Google Sheets Contacts with Dropcontact & Add to Lemlist
Automate pulling contacts from Google Sheets, enriching them with verified emails and details via Dropcontact, then adding to Lemlist campaigns for seamless lead outreach.
n8n$12.99Automate Client Email Logging with AI and Google Sheets
Streamline your client communication management by automatically logging emails into Google Sheets. This workflow identifies client names using AI and organizes email data for easy access and analysis.
Activepieces$2.99Track Tech Stacks & Decision Makers with BuiltWith to Google Sheets
Automates tracking company technology stacks via BuiltWith API, identifies CTOs and tech leads, monitors changes, and exports insights to Google Sheets for competitive intelligence.
n8n$24.99Sync Google Calendar Events with Asana Tasks and Google Sheets
This Zap automates the process of managing your tasks and events by integrating Google Calendar with Asana and Google Sheets. It filters events based on their start time, looks up relevant data in Google Sheets, creates or updates tasks in Asana, and ensures that your task management is always in sync with your calendar events. This helps you stay organized and efficient, reducing the risk of missing important deadlines or tasks.
Zapier$4.99Automatically Add New Google Sheets Entries as Mailchimp Subscribers
Streamline your email marketing by automatically adding new entries from Google Sheets to your Mailchimp subscriber list. This workflow ensures that your contact list is always up-to-date with the latest information.
Make$2.99Automate Filtering and Updating Rows in Google Sheets
Enhance your data management by automatically filtering and updating rows in Google Sheets. This workflow streamlines the process by applying specific filters to identify necessary rows and updating them efficiently, reducing manual effort and boosting productivity.
Make$2.99Automate Google Sheets to Mailchimp Integration with Scheduled Triggers
This workflow automates the process of transferring contacts from Google Sheets to Mailchimp. By utilizing n8n's capabilities, users can easily integrate their Google Sheets data into Mailchimp, streamlining email marketing efforts. With a schedul...
n8n$15.34Automate Email Validation in Google Sheets with Email Validator AI
Validates email addresses from Google Sheets using Email Validator AI API via RapidAPI, then updates rows with disposable/fake status for data cleanup.
n8n$12.99Automated Expense Tracking with Google Sheets and AI Chat Integration
Streamline your expense management by automating data entry through chat messages into Google Sheets.
n8n$14.98Automate Transistor.fm Subscriber Creation from Google Sheets
Automatically add new subscribers to Transistor.fm whenever a new row is added to your Google Sheets. This workflow checks for updates every 15 minutes, ensuring your subscriber list is always up-to-date.
Make$2.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