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.
Capture Facebook Leads in Google Sheets and Send Emails
This Zap automates the process of capturing leads from Facebook Lead Ads and adding them directly to a Google Sheets spreadsheet. By streamlining this workflow, you can ensure that all your leads are organized in one place, making it easier to manage and follow up with potential customers. This integration saves time and reduces the risk of losing valuable leads, allowing you to focus on converting them into sales.
Zapier$2.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 Email Categorization and Telegram Alerts with AI and Google Sheets
This workflow automatically categorizes incoming emails using Azure OpenAI and sends relevant alerts via Telegram. It also logs email details in Google Sheets for easy tracking and follow-up.
n8n$14.99Automate Lead Qualification in Google Sheets Using OpenAI GPT-4
This workflow automates the process of qualifying leads in Google Sheets by leveraging OpenAI's GPT-4. It evaluates new entries based on predefined criteria and updates the sheet with the qualification results.
n8n$9.99Automate Business Idea Extraction from Upwork Listings to Google Sheets
This workflow automatically fetches high-budget job listings from Upwork, extracts core business ideas using AI, and records them in a Google Sheet. It streamlines the process of identifying and documenting potential business opportunities.
n8n$14.99Automate Spotify Music Downloads to Google Drive with Logging in Google Sheets
This workflow automates the process of downloading Spotify tracks, storing them in Google Drive, and logging the details in Google Sheets. It streamlines music management for enthusiasts and content creators.
n8n$14.99Create a Context-Aware Slack Assistant with Google Sheets, Pinecone & GPT-4
This advanced n8n automation template empowers your Slack bot to act as an intelligent assistant: when a user asks a question or requests a suggestion (by mentioning the bot), it automatically retrieves the user's historical data and previous interactions from both Google Sheets and Pinecone. Using GPT-4o, the bot analyzes past updates, status reports, and context to generate a personalized, context-aware response directly in Slack. Perfect for teams seeking instant, data-driven support, this workflow transforms your Slack bot into a smart knowledge assistant that references your own organizational history to provide relevant answers and suggestions. **What This Template Does (Step-by-Step)** **Slack Bot Mention Trigger** - Listens for message or app_mention events where a user asks a question or requests a suggestion. - Captures the message body and user ID. **User Profile & Data Fetch** - Uses the Slack API to retrieve the user's profile. - Queries Google Sheets and Pinecone to collect the user's historical updates and interactions. **Contextual AI Lookup** - GPT-4o reviews the user's past status reports, messages, and activity. - Synthesizes a contextually relevant answer or suggestion based on prior data. **Personalized Response Generation** - The bot replies in Slack with a tailored answer, referencing the user's previous updates and current context. **Auto-Fix & Schema Validation** - Ensures the generated response is well-structured and matches your organization's data schema. **Document Update (Optional)** - Optionally logs the new interaction or suggestion back to Pinecone for future reference. **Required Integrations** - Slack Bot with channels:history, app_mentions:read, and users.profile:read - Google Sheets OAuth2 (for lead or user status records) - Pinecone Vector Store (for storing user status documents) - Azure OpenAI or OpenAI GPT-4o (for document generation and merging) - Cohere API (optional) for reranking relevance in vector search **Ideal For** - Remote teams running async daily standups - People ops tracking onboarding or churn signals - Founders building internal GP-powered tools - Managers consolidating Slack-based updates across teams - Teams wanting a Slack bot that provides personalized answers and suggestions based on past activity - Managers and team members seeking quick, AI-powered support and insights from their own work history - Organizations aiming to leverage internal data for smarter, context-aware assistance in Slack
n8n$14.99Create eSignatures.io contracts from Google Sheets
Every time a new row is added to your Google Sheets spreadsheet, Make will automatically create a contract from an eSignatures.io template. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1LuxqFtx8eBNUwLyHkPxbUpP-aqMMX8ykE25Yn4UmKk/edit?usp=sharing).
Make$3.99Interact with Event Schedules via Telegram Using Google Sheets
Enable seamless interaction with your event schedules stored in Google Sheets through a Telegram bot. This workflow allows users to query and receive information about past, present, and future events directly in Telegram.
n8n$14.99Automate LinkedIn Engagement with AI and Google Sheets Logging
This n8n workflow automates LinkedIn engagement by scraping posts, generating AI-driven comments, and logging interactions in Google Sheets. Enhance your professional networking with minimal effort.
n8n$9.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.99Google Sheets Form Automation: Collect User Insights Effortlessly
This workflow is designed to streamline the process of collecting user insights via a series of interactive forms, all integrated seamlessly with Google Sheets. By leveraging automation, businesses can efficiently gather valuable information from ...
Zapier$4.14Automate LinkedIn Posts from AI Tweets Using GPT-4 and Google Sheets
This workflow automatically creates and schedules LinkedIn posts from trending AI-related tweets. It fetches tweets, processes them to ensure uniqueness, formats them for LinkedIn, and posts them on a schedule.
n8n$24.99Extract & Summarize B2B Leads from Crunchbase with Bright Data, GPT-4O & Google Sheets
### Who this is for The Crunchbase B2B Lead Discovery Pipeline is designed for sales teams, B2B marketers, business analysts, and data operations teams who need a reliable way to extract, structure, and summarize company information from Crunchbase to fuel lead generation and market intelligence. This workflow is ideal for: 1. **Sales Development Reps (SDRs)** - Needing structured leads from Crunchbase 2. **Marketing Analysts** - Generating segmented outreach lists 3. **Growth Teams** - Identifying trending B2B startups 4. **RevOps Teams** - Automating company research pipelines 5. **Data Teams** - Consolidating insights into Google Sheets for dashboards ### What problem is this workflow solving? Manual extraction of company data from Crunchbase is time-consuming, inconsistent, and often lacks the contextual summary required for sales enablement or growth targeting. This workflow automates the extraction, transformation, summarization, and delivery of Crunchbase company data into structured formats, making it instantly usable for B2B targeting and analysis. It solves: - The difficulty of scaling lead discovery from Crunchbase - The need to summarize raw textual content for quick insights - The lack of integration between web scraping, LLM processing, and storage ### What this workflow does - **Markdown to Textual Data Extractor**: Takes raw scraped markdown from Crunchbase and converts it into readable plain text using a basic LLM chain - **Structured Data Extraction**: Applies a parsing model (OpenAI) to extract structured fields such as company name, funding rounds, industry tags, location, and founding year - **Summarization Chain**: Generates an executive summary from the raw Crunchbase text using a summarization prompt template - **Send to Google Sheets**: Adds the structured data and summary into a Google Sheet for team access and further processing - **Persist to Disk**: Saves both raw and structured data files locally for archiving or further use - **Webhook Notification**: Sends a structured payload to a webhook endpoint (e.g., Slack, CRM, internal tools) with lead insights ### Pre-conditions 1. You need to have a [Bright Data](https://brightdata.com/) account and do the necessary setup as mentioned in the Setup section below. 2. You need to have an OpenAI Account. ### Setup - Sign up at [Bright Data](https://brightdata.com/). - Navigate to Proxies & Scraping and create a new Web Unlocker zone by selecting Web Unlocker API under Scraping Solutions. - In n8n, configure the Header Auth account under Credentials (Generic Auth Type: Header Authentication).  The Value field should be set with the **Bearer XXXXXXXXXXXXXX**. The XXXXXXXXXXXXXX should be replaced by the Web Unlocker token. - In n8n, Configure the Google Sheet Credentials with your own account. Follow this documentation - [Set Google Sheet Credential](https://docs.n8n.io/integrations/builtin/credentials/google/) - In n8n, configure the OpenAi account credentials. - Ensure the URL and Bright Data zone name are correctly set in the **Set URL, Filename and Bright Data Zone** node. - Set the desired local path in the **Write a file** to disk node to save the responses. ### How to customize this workflow to your needs **LLM Prompt Customization**: - Modify the extraction prompt to include additional fields like revenue, social links, leadership team - Adjust summarization tone (e.g., executive summary, sales-focused snapshot or marketing digest) **File Persistence** - Store raw markdown, extracted JSON, and summary text separately for audit/debug **Webhook Notification** - Connect to CRM (e.g., HubSpot, Salesforce) via webhook to automatically create leads - Send Slack notifications to alert sales reps when a new high-potential company is discovered
n8n$14.99Automate Customer Feedback Analysis and Reporting with AI and Google Sheets
This workflow automates the analysis of customer feedback from Google Sheets using AI, generating insights, visualizations, and a comprehensive report ready for email delivery.
n8n$19.99Automate Driver License Data Extraction with Google Drive, VLM Run, and Google Sheets
Streamline the process of extracting data from driver license images uploaded to Google Drive using VLM Run's AI OCR, and store the structured data in Google Sheets.
n8n$9.99AI-Powered RAG Q&A Chatbot with OpenAI, Google Sheets, Glide, & Supabase
**Automate AI-Powered RAG System with Contextual Q&A, Google Sheets Integration, and Glide Frontend-Powered by n8n, OpenAI, Supabase, and Google Apps Script.** # Tools & Services Used - Glide (Frontend for user interactions) - Google Sheets (Stores questions and answers) - Google Apps Script (Forms + media upload handling) - OpenAI (Embeddings + GPT-4 to rank and generate answers) - Supabase (Optional for image hosting) - n8n (Automation logic and backend glue) # Workflow Overview ## This automation performs the following steps: - **Trigger**: Webhook receives a user question from a Glide frontend. - **Fetch Data**: Retrieves Q&A entries (and optionally, image URLs) from a connected Google Sheet. - **Rank Relevance**: - OpenAI Embeddings rank the relevance of stored questions to the new input. - Top matches are passed to a GPT-4 prompt for answer generation. - **Generate Answer**: - GPT-4 creates a contextual answer using the best match. - Optional: Includes media URL if attached to the matched answer. - **Response**: Sends the formatted answer back to Glide frontend (text + optional image). # Prerequisites ## Active accounts and API keys for: - OpenAI (API key with GPT-4 and embedding access) - Google Sheets (linked via Service Account or OAuth2 credentials) - Glide App (with a form to submit questions) - Supabase (optional, if hosting user-uploaded media) - n8n Self-hosted (for community nodes and webhook access) # How to Use This Template ## Step 1: Import the Template - Upload the provided JSON into your self-hosted n8n instance. - Requires installation of the Community Node: @n8n/n8n-nodes-openai-embeddings ## Step 2: Configure Credentials - **Webhook Trigger**: Replace the Glide webhook URL with your actual endpoint from your app. - **Google Sheets Node**: Set the spreadsheet ID and worksheet name to fetch your Q&A dataset. - **OpenAI Nodes**: - Insert your OpenAI API key. - Confirm that both text-embedding-ada-002 (or similar) and gpt-4 are available. - **Supabase or Apps Script (Optional)**: Ensure image links are correctly formed in the Sheet. ## Step 3: Customize Prompts and Thresholds - Update the OpenAI ranking prompt or similarity threshold in the Function or Code node. - Tailor GPT-4 prompts to return concise or detailed answers based on your use case. # Initial Test Run - Simulate a Question: - Trigger the Glide form with a sample question. - Check n8n logs for: - Matching score/ranking success - Correct retrieval from Sheets - GPT-4 answer generation - Image URL handling (if enabled) # Production Prep - Add error-handling nodes for cases when Sheets are empty or GPT-4 fails. - Set up logging via Google Sheets, Supabase, or external database. - Rate-limit or debounce requests from Glide if needed. # Use Cases - Customer Support Portals: Offer instant Q&A with your business data. - Internal Knowledgebase: Employees can query training manuals and SOPs. - AI Concierge: Combine structured answers with a friendly tone for guest interactions. # Disclaimer - Validate Glide form inputs before full deployment. - Ensure your OpenAI and Google Sheets usage stays within quota limits.
n8n$24.99Integrate Multi-Source AI Agent with OpenAI, Perplexity, and Google Sheets
Leverage a powerful AI agent that combines OpenAI's intelligence with real-time web searches, vector databases, and Google Sheets for comprehensive data retrieval and decision-making.
n8n$9.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.99Find Reddit Prospects & Generate Personalized Responses with Llama3 AI and Google Sheets
## Turn Reddit into Your Most Powerful Lead Generation Channel Discover hot prospects on Reddit who are actively discussing problems your product can solve - without spending hours manually searching and responding. This intelligent workflow automatically finds relevant conversations, analyzes intent with Llama3 AI, and crafts personalized responses that drive conversions. ### Automated Prospect Discovery Stop wasting time manually searching Reddit. Let AI find people who genuinely need your solution - while you focus on higher-value tasks. The workflow monitors target subreddits 24/7, ensuring you never miss a potential lead. ### Intelligent Relevance Filtering Not all mentions are quality leads. Our sophisticated Llama3 AI engine analyzes post content, sentiment, and intent to identify true business opportunities. Say goodbye to false positives and low-quality interactions. ### Personalized Response Generation Generic outreach gets ignored. This workflow crafts individualized responses that reference specific pain points from each post, positioning your solution as the perfect answer to their problem - dramatically increasing engagement rates. ### Complete Activity Tracking Every interaction is automatically logged in Google Sheets, creating a comprehensive database of your Reddit prospecting activities. Track which posts received responses, measure engagement, and refine your targeting over time. ### Set It and Forget It Once configured, the entire process runs autonomously. No more daily Reddit searches or manual outreach - just check your dashboard to see new prospects and conversations. ## Perfect For: - SaaS businesses targeting specific use cases - Consultants and agencies looking for clients with specific problems - Product companies monitoring customer pain points - Support teams finding users who need help ## Technical Requirements: - Reddit API credentials - Ollama with Llama3 model - Google account for tracking Get started today and transform Reddit from a time-sink into your most efficient lead generation channel!
n8n$9.99Create Trello cards from new Google Sheets spreadsheet rows
Create new Trello cards every time you add a row to your Google Sheets spreadsheet, powered by Make. This template uses this [example spreadsheet that we recommend to download](https://goo.gl/BqvfTW).
Make$2.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.99Automate Amazon Price Monitoring with Bright Data and Google Sheets
This workflow automates the process of monitoring Amazon product prices using Bright Data's Amazon Scraper API and Google Sheets. Ideal for market research, competitor analysis, or personal price tracking, it retrieves and updates price data for specified products.
n8n$9.99Extract, Summarize & Analyze Amazon Price Drops with Bright Data & Google Sheets
### Notice Community nodes can only be installed on self-hosted instances of n8n. ### Who this is for This n8n-powered automation uses Bright Data's MCP Client to extract real-time data from a price drop site listing Amazon products, including price changes and related product details. The extracted data is enriched with structured data transformation, content summarization, and sentiment analysis using Google Gemini LLM. The Amazon Price Drop Intelligence Engine is designed for: - **Ecommerce Analysts** who need timely updates on competitor pricing trends - **Brand Managers** seeking to understand consumer sentiment around pricing - **Data Scientists** building pricing models or enrichment pipelines - **Affiliate Marketers** looking to optimize campaigns based on dynamic pricing - **AI Developers** automating product intelligence pipelines ### What problem is this workflow solving? This workflow solves several key pain points: **Reliable Scraping**: Uses Bright Data MCP, a managed crawling platform that handles proxies, captchas, and site structure changes automatically. **Insight Generation**: Transforms unstructured HTML into structured data and then into human-readable summaries using Google Gemini LLM. **Sentiment Context**: Goes beyond raw pricing data to reveal how customers feel about the price change, helping businesses and researchers measure consumer reaction. **Automated Reporting**: Aggregates and stores data for easy access and downstream automation (e.g., dashboards, notifications, pricing models). ### What this workflow does **Scrape price drop site with Bright Data MCP** The workflow begins by scraping targeted price drop site for Amazon listings using Bright Data's Model Context Protocol (MCP). You can configure this to target: **Structured Data Extraction** Once the HTML content is retrieved, Google Gemini is employed to: - Parse and structure the product information (title, price, discount, brand, ratings) **Summarization & Sentiment Analysis** The extracted data is passed through an LLM chain to: - Generate a concise summary of the product and its recent price movement - Perform sentiment analysis on user reviews and public perception **Store the Results** - Save to disk for archiving or bulk processing - Updated in a Google Sheet, making it instantly shareable with your team or integrated into a BI dashboard ### Pre-conditions 1. Knowledge of Model Context Protocol (MCP) is highly essential. Please read this blog post - [model-context-protocol](https://www.anthropic.com/news/model-context-protocol) 2. You need to have the [Bright Data](https://brightdata.com/) account and do the necessary setup as mentioned in the **Setup** section below. 3. You need to have the Google Gemini API Key. Visit [Google AI Studio](https://aistudio.google.com/) 4. You need to install the Bright Data MCP Server [@brightdata/mcp](https://www.npmjs.com/package/@brightdata/mcp) 5. You need to install the [n8n-nodes-mcp](https://github.com/nerding-io/n8n-nodes-mcp) ### Setup 1. Please make sure to set up n8n locally with MCP Servers by navigating to [n8n-nodes-mcp](https://www.youtube.com/watch?v=NUb73ErUCsA) 2. Please make sure to install the Bright Data MCP Server [@brightdata/mcp](https://www.npmjs.com/package/@brightdata/mcp) on your local machine. 3. Sign up at [Bright Data](https://brightdata.com/). 4. Create a Web Unlocker proxy zone called mcp_unlocker on Bright Data control panel. 5. Navigate to Proxies & Scraping and create a new Web Unlocker zone by selecting Web Unlocker API under Scraping Solutions. 6. In n8n, configure the Google Gemini (PaLM) API account with the Google Gemini API key (or access through Vertex AI or proxy). 7. In n8n, configure the credentials to connect with MCP Client (SDIO) account with the Bright Data MCP Server as shown below.  Make sure to copy the Bright Data API_TOKEN within the Environments textbox above as API_TOKEN=<your-token> ### How to customize this workflow to your needs - **Target different platforms**: Switch Amazon for Walmart, eBay, or any e-commerce source using Bright Data's flexible scraping infrastructure. - **Enrich with more LLM tasks**: Add brand tone analysis, category classification, or competitive benchmarking using Gemini prompts. - **Visualize output**: Pipe the Google Sheet to Looker Studio, Tableau, or Power BI. - **Notification integrations**: Add Slack, Discord, or email notifications for price drop alerts.
n8n$14.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