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.
Automated AI Resume Screening and Evaluation with Google Sheets and Drive
This workflow automates the resume screening process using AI to extract and evaluate candidate information against job criteria stored in Google Sheets. It saves results in Google Sheets and uploads CVs to Google Drive, streamlining HR operations.
n8n$14.99Automate PDF Invoice Creation from Google Sheets Using PDF.co
This workflow automates the process of generating PDF invoices from Google Sheets data using a PDF.co template, ideal for small businesses seeking professional invoices.
n8n$4.99Automate AI Token Usage Tracking and Cost Estimation in Google Sheets
This workflow automates the process of tracking AI token usage and estimating costs by extracting token data from AI agents and storing it in Google Sheets. It is designed to work seamlessly with OpenAI, Google, and Anthropic APIs.
n8n$14.99Automate Viral Content Creation from Reddit to Google Sheets
This workflow automates the extraction, filtering, and scoring of trending Reddit posts for viral content potential, storing the results in Google Sheets for further content creation.
n8n$9.99Automate AI Video Creation from Google Sheets with Freepik and Google Drive
This n8n workflow automates the creation of AI-generated videos using prompts from Google Sheets. It leverages Freepik's API for video generation and uploads the completed videos to Google Drive, making it ideal for content creators and marketers.
n8n$9.99Automate Instagram Profile Data Collection and Storage in Google Sheets
Streamline the process of gathering Instagram profile data using Apify and store it efficiently in Google Sheets for easy access and analysis.
n8n$4.99Automate Gmail Emails from New Google Sheets Rows
Automatically send emails via Gmail whenever a new row is added to your Google Sheets. This workflow streamlines communication by using specified columns for email details.
Make$2.99Automate Error Logging and Notifications with Google Sheets and Gmail
This workflow automates error monitoring for your n8n instance by capturing workflow failures, logging them to Google Sheets, and sending email alerts via Gmail.
n8n$4.99Automate LinkedIn Lead Generation with Apify and Google Sheets
Streamline LinkedIn lead generation by extracting and enriching comments from targeted posts using Apify, and export the data to Google Sheets or CSV for easy access.
n8n$19.99Automate SEO Keyword Research with DataForSEO and Google Sheets
Streamline your SEO keyword research by automating the collection of keyword insights, suggestions, and SERP analysis directly into Google Sheets using DataForSEO.
n8n$19.99Automate Task Management via WhatsApp with GPT-4 and Google Sheets
Streamline your task management by integrating WhatsApp with Google Sheets and GPT-4. This workflow allows you to manage tasks and deadlines directly from WhatsApp, providing AI-powered insights and updates.
n8n$4.99Automate Personalized Instagram DMs Using Apify, OpenAI, and Google Sheets
Streamline your Instagram outreach by automating the creation of personalized direct messages using Apify, OpenAI, and Google Sheets. Ideal for creator outreach, customer interviews, and partnership prospecting.
n8n$9.99Automate Student Course Scheduling with Google Sheets and OpenAI
Efficiently generate personalized Fall 2025 course schedules for students by leveraging Google Sheets and OpenAI. This workflow selects courses based on completed prerequisites and term availability, ensuring a balanced schedule.
n8n$9.99AI-Powered Lead Research & Personalized Email Generation with Groq & Google Sheets
## Overall Description & Potential **<< What Does This Flow Do? >>** Overall, this workflow is an **intelligent sales outreach automation engine** that transforms raw leads from a form or a list into highly personalized, ready-to-send introductory email drafts. The process is: it starts by fetching data, enriches it with in-depth AI research to uncover pain points, and then uses those research findings to craft an email that is relevant to the solutions you offer. This system solves a key problem in sales: the lack of time to conduct in-depth research on every single lead. By automating the research and drafting stages, the sales team can focus on higher-value activities, like engaging with warm prospects and handling negotiations. Using Google Sheets as the main dashboard allows the team to monitor the entire process—from lead entry, research status, and email drafts, all the way to the send link—all within a single, familiar interface. **<< Potential Future Enhancements >>** This workflow has a very strong foundation and can be further developed into an even more sophisticated system: 1. **Full Automation (Zero-touch):** Instead of generating a manual-click link, the output from the AI Agent can be directly piped into a **Gmail** or **Microsoft 365 Email** node to send emails automatically. A `Wait` node could be added to create a delay of a few minutes or hours after the draft is created, preventing instant sending. 2. **Automated Follow-up Sequences:** The workflow can be extended to manage follow-up emails. By using a webhook to track email opens or replies, you could build logic like: *If the intro email is not replied to within 3 days, trigger the AI Agent again to generate follow-up email #1 based on a different template, and then send it.* 3. **AI-Powered Lead Scoring:** After the research stage, the AI could be given the additional task of **scoring leads** (e.g., 1-10 or High/Medium/Low Priority) based on how well the target company's profile matches your ideal customer profile (ICP). This helps the sales team prioritize the most promising leads. 4. **Full CRM Integration:** Instead of Google Sheets, the workflow could connect directly to **HubSpot, Salesforce, or Pipedrive**. It would pull new leads from the CRM, perform the research, draft the email, and log all activities (research results, sent emails) back to the contact's timeline in the CRM automatically. 5. **Multi-Channel Outreach:** Beyond email, the AI could be instructed to draft personalized **LinkedIn Connection Request** messages or **WhatsApp** messages. The workflow could then use the appropriate APIs to send these messages, expanding your outreach beyond just email.
n8n$14.99Clean & Standardize CSV Uploads for Google Sheets and Drive Imports
# Auto-Clean CSV Uploads Before Import This workflow automatically **cleans, validates, and standardizes any CSV file** you upload. Perfect for preparing customer lists, sales leads, product catalogs, or any messy datasets before pushing them into Google Sheets, Google Drive, or other systems. --- ## How It Works 1. **CSV Upload (Webhook)** - Upload your CSV via webhook (supports **form-data**, **base64**, or binary file upload). - Handles files up to ~10MB comfortably. 2. **Extract & Parse** - Reads raw CSV content. - Validates file structure and headers. - Detects and normalizes column names (e.g., `First Name` → `first_name`). 3. **Clean & Standardize Data** - **Removes duplicate rows** (based on email or all fields). - **Deletes empty rows**. - **Standardizes fields**: - Emails → lowercased, validated format. - Phone numbers → normalized `(xxx) xxx-xxxx` or `+1 format`. - Names → capitalized (John Smith). - etc → trims spaces & fixes inconsistent spacing. - Assigns each row a **data quality score** so you know how "clean" it is. 4. **Generate Cleaned CSV** - Produces a cleaned CSV file with the same headers. - Saves to Google Drive (optional). - Ready for immediate import into Sheets or any app. 5. **Google Sheets Integration (Optional)** - Clears out an existing sheet. - Re-imports the cleaned rows. - Perfect for always keeping your "master sheet" clean. 6. **Final Report** - Logs processing summary: - Rows before & after cleaning. - Duplicates removed. - Low-quality rows removed. - Average data quality score. - Outputs a neat summary for auditing. --- ## Setup Steps 1. **Upload Method** - Use the webhook endpoint generated by the `CSV Upload Webhook` node. - Send CSV via binary upload, base64 encoding, or JSON payload with `csv_content`. 2. **Google Drive (Optional)** - Connect your Drive OAuth credentials. - Replace `YOUR_DRIVE_FOLDER_ID` with your target folder. 3. **Google Sheets (Optional)** - Connect Google Sheets OAuth. - Replace `YOUR_GOOGLE_SHEET_ID` with your target sheet ID. 4. **Customize Cleaning Rules** - Adjust the `Clean & Standardize Data` code node if you want different cleaning thresholds (default = 30% minimum data quality). --- ## Example Cleaning Report **Input file:** `raw_leads.csv` - Rows before: **2,450** - Rows after cleaning: **1,982** - Duplicates removed: **210** - Low-quality rows removed: **258** - Avg. data quality: **87%** “Clean CSV saved to Drive “Clean data imported into Google Sheets “Full processing report generated --- ## Why Use This? - Stop wasting time manually cleaning CSVs. - Ensure **high-quality, import-ready data** every time. - Works with **any dataset**: leads, contacts, e-commerce exports, logs, surveys. - Completely free - a must-have utility in your automation toolbox. --- Upload dirty CSV → Get **clean, validated, standardized data** instantly!
n8n$9.99Automate Product Data and Customer Support via WhatsApp, GPT-4, and Google Sheets
Streamline product data entry and customer support by automating processes through WhatsApp messages, leveraging GPT-4 for AI-driven insights, and storing data in Google Sheets.
n8n$14.99Automate AI Prompt Refinement with Google Sheets and Telegram
This workflow transforms basic AI prompts into detailed, structured prompts using Google Sheets and Telegram for notifications. It enhances prompt clarity and structure, saving time on manual prompt engineering.
n8n$14.99Automate Facebook Lead Ads to Google Sheets Integration
Effortlessly transfer new leads from Facebook Lead Ads to Google Sheets for streamlined management and enhanced productivity.
MakeFreeAutomate Sales Outreach with OpenAI, Airtable & Google Sheets for Prospect Research
### Sales Assistant Build: Automate Prospect Research and Personalized Outreach for Sales Calls ### Steps to Connect: 1. **Google Sheets Setup** - Connect your Google account via OAuth2 in the Review Calls, Product List, Testimonials Tool, Update Sheet, and Update Sheets 2 nodes. - Duplicate the mock Google Sheet (ID: `1u3WMJwYGwZewW1IztY8dfbEf5yBQxVh8oH7LQp4rAk4`) to your drive and update the `documentId` in all Google Sheets nodes to match your copy's ID. - Ensure the sheet has tabs for Meeting Data, Products, and Success Stories populated with your data. - Setup time: ~5 minutes. 2. **OpenAI API Key** - Go to [OpenAI](https://platform.openai.com/) and generate your API key. - Paste this key into the credentials for both OpenAI Chat Model and OpenAI Chat Model1 nodes. - Setup time: ~2 minutes. 3. **Avily API Key** - Sign up at [Avily](https://avily.com/) and get your API key. - In the Avily node, replace the placeholder `api_key` in the JSON body with your key (e.g., `api_key: your-avily-key-here`). - Setup time: ~3 minutes. --- ### How it Works Triggers on a new sales call booking (manual for testing). Pulls prospect details from Google Sheets and researches their company, tech stack, and updates using Avily. Matches relevant products/solutions from your product list and updates the sheet. Generates personalized email confirmation (subject + body) and SMS using testimonials for relevance. Updates the sheet with the outreach content for easy follow-up. Setup takes ~10-15 minutes total. All nodes are pre-configured—edit only the fields above. Detailed notes (e.g., prompt tweaks) are in sticky notes within the workflow. ---
n8n$9.99Track Stock Prices with ScrapeGraphAI, Yahoo Finance & Google Sheets
# AI-Powered Stock Tracker with Yahoo Finance & Google Sheets  **COMMUNITY TEMPLATE DISCLAIMER: This is a community-contributed template that uses ScrapeGraphAI (a community node). Please ensure you have the ScrapeGraphAI community node installed in your n8n instance before using this template.** This automated workflow monitors stock prices by scraping real-time data from Yahoo Finance. It uses a scheduled trigger to run at specified intervals, extracts key stock metrics using AI-powered extraction, formats the data through a custom code node, and automatically saves the structured information to Google Sheets for tracking and analysis. ## Pre-conditions/Requirements ### Prerequisites - n8n instance (self-hosted or cloud) - ScrapeGraphAI community node installed - Google Sheets API access - Yahoo Finance access (no API key required) ### Required Credentials - **ScrapeGraphAI API Key** - For web scraping capabilities - **Google Sheets OAuth2** - For spreadsheet integration ### Google Sheets Setup Create a Google Sheets document with the following column structure: | Column A | Column B | Column C | Column D | Column E | Column F | Column G | |----------|----------|----------|----------|----------|----------|----------| | **symbol** | **current_price** | **change** | **change_percent** | **volume** | **market_cap** | **timestamp** | | AAPL | 225.50 | +2.15 | +0.96% | 45,234,567 | 3.45T | 2024-01-15 14:30:00 | ## How it works This automated workflow monitors stock prices by scraping real-time data from Yahoo Finance. It uses a scheduled trigger to run at specified intervals, extracts key stock metrics using AI-powered extraction, formats the data through a custom code node, and automatically saves the structured information to Google Sheets for tracking and analysis. ## Key Steps: - **Scheduled Trigger**: Runs automatically at specified intervals to collect fresh stock data - **AI-Powered Scraping**: Uses ScrapeGraphAI to intelligently extract stock information (symbol, current price, price change, change percentage, volume, and market cap) from Yahoo Finance - **Data Processing**: Formats extracted data through a custom Code node for optimal spreadsheet compatibility and handles both single and multiple stock formats - **Automated Storage**: Saves all stock data to Google Sheets with proper column mapping for easy filtering, analysis, and historical tracking ## Set up steps **Setup Time: 5-10 minutes** 1. **Configure Credentials**: Set up your ScrapeGraphAI API key and Google Sheets OAuth2 credentials 2. **Customize Target**: Update the website URL in the ScrapeGraphAI node to your desired stock symbol (currently set to AAPL) 3. **Configure Schedule**: Set your preferred trigger frequency (daily, hourly, etc.) for stock price monitoring 4. **Map Spreadsheet**: Connect to your Google Sheets document and configure column mapping for the stock data fields ## Node Descriptions ### Core Workflow Nodes: - **Schedule Trigger** - Initiates the workflow at specified intervals - **Yahoo Finance Stock Scraper** - Extracts real-time stock data using ScrapeGraphAI - **Stock Data Formatter** - Processes and formats extracted data for spreadsheet compatibility - **Google Sheets Stock Logger** - Saves formatted stock data to your spreadsheet ### Data Flow: 1. **Trigger** → **Scraper** → **Formatter** → **Logger** ## Customization Examples ### Track Multiple Stocks ```javascript // In the ScrapeGraphAI node, modify the URL to track different stocks: const stockSymbols = ['AAPL', 'GOOGL', 'MSFT', 'TSLA']; const baseUrl = 'https://finance.yahoo.com/quote/'; ``` ### Add Additional Data Fields ```javascript // In the Code node, extend the data structure: const extendedData = { ...stockData, pe_ratio: extractedData.pe_ratio, dividend_yield: extractedData.dividend_yield, day_range: extractedData.day_range }; ``` ### Custom Scheduling ```javascript // Modify the Schedule Trigger for different frequencies: // Daily at 9:30 AM (market open): 0 30 9 * * * // Every 15 minutes during market hours: 0 */15 9-16 * * 1-5 // Weekly on Monday: 0 0 9 * * 1 ``` ## Data Output Format The workflow outputs structured JSON data with the following fields: ```json { "symbol": "AAPL", "current_price": 225.50, "change": "+2.15", "change_percent": "+0.96%", "volume": "45,234,567", "market_cap": "3.45T", "timestamp": "2024-01-15 14:30:00Z" } ``` ## Troubleshooting ### Common Issues 1. **ScrapeGraphAI Rate Limits** - Implement delays between requests 2. **Yahoo Finance Structure Changes** - Update scraping prompts 3. **Google Sheets Permission Errors** - Verify OAuth2 credentials and document permissions ### Performance Tips - Use appropriate trigger intervals (avoid excessive scraping) - Implement error handling for network issues - Consider data validation before saving to
n8n$4.99Automate Lead Sync from Facebook/Google Ads to Google Sheets and Salesforce
Streamline your lead management by automatically capturing leads from Facebook or Google Ads, logging them in Google Sheets, and syncing with Salesforce CRM.
n8n$4.99Business Lead Generation with Apify Web Scraping and Google Sheets Storage
## This flexible template scrapes business listings for any industry and location, perfect for sales teams, marketers, and researchers. ### Good to know - Works with any business category (restaurants, contractors, retailers, etc.) - Fully customizable search parameters - Results automatically organized in Google Sheets - Built-in delay ensures scraping completes before data collection ## How it works 1. Trigger: Manual or scheduled start 2. Apify Configuration: Sets scraping parameters (industry, location, data fields) 3. Scraping Execution: Runs the web scraping job 4. Data Processing: Cleans and structures the raw data 5. Storage: Saves results to your Google Sheets ### What is Apify? Apify is a web scraping tool; in this workflow, the data is scraped from a Google Maps scraper: **https://apify.com/compass/crawler-google-places** ## How to use ### Apify Small # Lead Generation (Purple) **https://apify.com/compass/crawler-google-places** 1. Add location and industry to scrape (Apify) 2. Add the number of leads to output (Apify) 3. Copy over the JSON file into N8N 4. Copy & paste API endpoint Get Run URL in N8N ### Apify Large # Lead Generation (Grey) #### Configure the Manual Trigger When clicking, Execute workflow node is ready to use as-is. This triggers the entire lead generation process. #### Setup Start Results (Apify) Node Get Your Apify API Information #### Go to Apify.com and create a free account Navigate to Settings → Integrations → API tokens. Copy your API token. Find the Google Maps scraper actor ID: #### Configure the HTTP Request (start results) Method: POST URL: Replace enter apify (get run) with: https://api.apify.com/v2/acts/nwua9Gu5YrADL7ZDj/runs?token=YOUR_API_TOKEN C. Customize the JSON Body Parameters In the JSON body, modify these key fields: Location & Search: locationQuery: Change Toronto to your target city searchStringsArray: Change [barber] to your business type Examples: [restaurants], [dentists], [contractors] #### Configure the HTTP Request (start results) Method: GET URL: Enter the get dataset URL from Apify #### Split Out Node Select fields to append in the Google Sheet #### Test the Configuration Click Execute workflow to test. Check that the Apify job starts successfully. Note the job ID returned for the next section. This section initiates the scraping process and should complete in 30-60 seconds depending on your lead count. #### Setup Google Sheets Create a new Google Sheet with these columns: - title (business name) - address (full address) - state (state/province) - neighborhood (area/district) - phone (contact number) - emails (email addresses) Copy your Google Sheets document ID for workflow configuration ## Requirements - Apify account - Google Sheets document - Google OAuth credentials ## Customization Options ### For different use cases: - Lead Gen: Get business leads - Local SEO: Collect competitor data - Market Research: Analyze industry trends ### Advanced modifications: - Add email enrichment - Integrate with CRM systems - Set up automatic daily runs
n8n$9.99Automate SEO-Optimized WordPress Blog Posts with AI and Google Sheets
Streamline the creation of SEO-friendly WordPress blog posts by automating content generation, image creation, and meta tag optimization using AI models and Google Sheets.
n8n$14.99Automate YouTube Video Curation with Quality and Relevance Filtering to Google Sheets
This workflow automates the process of finding high-quality YouTube videos on specific topics, filters them based on quality and relevance, and exports the top results to Google Sheets. Ideal for content creators, educators, and marketers looking to build curated lists or gain content insights.
n8n$14.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