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 Expense Tracking via Chat with AI and Google Sheets
Streamline your expense tracking by sending a chat message to log expenses into Google Sheets using AI parsing and n8n automation.
n8n$9.99Track CVE Vulnerability Details & History with NVD API and Google Sheets
## Who is this for? NVD (National Vulnerability Database) data is essential for security analysts, vulnerability managers, and DevSecOps professionals who need to perform both CVE lookups and monitor historical change logs. This workflow helps streamline those efforts by providing structured outputs for audit, triage, or compliance tracking purposes. **Note:** While this example uses Google Sheets as the destination, you can easily modify the final destination node (e.g., send to Slack, email, database, etc.) based on your specific automation needs. ## What problem is this solving? Security teams often manually look up CVE data and track changes across multiple tools. This process is inefficient and error-prone. This workflow automates the CVE lookup and historical change tracking by logging enriched vulnerability data into Google Sheets in real-time. ## What this workflow does This workflow is designed for CVE API lookup and change history tracking. In many vulnerability automation pipelines, it is essential to determine not only the metadata of a CVE but also how it has evolved over time. Based on the operational need—whether it's enrichment, risk scoring, or remediation validation—this workflow becomes particularly handy in surfacing both current and historical CVE data. This template performs the following actions: - Accepts incoming webhook requests containing a CVE ID - Queries the NVD CVE Lookup API to fetch vulnerability metadata - Queries the NVD CVE History API to retrieve all historical changes - Flattens both datasets into a sheet-compatible structure - Appends vulnerability metadata to one sheet and change history to another within the same Google Spreadsheet ## Setup **Request an NVD API Key** To request an NVD API Key, please provide your organization name, a valid email address, and indicate your organization type at [NVD API Key Request](https://nvd.nist.gov/developers/request-an-api-key). You must scroll to the end of the Terms of Use Agreement and check "I agree to the Terms of Use" to obtain an API Key. After submission, you will receive a single-use hyperlink via email to activate and view your API Key. If not activated within seven days, a new request must be submitted. **API Rate Limits** Without an API key, you're limited to 5 requests per 30-second window. With an API key, you're allowed up to 50 requests in the same period. To prevent request throttling, it's recommended to introduce slight delays between consecutive API calls in production setups. 1. Clone or import this workflow into your n8n instance. 2. Set up the following credentials: - Google Sheets OAuth2 - NVD API Key (via HTTP Header Auth) 3. The workflow logs data to a Google Sheet titled **NVD Database**, with Sheet 1 named **CVE Lookup** and Sheet 2 named **CVE History**. 4. Trigger each workflow using the respective webhook URL, appending `?cveId=CVE-XXXX-XXXX` as a query parameter. ### **Example Webhook Request (CVE Change History)** You can test this workflow with the following example: ``` GET https://your-domain.com/webhook/cve-history?cveId=CVE-2023-34362 ``` ## How to customize this workflow - Use the `Edit Fields` node (optional) to centralize configuration like sheet name or query input - Extend the CVE flattening logic to include more nested metadata if needed - Integrate notification systems (e.g., Slack or email) by branching from the processing nodes - Modify webhook paths for better endpoint organization ## **Production Security Tips** - Use **HTTP Header Auth** on the webhook for secure access > **This template uses webhooks and NVD API access with authentication headers.** --- This template uses two flows: - **Webhook 1:** `NVD CVE Lookup` - Lookup CVE vulnerability metadata from NVD and sync to Google Sheet - **Webhook 2:** `NVD CVE Change History` - Track change history for CVEs via NVD and log each update Each flow: - Hits NVD's respective endpoint - Uses custom JS Code node to flatten the nested JSON - Syncs data to dedicated Google Sheet tabs - Consists of 4 nodes: Webhook → API Call → Parse → Sheet Sync Make sure both flows are activated and webhooks exposed for external access. Based on your needs, ensure you have a secure setup—whether hosted internally or in a cloud environment—when running n8n in production.
n8n$9.99Automate Social Media Content Creation and Posting with Google Sheets and GPT-4
Streamline your social media strategy by automating content generation and posting using Google Sheets and OpenAI's GPT-4, ensuring consistent and engaging posts across platforms.
n8n$4.99Automate Shopify Store Data Extraction and Logging to Google Sheets
This workflow automates the extraction of Shopify store and product data using RapidAPI's Shopify Scraper API and logs the information into Google Sheets for streamlined analysis.
n8n$9.99Track Student Attendance with Mobile App, Google Sheets, and Email Alerts
A lightweight no-code workflow that captures student check-in data via a mobile app or webhook, stores it in a Google Sheet, and instantly notifies the class teacher via email. ## What This Does - Students **check in using a mobile app or QR code** - Their data is **formatted and saved** to a Google Sheet - A **notification email** is sent to the class teacher in real time ## Workflow Steps | Step | Description | | ---------------------------- | ------------------------------------------------------------ | | **Student Check-in (Webhook)** | Triggered via POST request from mobile app or QR scanner | | **Format Data** | Cleans and prepares incoming JSON into structured format | | **Append or Update Row** | Saves student check-in data into Google Sheets | | **Email Teacher** | Sends formatted check-in email to the class teacher | | **Success Response** | Returns a confirmation response to the mobile app or system | ## Example Check-in Input (Webhook Body) ```json { "student_name": "Aarav Mehta", "student_id": "SU025", "class_name": "Grade 6B" } ``` ## Google Sheets Format | Student Name | Student ID | Class | Date | Time | | ------------ | ---------- | ------- | ---------- | ----- | | Aarav Mehta | SU025 | Grade 6B | 2025-08-06 | 08:35 | *Date and time are added dynamically in the workflow.* ## Setup Requirements - **n8n Instance** - Deployed with public webhook support - **Google Sheets** - Sheet with columns as shown above - **Email SMTP Settings** - For sending teacher notification ## Quick Setup Instructions 1. Import the workflow into your n8n instance 2. Replace the webhook URL in your mobile app 3. Set your Google Sheet ID and range 4. Enter the teacher's email in the **Email Teacher** node 5. Test with mock data 6. Deploy and use live!
n8n$9.99Automate Quiz Delivery from Google Sheets to Telegram with Status Tracking
Streamline the process of delivering quizzes from Google Sheets to a Telegram group by automating poll creation and status updates. This workflow ensures quizzes are sent sequentially and notifies admins when the sheet needs refilling.
n8n$9.99Automate Marketing Campaign ROI Reporting with Google Sheets and OpenAI
This n8n workflow automates the process of generating ROI reports for marketing campaigns by extracting data from Google Sheets, summarizing it with OpenAI, and emailing the results via Outlook.
n8n$14.99Automatically Log Gmail Emails to Google Sheets
Effortlessly transfer Gmail emails to Google Sheets by adding each email as a new row, ensuring organized and accessible data management.
MakeFreeAutomate Product Data Extraction from Google Sheets URLs with Dumpling AI
This workflow automates the extraction of product information from URLs listed in a Google Sheet, using Dumpling AI to gather details like product name, price, and description, and stores the data in another sheet.
n8n$4.99Automate Personalized Cold Emails Using Apify, OpenAI, and Google Sheets
This workflow streamlines the creation of personalized cold outreach emails by integrating lead data extraction, company website scraping, and AI-driven email crafting. Ideal for sales and marketing teams aiming to enhance outreach efficiency while maintaining personalization.
n8n$9.99Automate Google Maps Business Phone Scraping to Google Sheets
This n8n workflow automates the extraction of business phone numbers and other details from Google Maps using the Bright Data API, and stores the information in Google Sheets for easy access and management.
n8n$14.99Automate Lead Engagement with AI-Driven WhatsApp Messages and Google Sheets
This workflow captures leads from an inquiry form, crafts personalized WhatsApp messages using AI, and logs interactions in Google Sheets. It enhances lead engagement by automating initial outreach and tracking message success or failure.
n8n$9.99Automatically Generate Quotes in Google Docs from New Google Sheets Rows
Automatically create a quote document in Google Docs for each new row added in a Google Sheets spreadsheet. This workflow streamlines the process of generating quotes by using predefined templates.
Make$2.99Automate Video Creation and Upload to YouTube with Veo3 and Google Sheets
This workflow automates the creation of Veo3 videos and uploads them to YouTube, leveraging Google Sheets for data management and AI for content optimization.
n8n$9.99Automate SQL Queries on Google Sheets Data Using AI and PostgreSQL
This n8n workflow enables you to query structured data from Google Sheets or CSV files using AI-generated SQL, storing and processing it efficiently in PostgreSQL.
n8n$14.99Automate Sales Call Preparation and Follow-Ups with GPT-4, Tavily, and Google Sheets
Streamline your sales process by automating prospect research and personalized follow-up communications using GPT-4, Tavily, and Google Sheets. This workflow ensures you are always prepared with the latest company insights and never miss a follow-up.
n8n$9.99Automate Website Traffic Analysis with Semrush and Google Sheets
This workflow automates the process of analyzing website traffic using the Semrush API and logs the results into Google Sheets for easy access and reporting. Ideal for SEO professionals seeking efficient data tracking and analysis.
n8n$9.99Effortlessly Create AI Videos from Google Sheets with Fal.AI
Transform your ideas into AI-generated videos directly from Google Sheets using Fal.AI, offering a cost-effective alternative to Veo3.
n8n$9.99Automate Weekly Real Estate Listings to Google Sheets
Automatically scrape and store real estate listings from LoopNet into Google Sheets on a weekly schedule using Scrapeless and n8n.
n8n$4.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 Competitor Backlink Analysis with Bright Data and Google Sheets
This workflow automates the extraction and analysis of competitor backlink data using Bright Data and OpenAI, storing the results in Google Sheets for easy access and further analysis.
n8n$14.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 Upwork Job Listings to Google Sheets
Streamline your freelance job search by automatically scraping Upwork job listings and logging them into Google Sheets for easy tracking and analysis.
n8n$4.99Automate Prescription Delivery via Google Sheets to Email & WhatsApp
This is a fully working n8n workflow that sends prescriptions to patients via email and WhatsApp when a doctor enters prescription data into a Google Sheet. ## Google Sheets Structure **Main Sheet:** Required columns: - `prescription_id` (unique ID) - `patient_name` - `patient_email` - `patient_phone` - `doctor_name` - `prescription_date` - `prescription_details` - `dosage_instructions` - `followup_date` (optional) - `prescription_status` (set to new for new prescriptions) **Log Sheet:** This will be auto-created with columns for tracking sent notifications. ## Required Credentials Setup 1. **Google Sheets OAuth2 API**: Connect your Google account 2. **SMTP Credentials**: For email sending (Gmail, Outlook, etc.) 3. **WhatsApp API**: Meta Business WhatsApp API credentials ## Configuration Steps 1. Replace `YOUR_GOOGLE_SHEET_ID` with your actual Google Sheet ID 2. Replace `YOUR_WHATSAPP_PHONE_NUMBER_ID` with your WhatsApp Business phone number ID 3. Update the email sender address in the Send Email node 4. Set up your credentials in n8n ## Features Included - **Automated Trigger**: Monitors Google Sheet for new prescriptions - **Smart Filtering**: Only processes prescriptions with status new - **Rich Email Format**: Professional HTML email with prescription details - **WhatsApp Integration**: Sends formatted prescription text - **Comprehensive Logging**: Tracks all sent notifications - **Status Updates**: Marks prescriptions as sent after processing - **Error Handling**: Logs success/failure status for both channels ## Sample Data Format Add rows to your sheet like this: ``` prescription_id: RX001 patient_name: John Doe patient_email: john@email.com patient_phone: +1234567890 doctor_name: Dr. Smith prescription_date: 2025-01-15 prescription_details: Amoxicillin 500mg capsules dosage_instructions: Take 1 capsule 3 times daily with food followup_date: 2025-01-22 prescription_status: new ```
n8n$4.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