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.
Track Competitors' Instagram Metrics in Google Sheets
Automatically monitor and log your competitors' Instagram followers and media count in a Google Sheet for strategic insights.
Make$3.99Automate PDF Extraction and Summarization with Google Sheets and Discord
Automatically extract PDFs from a website, summarize them using AI, and send the summaries to a Discord channel while tracking processed URLs in Google Sheets.
n8n$14.99Automate LLM Testing with GPT-4 Judge & Google Sheets Tracking
## How it works - The workflow loads a list of test cases from a Google Sheet (previous results stored from an LLM). - For each test case, we execute a call to an LLM judge in parallel (using HTTP Request + Webhook nodes). - The judge uses the Input, Output, and Reference Answer fields from the spreadsheet to mark each LLM response as Pass/Fail. - The results are logged into a separate sheet in the same Sheets file. ## Set up steps: - Add your credentials for Google Sheets and OpenAI (or replace the OpenAI node with your favorite chat model). - Make a copy of the example Sheet to populate it with your own test data. - Run the workflow with the Execute Workflow button next to the Manual Trigger node.
n8n$14.99Automate LINE Notifications for New Google Sheets Entries
Automatically send LINE notifications whenever new rows are added to your Google Sheets. This integration keeps you updated on important data changes, enhancing your communication and response time.
Make$2.99Automate Brand and Competitor Mentions Tracking with ChatGPT and Google Sheets
This workflow automates the daily monitoring of brand and competitor mentions in AI responses. It logs interactions in Google Sheets and sends a detailed email report, providing insights into AI-driven brand perception.
n8n$9.99Automate Daily MLB Matchup Analysis with Google Sheets and Telegram
This workflow automates the analysis of daily MLB pitcher vs. batter matchups, integrating data from MLB's API into Google Sheets and sending top matchups to Telegram.
n8n$9.99Automate Task Logging from ClickUp to Google Sheets
Automatically log new ClickUp tasks into Google Sheets, ensuring seamless task management and data tracking.
MakeFreeAutomate Personalized Job Application Icebreakers with GPT-4 and Google Sheets
This workflow automates the creation of personalized email icebreakers for job applications using data from Google Sheets and GPT-4. It streamlines the process by fetching job listing data, generating customized icebreakers, and updating the sheet with the new content.
n8n$4.99Automate Blog Creation and Publishing with Gemini AI, Google Sheets, and GitHub
This n8n workflow automates the generation and publication of technical blog posts using topics from Google Sheets. It utilizes Gemini AI for content creation, commits the content to a GitHub repository, and updates a Jekyll-powered blog, streamlining the entire process.
n8n$14.99Track YouTube Channel's Top Videos in Google Sheets
Automatically fetch and record the most-viewed videos from specified YouTube channels into a Google Sheet for easy tracking and analysis.
n8n$9.99Automated Email Assistant for Suppliers Using OpenAI and Google Sheets
## Automated Email Assistant for Busy Professionals This assistant is designed for people who don't have time to write and send emails to suppliers. With just one request, it drafts and sends clear, professional messages automatically. ## How It Works The user makes a request (e.g., "Send an email to my fruit supplier asking for a quote on 1 crate of mangoes."). ## Workflow: 1. The AI agent searches for the supplier in a Google Sheets database. 2. It automatically drafts the email using OpenAI (with the tone and style you define). 3. It sends the email using your Gmail account connected through n8n. ## This assistant uses: - Google Sheets to manage your suppliers (name and email). - OpenAI to generate clear, natural messages. - MCP (client-server logic) to handle request processing. - Gmail as the sending channel for automated emails. ## Setup Instructions 1. Create a Google Sheets document with the supplier name and email, like this: | Supplier name | Email | |---------------|-------| | Proveedor de frutas Alvarez | fruteriaalvarez@alvarez.com | 2. Connect your Google Sheets and Gmail accounts within n8n. 3. Add your OpenAI API key. Test the automation by chatting with the integrated assistant. It will generate and send the email automatically to the indicated supplier. ## Requirements - OpenAI API key to generate email content. - Gmail account connected via OAuth2. - Google Sheets document with your supplier database. - n8n instance (cloud or self-hosted). ## Customization Adjust the OpenAI prompt to make the email tone more formal, casual, or technical. Add custom fields to your supplier sheet (location, notes, special conditions). Replace Google Sheets with a real database like Supabase or PostgreSQL for greater scalability.
n8n$9.99Automate Citation Source Extraction from Google AI Overview to Google Sheets
This workflow automates the extraction of citation sources from Google's AI Overview using DataForSEO and logs them into Google Sheets for analysis.
n8n$9.99Automate Incident Reporting & Alerts with Forms, Google Sheets, and Gmail
# Incident Reporting & Management Workflow (Form + Google Sheets + Email) This workflow automates incident reporting and management for operations teams by connecting a public reporting form with real-time logging in Google Sheets and instant alert emails to your support team. Whenever an incident is reported via the n8n form/webhook, all details are saved securely and immediately, and the right people are notified the moment issues occur. It's a fast, scalable solution for reliable incident handling. ## Who's It For - Renewable energy operators (solar/wind/green energy). - Facility and plant managers. - Environmental, EHS, and safety teams. - Technical support and incident response crews. - Maintenance & field operations teams. - Anyone aiming for compliance-ready, audit-friendly digital issue reporting. ## How It Works 1. **Form Submission**: An n8n-powered form (or webhook endpoint) receives incident reports, capturing all key details: reporter info, contact, location, date/time, type, severity, actions taken, photos, and more. 2. **Log to Google Sheets**: Each report is instantly appended as a new row in a secure Google Sheet, creating a searchable, timestamped audit trail. 3. **Email Alert (Gmail)**: An automatic email with incident summary and critical details lands in the support team's inbox seconds after submission, ensuring your response is always prompt. 4. **Workflow Automation**: These nodes are linked in n8n, enabling no-code/low-code back-end automation for complete visibility and control. ## How to Set Up 1. **Import Workflow**: In n8n, use Import from File to upload the workflow JSON provided. 2. **Edit Configuration**: - Update form fields as needed (label, validations, options for severity/category). - Enter your Google Sheet ID and sharing settings. - Configure Gmail/SMTP credentials and recipient address (example: `supportteam@mailinator.com` or your own team). 3. **Deploy Webhook**: Copy your n8n webhook URL and connect it to your reporting interface (form, app, device, etc.). 4. **Activate**: Enable the workflow in n8n. Submissions are now handled in real-time. 5. **Test**: Submit a sample incident to make sure data logs in Google Sheets and the alert email arrives as expected. ## Requirements | Tool | Purpose | |-----------------|-----------------------------------| | n8n Instance | Orchestrates the workflow | | Google Account | To access/use Google Sheets | | Gmail/SMTP | For sending incident alerts | | Incident Source | n8n Form, webhook, app, or device| ## How to Customize - **Form Fields**: Add/remove fields or validations in the n8n form for organization-specific needs (e.g., add photos, custom categories). - **Alert Routing**: Use IF nodes to send critical alerts via Slack, SMS, or escalate to on-call teams based on severity/type. - **Backend**: Replace Google Sheets with Notion, Airtable, PostgreSQL, or other databases. - **Reporting**: Add PDF nodes to auto-generate and send report summaries. - **Integrations**: Push incidents to ticketing, asset tracking, or calendar scheduling workflows. ## Add-Ons (Optional Extensions) | Feature | Description | |------------------|------------------------------------------------------| | Slack Alerts | Instantly notify Slack channels on critical issues | | Database Logging | Store reports in SQL/NoSQL systems | | PDF Generation | Email ready-to-use incident reports as PDFs | | Calendar Events | Schedule follow-ups or deadline reminders | | AI Categorization | Auto-classify incidents by severity/type | | Task Creation | Open tickets in Jira, Trello, ClickUp, or Asana | ## Use Case Examples - Field engineers report solar inverter faults with mobile forms. - Security personnel log site intrusions, with photos and severity. - IoT sensors auto-post equipment failures as incidents. - Compliance or EHS teams capture safety observations in real-time. - Technicians submit maintenance or post-repair issues instantly. ## Common Troubleshooting | Issue | Possible Cause | Solution | |--------------------------|---------------------------------------|----------------------------------------------------------| | Form not triggering | Webhook URL incorrect | Double-check webhook endpoint and method (POST) | | Email not delivered | Wrong SMTP/Gmail credentials | Re-enter credentials or verify SMTP access | | Google Sheets not updated | Sheets ID wrong/missing permissions | Use correct ID, share sheet with service account or make accessible | | Missing report fields in log | Form field names or types mismatch | Align JSON/form data keys with workflow node mappings | | Attachments not saved | Field not set for file type | Review form field definitions and adjust as needed | ## Need Help? Want a tailored setup, advanced automations, or powerful add-ons (AI, SLAs, PDF logs, ticketing integration)? Our n8n workflow experts at WeblineIndia are ready to help you engineer seamless incident management for any industry. ☎️ Contact WeblineIndia - Your Automation
n8n$4.99Automate Google Places Data Collection and Storage in Google Sheets
Streamline your lead generation by automatically scraping Google Places data using Dumpling AI and storing it in Google Sheets. Ideal for marketers and SEO professionals seeking efficient data collection.
n8n$4.99Automate Sales Performance Tracking with AI and Google Sheets
This workflow automates the tracking of sales reps' performance by aggregating data from CRM and communication logs, analyzing it with AI, and storing insights in Google Sheets. It helps managers focus on coaching rather than manual reporting.
n8n$14.99Manage Personal Expenses with Webhooks and Google Sheets Automated Tracker
- How it works: This system functions by receiving expenses via webhook POS. It validates the data, stores it in Google Sheets, and, daily at 8 PM, generates and sends financial summaries. Automatic categorization simplifies the organization of expenses. - Set up steps: Setup involves creating the Google Sheet, configuring the webhook, and defining the categorization rules. The process is quick and intuitive, taking about 10-15 minutes for the system to be ready to receive your expenses.
n8n$9.99Automate User Onboarding and Tracking with Database, Saleshandy, and Google Sheets
Streamline your user onboarding process by automatically importing new signups from your database, enrolling them in a Saleshandy email sequence, and logging their activity in Google Sheets for tracking and analytics.
n8n$14.99Automate LinkedIn Profile Enrichment with Ghost Genius and Google Sheets
Streamline the process of gathering comprehensive LinkedIn profile data using Ghost Genius and Google Sheets. Ideal for sales, recruitment, and marketing teams seeking efficient lead generation and candidate sourcing.
n8n$4.99Automate Job Tracking from Y Combinator to Google Sheets
Automatically scrape and store the latest job listings from Y Combinator's Jobs page into Google Sheets every 6 hours using n8n and Scrapeless.
n8n$9.99Collect Company Social Media Profiles with Extruct AI to Google Sheets
**Who's it for:** Sales teams, marketers, and analysts who need to quickly access all the social media and public profile links for any company. **How it works / What it does:** When you enter a company into the form, this workflow automatically searches for and collects all available links to the company's social media accounts, review sites, and public profiles from sources like Crunchbase and Zoominfo. All discovered URLs are added directly to your Google Sheet. **How to set up:** 1. Create an Extruct account at [www.extruct.ai/](https://www.extruct.ai/). 2. Open the Extruct table template, find the table ID in your browser's address bar, and copy it. 3. Make a copy of the provided Google Sheets template to your own Google Drive. 4. In n8n, paste the table ID into the variables node of your flow. 5. Set up Bearer authentication in every HTTP Request node using your Extruct API token (found on the API page in Extruct). 6. In the Google Sheets node, paste the link to your copied template and connect your Google account. 7. Run the flow once to load the fields, then map the output fields to the correct columns in your sheet. 8. Activate the flow and start adding companies via the form. **Requirements:** - Extruct account and API token - Extruct table template - Google account with Google Sheets **How to customize the workflow:** You can add your own columns to the Extruct table and your Google Sheet. Just add the new column in both places and map it in the Google Sheets node in n8n.
n8n$9.99Automate Job Search and Matching with Adzuna API, GPT-3.5, and Google Sheets
Job Search Automation Workflow Streamline Job Discovery with API-Powered Intelligence This workflow template transforms the job search process by leveraging the Adzuna API and AI to automatically find, summarize, and evaluate job opportunities. Unlike traditional RSS-based job search tools, this workflow connects directly to Adzuna's comprehensive job API for real-time, high-quality job data. Workflow Overview The Job Search Automation Workflow follows a streamlined process: - Define job titles to search for - Fetch current job listings from Adzuna's API - Split individual job results for processing - Use AI to extract and summarize key job information - Score each job against candidate profiles - Organize results for easy review This automation eliminates manual searching across job boards and provides objective evaluation of opportunities, saving valuable time for both job seekers and professionals who support them. Technical Implementation The workflow is built with a focus on efficiency and extensibility: - API Integration: Direct connection to Adzuna's job API ensures access to current listings with comprehensive details - AI Processing: Leverages OpenAI's GPT models to intelligently summarize job descriptions and evaluate candidate fit - Modular Design: Each node serves a specific purpose, making the workflow easy to understand and customize - Scalable Architecture: Can be expanded to include additional job sources or evaluation criteria Use Cases This template serves multiple user groups: - Job Seekers: Automate discovery of relevant positions matching your skills - Recruiters: Quickly identify quality positions for your candidate pool - Career Coaches: Systematically help clients find suitable positions - AI Automation Builders: Learn how to integrate job APIs with AI evaluation systems Prerequisites To use this workflow, you'll need: - An Adzuna API key (available at Adzuna.com) - An n8n instance (cloud or self-hosted) - OpenAI API credentials (or compatible alternative) Getting Started - Import this template to your n8n instance - Configure your Adzuna API credentials - Set up your OpenAI API connection - Customize job titles and candidate profiles - Execute the workflow to start discovering opportunities Customization Options The workflow can be easily adapted to your specific needs: - Modify job search parameters (location, industry, etc.) - Adjust AI prompts for different summarization styles - Customize scoring criteria based on specific skills or requirements - Add nodes to integrate with other tools in your workflow Why This Approach Matters Traditional job search methods often rely on RSS feeds, which can be limited in detail and frequency of updates. By connecting directly to the Adzuna API, this workflow ensures you're always working with the most current job data available. The AI-powered evaluation provides objective scoring of how well each position matches candidate profiles, helping prioritize applications for positions with the highest potential fit. Whether you're a job seeker looking to streamline your search, a professional helping others find opportunities, or an automation enthusiast interested in API integrations, this template provides a solid foundation for more efficient job discovery and evaluation.
n8n$9.99Automate LinkedIn Prospecting with AI and Google Sheets
Streamline your LinkedIn prospecting by using AI to find relevant profiles based on natural language queries and automatically save the results to Google Sheets.
n8n$9.99Automate YouTube Video Uploads with Google Sheets and Drive
Streamline your YouTube video publishing by automating uploads using metadata from Google Sheets and video files from Google Drive. This workflow ensures timely uploads and organizes your video assets efficiently.
n8n$9.99Parallel LLM Evaluation on Legal Documents with Google Sheets and OpenAI
Efficiently benchmark multiple LLMs on legal documents using Google Sheets and OpenAI, leveraging parallel processing for faster results.
n8n$14.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