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 Personal Finance Tracking with Telegram and Google Sheets
Effortlessly track your expenses and income using Telegram messages and Google Sheets integration, enhanced by AI-powered categorization.
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 Construction Blueprint Processing to Google Sheets
Streamline the conversion of construction blueprints from Google Drive into structured Google Sheets entries using VLM Run for efficient data management.
n8n$4.99Seamlessly Sync Google Sheets Contacts to MailChimp
Effortlessly transfer contacts from Google Sheets to MailChimp, ensuring your subscriber lists are always up-to-date.
n8n$4.99Automate Lead Updates from Google Sheets to Discord Notifications
Streamline your lead management by automatically updating lead information in Google Sheets and notifying your team via Discord.
ZapierFreeAutomate Support Ticket Categorization and Reporting with AI and Google Sheets
Streamline your support process by automatically categorizing tickets using AI, storing data in Google Sheets, and generating insightful reports.
n8n$14.99Transform BuiltWith Data into Trello Sales Leads via Google Sheets
This workflow automates the conversion of BuiltWith technology data into actionable Trello cards, creating a visual sales pipeline for efficient lead management.
n8n$9.99Create Instagram posts from filtered Google Sheets rows and update the sheet with post details
A ready-to-use Make workflow that connects Google-sheets, Instagram-business. Create Instagram posts from filtered Google Sheets rows and update the sheet with post details. Customize and deploy in minutes.
Make$3.99Alert on Equipment Health Issues with Google Sheets and MS Teams Integration
# Advanced Equipment Health Monitor with MS Teams Integration (n8n | API | Google Sheets | MS Teams) This n8n workflow automatically monitors equipment health by fetching real-time metrics like temperature, voltage, and operational status. If any of these parameters cross critical thresholds, an alert is instantly sent to a Microsoft Teams channel and the event is logged in Google Sheets. The workflow runs every 15 minutes by default. ## Quick Implementation Steps 1. **Import the workflow JSON** into your n8n instance. 2. **Open the Set Config node** and update: - API endpoint - Teams webhook URL - Threshold values - Google Sheet ID 3. **Activate the workflow** to start receiving alerts every 15 minutes. ## Who's It For - Renewable energy site operators (solar, wind) - Plant maintenance and operations teams - Remote infrastructure monitoring services - IoT-integrated energy platforms - Enterprise environments using Microsoft Teams ## Requirements | Tool | Purpose | |------|---------| | n8n Instance | To run and schedule automation | | HTTP API | Access to your equipment or IoT platform health API | | Microsoft Teams | Incoming Webhook URL configured | | Google Sheets | Logging and analytics | | SMTP (optional) | For email-based alternatives or expansions | ## What It Does - **Runs every 15 minutes** to check the latest equipment metrics. - **Compares values** (temperature, voltage, status) against configured thresholds. - **Triggers a Microsoft Teams message** when a threshold is breached. - **Appends the alert data** to a Google Sheet for logging and review. ## Workflow Components - **Set Node:** Configures thresholds, endpoints, webhook URL, and Sheet ID. - **Cron Node:** Triggers the check every 15 minutes. - **HTTP Request Node:** Pulls data from your equipment health monitoring API. - **IF Node:** Evaluates if conditions are within or outside defined limits. - **MS Teams Alert Node:** Sends structured alerts using a Teams incoming webhook. - **Google Sheets Node:** Logs alert details for recordkeeping and analytics. ## How To Set Up - Step-by-Step 1. **Import Workflow:** - In n8n, click **Import** and upload the provided `.json` file. 2. **Update Configurations:** - Open the **Set Config** node. - Replace the placeholder values: - `apiEndpoint`: URL to fetch equipment data. - `teamsWebhookUrl`: Your MS Teams channel webhook. - `temperatureThreshold`: Example = 80 - `voltageThreshold`: Example = 400 - `googleSheetId`: Google Sheet ID (must be shared with n8n service account). 3. **Check Webhook Integration:** - Ensure your MS Teams webhook is properly authorized and points to a live channel. 4. **Run & Monitor:** - Enable the workflow and view logs/alerts. - Adjust thresholds as needed. ## How To Customize | Customization | How | |---------------|-----| | Add more parameters (humidity, pressure) | Extend the HTTP + IF node conditions | | Change alert frequency | Edit the Cron node | | Use Slack or Email instead of Teams | Replace MS Teams node with Slack or Email node | | Add PDF Report Generation | Use HTML to PDF node and email the report | | Export to Database | Add a PostgreSQL or MySQL node instead of Google Sheets | ## Add-ons (Advanced) | Add-on | Description | |--------|-------------| | Auto-ticketing | Auto-create issues in Jira, Trello or ClickUp for serious faults | | Dashboard Sync | Send real-time logs to BigQuery or InfluxDB | | Predictive Alerts | Use machine learning APIs to flag anomalies | | Daily Digest | Compile all incidents into a daily summary email or Teams post | | Mobile Alert | Integrate Twilio for SMS alerts or WhatsApp notifications | ## Example Use Cases 1. Monitor solar inverter health for overheating or voltage drops. 2. Alert field engineers via Teams when a wind turbine sensor fails. 3. Log and visualize hardware issues for weekly analytics. 4. Automate SLA compliance tracking through timely notifications. 5. Ensure distributed infrastructure (e.g., substations) are always in operational range. ## Troubleshooting Guide | Issue | Possible Cause | Solution | |-------|----------------|----------| | No Teams alert | Incorrect webhook URL or formatting | Recheck the Teams webhook and payload | | Workflow not triggering | Cron node misconfigured | Ensure it's set to run every 15 mins and workflow is active | | Google Sheet not updating | Sheet ID is wrong or not shared | Share Sheet with your n8n Google service account | | No data from API | Endpoint URL is down or wrong | Test the endpoint manually with Postman or browser | --- ## Need Assistance? Need help tailoring this to your exact equipment type or expanding the workflow? Contact WeblineIndia - Expert automation partners for renewable energy, infrastructure, and enterprise workflows.
n8n$4.99Automate Lead Magnet Idea Generation from Google Sheets with RapidAPI AI
This n8n workflow automates the generation of lead magnet ideas by leveraging topics and URLs stored in Google Sheets. It utilizes the Lead Magnet Idea Generator AI API to create valuable content suggestions, streamlining the content ideation process for marketers.
n8n$9.99Automate Reddit Comment Sentiment Analysis with AI and Store in Google Sheets
This workflow automates the process of analyzing Reddit comments for sentiment using AI and stores the results in Google Sheets. It helps in understanding public sentiment efficiently without manual effort.
n8n$14.99Automate Customer Satisfaction Surveys with Freshdesk and Google Sheets
Streamline your customer feedback process by automatically sending satisfaction surveys when Freshdesk tickets are resolved and storing responses in Google Sheets for analysis.
n8n$14.99Automate Lead Qualification in Google Sheets Using OpenAI GPT-4
This workflow automates the process of qualifying leads in Google Sheets by leveraging OpenAI's GPT-4. It evaluates new entries based on predefined criteria and updates the sheet with the qualification results.
n8n$9.99Automate Invoice Follow-ups with Google Sheets and Email
This workflow automates the process of following up on unpaid invoices by checking a Google Sheets database daily, calculating overdue days, and sending tailored email reminders.
n8n$4.99Automate Instagram Media Insights Logging to Google Sheets
Automatically retrieve media insights from your Instagram account and log them into Google Sheets for streamlined data analysis.
Make$4.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 Instagram Comment Responses with Google Sheets & CRM
Monitors Instagram comments via Graph API, sends keyword-based auto-responses from Google Sheets, and logs interactions for CRM tracking. Saves time on social engagement while nurturing leads.
n8n$24.99Automate Task Logging from ClickUp to Google Sheets
Automatically log new ClickUp tasks into Google Sheets, ensuring seamless task management and data tracking.
MakeFreeAutomate Your Tweet Scheduling with Google Sheets Integration
This workflow enables users to automate the posting of tweets based on data stored in a Google Sheet. By leveraging a scheduled trigger, it fetches tweets from a designated Google Sheets document at defined intervals, ensuring a steady flow of con...
n8n$11.47Automate 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.99Compare Different LLM Responses Side-by-Side with Google Sheets
This workflow allows you to **easily evaluate and compare the outputs of two language models (LLMs)** before choosing one for production. In the chat interface, both model outputs are shown side by side. Their responses are also logged into a Google Sheet, where they can be evaluated manually or automatically using a more advanced model. ### Use Case You're developing an AI agent, and since LLMs are non-deterministic, you want to determine which one performs best for your specific use case. This template is designed to help you compare them effectively. ### How It Works - The user sends a message to the chat interface. - The input is duplicated and sent to two different LLMs. - Each model processes the same prompt independently, using its own memory context. - Their answers, along with the user input and previous context, are logged to Google Sheets. - You can review, compare, and evaluate the model outputs manually (or automate it later). - In the chat, both responses are also shown one after the other for direct comparison. ### How to Use It - Copy this [Google Sheets template](https://docs.google.com/spreadsheets/d/1grO5jxm05kJ7if9wBIOozjkqW27i8tRedrheLRrpxf4/) (File > Make a Copy). - Set up your **System Prompt** and **Tools** in the **AI Agent** node to suit your use case. - Start chatting! Each message will trigger both models and log their responses to the spreadsheet. Note: This version is set up for two models. If you want to compare more, you'll need to extend the workflow logic and update the sheet. ### About Models You can use **OpenRouter** or **Vertex AI** to test models across providers. If you're using a node for a specific provider, like OpenAI, you can compare different models from that provider (e.g., `gpt-4.1` vs `gpt-4.1-mini`). ### Evaluation in Google Sheets This is ideal for teams, allowing non-technical stakeholders (not just data scientists) to evaluate responses based on real-world needs. Advanced users can automate this evaluation using a more capable model (like `o3` from **OpenAI**), but note that this will increase token usage and cost. ### Token Considerations Since **each input is processed by two different models**, the workflow will consume more tokens overall. Keep an eye on usage, especially if working with longer prompts or running multiple evaluations, as this can impact cost.
n8n$14.99Automate PDF Data Extraction and Storage in Google Sheets
Streamline your workflow by automatically extracting data from PDFs and storing it in Google Sheets. This process is ideal for managing invoices, orders, and reports efficiently.
Make$4.99Send WhatsApp template messages based on Google Sheets content
Automatically send personalized WhatsApp messages using Google Sheets data. Streamline communication by integrating Google Sheets with WhatsApp Business Cloud for efficient messaging.
Make$2.99Automate LEDGERS Contact Creation from Google Sheets Using AI
This workflow automates the creation of contacts in LEDGERS by parsing unstructured data from Google Sheets using AI. It streamlines data entry and reduces errors by leveraging AI to format and sync contact information.
n8n$9.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