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.
Classify and Summarize WeChat Articles with GPT-4, Nano to Google Sheets, and Notion
## Who's it for ☀️ This template is perfect for content creators, marketers, and researchers managing WeChat public account articles! It's ideal for n8n newcomers or anyone wanting to save time on manual content analysis, especially if you use Google Sheets for tracking. Whether you're into AI, data analytics, or automation, this is for you! ➡️ ## How it works / What it does ⚙️ This workflow automates the retrieval, filtering, classification, and summarization of WeChat articles. It reads RSS feed links from a Google Sheet, filters articles from the last 10 days, cleans HTML content, classifies them as relevant or not, generates insightful Chinese summaries with AI, and saves results to Google Sheets and Notion. Outputs are Slack-formatted for team collaboration! ## How to set up 🛠️ 1. **Prepare Google Sheets**: Use your own documentId (replace the example) and set up sheets Save Initial Links (gid=198451233) and Save Processed Data (gid=1936091950). 2. **Configure Credentials**: Add Google Sheets and OpenAI API credentials—avoid hardcoding keys! 3. **Set RSS Feed**: Update the rss_feed_url in the RSS Read node with your WeChat RSS feed. 4. **Customize AI**: Tweak Relevance Classification and Basic LLM Chain prompts for your topics (e.g., data analytics, AI). 5. **Notion (Optional)**: Swap the databaseId (e.g., 22e79d55-2675-8055-a143-d55302c3c1b1) with your own. 6. **Run Workflow**: Trigger manually via the "Execute workflow" node. ## Requirements 📌 - n8n account with Google Sheets and OpenAI integrations. - Access to a WeChat public account RSS feed. - Basic JSON and node config knowledge. ## How to customize the workflow ⚒️ - **Topic Adjustment**: Update categories in Relevance Classification for new topics (e.g., technology, education). - **Summary Length**: Modify the LLM prompt in Basic LLM Chain to adjust length or style. - **Output Destination**: Add Slack or Email nodes for more outputs. - **Date Filter**: Change the IF (Filter by Date) condition (e.g., 7 days instead of 10). - **Scalability**: Use a Schedule Trigger node for automation.
n8n$14.99Automate HR Candidate Screening with AI Calls and Google Sheets
Streamline your HR candidate screening process by automating calls, transcriptions, and data analysis using AI and Google Sheets. Ideal for high-volume recruitment.
n8n$9.99Automated Reservation System with Telegram, Google Gemini AI, and Google Sheets
**What It Is** SmartReserve is a flexible, automated Telegram chatbot built in n8n that allows users to request and confirm reservations for any kind of resource—training sessions, equipment, appointments, event slots, or more. It connects with Google Sheets for live availability tracking and automatically sends confirmation emails to your users. **How It Works** **Telegram Chatbot Interface** Users interact with a friendly bot to submit their reservation request. The bot collects: - Date - Name - Email - Resource / Service - Start Time & End Time - Final confirmation All in one seamless message. **Conflict-Free Booking System** The bot checks your existing reservation sheet to avoid time overlaps before confirming. **Google Sheets Integration** Two spreadsheets are used: - Resource Info: Define available services, resources, or assets. - Reservation Log: Store confirmed reservations in structured rows. **Confirmation via Email** Once a reservation is accepted, the bot sends a detailed confirmation email to the user. **Setup Steps** 1. Import the n8n Workflow - Use the provided .json template inside your n8n workspace. 2. Create Your Google Sheets - Sheet 1: Resource Info (e.g., rooms, courts, sessions, etc.) - Sheet 2: Reservation Log with these headers: - Date | Name | Email | Resource | Start Time | End Time | Status 3. Set Telegram Bot Token - Create a Telegram bot and paste the token into n8n credentials. 4. Connect Google Sheets - Add your Google account to n8n and allow spreadsheet access. 5. Customize for Your Use Case - Rename “Resource” to anything (e.g., Room, Coach, Equipment). - Edit confirmation text and branding inside the “Set” and “Email” nodes. 6. Go Live! - Enable the workflow, and you're ready to accept real-time reservations. **What You Get** - One-click Telegram reservation system - Conflict checker with Google Sheets - Auto email confirmation - User-friendly one-shot data collection - Fully editable & extendable workflow - Future updates and support options **Need Help Setting It Up?** If you'd like help customizing or deploying this workflow, I offer quick setup assistance and extended support. Contact: tharwat.elsayed.hamad@gmail.com WhatsApp: +201061803236 Whether you're setting it up for your team, your club, or your business—I'm here to help!
n8n$9.99Automate Lead Generation & Email Outreach with Apify, Apollo.io, GP-4 & Google Sheets
## 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 solution to automate your entire B2B lead generation pipeline, from discovering recently funded companies to drafting hyper-personalized outreach emails with AI. ## Who's this workflow for? - Sales Development Representatives (SDRs) - Business Development Teams - Growth Hackers - Startup Founders - Marketing Agencies ## How it works **1. Scrape Funded Companies:** The workflow begins by using Apify to scrape a target list of recently funded companies directly from a Crunchbase search. **2. Enrich with Apollo.io:** It takes each company and uses the Apollo.io API to find key decision-makers (like VPs, Directors) and enrich their contact information, including finding their email addresses. **3. Populate Google Sheets:** All the gathered lead data—company name, contact name, title, email, LinkedIn URL, etc.—is neatly organized and added to a Google Sheet. **4. AI-Personalized Email Crafting:** The workflow sends the leads' information to OpenAI (GPT-4) with a highly specialized prompt, instructing it to write a concise, impactful, and hyper-personalized first touch cold email. **5. Update Lead List with Email Content:** Finally, the unique, AI-generated email is saved back into the Google Sheet alongside the corresponding lead's information, making it ready for you to send. ## Pre-conditions and Requirements Before you can successfully execute this workflow, you must have the following accounts, credentials, and assets in place. **1. n8n Instance:** You need an active n8n instance (self-hosted). **2. Apify Account & Crunchbase Access:** - Apify Account: A registered account on Apify. - Crunchbase Account: An active, logged-in Crunchbase account (a paid subscription is recommended for accessing detailed search filters). **3. Apollo.io API:** You need an Apollo.io plan that includes API access. You can generate the API from settings. **4. Google Sheet:** Create a new Google Sheet to store your leads. The workflow is configured for two tabs: one for raw data (HealthCare in the template) and one for email generation (Company sheet). **5. OpenAI Account:** An account with OpenAI with API access and billing set up. ## Setup Instructions **1. Apify Connection:** - Connect your Apify account in the Run an Actor node. - You'll need an Apify scraper, [here's the link](https://console.apify.com/actors/BBfgvSNWcySEk1jQO/input) - In the Custom Body field, update the search.url with your target Crunchbase discovery URL and provide a valid cookie for authentication. **2. Apollo.io Connection:** - Connect your Apollo.io account using HTTP Header Authentication in the three Apollo nodes. - You will need to provide your API key. **3. Google Sheets Connection:** - Connect your Google Sheets account. - Create a spreadsheet and update the Document ID and Sheet Name in the three Google Sheets nodes to match yours. Ensure your sheet columns are set up to receive the data. **4. OpenAI Connection:** - Connect your OpenAI account in the Message a model node. The prompt is pre-engineered for high-quality output, but you can tailor it to better fit your specific value proposition. **5. Activate Workflow:** - Click Execute workflow to run the automation manually and watch your AI-powered lead list build itself. ## Customization Guide This workflow is a powerful template. To adapt it to your specific business needs, you should review and modify the following nodes. **1. Changing Your Target Companies (The Source)** - Node: Run an Actor - What to change: The search.url parameter inside the customBody. - How to do it: 1. Go to Crunchbase and perform a search for your ideal companies (e.g., filter by different funding rounds, industry, location, keywords, etc.). 2. Copy the URL from your browser's address bar after the search results have loaded. 3. Paste this new URL as the value for search.url in the node. 4. You can also adjust count: 10 to pull more or fewer companies per run. Be mindful of Apify and Apollo credit usage. **2. Defining Your Ideal Contact Persona** - Node: Apollo - Get User - What to change: The person_seniorities and person_titles arrays in the jsonBody. - How to do it: **1. Seniority:** Modify the person_seniorities list to match who you sell to. Examples: [c_level, founder] or [manager, contributor]. **2. Job Titles:** This is crucial. Replace the existing list of titles (engineering, technology, etc.) with keywords relevant to your target buyer. For example, if you sell to marketing teams, you might use: [marketing, demand generation, growth, content, brand]. **3. Configuring Your Google Sheet Destination** - Nodes: Append or update row in sheet and Update row in sheet - What to change: The documentId and sheetName.
n8n$24.99Automate Social Media Posting from Google Sheets to Twitter and Instagram
This workflow automates the process of posting content from Google Sheets to Twitter and Instagram. It fetches pending rows, generates captions, converts them into images, and posts them on social media platforms.
n8n$14.99Automate Expense Tracking with Telegram and Google Sheets
Streamline your expense tracking by sending messages to a Telegram bot, which uses AI to parse and log expenses into Google Sheets. Perfect for freelancers and small business owners.
n8n$9.99Automate AI Content Creation and Publishing with Google Sheets and Telegram
This n8n workflow automates the creation and publishing of AI-generated content. It crafts unique articles in Thai, generates AI images, and publishes them to your website, notifying you via Telegram.
n8n$14.99AI Powered Language Teacher with Telegram, Google Sheets, and GPT-4
Tags: Productivity, Education, Learning, Language ### Context I'm a **Supply Chain Data Scientist from Paris** who lived six years in China - and yes, **learning Mandarin while working full-time was tough**.  Learning Mandarin as an adult can be very difficult, especially if you have a full-time job. With AI, you can now have a **Chinese tutor available 24/7** on your phone - no excuses left! It is with this spirit that I designed this workflow to support fellow Mandarin learners with a **Chinese teacher powered by GPT-4**. Boost your **language skills** with AI using N8N! For business inquiries, you can add me on [LinkedIn](https://www.linkedin.com/in/samir-saci) ### Who is this template for? This workflow template is designed for **language learners** and **educators** who need support to learn a vocabulary list in Mandarin (or any other language) using **Open AI GPT-4**, an **AI agent** and a **Telegram Bot** to interact with users.  For the vocabulary list, you can use another template shared in my profile [Generate Anki Flash Cards for Language Learning with Google Translate and GPT-4](https://n8n.io/workflows/3195-generate-anki-flash-cards-for-language-learning-with-google-translate-and-gpt-4/) to generate the Google Sheet needed in this workflow. ### How does it work? The workflow loads a **vocabulary list** stored in your **Google Sheet**.  The bot will: 1. Load your vocabulary list from Google Sheets 2. Generate multiple-choice questions with GPT-4 3. Evaluate your answer and give instant feedback 4. Loop to the next word until you're fluent  These fields will be automatically added to a Google Sheet, ready to be loaded in Anki to create flash cards. ### What do I need to start? This workflow does not require any advanced programming skills. #### Prerequisite - A **Google Drive Account** with a folder including a Google Sheet filled with the vocabulary list you want to learn. - API Credentials: **Open AI API** for the chat model, **Google Drive API** and **Google Sheets API** activated with OAuth2 credentials - A **Telegram Bot** with its token recorded in the Telegram Node Credentials - **A Google Sheet** with two columns (initialText: words in your own language, translatedText: words in the target language) ### Next Steps Follow the sticky notes to set up the parameters inside each node and get ready to pump your learning skills.  [Watch My Tutorial](https://youtu.be/MQV8wDSug7M) Curious how N8N can supercharge learning or supply chain? Let's connect on [LinkedIn](https://www.linkedin.com/in/samir-saci) --- ### Notes - This workflow can be used **for any language**. In the AI Agent prompt, you just need to replace Chinese with your language. This workflow has been created with N8N 1.82.1 Submitted: March 23, 2025
n8n$9.99Automate Daily Stock Market Insights with AI and Google Sheets
This n8n workflow delivers personalized daily stock market intelligence by integrating real-time data from Perplexity AI with your Google Sheets portfolio, providing actionable insights and trade suggestions via Telegram.
n8n$9.99Automated Vulnerability Scanning and Reporting with Nessus, AI, and Google Sheets
This workflow automates vulnerability scanning using Nessus, applies AI-based risk triage, and generates comprehensive reports in Google Sheets. It is designed for security teams to streamline compliance with NIST CSF and CISA KEV guidelines.
n8n$24.99Automate Invoice Data Extraction from Google Drive to Google Sheets with Dumpling AI
Streamline your invoice processing by automatically extracting data from Google Drive PDFs and saving it to Google Sheets using Dumpling AI. This workflow reduces manual entry errors and saves time for finance teams.
n8n$4.99Automate Birthday Discount Emails with Google Sheets and Gmail
This workflow automatically sends personalized birthday discount emails to customers by integrating Google Sheets and Gmail, enhancing customer loyalty and driving sales.
n8n$4.99Automate Construction Site Attendance with Geofencing and Google Sheets
This n8n workflow automates the tracking of construction site attendance using geofencing technology. It logs workers' Punch In and Punch Out times based on their GPS location, stores the data in Google Sheets, and sends email alerts for any errors.
n8n$4.99Automate Resume Screening from Gmail to Google Sheets with AI
This n8n workflow automates the process of collecting, extracting, and scoring resumes sent to a Gmail inbox. It uses AI to evaluate candidates and logs their scores in a Google Sheet, streamlining recruitment efforts.
n8n$4.99Automate Job Search and Organization with AI and Google Sheets
Streamline your job search by using AI to analyze your resume, find relevant job listings, and organize them in Google Sheets for easy access and management.
n8n$9.99Automate Instagram Carousel Posts with AI-Generated Content from Google Sheets
Streamline your Instagram content strategy by automatically creating and posting carousels with AI-generated images and captions, all sourced from Google Sheets.
n8n$19.99Automate Travel Agent Outreach with Web Scraping, OpenAI, and Google Sheets
**Automated Workflow: Scrape Travel Agent Contacts and Send Personalized Survey Emails** This workflow is designed to automate the process of scraping travel agent contact data, standardizing the information, storing it, and then sending out personalized survey emails using AI. It's especially useful for outreach campaigns, research, or lead generation. **Workflow Breakdown** **Part 1: Scraping and Storing Travel Agent Data** 1. **HTTP Scrape Website** - Type: HTTP Request (POST) - Function: Calls a third-party scraping API (https://api.firecrawl.dev...) to scrape data from a travel agent listing site. - Purpose: Extract raw HTML or structured data from a website containing contact info. 2. **OpenAI Standardize Data** - Type: OpenAI Message Model - Function: Uses AI to clean and standardize the raw scraped data into structured JSON (e.g., name, email, agency, location). - Purpose: Ensures uniformity in formatting, making data easier to process downstream. 3. **Split Out** - Type: Item Splitter - Function: Splits the standardized array of agent records into individual items. - Purpose: Allows appending each agent as a separate row in Google Sheets. 4. **Google Sheet - Data Store** - Type: Google Sheets (Append) - Function: Stores each individual record in a spreadsheet. - Purpose: Maintains a centralized and accessible log of scraped and processed contacts. **Part 2: Read Records and Send Personalized Survey Emails** Triggered Manually - when “Test Workflow” button is clicked. 1. **Trigger - When clicking Test Workflow** - Type: Manual Trigger - Function: Starts the second part of the workflow manually. - Use Case: Testing or running the outreach email process on demand. 2. **Google Sheet Data Store (Read)** - Type: Google Sheets (Read) - Function: Reads the stored travel agent records from the spreadsheet. - Purpose: Retrieves contact details and context for personalized messaging. 3. **OpenAI Mail Composer** - Type: OpenAI Message Model - Function: Generates a custom email for each agent using their details. - Purpose: Creates human-like, engaging emails that include a survey link (optional input). 4. **Google Sheet Update Records** - Type: Google Sheets (Update) - Function: Optionally marks the record as emailed or logs the date of outreach. - Purpose: Prevents duplicate outreach and helps track campaign status. 5. **Send Email** - Type: Email Node (SMTP or integrated service) - Function: Sends the personalized email generated by OpenAI. - Purpose: Delivers the survey to each travel agent with contextually relevant messaging. - Use Case: Targeted email outreach to travel agents. Collect insights or feedback via survey links. Use personalized messaging to improve response rates. **Benefits:** - Fully automated scraping and processing. - Personalized at scale using OpenAI. - Easily repeatable for different domains or campaigns. - Centralized recordkeeping in Google Sheets. **Tech Stack:** - n8n: Automation and workflow management - OpenAI: AI-based text standardization and email generation - Firecrawl (or similar): Web scraping API - Google Sheets: Data storage and tracking - Email Node: Survey email delivery
n8n$9.99Streamline Gym Lead Management with Facebook Ads, WhatsApp, and Google Sheets
This workflow captures leads from Facebook Ads, sends automated WhatsApp messages, and tracks bookings in Google Sheets. It ensures efficient lead nurturing by sending reminders for up to five days and stops follow-ups once a booking is confirmed.
n8n$14.99Automate Customer Interactions with WhatsApp Business and Google Sheets
This n8n workflow automates customer interactions and appointment management using WhatsApp Business and Google Sheets. It sends notifications, stores user messages, and manages replies efficiently.
n8n$9.99Automate Instagram Reel Analysis and Content Creation with AI and Google Sheets
This workflow automates the process of analyzing Instagram Reels and generating viral content ideas using AI. It extracts insights and scripts from Reels, saving them to Google Sheets for easy access.
n8n$24.99Automated Cold Email Outreach with Gmail & Google Sheets
**Description:** Boost your sales pipeline with this fully automated Cold Email Outreach workflow in n8n, integrating Gmail and Google Sheets. This template sends cold emails daily at 2 PM to leads fetched from a Google Sheet. Once an email is sent, the workflow updates the lead's status to prevent duplicates. **Features:** - Daily scheduled trigger at 2 PM - Fetches leads with status not emailed from Google Sheets - Sends emails via Gmail - Updates lead status in Google Sheets post-email - Batch processing for efficient outreach Perfect for freelancers, agencies, and startups looking to automate lead engagement and track responses in real-time—all without writing a single line of code.
n8n$4.99Automate Personalized Cold Emails for Dental Clinics Using Google Sheets and OpenAI
This n8n workflow automates the creation of personalized cold emails for dental clinics, leveraging Google Sheets and OpenAI's GP-4o-mini model to enhance outreach efficiency and engagement.
n8n$9.99Automate Invoice and Receipt Data Extraction to Google Sheets
Streamline your bookkeeping by automatically extracting invoice and receipt data using Gemini OCR and saving it to Google Sheets from sources like Google Drive, Gmail, and Telegram.
n8n$14.99Automate AI-Driven Outreach with Google Sheets, Gmail, and Gemini
Streamline your lead generation and outreach by integrating AI-generated messaging with Google Sheets and Gmail using n8n. This workflow automates personalized email campaigns, leveraging Google Gemini for AI-optimized content.
n8n$9.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