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.
Custom Pomodoro Tracker using Telegram and Google Sheets
**Tags**: Productivity, Pomodoro, Organization ### Context Hey! I'm Samir, a Supply Chain Engineer and Data Scientist from Paris, founder of [LogiGreen Consulting](https://logi-green.com). A significant improvement in my productivity came from following the **Pomodoro Technique**. ### What is the Pomodoro Technique? The Pomodoro Technique is a time management method that breaks your workday into 25-minute focus intervals followed by short breaks. After 4 cycles, you take a longer break to recharge. It helps maintain concentration while preventing burnout.  I've used this technique with web apps to receive break/work notifications. But I always wished I had a way to **track my sessions** for self-assessment. > Let's use **n8n** to boost our productivity and log our deep work sessions automatically! For business inquiries, you can add me on [Here](https://www.linkedin.com/in/samir-saci) ### Who Is This Template For? I built this workflow for creators, freelancers, students, and professionals who love the Pomodoro technique but want more than just timers - they want data. This template helps you: - Track every deep work session automatically - Store logs in Google Sheets for later analysis - Stay in control via Telegram commands - There is no need to pay for premium apps. It's all **free** and powered by **n8n**. ### How Does It Work? This Telegram bot tracks your Pomodoro sessions and sends you alerts during the process. **Here's what happens:** 1. A user sends `/start` to the bot. 2. It launches a 25-minute deep work timer. 3. After 25 minutes, the bot sends a break reminder. 4. **After four cycles**, a long break is triggered and the session is logged. 5. The session is **automatically recorded to Google Sheets** with (Date & Time, User ID, Pomodoro count, Session ID, Duration of focus and breaks)  ### What Gets Tracked? | Field | Description | |-------------------|-----------------------------------| | Date & Time | When the session was logged | | User ID | Your Telegram ID | | Block Type | Deep Work or Short Break | | Pomodoro Count | Number of cycles completed | | Working Session ID| Unique ID for each session | | Focus Duration | Length of each deep work session | | Break Duration | Short or long break info | You can use this workflow as a base to bring additional features like: - Connecting with tasks from **Google Tasks** - Send automated productivity reports to monitor your activity - Link a Pomodoro with a task using **Google Calendar** ### What Do I Need to Start? This workflow is beginner-friendly - **no coding required**. - **Google Drive API** and **Google Sheets API** credentials - A Google Sheet set up to log sessions (with the columns of the table above) - API Credentials: - **Google Sheets API** (OAuth2) - **Telegram Bot Token** - Telegram app to chat with the bot > The template is plug-and-play. Just follow the sticky notes in the n8n editor to configure it. ### Next Steps Follow the sticky notes in the n8n workflow editor to: - Set your credentials - Connect your Google Sheet - Initialize the static data - Launch your first `/start` command on Telegram  [**Watch My Tutorial**](https://www.youtube.com/watch?v=ztMMrmbgGEo) Curious how n8n can supercharge **productivity and learning skills?** Let's connect on [**LinkedIn**](https://www.linkedin.com/in/samir-saci) This workflow has been created with N8N 1.82.1 Submitted: March 24th, 2025
n8n$14.99Automate SEO Keyword Tracking and Notifications with Google Sheets and SerpAPI
This n8n workflow automates the tracking of SEO keyword positions in Google SERPs using SerpAPI, logs the data in Google Sheets, and sends notifications via WhatsApp and email for any ranking changes.
n8n$14.99Automate AI Chat Logs Transfer from Postgres to Google Sheets
This n8n workflow automates the retrieval of AI agent chat logs from a Postgres database and exports them to Google Sheets, creating a new sheet for each session. Ideal for teams needing to review and analyze chat logs collaboratively.
n8n$14.99Automate Website Tool Analysis with Telegram, Apify, AI & Google Sheets
#### Description This powerful workflow automates the evaluation of new digital tools, websites, or platforms with the goal of assessing their potential impact on your business. By leveraging Telegram for user input, Apify for deep content extraction, advanced AI for contextual analysis, and Google Sheets for personalized data integration and record-keeping, this tool delivers clear, actionable verdicts that help you determine whether a tool is worth adopting or exploring further. #### Key Features and Workflow User-Friendly Input: Submit URLs of tools or websites directly through Telegram for quick and easy evaluation requests. - Dynamic Content Extraction: The workflow retrieves detailed content from the submitted URLs using the Apify web crawler, capturing rich data for analysis. - AI-Powered Cleaning & Analysis: Sophisticated AI models filter out noise, distill meaningful insights, and contextualize findings based on your business profile and goals stored in Google Sheets. - Personalized Business Context: Integration with Google Sheets brings in your company's specialization, current focus, and strategic objectives to tailor the analysis specifically to your needs. - Structured Analysis Output: Receive a thorough, structured report including concise summaries, key considerations, business impact, benefits, risks, actionable insights, and an easy-to-understand final verdict on the tool's relevance. - Decision Support: The tool estimates effort, time to value, urgency, and confidence levels, enabling informed prioritization and strategic decision-making. - Seamless Communication: Results are sent back via Telegram, ensuring you get timely and direct feedback without needing to leave your messaging app. - Record Keeping & Tracking: All analyses and decisions are logged automatically into Google Sheets, creating a searchable knowledge base for ongoing reference and reporting. #### Setup Instructions for Key Nodes Telegram Trigger Node: 1. Configure your Telegram bot API credentials here. 2. Link the bot to your Telegram account to receive messages for URL submissions. URL Extraction Node: No credentials needed. This node extracts URLs from incoming messages for processing. Apify Web Crawler Node Setup Guide: Go to Apify's website, sign up for an account if you don't have one, and get your API token from your profile's API tokens section. Then, paste this token into the Apify Node's API Key field in n8n. AI Cleaning and Analysis Nodes: 1. Configure OpenAI or compatible AI service API keys for content processing. 2. Customize prompts or models if desired to align analysis style. Google Sheets Nodes: 1. Connect using your Google account and provide access to the specified Google Sheet. 2. Ensure sheets for Company Details and Analysis Results exist with proper columns as per this workflow. Telegram Reply Node: Use the Telegram bot API credentials to send analysis summaries and verdicts back to users. ###### Access and Edit the Google Sheet You can access the Google Sheet used by this workflow here: [Access the Google Sheet here](https://docs.google.com/spreadsheets/d/1RCMapKv9IPdwNz4Rp-Ma2iKzdWDEbxggYrq9K2_pU-w/edit?usp=sharing) Please make a copy of the sheet to your own Google Drive before connecting it with this workflow. This allows you to customize the sheets, update company information, and manage analysis results securely without affecting the original template. #### Extendibility Beyond manual URL submissions, you can enhance this workflow by scheduling automated daily checks of new product launches from platforms like Product Hunt. The system can proactively analyze emerging tools and deliver timely updates via Telegram, email, or other channels, helping you stay ahead of innovation effortlessly.
n8n$14.99Automate Amazon Price Monitoring with Bright Data and Google Sheets
This workflow automates the process of monitoring Amazon product prices using Bright Data's Amazon Scraper API and Google Sheets. Ideal for market research, competitor analysis, or personal price tracking, it retrieves and updates price data for specified products.
n8n$9.99Automate 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 Google AI Mode Reference Tracking to Google Sheets with DataForSEO
This workflow automates the extraction of source references from Google AI Mode using DataForSEO and records them in Google Sheets. Ideal for SEO analysts and marketers to monitor brand visibility and competitor mentions.
n8n$9.99Automate Contact Enrichment from Google Sheets with Apollo and Telegram Alerts
Streamline your procurement contact enrichment by automatically fetching and updating contact details from Google Sheets using Apollo's API, and receive notifications via Telegram.
n8n$14.99Automate Driver License Data Extraction with Google Drive, VLM Run, and Google Sheets
Streamline the process of extracting data from driver license images uploaded to Google Drive using VLM Run's AI OCR, and store the structured data in Google Sheets.
n8n$9.99Automate B2B Lead Qualification with VAPI and Google Sheets
This n8n workflow automates the qualification of B2B leads through voice calls using the VAPI API, and integrates the collected data into Google Sheets. It triggers upon the addition of a new lead's phone number, enhancing efficiency in lead qualification and data management.
n8n$9.99Real-time Sales Pipeline Analytics with Bright Data, OpenAI, and Google Sheets
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automatically tracks key sales pipeline metrics—new leads, deal stages, win rates—and sends actionable insights to your team. Eliminate manual CRM exports and stay on top of revenue health. ## Overview The automation queries your CRM API (HubSpot, Salesforce, or Pipedrive) on a schedule, pulls pipeline data, and feeds it into OpenAI for anomaly detection (e.g., stalled deals). Summaries and alerts appear in Slack, while daily snapshots are archived in Google Sheets for trend analysis. ## Tools Used - **n8n** - Pipeline orchestration - **CRM API** - Connects to your chosen CRM - **OpenAI** - Detects anomalies and highlights risks - **Slack** - Notifies reps and managers in real time - **Google Sheets** - Stores historical pipeline data ## How to Install 1. **Import the Workflow** into n8n. 2. **Connect Your CRM**: Provide API credentials in the HTTP Request node. 3. **Set Up OpenAI**: Add your API key. 4. **Authorize Slack & Google Sheets**. 5. **Customize Thresholds**: Adjust what constitutes a stalled deal or low conversion. ## Use Cases - **Sales Management**: Monitor pipeline health without dashboards. - **Revenue Operations**: Detect bottlenecks early. - **Forecasting**: Use historical snapshots to improve predictions. - **Rep Coaching**: Alert reps when deals stagnate. ## Connect with Me - **Website**: https://www.nofluff.online - **YouTube**: https://www.youtube.com/@YaronBeen/videos - **LinkedIn**: https://www.linkedin.com/in/yaronbeen/ - **Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission) #n8n #automation #salespipeline #crm #openai #slackalerts #n8nworkflow #nocode #revenueops
n8n$14.99Automate Google Sheets Contact Sync with SeaTable
Effortlessly synchronize your Google Sheets contacts with SeaTable, ensuring your data is always up-to-date by automatically inserting or updating records.
n8n$14.99Extract Data from YAPE Receipts via Telegram OCR and Store in Google Sheets
## Detailed Technical Description This **n8n** workflow automates [Yape](https://www.yape.com.pe/) payment receipt processing, integrating [Telegram bot](https://core.telegram.org/bots), AI-powered OCR, and [Google Sheets](https://support.google.com/docs/answer/6000292) automation. By leveraging **[ChatGPT](https://chatgpt.com/)** Vision Computing, it extracts and structures transaction details, eliminating the need for manual entry. Ideal for freelancers, businesses, and finance teams, this workflow ensures error-free, real-time financial tracking. The AI agent powered by **[DeepSeek](https://www.deepseek.com/)** refines and formats the extracted text, storing it in [Google Sheets](https://support.google.com/docs/answer/6000292) for easy accessibility and reporting. Users can track payments, monitor cash flow, and generate financial reports without any manual work. This seamless integration boosts efficiency, reduces errors, and automates financial record-keeping with 100% accuracy. ### Technologies Used: - **n8n** - Workflow orchestrator. - **Telegram** - Handles image reception and notifications. - **Google Drive** - Manages file creation and storage. - **Google Sheets** - Automatically logs extracted data into spreadsheets. ### Artificial Intelligence: - **ChatGPT** Vision Computing - Performs OCR on payment receipts. - **DeepSeek** AI - Organizes and converts extracted data into a structured format. --- ## Pre-conditions: - `A Telegram Bot` - Must be created to receive images. [Setup Guide](https://core.telegram.org/bots/features#creating-a-new-bot) - `Google Sheets API Key` - Required to store extracted data. [Setup Guide](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets/) - `ChatGPT API Key` - Used for OCR and AI text extraction. [Get it here](https://help.openai.com/en/articles/4936850-where-do-i-find-my-openai-api-key) - `DeepSeek API Key` - Processes extracted text into structured data. [Get it here](https://platform.deepseek.com/api_keys) #### 1. Image Reception & OCR Processing The user attaches a Yape payment receipt image to the Telegram bot conversation.  #### 2. Analyze Image (OCR) A **ChatGPT** Vision Computing model processes the image and extracts all visible text, ensuring high-accuracy OCR for structured data extraction.  #### 3. Analyze and format text Intelligent Data Processing with AI The extracted text is sent to a **DeepSeek-based** AI agent that: - Identifies and structures key transaction details (amount, date, sender, transaction ID, etc.). - Converts the data into a structured JSON format.  #### 4. Data Storage in Google Sheets **Google Drive** integration is established. If the Google Sheets file does not exist, it is automatically created. Extracted data is automatically recorded in the corresponding spreadsheet, enabling effortless tracking and streamlined financial organization.  ## Benefits: - Time-saving - Eliminates manual payment processing. - Error-free data entry - Reduces human mistakes in record-keeping. - 100% automation - No manual intervention required. - Seamless integration - Easily connects with other workflows. **NOTE**: _The extracted transaction data will be stored in a Google Sheets file with the following columns:_ | Column Name | Description | |:---------------------:|-----------------------------------------------------------| | **id** | Unique identifier for each transaction. | | **beneficiaryName** | Name of the recipient of the payment. | | **amount** | Payment amount in the specified currency. | | **currency** | Currency used for the transaction (e.g., PEN, USD). | | **company** | The entity or service handling the transaction. | | **date** | Date of the transaction in a human-readable format. | | **hour** | Time of the transaction. | | **originalDate** | The exact date extracted from the receipt. | | **dateISO** | Standardized ISO 8601 date format. | | **operation** | Type of financial operation (e.g., deposit, transfer). | | **operationNumber** | Unique operation number provided by the payment system. | | **beneficiaryNumber** | Account or phone number of the recipient. | | **commission** | Any commission or fee charged for the transaction. | | **account** | Account number or reference used for the payment. | | **channel** | Payment method used (e.g., app, POS, bank transfer). | | **agentCode** | Identifier of the agent or entity processing the payment. | --- This workflow is perfect for
n8n$24.99Automated Error Alerts with Google Sheets, Telegram, and Gmail in n8n
This workflow automates error handling in n8n by logging errors to Google Sheets, notifying a Telegram channel, and sending email alerts via Gmail, ensuring prompt awareness of issues.
n8n$4.99Automate Meeting Attendee Data Enrichment with Apollo.io and Google Sheets
Streamline your meeting preparation by automatically enriching attendee profiles with Apollo.io data and logging it into Google Sheets. Perfect for sales, customer success, and recruitment professionals.
n8n$9.99Automate Email Campaigns with Google Sheets and Gmail Using n8n
Streamline your email outreach by automating personalized email sequences using Google Sheets and Gmail with n8n, without incurring additional API costs.
n8n$14.99Automate Shipment Tracking and Customer Notifications via Google Sheets and WhatsApp
This workflow automates the tracking of shipments using Delhivery and DHL APIs, updates Google Sheets, and sends notifications to customers via WhatsApp and email when shipment statuses change.
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.99Automate Profile List Building with Airtop and Google Sheets
Streamline the process of building targeted lists of profiles from various platforms using Airtop and Google Sheets, enhancing accuracy and saving time.
n8n$4.99Automate Google Business Profile Posts with GP-4 and Google Sheets
This powerful n8n workflow automatically generates and publishes Google Business Profile (GMB) posts using topics listed in a Google Sheet. It uses **OpenAI** to write SEO-optimized post descriptions and generate **AI images** based on the topic, then posts them directly to your **GMB profile** and marks them as published in the sheet. --- ## Use Case Perfect for: - Digital marketers managing local SEO - Agencies automating content for clients - Businesses regularly posting to GMB - Teams managing editorial calendars via Google Sheets --- ## Workflow Overview | Node | Purpose | |-------------------------------|------------| | **Schedule Trigger** | Runs daily at 9AM (configurable) | | **Get Unpublished Row** | Reads a row from Google Sheet where Status is not marked Published | | **Generate Post Text** | Uses OpenAI (GPT-4) to write a compelling, local-business optimized post | | **Generate Post Image** | Uses DALL·E or similar to create an image matching the topic | | **Post to GMB** | Publishes the generated content to your Google Business Profile | | **Update Sheet** | Marks the status as Published in the Google Sheet | --- ## Google Sheet Format | Column Name | Description | |-------------|-------------| | Topic | The subject or idea for the GMB post | | Status | Should be blank or Unpublished to trigger the flow | | Date | (Optional) Posting schedule or note | | Notes | (Optional) Internal info - not used in the automation | --- ## Google My Business API Setup ### 1. Google Cloud Configuration - Go to [Google Cloud Console](https://console.cloud.google.com/) - Enable the **Google My Business API** - Create **OAuth2 Client ID** and **Client Secret** - Add this required scope: ``` ### 2. Request for GMB Quota - You need to request for GMB (Google Business Profile) API Quota from here, because by default it sets to zero: https://support.google.com/business/contact/api_default ``` ### 3. n8n Credential Setup - In n8n, go to **Credentials > Google OAuth2** - Use your **Client ID** and **Client Secret** - Use this credential in GMB-related nodes --- ## OpenAI Prompt Customization Modify the prompt in the OpenAI node to match your brand's voice: ### Example Prompt ```text Write a short, engaging Google Business Post about: {{ $json.topic }}. Make it suitable for a local audience and include a subtle call to action. ``` --- ## Optional Enhancements - Add **If** node to delay publishing on certain days - Use **Slack or Email** notifications to alert before/after posting - Use **Multiple Businesses** by adding a Router or Switch node per GMB account --- ## Benefits - Fully automated GMB posting - SEO-optimized, AI-written content - Matching images for visual engagement - Maintains a content log via Google Sheets - Easily customizable prompt logic and schedule
n8n$4.99Extract Business Data from Google Maps via Chat to Excel and Google Sheets
## Who is this for This workflow is designed for marketers, researchers, and business owners who need to quickly find and export company data from Google Maps into a structured table format. ## What problem is this workflow solving Manually collecting business contact information from Google Maps is time-consuming and error-prone. This workflow automates the process, allowing users to instantly extract company data and export it to Excel or Google Sheets for further use. For example, title, rating, reviews, address, operating hours, phone, website, type, GPS coordinates. ## What this workflow does - Takes a user's search query via chat - Scrapes company data from Google Maps based on that query - Returns the results in a downloadable Excel file - Saves the same data to a connected Google Sheets document for easy access and sharing ## Setup 1. Add your credentials: - Google Sheets API - Google Maps API 2. Run the workflow and enter your search request in the chat interface 3. Retrieve your results from either: - The Get XLSX node as an Excel file - The linked Google Sheets file
n8n$9.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.99Automate Tracking of Website Visibility in Google AI Overviews with SerpAPI and Google Sheets
This workflow automates the process of tracking your website's visibility in Google's AI Overviews using SerpAPI and Google Sheets. It helps SEO professionals and digital marketers identify if their site appears in AI-generated search results.
n8n$4.99Automate SEO Keyword Analysis with RapidAPI and Log to Google Sheets
## **Automated Keyword Analysis and Google Sheets Logging** Automate keyword research with n8n and log essential SEO data like search volume, trends, competition, and keyword difficulty directly into Google Sheets. Simplify your SEO efforts with real-time insights. ## Node-by-Node Explanation ### 1. **On form submission (Trigger)** - **Purpose:** Triggers the workflow when a user submits the form with country and keyword as inputs. - **Explanation:** This node initiates the process by accepting user input from the form and passing it to the next node for analysis. ### 2. **Keyword Analysis (HTTP Request)** - **Purpose:** Sends a request to an external SEO API to analyze the provided keyword, fetching data like search volume, trends, and competition. - **Explanation:** This node calls the [**Keyword Research Tool API**](https://rapidapi.com/skdeveloper/api/keyword-research-tool3) with the country and keyword inputs from the form, retrieving essential keyword data for further processing. ### 3. **Re-format output (Code)** - **Purpose:** Processes and reformats the API response into a structured format suitable for logging into Google Sheets. - **Explanation:** Extracts and organizes the keyword data (e.g., competition, CPC, search volume) into a format that can be easily mapped to Google Sheets columns. ### 4. **Google Sheets (Append)** - **Purpose:** Appends the reformatted keyword data into the specified Google Sheets document. - **Explanation:** Logs the fetched keyword insights into a Google Sheets document, allowing for continuous tracking and analysis. --- ## **Benefits of This Workflow** - **Automated Keyword Research:** Eliminates manual keyword research by automating the entire process using the [**Keyword Research Tool API**](https://rapidapi.com/skdeveloper/api/keyword-research-tool3). - **Real-time Data Tracking:** Fetches up-to-date SEO metrics from the [**Keyword Research Tool API**](https://rapidapi.com/skdeveloper/api/keyword-research-tool3) and logs them directly into Google Sheets for easy access and analysis. - **Efficient Workflow:** Saves time by integrating multiple tools (form, SEO API, Google Sheets) into one seamless process. - **SEO Insights:** Provides detailed insights like search volume, trends, competition, and keyword difficulty, aiding in strategic decision-making with the help of the [**Keyword Research Tool API**](https://rapidapi.com/skdeveloper/api/keyword-research-tool3). --- ## **Use Case** This workflow is ideal for digital marketers, SEO professionals, and content creators who need to analyze keyword performance and track essential SEO metrics efficiently. It automates the process of keyword research by calling the [**Keyword Research Tool API**](https://rapidapi.com/skdeveloper/api/keyword-research-tool3), fetching relevant data, and logging it into Google Sheets. This makes it easier to monitor and optimize SEO strategies in real-time.
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