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 Lead Enrichment from Google Sheets to HubSpot with Surfe
Streamline your lead enrichment process by automatically enriching contact data from Google Sheets using Surfe and updating HubSpot CRM.
n8n$9.99Automate Multi-Broker Portfolio Tracking with Google Sheets and Telegram Alerts
Streamline your investment tracking across multiple brokers with real-time updates and alerts via Telegram. This workflow integrates Google Sheets and Telegram to provide a comprehensive view of your financial portfolio, offering scheduled and on-demand updates.
n8n$9.99Create a Context-Aware Slack Assistant with Google Sheets, Pinecone & GPT-4
This advanced n8n automation template empowers your Slack bot to act as an intelligent assistant: when a user asks a question or requests a suggestion (by mentioning the bot), it automatically retrieves the user's historical data and previous interactions from both Google Sheets and Pinecone. Using GP-4o, the bot analyzes past updates, status reports, and context to generate a personalized, context-aware response directly in Slack. Perfect for teams seeking instant, data-driven support, this workflow transforms your Slack bot into a smart knowledge assistant that references your own organizational history to provide relevant answers and suggestions. **What This Template Does (Step-by-Step)** **Slack Bot Mention Trigger** - Listens for message or app_mention events where a user asks a question or requests a suggestion. - Captures the message body and user ID. **User Profile & Data Fetch** - Uses the Slack API to retrieve the user's profile. - Queries Google Sheets and Pinecone to collect the user's historical updates and interactions. **Contextual AI Lookup** - GP-4o reviews the user's past status reports, messages, and activity. - Synthesizes a contextually relevant answer or suggestion based on prior data. **Personalized Response Generation** - The bot replies in Slack with a tailored answer, referencing the user's previous updates and current context. **Auto-Fix & Schema Validation** - Ensures the generated response is well-structured and matches your organization's data schema. **Document Update (Optional)** - Optionally logs the new interaction or suggestion back to Pinecone for future reference. **Required Integrations** - Slack Bot with channels:history, app_mentions:read, and users.profile:read - Google Sheets OAuth2 (for lead or user status records) - Pinecone Vector Store (for storing user status documents) - Azure OpenAI or OpenAI GP-4o (for document generation and merging) - Cohere API (optional) for reranking relevance in vector search **Ideal For** - Remote teams running async daily standups - People ops tracking onboarding or churn signals - Founders building internal GP-powered tools - Managers consolidating Slack-based updates across teams - Teams wanting a Slack bot that provides personalized answers and suggestions based on past activity - Managers and team members seeking quick, AI-powered support and insights from their own work history - Organizations aiming to leverage internal data for smarter, context-aware assistance in Slack
n8n$14.99Automate Fiverr UGC Gig Tracking with Google Sheets
This n8n workflow automates the process of monitoring Fiverr User-Generated Content (UGC) gigs by scraping, parsing, and logging data into Google Sheets. It provides continuous market insights and historical data preservation.
n8n$4.99Automate Backlink Status Monitoring with Google Sheets and DataForSEO
This n8n workflow automates the process of checking the status of backlinks listed in a Google Sheet using the DataForSEO On-Page API. It verifies if backlinks are live, dofollow, or lost, and updates the status back in the Google Sheet.
n8n$9.99Automate Business Lead Generation from Reddit to Google Sheets
This n8n workflow automates the process of generating business leads by searching Reddit for posts with specific keywords, analyzing and summarizing the content using OpenRouter AI, and logging the results in Google Sheets.
n8n$14.99Automate Data Transfer from Webhook to ChatGPT and Google Sheets
Streamline your workflow by automatically sending data from a Webhook to ChatGPT for processing, and then storing the results in a Google Sheet for easy access and analysis.
Make$3.99Automate Facebook Insights Data Import to Google Sheets
Effortlessly transfer Facebook Insights data to Google Sheets, enabling streamlined data analysis and reporting.
MakeFreeImport 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.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 Weekly Business Reports with AI and Google Sheets
This workflow automates the creation of weekly business reports by pulling data from Google Sheets, analyzing it with AI, and generating a formatted Google Document. The report is then sent to Slack for team review and approval, ensuring consistent recognition of team progress.
Activepieces$2.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 Negative PR Monitoring on Reddit with AI and Google Sheets
This workflow automates the monitoring of brand reputation by scanning Reddit for negative sentiment, filtering relevant posts, and logging them into Google Sheets for tracking.
n8n$9.99Reddit Sentiment Analysis for Apple WWDC25 with GeminAI and Google Sheets
This workflow automates sentiment analysis of Reddit posts related to Apple's WWDC25 event. It extracts data, categorizes posts, analyzes the sentiment of comments, and updates a Google Sheet with the results. ### Prerequisites 1. **Bright Data Account:** You need a Bright Data account to scrape Reddit data. Ensure you have the correct permissions to use their API. [https://brightdata.com/](https://brightdata.com/) 2. **Google Sheets API Credentials:** Enable the Google Sheets API in your Google Cloud project and create credentials (OAuth 2.0 Client IDs). 3. **Google Gemini API Credentials:** You need a Gemini API key to run the sentiment analysis. Ensure you have the correct permissions to use their API. [https://ai.google.dev/](https://ai.google.dev/). You can use any other models of choice. ### Setup 1. **Import the Workflow:** Import the provided JSON workflow into your n8n instance. 2. **Configure Bright Data Credentials:** In the scrape Reddit and the get status nodes, in Header Parameters find the Authorization field, replace `Bearer 1234` with your Bright Data API key. Apply this to every node that utilizes your Bright Data API Key. 3. **Set up the Google Sheets API credentials** - In the Append Sentiments node, set up the Google Sheets API by connecting your Google Sheets account through OAuth 2 credentials. 4. **Configure the Google Gemini Credential ID** - In the Sentiment Analysis per comment node, set up the Google Gemini API by connecting your Google AI account through the API credentials. 5. **Configure Additional Parameters:** - In the scrape Reddit node, modify the JSON body to adjust the search term, date, or sort method. - In the Wait node, alter the Amount to adjust the polling interval for scraping status, it is set to 15 seconds by default. - In the ext Classifier node, customize the categories and descriptions to suit the sentiment analysis needs. Review categories such as WWDC events to ensure relevancy. - In the Sentiment Analysis per comment node, modify the system prompt template to improve context. ### Customization Options 1. Bright Data API parameters to adjust scraping behavior. 2. Wait node duration to optimize polling. 3. ext Classifier categories and descriptions. 4. Sentiment Analysis system prompt. ### Use Case Examples - **Brand Monitoring:** Track public sentiment towards Apple during and after the WWDC25 event. - **Product Feedback Analysis:** Gather insights into user reactions to new product announcements. - **Competitive Analysis:** Compare sentiment towards Apple's announcements versus competitors. - **Event Impact Assessment:** Measure the overall impact of the WWDC25 event on various aspects of Apple's business. ### Target Audiences - Marketing professionals in the tech industry, - Brand managers, - Product managers, - Market research analysts, - Social media managers ### Troubleshooting 1. Workflow fails to start. Check that all necessary credentials (Bright Data and Google Sheets API) are correctly configured and that the Bright Data API key is valid. 2. Data scraping fails. Verify the Bright Data API key, ensure the dataset ID is correct, and inspect the Bright Data dashboard for any issues with the scraping job. 3. Sentiment analysis is inaccurate. Refine the categories and descriptions in the ext Classifier node. Check that you have the correct Google Gemini API key, as the original is a placeholder. 4. Google Sheets are not updating. Ensure the Google Sheets API credentials have the necessary permissions to write to the specified spreadsheet and sheet. Check API usage limits. 5. Workflow does not produce the correct output. Check the data connections, by clicking the connections, and looking at which data is being produced. Check all formulas for errors. Happy productivity!
n8n$14.99Automate Jura Coffee Machine Usage Logging with Webhook and Google Sheets
Automatically log coffee usage from your Jura E8 espresso machine using a webhook and Google Sheets. This workflow captures data via Bluetooth and appends it to a Google Sheet for easy tracking and analysis.
n8n$9.99Analyze Browsing History and Generate Automation Suggestions with OpenRouter AI and Google Sheets
# Browsing History Automation Analyzer - Automation Toolkit (Google Sheets + AI) This **n8n workflow** analyzes your browsing history to identify opportunities for automation. It reads history from a Google Sheet, groups visits by domain, filters out irrelevant entries, and uses AI to recommend what can be automated - including how and why. --- ## What It Does - **Reads** your browsing history from Google Sheets - **Groups** history by domain - **Filters out** common non-actionable domains (e.g., YouTube, Google) - **Uses AI** to analyze whether your activity on each site is automatable - **Provides suggestions** including what to automate, how to do it, and which tools to use - **Saves results** into a new tab in the same Google Sheet - **Searches for n8n workflow templates** related to the suggested automation --- ## Demo Sheet Input + output are handled via the following Google Sheet: **Spreadsheet**: [View on Google Sheets](https://docs.google.com/spreadsheets/d/1V26KDJLBZno6e_VxaBqhsK_JOOOn_5N6uww2apcAeoc/edit?usp=drivesdk) - **Sheet: `history`** - Input browsing history - **Sheet: `automations`** - Output AI automation suggestions --- ## AI Analysis Logic The AI agent receives each domain's browsing history and responds with: - `domain`: The website domain - `automatable`: true/false - `what_to_automate`: Specific actions that can be automated - `reason`: Why it's suitable (or not) for automation - `tool`: Suggested automation tool (e.g., n8n, Apify) - `automation_rating`: High, Medium, Low, or Not Automatable - `n8n_template`: Relevant automation template (if found) --- ## Technologies Used | Tool | Purpose | |------------------------|--------------------------------| | **n8n** | Workflow automation | | **LangChain AI Agent** | AI-based analysis | | **Google Sheets Node** | Input/output data handling | | **OpenRouter (LLM)** | Language model for intelligent reasoning | | **JavaScript Code Node** | Grouping and formatting logic | | **Filter Node** | Remove unwanted domains | | **HTTP Request Node** | Search n8n.io templates | --- ## Chrome History Export You can use this Chrome extension to export your browsing history in a format compatible with the workflow: [Export Chrome History Extension](https://chromewebstore.google.com/detail/export-chrome-history/dihloblpkeiddiaojbagoecedbfpifdj?pli=1) --- ## Want Personalized Automation Advice? If you'd like **personalized automation recommendations** based on your browsing history - just like what this workflow provides - feel free to contact me directly: > **msaidwolfltd@gmail.com** I'll help you discover what tasks you can automate to save time and boost productivity. --- ## Example Use Cases - Automate daily logins to dashboards - Auto-fill forms on repetitive websites - Schedule data exports from web portals - Trigger reminders based on recurring visits - Discover opportunities for scraping and integration --- ## License This workflow is provided as-is for educational and personal use. For commercial or customized use, contact the author. ---
n8n$9.99Extract Data from Trip Receipts with GP-4.1-mini, Google Sheets & Email Notifications
# Automated Expense Reporting Workflow With GPT-4.1-mini ## ☀ Who's it for This workflow is designed for employees who need to submit expense claims for business trips. It automates the process of extracting data from receipts/invoices, logging it to a Google Sheet, and notifying the finance team via email. Ideal users: - Employees submitting business trip expense claims - HR or Admins reviewing travel-related reimbursements - Finance teams responsible for processing claims ## ℹ How it works / What it does 1. **Employee submits a form** with trip information (name, department, purpose, dates) and uploads one or more receipts/invoices (PDF). 2. **Uploaded files are saved to Google Drive** for record-keeping. 3. Each PDF is passed to a **DocClaim Assistant agent**, which uses GPT-4.0 and a structured parser to extract structured invoice data. 4. The data is **transformed and formatted** into a standard JSON structure. 5. Two parallel paths are followed: - Invoice records are appended to a **Google Sheet** for centralized tracking. - A detailed **HTML email** summarizing the trip and expenses is generated and sent to the **finance department** for claim processing. ## ✅ How to set up 1. **Create a form** to capture: - Employee Name - Department - Trip Purpose - From Date / To Date - Receipt/Invoice File Upload (multiple PDFs) 2. **Configure file upload node** to store files in a specific Google Drive folder. 3. **Set up DocClaim Agent** using: - GPT-4.0 or any LLM with document analysis capability - Output parser for standardizing extracted receipt data (e.g., vendor, total, tax, date) 4. **Transform extracted data** into a structured claim record (Code Node). 5. **Path 1**: Save records to a Google Sheet (one row per expense). 6. **Path 2**: - Format the employee + claim data into a dynamic **HTML email** - Use `Send Email` node to notify the finance department (e.g., `finance@yourcompany.com`) ## 📋 Requirements - n8n running with access to: - Google Drive API (for file uploads) - Google Sheets API (for logging expenses) - Email node (SMTP or Gmail for sending) - GPT-4.0 or equivalent LLM with document parsing ability - PDF invoices with clear formatting - Shared Google Sheet for claim tracking - Optional: Shared inbox for finance team ## © How to customize the workflow - **Add approval steps**: route the email to a manager before finance - **Attach original PDFs**: include uploaded files in the email as attachments - **Localize for other languages**: adapt form labels, email content, or parser prompts - **Sync to ERP or accounting system**: replace Google Sheet with QuickBooks, Xero, etc. - **Set limits/validation**: enforce max claim per trip or required fields before submission - **Auto-tag expenses**: add categories (e.g., travel, accommodation) for better reporting
n8n$14.99Automate Spotify Music Downloads to Google Drive with Logging in Google Sheets
This workflow automates the process of downloading Spotify tracks, storing them in Google Drive, and logging the details in Google Sheets. It streamlines music management for enthusiasts and content creators.
n8n$14.99Analyze Amazon Purchase Trends 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 analyzes purchase trends and consumer behavior patterns to identify market opportunities and optimize business strategies. It saves you time by eliminating the need to manually analyze sales data and provides insights into buying patterns, seasonal trends, and customer preferences. ## Overview This workflow automatically scrapes e-commerce platforms, marketplace data, and sales analytics to extract purchase trends, product popularity, and consumer behavior insights. It uses Bright Data to access sales data and AI to intelligently analyze purchasing patterns, seasonal trends, and market opportunities. ## Tools Used - **n8n**: The automation platform that orchestrates the workflow - **Bright Data**: For scraping e-commerce and marketplace platforms without being blocked - **OpenAI**: AI agent for intelligent purchase trend analysis and forecasting - **Google Sheets**: For storing purchase trend data and analysis results ## How to Install 1. **Import the Workflow**: Download the .json file and import it into your n8n instance. 2. **Configure Bright Data**: Add your Bright Data credentials to the MCP Client node. 3. **Set Up OpenAI**: Configure your OpenAI API credentials. 4. **Configure Google Sheets**: Connect your Google Sheets account and set up your trend analysis spreadsheet. 5. **Customize**: Define target marketplaces and trend analysis parameters. ## Use Cases - **E-commerce Strategy**: Identify trending products and market opportunities. - **Product Development**: Understand consumer preferences and demand patterns. - **Marketing Planning**: Optimize campaigns based on seasonal purchase trends. - **Business Intelligence**: Make data-driven decisions using market trend insights. ## 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 #purchasetrends #marketanalysis #brightdata #webscraping #ecommerce #n8nworkflow #workflow #nocode #trendanalysis #consumerinsights #marketresearch #salesanalytics #businessintelligence #markettrends #customerinsights #ecommerceanalysis #salesdata #marketforecasting #consumerdata #purchaseanalysis #retailanalytics #marketinsights #demandforecasting #salestrends #consumertrends #marketintelligence #buyingpatterns #marketdemand
n8n$9.99Automate Email Categorization and Telegram Alerts with AI and Google Sheets
This workflow automatically categorizes incoming emails using Azure OpenAI and sends relevant alerts via Telegram. It also logs email details in Google Sheets for easy tracking and follow-up.
n8n$14.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.99Convert Google Sheets to CSV and Share via Slack
Automatically convert Google Sheets data to a CSV file and share it in Slack when your bot is mentioned with a Google Sheets link.
n8n$4.99AI-Powered RAG Q&A Chatbot with OpenAI, Google Sheets, Glide, & Supabase
**Automate AI-Powered RAG System with Contextual Q&A, Google Sheets Integration, and Glide Frontend-Powered by n8n, OpenAI, Supabase, and Google Apps Script.** # Tools & Services Used - Glide (Frontend for user interactions) - Google Sheets (Stores questions and answers) - Google Apps Script (Forms + media upload handling) - OpenAI (Embeddings + GPT-4 to rank and generate answers) - Supabase (Optional for image hosting) - n8n (Automation logic and backend glue) # Workflow Overview ## This automation performs the following steps: - **Trigger**: Webhook receives a user question from a Glide frontend. - **Fetch Data**: Retrieves Q&A entries (and optionally, image URLs) from a connected Google Sheet. - **Rank Relevance**: - OpenAI Embeddings rank the relevance of stored questions to the new input. - Top matches are passed to a GPT-4 prompt for answer generation. - **Generate Answer**: - GPT-4 creates a contextual answer using the best match. - Optional: Includes media URL if attached to the matched answer. - **Response**: Sends the formatted answer back to Glide frontend (text + optional image). # Prerequisites ## Active accounts and API keys for: - OpenAI (API key with GPT-4 and embedding access) - Google Sheets (linked via Service Account or OAuth2 credentials) - Glide App (with a form to submit questions) - Supabase (optional, if hosting user-uploaded media) - n8n Self-hosted (for community nodes and webhook access) # How to Use This Template ## Step 1: Import the Template - Upload the provided JSON into your self-hosted n8n instance. - Requires installation of the Community Node: @n8n/n8n-nodes-openai-embeddings ## Step 2: Configure Credentials - **Webhook Trigger**: Replace the Glide webhook URL with your actual endpoint from your app. - **Google Sheets Node**: Set the spreadsheet ID and worksheet name to fetch your Q&A dataset. - **OpenAI Nodes**: - Insert your OpenAI API key. - Confirm that both text-embedding-ada-002 (or similar) and gpt-4 are available. - **Supabase or Apps Script (Optional)**: Ensure image links are correctly formed in the Sheet. ## Step 3: Customize Prompts and Thresholds - Update the OpenAI ranking prompt or similarity threshold in the Function or Code node. - Tailor GPT-4 prompts to return concise or detailed answers based on your use case. # Initial Test Run - Simulate a Question: - Trigger the Glide form with a sample question. - Check n8n logs for: - Matching score/ranking success - Correct retrieval from Sheets - GPT-4 answer generation - Image URL handling (if enabled) # Production Prep - Add error-handling nodes for cases when Sheets are empty or GPT-4 fails. - Set up logging via Google Sheets, Supabase, or external database. - Rate-limit or debounce requests from Glide if needed. # Use Cases - Customer Support Portals: Offer instant Q&A with your business data. - Internal Knowledgebase: Employees can query training manuals and SOPs. - AI Concierge: Combine structured answers with a friendly tone for guest interactions. # Disclaimer - Validate Glide form inputs before full deployment. - Ensure your OpenAI and Google Sheets usage stays within quota limits.
n8n$24.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