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.
Track Expenses by Parsing Telegram Transaction Messages to Google Sheets
**Overview** This n8n workflow template automatically parses incoming Telegram transaction messages and logs structured data into a Google Sheet. It's designed to help individuals and small businesses track and record transactions shared via Telegram without manual data entry. **Target Audience** This template is ideal for: - Individuals, freelancers, and small businesses who receive transaction or payment notifications through Telegram and want to organize them in Google Sheets. - Anyone using self-hosted n8n (required due to custom community nodes). **Problem Solved** Manually copying transaction details from Telegram to Google Sheets is error-prone and time-consuming. This workflow automates the process by: - Monitoring a Telegram bot/chat for new messages. - Parsing transaction details (amount, sender, date, etc.). - Logging them in real-time into a Google Sheet for easy tracking. **Setup Instructions** 1. **Telegram Bot Setup** - Create a Telegram bot using BotFather. - Add the bot to the desired group/channel and grant admin permissions if needed. - Note down the bot token. 2. **Google Sheets Setup** - Create a Google Sheet with relevant columns (e.g., Date, Amount, Sender, Transaction ID). - Set up Google Sheets credentials in n8n for access. 3. **n8n Workflow Configuration** - Import this template into your self-hosted n8n instance. - Update the Telegram node: Add your bot token and specify the chat/group ID. - Update the Google Sheets node: Link it to your created sheet and ensure column mapping matches your sheet structure. - Adjust parsing logic if your message format varies (see next section for examples). 4. **Community Nodes** - This workflow uses custom community nodes. Ensure these are installed via the n8n settings or CLI: - [List your required community nodes here, e.g., n8n-nodes-telegram, n8n-nodes-gsheet, etc.] 5. **Activate the Workflow** - Save and activate your workflow. Send a test transaction message to your Telegram group/chat and verify data appears in your Google Sheet. 6. **Troubleshooting** - If messages are not being picked up, check bot permissions and the chat ID. - Ensure Google Sheets credentials are correct and the sheet is accessible. - Double-check that custom nodes are properly installed and up-to-date. **Example Telegram Message Formats** - Received: $75 from @john_doe on 2024-05-29. Transaction ID: 12345XYZ. - Paid $120 to @vendor on 2024-05-28. Ref: 67890ABC. - You received ₹5,000 from @amit. ID: 54321PQR. Date: 29/05/2024 The workflow parses messages in the above formats and logs the following columns: - Date - Amount - Sender/Receiver - Transaction/Reference ID If your message format differs, update the regex in the parsing node. **Disclaimer** This n8n workflow template uses custom community nodes and is only compatible with the self-hosted version of n8n. **Workflow Changes (For n8n Canvas)** Rename the Nodes: - If node → "Is Transaction Message?" - Google Sheets node → "Log to Google Sheet" (Rename other generic nodes for clarity, e.g., Telegram → "Listen for Telegram Messages", Function → "Parse Transaction Details") Sticky Note Improvement: (Edit the sticky note or add one if missing) **Workflow Steps:** - Listen for Telegram Messages: This node receives new messages from the Telegram bot. - Is Transaction Message? Checks if the message matches known transaction patterns. - Parse Transaction Details: Extracts amount, sender, date, and transaction ID using regex. - Log to Google Sheet: Records the parsed transaction in the linked Google Sheet for easy tracking.
n8n$4.99Automate Website Screenshot Capture from Google Sheets to Google Drive
This workflow automates the process of capturing website screenshots from URLs listed in a Google Sheet and saving them to Google Drive using the CustomJS PDF Toolkit.
n8n$3.99Automate Sentiment Analysis of Customer Reviews in Google Sheets
Automatically analyze the sentiment of customer reviews added to a Google Sheet and update the sheet with the sentiment results. This workflow helps in quickly identifying customer satisfaction trends and prioritizing follow-ups.
n8n$4.99Voice-Controlled Expense Tracker with Siri, AI, and Google Sheets
What It Does: This project lets you talk to Siri (via Apple Shortcuts) and record or query your daily spending. The shortcut sends your message to an n8n Webhook, which uses AI to decide whether it's for writing or reading finance data, then replies with a human-friendly message - all powered by n8n + AI + Google Sheets. --- **PAR 1: n8n Setup** 1. Create a Webhook trigger in n8n - Add a node: Webhook - Set HTTP Method: POST - Set Path: siri-finance - Enable “Respond to Webhook” = “Yes” 2. Add AI Agent Node (e.g., OpenAI, Ollama, Gemini) - Use system prompt like: "You are a finance assistant. Decide if the user wants to record or read transactions. If it's recording, return a JSON object with date, type, name, amount, and expense/income. If it's reading, return date range and type (Expense/Income). Always reply with a human-friendly summary." - Input: {{ $json.text }} (from webhook) - Output: structured json.output 3. (Optional) Add Logic to write to DB / Supabase / Google Sheets - Append tool: Adds a new row - Read tool: Queries past data - Now your n8n flow is ready! --- **PAR 2: iOS Shortcut Setup** 1. Create a new Shortcut - Name it: Siri Finance Bot (or Finance Bot) - Add Action: Ask for Input - Prompt: "What would you like to record or query?" - Input Type: Text - Add Action: Get Contents of URL - Method: POST - URL: https://your-n8n-domain/webhook/siri-finance - Headers: Content-Type: application/json - Request Body: ``` { "text": "Provided Input" } ``` - Replace "Provided Input" with Magic Variable “Input Result” 2. Show Result - Add Action: Show Result - Content: Get Contents of URL 3. Optional: Add “Speak Text” - If you want Siri to speak it back, add Speak Text after Show Result. --- **Example Usage** You: "Hey Siri, log expense $50 for coffee" Siri: "Logged expense: Coffee $50" Or You: "Hey Siri, what's my total expense for July?" Siri: "Total expense for July: $7684.64" --- **Files to Share** You can package the following: - .shortcut file export - Sample n8n workflow .json - Optional Supabase schema / Google Sheet template --- **Tips for Newcomers** - Keep your Webhook public but protect with a token if needed. - Ensure you handle emoji and newline safely for iOS compatibility. - Add logging nodes in n8n to help debug Siri messages. --- **Optional Project Name** "Siri Finance Bot" / "Finance VoiceBot" A simple voice-first way to manage your daily expenses.
n8n$9.99Automate SSL Certificate Monitoring with Google Sheets and Email Alerts
This n8n workflow automatically checks SSL certificates for websites listed in a Google Sheet and sends email alerts if any are expiring within 14 days. This helps prevent downtime and security issues caused by expired certificates.
n8n$14.99Automate LLM Testing with GP-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 Business Lead Scraping and Data Cleaning to Google Sheets
Streamline your lead generation process by automatically scraping business leads from Scrapeless, cleaning the data, and exporting it to Google Sheets for easy access and analysis.
n8n$4.99Automate Invoice Data Extraction from Gmail to Google Sheets
Streamline your invoice processing by automatically extracting data from PDF attachments in Gmail and storing it in Google Sheets using LlamaParse and Gemini LLM.
n8n$14.99Send Telegram Messages for New Google Sheets Rows
Automatically send Telegram messages whenever a new row is added to your Google Sheets. This workflow streamlines communication by instantly notifying your Telegram contacts with relevant data.
Make$2.99Automate Event Data Collection from 10times Using AI and Google Sheets
Streamline your event data collection process by automatically scraping and organizing event information from 10times into Google Sheets using AI and Bright Data.
n8n$9.99Extract & Summarize B2B Leads from Crunchbase with Bright Data, GP-4O & Google Sheets
### Who this is for The Crunchbase B2B Lead Discovery Pipeline is designed for sales teams, B2B marketers, business analysts, and data operations teams who need a reliable way to extract, structure, and summarize company information from Crunchbase to fuel lead generation and market intelligence. This workflow is ideal for: 1. **Sales Development Reps (SDRs)** - Needing structured leads from Crunchbase 2. **Marketing Analysts** - Generating segmented outreach lists 3. **Growth Teams** - Identifying trending B2B startups 4. **RevOps Teams** - Automating company research pipelines 5. **Data Teams** - Consolidating insights into Google Sheets for dashboards ### What problem is this workflow solving? Manual extraction of company data from Crunchbase is time-consuming, inconsistent, and often lacks the contextual summary required for sales enablement or growth targeting. This workflow automates the extraction, transformation, summarization, and delivery of Crunchbase company data into structured formats, making it instantly usable for B2B targeting and analysis. It solves: - The difficulty of scaling lead discovery from Crunchbase - The need to summarize raw textual content for quick insights - The lack of integration between web scraping, LLM processing, and storage ### What this workflow does - **Markdown to Textual Data Extractor**: Takes raw scraped markdown from Crunchbase and converts it into readable plain text using a basic LLM chain - **Structured Data Extraction**: Applies a parsing model (OpenAI) to extract structured fields such as company name, funding rounds, industry tags, location, and founding year - **Summarization Chain**: Generates an executive summary from the raw Crunchbase text using a summarization prompt template - **Send to Google Sheets**: Adds the structured data and summary into a Google Sheet for team access and further processing - **Persist to Disk**: Saves both raw and structured data files locally for archiving or further use - **Webhook Notification**: Sends a structured payload to a webhook endpoint (e.g., Slack, CRM, internal tools) with lead insights ### Pre-conditions 1. You need to have a [Bright Data](https://brightdata.com/) account and do the necessary setup as mentioned in the Setup section below. 2. You need to have an OpenAI Account. ### Setup - Sign up at [Bright Data](https://brightdata.com/). - Navigate to Proxies & Scraping and create a new Web Unlocker zone by selecting Web Unlocker API under Scraping Solutions. - In n8n, configure the Header Auth account under Credentials (Generic Auth Type: Header Authentication).  The Value field should be set with the **Bearer XXXXXXXXXXXXXX**. The XXXXXXXXXXXXXX should be replaced by the Web Unlocker token. - In n8n, Configure the Google Sheet Credentials with your own account. Follow this documentation - [Set Google Sheet Credential](https://docs.n8n.io/integrations/builtin/credentials/google/) - In n8n, configure the OpenAi account credentials. - Ensure the URL and Bright Data zone name are correctly set in the **Set URL, Filename and Bright Data Zone** node. - Set the desired local path in the **Write a file** to disk node to save the responses. ### How to customize this workflow to your needs **LLM Prompt Customization**: - Modify the extraction prompt to include additional fields like revenue, social links, leadership team - Adjust summarization tone (e.g., executive summary, sales-focused snapshot or marketing digest) **File Persistence** - Store raw markdown, extracted JSON, and summary text separately for audit/debug **Webhook Notification** - Connect to CRM (e.g., HubSpot, Salesforce) via webhook to automatically create leads - Send Slack notifications to alert sales reps when a new high-potential company is discovered
n8n$14.99Automate Meeting Minutes Distribution via Google Sheets and Gmail
Streamline your meeting minutes distribution by automatically sending summaries via Gmail from notes stored in Google Sheets.
n8n$4.99Analyze Hacker News for Business Insights Using AI and Google Sheets
This n8n workflow monitors top Hacker News posts to identify business-related pain points using AI, and logs results into Google Sheets for further analysis.
n8n$14.99Track Student Arrival with iOS Automation, Google Sheets & Email Alerts
This workflow automates **real-time student tracking** using **iOS Shortcuts and geolocation data**, notifying both **teachers and parents** based on geofenced logic. ## What This Workflow Does - Receives student **location updates via webhook** (iOS Shortcuts) - Detects if the student has **arrived at school** - Logs arrival data to Google Sheets - **Sends email alerts** to teachers and/or parents based on location ## Workflow Steps | Step | Description | | --------------------------- | -------------------------------------------------------- | | **Location Update Webhook** | Triggered via iOS Shortcut when student location updates | | **Process Location Data** | Extracts coordinates and metadata | | **Student Arrived?** | Checks if student entered school zone | | **Log School Arrival** | Adds arrival data to Google Sheet | | **At School?** | Double-checks geofence condition before notifying | | **Notify Teacher** | Sends email if student is confirmed at school | | **Notify Parent** | Sends email to parent (can vary based on geofence logic) | | **Success Response** | Returns a 200 response to the triggering device | ## How the Logic Works 1. The student's phone runs a shortcut when near school. 2. Sends coordinates to webhook. 3. Workflow compares coordinates with predefined geofence (e.g., radius around school). 4. If inside school zone: * Log arrival * Notify teacher and/or parent 5. Else: * Optionally notify parent only ## iOS Shortcut Sample (Trigger Setup) - **Automation Trigger**: Arrive at Location (e.g., School) - **Action**: Run Shortcut → Make Web Request (POST) **POST URL:** ``` https://your-n8n-instance.com/webhook/location-update ``` **Body Example:** ```json { "student_id": "SU042", "student_name": "Anaya Joshi", "lat": 19.0760, "lng": 72.8777, "timestamp": "2025-08-06T08:05:00" } ``` ## Google Sheets Logging | Student ID | Name | Date | Time | Status | | ---------- | ----------- | ---------- | ----- | ------- | | SU042 | Anaya Joshi | 2025-08-06 | 08:05 | Arrived | ## Setup Requirements - **n8n Instance** with webhook support - **Google Sheet** with appropriate columns - **iOS Shortcut** setup on student device - **Teacher and Parent Email Addresses** configured in workflow
n8n$9.99Automate Trade Logging and Updates via Telegram and Google Sheets
Streamline your trading journal by automatically logging and updating trades through Telegram messages, with data stored in Google Sheets.
n8n$14.99Extract, Summarize & Analyze Amazon Price Drops with Bright Data & Google Sheets
### Notice Community nodes can only be installed on self-hosted instances of n8n. ### Who this is for This n8n-powered automation uses Bright Data's MCP Client to extract real-time data from a price drop site listing Amazon products, including price changes and related product details. The extracted data is enriched with structured data transformation, content summarization, and sentiment analysis using Google Gemini LLM. The Amazon Price Drop Intelligence Engine is designed for: - **Ecommerce Analysts** who need timely updates on competitor pricing trends - **Brand Managers** seeking to understand consumer sentiment around pricing - **Data Scientists** building pricing models or enrichment pipelines - **Affiliate Marketers** looking to optimize campaigns based on dynamic pricing - **AI Developers** automating product intelligence pipelines ### What problem is this workflow solving? This workflow solves several key pain points: **Reliable Scraping**: Uses Bright Data MCP, a managed crawling platform that handles proxies, captchas, and site structure changes automatically. **Insight Generation**: Transforms unstructured HTML into structured data and then into human-readable summaries using Google Gemini LLM. **Sentiment Context**: Goes beyond raw pricing data to reveal how customers feel about the price change, helping businesses and researchers measure consumer reaction. **Automated Reporting**: Aggregates and stores data for easy access and downstream automation (e.g., dashboards, notifications, pricing models). ### What this workflow does **Scrape price drop site with Bright Data MCP** The workflow begins by scraping targeted price drop site for Amazon listings using Bright Data's Model Context Protocol (MCP). You can configure this to target: **Structured Data Extraction** Once the HTML content is retrieved, Google Gemini is employed to: - Parse and structure the product information (title, price, discount, brand, ratings) **Summarization & Sentiment Analysis** The extracted data is passed through an LLM chain to: - Generate a concise summary of the product and its recent price movement - Perform sentiment analysis on user reviews and public perception **Store the Results** - Save to disk for archiving or bulk processing - Updated in a Google Sheet, making it instantly shareable with your team or integrated into a BI dashboard ### Pre-conditions 1. Knowledge of Model Context Protocol (MCP) is highly essential. Please read this blog post - [model-context-protocol](https://www.anthropic.com/news/model-context-protocol) 2. You need to have the [Bright Data](https://brightdata.com/) account and do the necessary setup as mentioned in the **Setup** section below. 3. You need to have the Google Gemini API Key. Visit [Google AI Studio](https://aistudio.google.com/) 4. You need to install the Bright Data MCP Server [@brightdata/mcp](https://www.npmjs.com/package/@brightdata/mcp) 5. You need to install the [n8n-nodes-mcp](https://github.com/nerding-io/n8n-nodes-mcp) ### Setup 1. Please make sure to set up n8n locally with MCP Servers by navigating to [n8n-nodes-mcp](https://www.youtube.com/watch?v=NUb73ErUCsA) 2. Please make sure to install the Bright Data MCP Server [@brightdata/mcp](https://www.npmjs.com/package/@brightdata/mcp) on your local machine. 3. Sign up at [Bright Data](https://brightdata.com/). 4. Create a Web Unlocker proxy zone called mcp_unlocker on Bright Data control panel. 5. Navigate to Proxies & Scraping and create a new Web Unlocker zone by selecting Web Unlocker API under Scraping Solutions. 6. In n8n, configure the Google Gemini (PaLM) API account with the Google Gemini API key (or access through Vertex AI or proxy). 7. In n8n, configure the credentials to connect with MCP Client (SDIO) account with the Bright Data MCP Server as shown below.  Make sure to copy the Bright Data API_TOKEN within the Environments textbox above as API_TOKEN=<your-token> ### How to customize this workflow to your needs - **Target different platforms**: Switch Amazon for Walmart, eBay, or any e-commerce source using Bright Data's flexible scraping infrastructure. - **Enrich with more LLM tasks**: Add brand tone analysis, category classification, or competitive benchmarking using Gemini prompts. - **Visualize output**: Pipe the Google Sheet to Looker Studio, Tableau, or Power BI. - **Notification integrations**: Add Slack, Discord, or email notifications for price drop alerts.
n8n$14.99Automate UX Interview Transcription and Analysis with OpenAI and Google Sheets
Streamline the process of analyzing UX interviews by automatically transcribing audio files with OpenAI and exporting the insights to Google Sheets.
n8n$9.99Automate Hourly Crypto Rate Monitoring with Alpha Vantage and Google Sheets
This workflow automates the hourly monitoring of cryptocurrency exchange rates for Bitcoin (BTC) and Ethereum (ETH) using the Alpha Vantage API. The data is logged into Google Sheets and alerts are sent via Telegram.
n8n$9.99Automate Legal Benchmarking with Google Sheets and LLM Evaluation
This workflow automates the evaluation of legal test cases stored in Google Sheets using various LLMs. It extracts data from PDFs, evaluates outputs with an LLM judge, and logs results back to Google Sheets.
n8n$14.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.99Create eSignatures.io contracts from Google Sheets
Every time a new row is added to your Google Sheets spreadsheet, Make will automatically create a contract from an eSignatures.io template. he template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1LuxqFtx8eBNUwLyHkPxbUpP-aqMMX8ykE25Yn4UmKk/edit?usp=sharing).
Make$3.99Automate Address Geocoding with Google Sheets and Google Maps API
Effortlessly convert addresses into latitude and longitude coordinates using Google Sheets and the Google Maps API, ideal for applications like delivery routing and market analysis.
n8n$4.99Automate TikTok to YouTube Shorts with Google Sheets and Telegram Notifications
Effortlessly transfer TikTok videos to YouTube Shorts, log activities in Google Sheets, and receive Telegram alerts with this n8n automation workflow.
n8n$14.99Google Sheets Form Automation: Collect User Insights Effortlessly
This workflow is designed to streamline the process of collecting user insights via a series of interactive forms, all integrated seamlessly with Google Sheets. By leveraging automation, businesses can efficiently gather valuable information from ...
Zapier$4.14
More integrations
Custom AI Systems & Services
Our team of experienced AI builders will help build custom AI systems, workflows, and solutions.
Request Custom Work