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 News Summarization and Email Delivery with OpenAI and Google Sheets
This workflow fetches top news headlines every 10 minutes, summarizes them using OpenAI's GPT-4o model, and sends a concise email digest to recipients listed in a Google Sheet. Ideal for staying informed with minimal effort.
n8n$4.99Monitor OpenAI Token Usage and AI Agent Metrics in Google Sheets
Automatically track and log token usage and costs from AI agents into Google Sheets for enhanced observability and billing transparency.
n8n$9.99Automate Real-time QuickBooks Invoice Sync to Google Sheets
# This n8n template from [Intuz](https://www.intuz.com/) provides a complete and automated solution for real-time financial reporting. It instantly syncs new QuickBooks invoices to Google Sheets, using specific invoice data or keywords as triggers to ensure your financial records are always accurate and up-to-date. It uses a webhook to capture every new or updated invoice and logs the essential details into a designated Google Sheet. Perfect for creating custom reports, data backups, or a real-time dashboard of your accounts receivable. ## Use Cases - **Financial Reporting:** Create a simple, shareable Google Sheet for team members who don't have QuickBooks access. - **Data Backup:** Maintain a secure, independent log of all your invoices outside of the QuickBooks ecosystem. - **Custom Dashboards:** Use the Google Sheet as a data source for tools like Google Data Studio or Grafana to build custom financial dashboards. - **Auditing:** Easily track the history and status of all invoices in a simple, searchable spreadsheet format. ## How it Works **1. Instant Webhook Trigger:** The workflow activates the moment an invoice is created or updated in QuickBooks. The QuickBooks webhook sends a notification to n8n, kicking off the process in real time. **2. Fetch Full Invoice Details:** The initial webhook notification only contains the invoice ID. This node uses that ID to make a call back to the QuickBooks API and retrieve the complete invoice data, including customer name, due date, and more. **3. Format Key Data:** A simple Code node cleans up the data fetched from QuickBooks. It extracts only the fields you need—ID, Domain, Customer Name, and Due Date—and structures them perfectly for the next step. **4. Append or Update in Google Sheets:** The final node connects to your Google Sheet and uses the powerful Append or Update operation. - If the ID of the invoice doesn't exist in the sheet, it adds a new row. - If the ID already exists, it updates the existing row with the latest information. This ensures your Google Sheet is always a perfect mirror of your QuickBooks invoice data, preventing duplicates and keeping everything current. ## Setup Instructions For this workflow to run successfully, follow these setup steps: **1. Credentials:** - QuickBooks: Connect your QuickBooks account credentials to n8n. - Google: Connect your Google account using OAuth2 credentials. Ensure the Google Sheets and Google Drive APIs are enabled. **2. QuickBooks Webhook Configuration:** - Activate the workflow. Copy the Production URL from the Webhook node. - In your Intuit Developer Portal, go to the webhooks section for your app. - Paste the URL and subscribe to Invoice events (e.g., Create, Update). **3. Google Sheet Setup:** - Create a Google Sheet for your invoice data. - Crucially, create the following headers in the first row of your sheet: - ID - Domain - Customer Name - Due Date **4. Node Configuration:** - In the Append or update row in sheet node, select your Google Sheet document and the specific sheet name from the dropdown lists. The columns should map automatically if you've set up the headers correctly. ## Connect with us - Website: https://www.intuz.com/services - Email: getstarted@intuz.com - LinkedIn: https://www.linkedin.com/company/intuz - Get Started: https://n8n.partnerlinks.io/intuz ## For Custom Workflow Automation Click here - [Get Started](https://www.intuz.com/get-started)
n8n$9.99Create Dynamic Forms with Auto-Updating Dropdowns from Google Sheets
This workflow enables the creation of forms with dropdown fields that automatically update based on data from Google Sheets, ensuring your forms always reflect the latest information.
n8n$14.99Automate AI-Powered Newsletter Drafts from Google Sheets to Notion
Transform Google Sheets entries into polished newsletter drafts in Notion using AI. This workflow automates the drafting process, leveraging GPT-3.5 for content creation and updating statuses in Google Sheets.
n8n$9.99Auto-Generate Product Comparison Pages with OpenAI & Google Sheets
## Auto-generate product comparison pages that help users buy faster This workflow creates detailed X vs Y product comparison pages designed to help readers make faster, more confident purchase decisions - all with zero manual writing. --- ### How it works - Triggered manually or via Google Sheets row - Takes two product names as input (e.g., "Notion vs Evernote") - Uses AI to generate: - A compelling title and meta description - Clear feature-by-feature comparison - Use-case-based recommendations - An FAQ section tailored to user pain points - Saves each section into a Google Sheet for review or publishing - Final output can be exported to your CMS or website builder (like Dorik, Webflow, etc.) --- ### Set up steps - You'll need OpenAI and Google Sheets credentials - Takes **10-15 minutes** to plug in your keys and connect the sheet - Adjust prompts to match your brand tone or SEO goals You can easily expand this to generate pricing tables, testimonials, or even localized versions using the same structure. --- Ideal for SaaS companies, affiliate marketers, or content teams who want to scale up comparison content - without spending hours writing.
n8n$24.99Automate WhatsApp Sales with AI and Google Sheets Integration
Transform your WhatsApp channel into an AI-driven sales assistant that integrates with Google Sheets for product data and sends purchase notifications via Gmail.
n8n$9.99Automated SEC Form D Filings Tracker with Google Sheets Integration
## Description This workflow automatically monitors and tracks SEC Form D filings (private placement offerings) by fetching data from the SEC EDGAR database every 10 minutes during business hours and saving new filings to Google Sheets for analysis and tracking. ## Who's it for - **Venture capitalists** tracking private funding rounds and market activity - **Investment analysts** researching private placement trends and opportunities - **Financial researchers** collecting data on private securities offerings - **Business development teams** identifying potential partnership or acquisition targets - **Compliance professionals** monitoring regulatory filings in their industry ## How it works The workflow connects to the SEC EDGAR RSS feed to fetch the latest Form D filings, parses the XML data, extracts key information including CIK numbers and filing links, filters out duplicates from previous runs, and automatically saves new filings to a Google Sheets document for easy analysis and tracking. ## What it does 1. **Automated scheduling** - Runs every 10 minutes during business hours (6 AM - 9 PM, Monday-Friday) 2. **Fetches SEC data** - Retrieves the 40 most recent Form D filings from SEC EDGAR RSS feed 3. **Parses filing data** - Converts XML to structured data and extracts CIK numbers, titles, and links 4. **Filters duplicates** - Only processes new filings that haven't been seen in previous executions 5. **Saves to sheets** - Appends new filing data to Google Sheets with proper formatting ## Requirements - **Google Sheets API access** with OAuth2 credentials configured - **Google Sheets document** - Make a copy of [this template sheet](https://docs.google.com/spreadsheets/d/1VoGfVpk1mMrqKIc5hsO7peYuLx0SwhsbW7uUeYJCmrU/edit?usp=sharing) - **n8n instance** running continuously for scheduled execution ## How to set up 1. **Copy the template Google Sheet** from the link above to your Google Drive 2. **Configure Google Sheets OAuth2** authentication in n8n credentials 3. **Update the Google Sheets document ID** in the Save to SEC Data Sheet node to point to your copied sheet 4. **Customize the User-Agent header** in the HTTP Request node with your contact information (required by SEC) 5. **Activate the workflow** - The schedule trigger will start monitoring automatically 6. **Test manually** by replacing the Schedule Trigger with a Manual Trigger for initial testing ## How to customize the workflow - **Schedule frequency**: Modify the cron expression in the Schedule Trigger (default: every 10 minutes) - **Business hours**: Adjust the time range (default: 6 AM - 9 PM EST) - **Working days**: Change from Monday-Friday to include weekends if needed - **Filing count**: Modify the SEC URL to fetch more than 40 filings (change `count=40` parameter) - **Form types**: Update the URL to track different SEC forms (change `type=D` to other form types) - **Output format**: Customize the Google Sheets column mapping to include additional fields - **Notifications**: Add Slack, email, or webhook nodes to get alerts for new filings ## Output data includes - **CIK Number** - Central Index Key for the filing company - **Company Title** - Name of the company making the filing - **Form Type** - Type of SEC form (Form D for private placements) - **HTML Filing Link** - Link to view the filing in SEC EDGAR system - **XML Filing Link** - Direct link to the raw text version of the filing - **Updated Date** - When the filing was submitted to SEC ## Key features - **Duplicate prevention** - Built-in deduplication ensures no filing is processed twice - **Business hours scheduling** - Respects SEC server load by running only during business hours - **SEC compliance** - Includes proper User-Agent header as required by SEC guidelines - **Automatic link generation** - Creates both HTML and XML links for easy access to filings - **CIK extraction** - Automatically extracts company CIK numbers from filing titles **Note**: This workflow is designed for monitoring public SEC filings and complies with SEC EDGAR access guidelines. The User-Agent header must be updated with your contact information before use.
n8n$9.99Automate AI Description Generation for New Google Sheets Entries Using GPT-4.1 Mini
This n8n workflow automatically generates AI-based descriptions for new entries in Google Sheets using GPT-4.1 Mini, streamlining content creation for various applications.
n8n$9.99Automate File URL Retrieval via LINE Bot and Google Sheets with AI
This workflow uses a LINE Bot to process natural language queries, extract filenames with AI, and retrieve corresponding Google Drive URLs from Google Sheets.
n8n$4.99Track YouTube Trends by Country and Language with RapidAPI and Google Sheets
Discover trending YouTube videos by country and language using this automated n8n workflow. This workflow utilizes the YouTube Trend Finder API and logs insights into Google Sheets, making it ideal for content creators, marketers, and researchers.
n8n$9.99Automate AI Upwork Proposal Generation with Apify, Google Sheets & Gemini
## Disclaimer Community nodes are used, and the template can only be used on self-hosted n8n instances.  ## This n8n template from [Intuz](https://www.intuz.com/) provides a complete and automated solution for finding relevant Upwork jobs and generating highly-personalized, knowledge-base-driven proposals using AI. This workflow acts as an autonomous agent, handling everything from job discovery to drafting the final proposal text, ready for you to review and submit. ## Who's this workflow for? - Freelancers & Consultants - Digital Agencies - Business Development Teams - Sales Professionals ## How it works **1. Scrape Upwork for New Jobs**: The workflow starts by running an Apify actor to scrape Upwork based on your defined criteria (keywords, categories, payment verification, etc.). **2. Log Jobs to Google Sheets:** The newly found job opportunities are automatically saved as new rows in a Google Sheet, creating a central dashboard for tracking. A notification is sent confirming the new jobs found. **3. Trigger AI Proposal Generation:** The workflow then reads the new jobs from the sheet and, for each one that hasn't been applied for, triggers the AI. **4. Craft a Knowledge-Based Proposal:** It sends the job details to a Google Gemini AI model. The AI uses a detailed, built-in Company Knowledge Base (which you can customize) to write a comprehensive and relevant proposal. It addresses client questions, highlights relevant experience, and suggests a timeline. **5. Save the Proposal Draft:** The AI-generated proposal is saved back into the Google Sheet in the corresponding job row. **6. Final Notification:** A final email is sent to notify you that the proposals are ready, including a link to the sheet for final review and submission on Upwork. ## Setup Instructions **1. Apify Configuration:** - In the "Run Upwork Actor..." node, connect your Apify account. - We have used this Apify scraper- [Upwork Extractor](https://apify.com/jupri/upwork) - In the Custom Body field, customize the search parameters (like category, search.any keywords) to match the jobs you are looking for. **2. Google Gemini AI Configuration:** - In the Google Gemini Chat Model node, connect your Google Gemini (PaLM) API account. - Crucially: In the Proposal Crafting node, edit the prompt to replace the Company Knowledge Base with your own company's details, services, and project examples. This is essential for personalizing the proposals. **3. Google Sheets Setup:** - Connect your Google Sheets account. - In all three Google Sheets nodes, select your credentials and update the Document ID and Sheet Name to point to your Upwork tracking sheet. **4. Gmail Configuration:** - In both Gmail nodes, connect your account and update the sending email address to your own. **5. Execute the Workflow:** - Click "Execute workflow" to run the entire job scraping and proposal generation process. ## Key Requirements to Use This Template - n8n Instance: An active n8n account (Cloud or self-hosted). - Apify Account: An active Apify account with an API key and sufficient credits/subscription to run the Upwork Extractor actor. - Google Account & Sheet: A pre-made Google Sheet with columns for Title, URL, Description, Skills, Questions, Applied, and Proposal Template. - Google Gemini AI Account: A Google Cloud account with the Vertex AI API (for Gemini models) enabled and an associated API Key. - Gmail Account: A Gmail account to send and receive notifications about the workflow's progress. ## Connect with us - Website: https://www.intuz.com/services - Email: getstarted@intuz.com - LinkedIn: https://www.linkedin.com/company/intuz - Get Started: https://n8n.partnerlinks.io/intuz ## For Custom Workflow Automation Click here- [Get Started](https://www.intuz.com/get-started)
n8n$14.99Automate Y Combinator Startup Data Collection with Apify and Google Sheets
Streamline the process of collecting and organizing startup data from Y Combinator into Google Sheets using Apify. Ideal for sales teams, investors, and researchers.
n8n$9.99Automate YouTube Channel Video Extraction to Google Sheets
This n8n workflow automates the extraction of video metadata from YouTube channels and saves it to Google Sheets. Ideal for content strategists, marketers, and researchers who need structured video data.
n8n$14.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.99Automate Blog Creation with AI and Google Sheets Integration
This n8n workflow automates the end-to-end process of generating, evaluating, and publishing SEO-friendly blog content using AI and Google Sheets. Ideal for marketing teams and content creators aiming to streamline their content pipeline.
n8n$9.99Automate TikTok Profile and Transcript Extraction to Google Sheets
Streamline the process of monitoring TikTok profiles and extracting video transcripts by automating data collection and storage in Google Sheets using Dumpling AI.
n8n$4.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.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.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 Local Business Contact Extraction with Google Sheets and AI
This n8n workflow automates the extraction of local business contact details using search terms and locations from Google Sheets. It enriches the data with email addresses using AI, ensuring efficient lead generation.
n8n$14.99Automate Cold Calling with AI and Google Sheets
Streamline your cold calling process by integrating Vapi.ai's conversational AI with Google Sheets and Slack, enabling efficient lead qualification and follow-up.
n8n$19.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.99Health Check Websites with Google Sheets & Telegram Alerts
## What does this template do? This workflow performs scheduled health checks on a list of URLs stored in a Google Sheet. Every X minutes, it retrieves the URLs, sends HTTP requests to check their availability, and notifies a Telegram chat if any request fails. You can easily replace Telegram with any other notification service supported by n8n, such as Slack, Discord, Email, or Microsoft Teams. ## Use Case Ideal for monitoring internal or external services, ensuring uptime and responsiveness. Integrate with your preferred messaging platform for real-time failure notifications without setting up complex infrastructure. ## What the Workflow Does - Triggers at regular intervals using **Schedule Trigger** - Reads URLs from a **Google Sheet** - Sends HTTP requests to check URL health - Sends failure alerts (including error code and URL) to **Telegram (or any service of your choice)** ## Apps & Services Used - Google Sheets - Telegram (or alternative notification service) - HTTP Request ## Pre-requisites - Telegram bot and chat ID (if using Telegram) - Connected Google Sheet with a `URLS` column ([template](https://docs.google.com/spreadsheets/d/17-tY9_wn-D2FV627Sx3-Z3abqFYvz794edej7es5J6w/edit?usp=sharing)) ## Customization Tips - Adjust the schedule interval in the trigger node - Replace Telegram with Slack, Email, Discord, or any other notification node - Customize alert messages with more context or formatting - Add filters, retries, or logging as needed
n8n$4.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