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 Viral YouTube Video Analysis and Export to Google Sheets
Effortlessly analyze YouTube videos for viral potential by evaluating engagement metrics and export the results to Google Sheets for easy review and sharing.
n8n$14.99Automate Server Uptime Monitoring with Google Sheets and Email Alerts
This workflow automates server uptime monitoring by pinging servers listed in a Google Sheet every minute. It logs server status and sends email alerts if any server is down, ensuring you stay informed about server health without manual checks.
n8n$4.99Automate Vendor Risk Evaluation with AI and Google Sheets
Streamline the vendor onboarding process by automating risk evaluation, documentation, and alerts using AI and Google Sheets.
n8n$4.99Automate Export of Google Search Console Data to Google Sheets
This workflow automates the extraction of data from Google Search Console and exports it to Google Sheets for easy visualization and analysis, streamlining SEO tasks.
n8n$14.99Automate Video Transcription and Blog Research with AI and Google Sheets
This workflow automates the process of converting uploaded videos into structured blog research. It transcribes videos, extracts keywords, performs competitor research, and organizes the findings in Google Sheets using Dumpling AI and OpenAI.
n8n$9.99Generate Personalized Cold Outreach Icebreakers with GPT-4 and Google Sheets
## Automated Personalized Email Icebreakers This workflow automates creating personalized email icebreakers. It reads leads from a Google Sheet, scrapes their company website, uses OpenAI to analyze the data and craft a unique opening line, and then saves that icebreaker back into the original sheet. ## How It Works - **Fetch Lead**: The workflow starts, loops through your leads, and pulls one from your Google Sheet. - **Scrape & Summarize**: It scrapes the lead's company website and uses a fast OpenAI model to summarize the key points about the company and the person. - **Generate Icebreaker**: This summary is then sent to a more powerful OpenAI model, which follows specific instructions to write a short, personalized icebreaker. - **Update Sheet**: The new icebreaker is saved back into the correct lead's row in your Google Sheet, using their email to match the record. --- ## Requirements - An n8n instance. - An OpenAI API key with available credits. - A Google account with a Sheet for your leads. - The Google Sheet must have columns for lead data (e.g., `Email`, `Website`, `Company Name`) and an empty column named `icebreaker`. - The `Email` column must be unique for each lead. --- ## Setup Instructions 1. **Add Credentials**: In n8n, add your OpenAI API key and connect your Google account via the **Credentials** menu. 2. **Configure Google Sheets Nodes**: Select each of the two Google Sheets nodes (`Client data` and `Add icebreaker to sheet`). In each, choose your credential, select your spreadsheet and the specific sheet name, and ensure the column mapping is correct. 3. **Configure OpenAI Nodes**: Select both OpenAI nodes (`Summarizing prospect data` and `Creating icebreaker`) and choose your OpenAI credential from the dropdown. 4. **Verify Update Node**: On the final `Add icebreaker to sheet` node, ensure the **Operation** is set to `Append Or Update` and the **Matching Columns** field is set to `Email`. --- ## Customization Options - **Trigger**: Change the manual start to an automatic trigger, like when a new row is added to the sheet or on a daily schedule (Cron). - **AI Prompt**: Modify the prompt in the Creating icebreaker node to change the tone, style, or length of the output. - **AI Model**: Experiment with different OpenAI models (like `gpt-4`) for a different balance of cost, speed, and quality. - **Data Source**: Replace Google Sheets with a CRM like HubSpot or a database like Postgres.
n8n$9.99Automate Video Publishing Across Multiple Social Platforms from Google Sheets
This workflow automates the distribution of video content from Google Sheets to various social media platforms using the Blotato API. It efficiently manages video uploads and posts across Instagram, Facebook, LinkedIn, TikTok, YouTube, Threads, Twitter, Bluesky, and Pinterest, including AI-generated images for Pinterest.
n8n$14.99Automate MySQL to Google Sheets Data Sync with Duplicate Prevention
This n8n workflow automates the synchronization of new records from a MySQL database to a Google Sheet every 15 minutes, ensuring no duplicates are transferred.
n8n$9.99Generate SWOT Analysis Reports with OpenAI, Google Sheets & API Template PDF Export
### SWOT Analysis Generator that Produces PDF Reports In n8n Want to skip the manual work and instantly generate SWOT analyses for your business plans, investor decks, or strategy docs? This workflow lets you automate the entire SWOT (Strengths, Weaknesses, Opportunities, Threats) process—using AI and no-code tools! Whether you're using this for yourself or creating documents for clients, this workflow will save you hours of time and help identify the key components of growing any business. #### Tools We'll Be Using: - **OpenAI API**: Powers AI-driven extraction and generation of SWOT sections, introductions, conclusions, and more. - **n8n**: The no-code automation platform that orchestrates this workflow. - **Google Sheets**: Stores your company data and report outputs (download the provided SWOT Analysis template and fill it out). - **APItemplate.io**: Converts HTML reports into downloadable, multi-page PDFs. - **DeepSeek API** *(optional)*: An alternative to OpenAI for specific reasoning tasks. - **Gmail OAuth2**: Sends the final report via email. If you're building a business, doing client work, or just want faster strategic planning—this will save you HOURS. --- ### How It Works This n8n workflow transforms structured company data from a Google Sheet into a fully formatted, investor-grade SWOT report in both HTML and PDF formats. Here's the process in a few high-level steps: 1. **Load Data**: Pulls company information from the Company Info Input tab in the SWOT Analysis Google Sheet. 2. **AI Analysis**: Uses AI (via OpenAI or DeepSeek) to categorize data into Strengths, Weaknesses, Opportunities, and Threats, and generates detailed narrative sections for each. 3. **Create Report Sections**: Produces a strategic introduction, conclusion, table of contents, and title page using AI. 4. **Format and Combine**: Converts all sections into styled HTML and merges them into a single document. 5. **Generate PDF**: Converts the HTML into a polished, multi-page PDF using APItemplate.io. 6. **Save and Share**: Saves the report back to Google Sheets and emails the PDF to a specified recipient. The result is a professional, investor-ready SWOT report with minimal manual effort, ready for sharing or review. --- ### Setup Steps Setting up this workflow typically takes **15-30 minutes**, depending on your familiarity with the tools. Here's what you'll need to do: - **Configure Credentials**: Set up API keys and OAuth2 credentials for Google Sheets, OpenAI, APItemplate.io, Gmail, and optionally DeepSeek. - **Prepare Your Google Sheet**: Download the provided SWOT Analysis template, fill out the Company Info Input tab with your company data, and ensure it's accessible. - **Import the Workflow**: Copy the workflow JSON into your n8n instance and connect your credentials. **Detailed instructions** for each step, including credential setup and customization options, are available in the sticky notes within the workflow. Refer to these for step-by-step guidance. --- ### Benefits - **Efficiency**: Automates the entire SWOT report generation process, saving hours of manual work. - **Professional Output**: Delivers fully styled HTML and PDF reports with headings, paragraphs, and custom layouts. - **AI-Driven Insights**: Ensures clarity and relevance in every section through targeted AI analysis. - **Seamless Sharing**: Automatically saves reports to Google Sheets and emails them to stakeholders. This workflow is perfect for entrepreneurs, consultants, or strategists looking to streamline their SWOT analysis process and deliver high-quality, professional reports effortlessly.
n8n$24.99AI-Powered Credit Card Recommendation System with OpenAI GPT, Telegram & Google Sheets
Overview Confused about which credit card to actually get or swipe? With 100+ cards on the market, hidden caps, and milestone rules, most people end up leaving rewards, perks, and cashback on the table. This workflow uses n8n + GPT + Google Sheets + Telegram to recommend the best credit card for each user's lifestyle in under 3 seconds, while keeping the logic transparent with a value breakdown. What does this workflow do? This workflow: - Captures User Inputs - Users answer a 7-question lifestyle quiz via Telegram. - Stores Responses - Google Sheets logs all answers for resumption & deduplication. - Scores Answers - n8n Function nodes map single & multi-select inputs into scores. - Generates Recommendations - GPT analyses profile vs. 30+ card dataset. - Breaks Down Value - Outputs a transparent table of rewards, milestones, lounge value. - Delivers Results - Top 3 card picks returned instantly on Telegram. Why is this useful? Most card comparison tools only list features; they don't personalize or calculate actual value. This workflow builds a decision engine: - Personalized – matches lifestyle to best-fit cards - Transparent – shows value in real currency (rewards, milestones, lounges) - Fast – answers in under 3 seconds - Organized – Google Sheets keeps an audit trail of every user + dedupe Tools used - n8n (Orchestrator): Orchestration + logic branching - Telegram: User-facing quiz bot - Google Sheets: Database of credit cards + logs of user answers - OpenAI (GPT): Analyses user profile & generates recommendations Who is this for? - Fintech product builders – see how AI can power recommendation engines - Cardholders – understand which card fits their lifestyle best - n8n makers – learn how to combine Sheets + GPT + chat interface into one workflow How to adapt it for your country/location This workflow uses a credit card dataset stored in Google Sheets. To make it work for your country: - Build your dataset – scrape or collect card details from banks, comparison sites, or official portals - Fields to include: Fees, Reward rate, Lounge access, Forex markup, Reward caps, Milestones, Eligibility. - You can use web crawlers (e.g., Apify, PhantomBuster) to automate data collection. - Update the Google Sheet – replace the India dataset with your country's cards. - Adjust scoring logic – modify Function nodes if your cards use different reward structures (e.g., cashback %, miles, points value). - Run the workflow – GPT will analyse against the new dataset and generate recommendations specific to your country. This makes the workflow flexible for any geography. Workflow Highlights - End-to-end credit card recommendation pipeline (quiz → scoring → GPT → result) - Handles single + multi-select inputs fairly with % match scoring - Transparent value breakdown in local currency (rewards, milestones, lounge access) - Google Sheets for persistence, dedupe & audit trail - Delivers top 3 cards in <3 seconds on Telegram - Fully customizable for any country by swapping the dataset
n8n$24.99Automate Cold Lead Re-Engagement with AI, Outlook, and Google Sheets
This n8n workflow automates the re-engagement of cold leads by summarizing past emails and generating personalized outreach using OpenAI. It integrates with Google Sheets to pull contacts, fetches prior communications from Outlook, and drafts re-engagement emails for review.
n8n$9.99Automate E-commerce Platform Detection with Google Sheets
This n8n workflow automates the detection of e-commerce platforms, frameworks, and payment gateways by analyzing website data. It updates Google Sheets with structured results, aiding in lead generation, competitive analysis, and market research.
n8n$9.99Automate Twitter Brand Promotion with AI and Google Sheets Reporting
This n8n workflow automates brand promotion by generating human-like responses to Twitter posts using Anthropic Claude AI and logs the interactions in Google Sheets for tracking.
n8n$14.99Extract Business Email Addresses Using SerpApi and ScrapingBee from Google Sheets
# Lead Enrichment & Email Discovery from Google Sheets ## What this workflow does This template automates the enrichment of business leads from a Google Sheet by: * Triggering when a row is activated * Searching for company information with Serper.dev * Generating and validating potential contact pages * Scraping company pages with ScrapingBee * Extracting emails and updating the sheet * Marking rows as finished --- ## Prerequisites * Google Sheet with columns: `business type`, `city`, `state`, `activate` * **Copy the ready-to-use template:** [Sheet Template](https://docs.google.com/spreadsheets/d/1222vBxE2UBb1MK2xDMoQSd5WHQ7mA5Ew-W6vBgfCJs/edit?usp=sharing) * Google Sheets API credentials (from Google Cloud) * Serper.dev API key (free tier available) * ScrapingBee API key (free tier available) --- ## Inputs * **Google Sheet row:** Must include `business type`, `city`, `state`, `activate` * **Set Information Node:** `country`, `country_code`, `language`, `result_count` (can also be provided via columns in the sheet) --- ## Outputs * **Google Sheet update:** Company names, URLs, found email addresses (comma-separated if multiple), and status updates (`Running`, `Missing information`, `Finished`) --- ## Configuration Required * Connect Google Sheets node with your Google Cloud credentials * Add your Serper.dev API key to the HTTP Request node * Add your ScrapingBee API key to the scraping node * Adjust search and filtering options as needed --- ## How to customize the workflow * **Send `country`, `country_code`, and `result_count` from the sheet:** Add these as columns in your sheet and update the workflow to read their values dynamically, making your search fully configurable per row. * **Add more blacklist terms:** Update the code node with additional company names or keywords you want to exclude from the search results. * **Extract more contact details:** Modify the email extraction code to find other contact info (like phone numbers or social profiles) if needed.
n8n$14.99Convert JSON Data to Google Sheets Entries
This workflow reads JSON data from a file and appends it to a Google Sheets document, enabling seamless data transfer and storage.
n8n$3.99Automate Video Uploads to YouTube and LinkedIn from Google Sheets
Streamline your content distribution by automatically uploading new videos to YouTube and LinkedIn using links from Google Sheets. Enhance your online presence and ensure timely engagement with your audience.
Make$4.99Automate Daily Competitor Analysis with SerpAPI, Google Sheets, and Airtable
This workflow automates the process of gathering competitor information for companies listed in Google Sheets using SerpAPI, and logs the results in both Google Sheets and Airtable. It runs on a daily schedule, ensuring up-to-date insights without manual intervention.
n8n$9.99Gather Complete YouTube Channel Data to Google Sheets
### This N8N template demonstrates how to use our tool to collect key information from any YouTube channel - including title, description, custom URL, stats (views, subscribers, videos), creation date, country, keywords, thumbnails, and channel ID. Everything is fetched and saved directly in a linked Google Sheet. Use cases are many: Whether you're part of an MCN or YouTube channel network, a digital marketing agency, an influencer analyst, or a growth-focused YouTube consultant, this tool helps you instantly access detailed channel data for scouting, benchmarking, and strategic planning. It's perfect for competitive research, brand vetting, or building your next performance dashboard. ## How It Works - The workflow starts when you manually click **Test Workflow** or **Execute Workflow** in N8N. - It reads through the list of **full channel URLs or custom channel URLs** from the **Channel URLs** tab in a connected Google Sheet. Only the URLs marked with the **Ready** status will be processed. - The tool loops through each row and prepares the necessary data for the YouTube API call later. - A **Switch** node detects the URL type of each input (whether it's a full or custom channel URL) and routes it accordingly. - Based on the input type, the appropriate YouTube API endpoint is triggered to fetch channel metrics. - It checks whether the API call is successful before continuing: - If successful, the fetched data is written back to the connected Google Sheet in the same row and the row's status is updated to **Finished**. - If it fails, the row's status is updated to **Error**. ## How to Use - Download the workflow package. - Import the workflow package into your N8N interface. - Duplicate the [**YouTube - Get Channel Information** Google Sheet template](https://docs.google.com/spreadsheets/d/1easnNMrm8ovxhlZQwPUge6UbPnUVFKBeaQY5EmmG1gM/edit?gid=426418282#gid=426418282) into your Google Sheets account. - Set up **Google Cloud Console** credentials in the following nodes in N8N, ensuring enabled access and suitable rights to Google Sheets and YouTube services: + For Google Sheets access, ensure each node is properly connected to the correct tab in your connected Google Sheet template: Node **Google Sheets - Get Channel URLs** connected to tab **Channel URLs**; Node **Google Sheets - Update Data** connected to tab **Channel URLs**; Node **Google Sheets - Update Data - Error** connected to tab **Channel URLs**. + For YouTube access, set up a GET method to connect to YouTube API in the following nodes: Node **HTTP Request - Get Comments For Video URLs 1**; Node **HTTP Request - Get Comments For Video URLs 2**. - In your connected Google Sheet, enter the full or custom channel URLs that you want to crawl and set the row's status to **Ready**. - Run the workflow by clicking **Execute Workflow** or **Test Workflow** in N8N. - View the results in your Google Sheet: Successful fetches will update channel data in the same row in **Channel URLs** tab and the row's status is updated to **Finished**; otherwise, the row's status will be changed to **Error**. ## Requirements - Basic setup in Google Cloud Console (OAuth or API Key method enabled) with enabled access to YouTube and Google Sheets. ## How to Customize - By default, the workflow is manually triggered in N8N. However, you can automate the process by adding a Google Sheets trigger that monitors new entries in your **YouTube - Get Channel Information** template and starts the workflow automatically. ## Need Help? Join our community on different platforms for support, inspiration, and tips from others. Website: https://www.agentcircle.ai/ Etsy: https://www.etsy.com/shop/AgentCircle Gumroad: http://agentcircle.gumroad.com/ Discord Global: https://discord.gg/d8SkCzKwnP FB Page Global: https://www.facebook.com/agentcircle/ FB Group Global: https://www.facebook.com/groups/aiagentcircle/ X: https://x.com/agent_circle YouTube: https://www.youtube.com/@agentcircle LinkedIn: https://www.linkedin.com/company/agentcircle
n8n$9.99Streamline Resume Screening with AI and Google Sheets
Automate the resume review process by integrating AI-driven data extraction and Google Sheets for efficient candidate evaluation and tracking.
n8n$14.99Automatic Event Creation in Google Calendar from Google Sheets Data
This workflow streamlines the process of creating events in Google Calendar using event data stored in a Google Sheet. The process begins by retrieving the latest event entry from Google Sheets, ensuring only the most recent event details are processed. Once fetched, a Function node formats the event date to align with Google Calendar's required format, ensuring consistency and preventing date-related errors. After formatting, the structured event details are sent to Google Calendar, where an event is created with essential information such as the event title (summary), description, date, and location. Additionally, the workflow allows customization by setting the event's status as either Busy or Available, helping attendees manage their schedules. A background color can also be assigned for better visibility and categorization. By automating this process, you eliminate the need for manual event creation, ensuring seamless synchronization between Google Sheets and Google Calendar. This improves efficiency, accuracy, and productivity, making event management effortless. ## Prerequisites **Before setting up this workflow, ensure the following:** - You have an active Google account connected to Google Sheets and Google Calendar. - The Google Sheets API and Google Calendar API are enabled in the Google Cloud Console. - n8n has the necessary OAuth2 authentication configured for both Google Sheets and Google Calendar. - Your Google Sheet has columns for event details (event name, description, location, date, etc.). | Event Name | Event Description | Event Start Date | Location | |------------|-------------------|------------------|----------| | Birthday | Celebration | 27-Mar-1989 | City | | Anniversary| Celebration | 10-Jun-2015 | City | ## Customization Options - Modify the Google Sheets trigger to track updates in specific columns. - Adjust the data formatting function to support: - Different date/time formats - Time zone settings - Custom event colors - Attendee invitations ## Steps ### Step 1: Add the Google Sheets Trigger Node - Click Add Node and search for Google Sheets. - Select Google Sheets Trigger and add it to the workflow. - Authenticate using your Google account (select an existing account if already authenticated). - Select the Spreadsheet and Sheet Name to monitor. - Set the Trigger Event to Row Added. - Click Execute Node to test the connection. - Click Save. ### Step 2: Process Data with Function Node - Click Add Node and search for Function. - Add the Function Node and connect it to the Google Sheets Trigger Node. - In the function editor, write a script to extract and format data. - Ensure the required fields (title, location, date) are properly structured. - Click Execute Node to verify the formatted output. - Click Save. ### Step 3: Add the Google Calendar Node - Click Add Node and search for Google Calendar. - Select Create Event operation. - Authenticate with Google Calendar. - Map the required fields - Title - Description - Location - Start time - Optional: Set Event Status and Event Colors. - Click Execute Node to test event creation. - Click Save. ### Step 4: Final Steps - Connect all nodes in sequence (Google Sheets Trigger → Function Node → Google Calendar Node). - Test the workflow by adding a sample row in Google Sheets. - Verify that the event is created in Google Calendar with the correct title, description, date, and location. ## About WeblineIndia This workflow was built by the [AI development](https://www.weblineindia.com/ai-development.html) team at WeblineIndia. We help businesses automate processes, reduce repetitive work, and scale faster. Need something custom? You can [hire AI developers](https://www.weblineindia.com/hire-ai-developers.html) to build workflows tailored to your needs.
n8n$4.99Automate Daily Email Reminders from Google Sheets Using Gmail
Streamline your daily communication by automatically sending email reminders from Google Sheets using Gmail and n8n. Ideal for teams and businesses needing timely updates.
n8n$4.99Automate Customer Product Inquiries with AI and Google Sheets
Enhance your e-commerce customer service by automating product inquiries using AI to generate personalized responses from your Google Sheets product database.
n8n$9.99Build a Multi-Model AI Chatbot with Telegram, AIMLAPI, and Google Sheets
This n8n workflow allows Telegram users to interact with multiple AI models dynamically. Users can select models using #model_id commands and track their daily usage via Google Sheets.
n8n$14.99Automate Coupon Validation and Notification via Google Sheets and Gmail
Efficiently validate coupons, update records in Google Sheets, and notify users via Gmail. Streamline your coupon management to save time and reduce errors.
Activepieces$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