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.
Automate Google Sheets Updates with Etsy Ledger Entries
Automatically add new rows to a Google Sheet for each ledger entry from Etsy, streamlining your financial tracking process.
MakeFreeAutomate Company Enrichment and Sync from Google Sheets to HubSpot
This workflow enriches new company entries from Google Sheets using AI, checks for existing records in HubSpot, and updates both platforms seamlessly.
n8n$9.99Automate Meal Nutrient Logging from Telegram to Google Sheets via AI
Streamline your nutrition tracking by automating meal data logging from Telegram to Google Sheets using AI for transcription and analysis.
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.99Import Google Keep Notes to Google Sheets Using OpenAI and Google Drive
This n8n workflow automates the import of your Google Keep notes into a structured Google Sheet, using Google Drive, OpenAI for AI-powered processing, and JSON file extraction. It's perfect for users who want to turn exported Keep notes into a searchable, filterable spreadsheet - optionally enhanced by AI summarization or transformation. ## Who is this for? - Researchers, knowledge workers, and digital minimalists who rely on Google Keep and want to better organize or analyze their notes. - Anyone who regularly exports Google Keep notes and wants a clean, automated workflow to store them in Google Sheets. - Users looking to apply AI to process, summarize, or extract insights from raw notes. ## What problem is this workflow solving? Exporting Google Keep notes via Google Takeout gives you unstructured .json files that are hard to read and manage. This workflow solves that by: - Filtering relevant .json files - Extracting note content - (Optionally) applying AI to analyze or summarize each note - Writing the result into a structured Google Sheet ## What this workflow does 1. Google Drive Search: Looks for .json files inside a specified Keep folder. 2. Loop: Processes files in batches of 10. 3. File Filtering: Filters by .json extension. 4. Download + Extract: Downloads each file and extracts note content from JSON. 5. Optional Filtering: Only keeps non-archived notes or those meeting content criteria. 6. AI Processing (optional): Uses OpenAI to summarize or transform the note content. 7. Prepare for Export: Maps note fields to be written. 8. Google Sheets: Appends or updates the target sheet with the note data. ## Setup - Export your Google Keep notes using Google Takeout: - Deselect all, then choose only Google Keep. - Choose "Send download link via email". - Unzip the downloaded archive and upload the .json files to your Google Drive. - Connect Google Drive, OpenAI, and Google Sheets in n8n. - Set the correct folder path for your notes in the “Search in ‘Keep’ folder” node. - Point the Google Sheet node to your spreadsheet ## How to customize this workflow to your needs Skip AI processing: If you don't need summaries or transformations, remove or disable the OpenAI Chat Model node. Filter criteria: Customize the Filter node to extract only recent notes, or those containing specific keywords. AI prompts: Edit the Tools Agent or Chat Model node to instruct the AI to summarize, extract tasks, categorize notes, etc. Field mapping: Adjust the “Set fields for export” node to control what gets written to the spreadsheet. Use this template to build a powerful knowledge extraction tool from your Google Keep archive - ideal for backups, audits, or data-driven insights.
n8n$14.99Add Google Sheets rows for Layerise experiences
Make will import your Layerise experiences into your Google sheets worksheet as a row. Heres the [sheet](https://docs.google.com/spreadsheets/d/1Bd3ef6vSgP-rzYHyhAqoXZSKsWzguhRGmsAAODFCtVo/edit?usp=sharing) used in this scenario.
Make$2.99Automate Website Change Detection with Firecrawl, Google Sheets, and Gmail Alerts
Automatically monitor dynamic websites for changes and receive instant email alerts. This workflow uses Firecrawl to scrape JavaScript-rendered content, logs changes in Google Sheets, and sends notifications via Gmail.
n8n$14.99Automate YouTube Video Summaries to Slack Using Google Sheets and AI
Streamline your workflow by automatically summarizing new YouTube videos and posting them to Slack. This automation fetches video details, generates concise summaries using AI, and delivers them directly to your Slack channel.
n8n$24.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.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 EDI Message Processing with Gmail and Google Sheets
Streamline the processing of EDI messages by automatically parsing emails from Gmail and logging the data into Google Sheets. This workflow simplifies manual data handling for small businesses.
n8n$14.99Seamlessly Create QuickBooks Invoices from Google Sheets Data
Automate the process of generating QuickBooks Online invoices from Google Sheets entries, eliminating manual data entry and reducing errors.
n8n$4.99Automate Facebook Insights Data Import to Google Sheets
Effortlessly transfer Facebook Insights data to Google Sheets, enabling streamlined data analysis and reporting.
MakeFreeAutomate HubSpot Buying Group Enrichment with Surfe and Google Sheets
Automatically identify and enrich key contacts in HubSpot deals using Surfe and Google Sheets, ensuring no decision-maker is overlooked.
n8n$14.99Automate Expense Tracking from LINE Messages to Google Sheets Using GPT-4
This workflow automates the process of logging expenses from LINE messages into Google Sheets using GPT-4. It handles both text and image inputs, extracting relevant data and ensuring no duplicate entries.
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 Weekly Student Progress Reports via Gmail and Google Sheets
This n8n workflow automates the creation and delivery of weekly student performance reports to parents using data from a Learning Management System (LMS). It compiles grades, attendance, and progress notes into a formatted report and sends it via email, streamlining communication without manual intervention.
n8n$9.99Automate Competitor Price Monitoring with Bright Data and Google Sheets
This workflow automates the monitoring of competitor pricing by scraping websites and logging data into Google Sheets, providing real-time insights into market trends.
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 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.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 Personalized Email Campaigns Using Google Sheets and AI
This workflow automates the creation and delivery of personalized marketing emails by integrating Google Sheets with AI content generation, streamlining your email marketing efforts.
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 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