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 Comprehensive Research with AI and Google Sheets
Streamline your research process by automating data collection from web, news, and academic sources, with AI-powered analysis and storage in Google Sheets.
n8n$14.99Schedule Food Photo Sharing to Pinterest with GP-3.5 Captions and Google Sheets
In this guide, we'll walk you through setting up an AI-driven workflow that automatically processes highly-rated food photos from a Google Sheet, generates AI-powered captions, shares them to Pinterest, and updates the sheet to reflect the posts. Ready to automate your food photo sharing? Let's dive in! ## What's the Goal? - Automatically detect and process highly-rated food photos (4 stars or above) from a Google Sheet. - Use AI to generate engaging and relevant captions. - Share the photos with captions to Pinterest via the Pinterest API. - Update the Google Sheet to mark photos as posted. - Enable scheduled automation for consistent posting. By the end, you'll have a self-running system that shares your best food photos effortlessly. ## Why Does It Matter? Manual photo sharing is time-consuming and inconsistent. Here's why this workflow is a game changer: - **Zero Human Error**: AI ensures consistent captions and posting accuracy. - **Time-Saving Automation**: Automatically handle photo sharing, boosting efficiency. - **Scheduled Posting**: Maintain a regular presence on Pinterest without manual effort. - **Focus on Creativity**: Free your team from repetitive posting tasks. Think of it as your tireless social media assistant that keeps your Pinterest feed vibrant. ## How It Works Here's the step-by-step magic behind the automation: ### Step 1: Trigger the Workflow - Detect new photos to post using the Daily Post Scheduler node (e.g., once daily). - Initiate the workflow at a scheduled time to check for new food photos. ### Step 2: Fetch Food Photos from Sheet - Retrieve rows from the Google Sheet that contain food photo metadata like image URLs, ratings, and status. ### Step 3: Filter 4+ Star Dishes - Filter only those food entries with high ratings (4 stars or above) and unposted status. ### Step 4: AI Caption Generator - Use AI (e.g., GPT/OpenAI) to create engaging and relevant captions for selected food photos. ### Step 5: Upload to Pinterest - Automatically post the food photo with the generated caption to Pinterest via the Pinterest API. ### Step 6: Mark as Posted in Sheet - Update the Google Sheet to reflect that the photo has been successfully shared. ## How to Use the Workflow? Importing a workflow in n8n is a straightforward process that allows you to use pre-built workflows to save time. Below is a step-by-step guide to importing the Automated Food Photo Sharing workflow in n8n. ### Steps to Import a Workflow in n8n 1. **Obtain the Workflow JSON** - **Source the Workflow**: Workflows are shared as JSON files or code snippets, e.g., from the n8n community, a colleague, or exported from another n8n instance. - **Format**: Ensure you have the workflow in JSON format, either as a file (e.g., workflow.json) or copied text. 2. **Access the n8n Workflow Editor** - Log in to n8n (via n8n Cloud or self-hosted instance). - Navigate to the Workflows tab in the n8n dashboard. - Click Add Workflow to create a blank workflow. 3. **Import the Workflow** - **Option 1: Import via JSON Code (Clipboard)**: - Click the three dots in the top-right corner to open the menu. - Select Import from Clipboard. - Paste the JSON code into the text box. - Click Import to load the workflow. - **Option 2: Import via JSON File**: - Click the three dots in the top-right corner. - Select Import from File. - Choose the .json file from your computer. - Click Open to import. ### Setup Notes - **Google Sheet Columns**: Ensure your Google Sheet includes the following columns: `Image URL`, `Rating` (numeric, e.g., 1-5), `Feedback` (text), `Pin Title`, `Pin Description`, `Destination URL`, `Board ID`, and `Status` (e.g., Pending or Posted). - **Google Sheets Credentials**: Configure OAuth2 settings in the Fetch Food Photos node with your Google Sheet ID and credentials. - **AI Model**: Set up the AI Caption Generator node with OpenAI credentials (e.g., API key). - **Pinterest API**: Authorize the Upload to Pinterest node with Pinterest API credentials (e.g., Bearer token) and obtain the Board ID. - **Scheduling**: Adjust the Daily Post Scheduler node to your preferred posting time (e.g., daily at 9 AM).
n8n$9.99Automate Google Sheets and Gmail Integration via Webhook
Streamline your data collection and communication processes with this Google Sheets and Gmail automation workflow.
Zapier$16.33Track YouTube Trends by Country and Language with RapidAPI and Google Sheets
Discover trending YouTube videos by country and language using this automated n8n workflow. This workflow utilizes the YouTube Trend Finder API and logs insights into Google Sheets, making it ideal for content creators, marketers, and researchers.
n8n$9.99Automate LinkedIn Profile Monitoring with Google Sheets and Slack Alerts
This workflow automates the monitoring of LinkedIn profile changes, sending Slack notifications and updating Google Sheets with the latest information. Ideal for sales teams, recruiters, and HR professionals to stay informed about network updates.
n8n$24.99Automate Y Combinator Startup Data Collection with Apify and Google Sheets
Streamline the process of collecting and organizing startup data from Y Combinator into Google Sheets using Apify. Ideal for sales teams, investors, and researchers.
n8n$9.99Create Dynamic Forms with Auto-Updating Dropdowns from Google Sheets
This workflow enables the creation of forms with dropdown fields that automatically update based on data from Google Sheets, ensuring your forms always reflect the latest information.
n8n$14.99Automate Lead Extraction from Gmail to Google Sheets with Slack Alerts
This workflow automates the extraction of business leads from Gmail, storing them in Google Sheets, and sending notifications via Slack. It filters emails to exclude personal and generic addresses, ensuring only potential leads are processed.
n8n$14.99Automate News Summarization and Email Delivery with OpenAI and Google Sheets
This workflow fetches top news headlines every 10 minutes, summarizes them using OpenAI's GPT-4o model, and sends a concise email digest to recipients listed in a Google Sheet. Ideal for staying informed with minimal effort.
n8n$4.99Automate Gmail Metadata Extraction to Google Sheets
Automatically extract and store metadata from new Gmail emails into Google Sheets for efficient record-keeping and workflow automation.
n8n$4.99Automate Restaurant Orders with AI Recommendations via Google Sheets and Telegram
Streamline restaurant order processing by automatically triggering workflows on new orders, extracting data from Google Sheets, using Gemini AI for dish recommendations, and sending personalized suggestions through Telegram.
n8n$14.99Automate AI-Powered Newsletter Drafts from Google Sheets to Notion
Transform Google Sheets entries into polished newsletter drafts in Notion using AI. This workflow automates the drafting process, leveraging GPT-3.5 for content creation and updating statuses in Google Sheets.
n8n$9.99Automate Twitter Profile Data Scraping and Google Sheets Integration
This n8n workflow automates the process of scraping Twitter profile data using the Bright Data API and stores the results in Google Sheets. Ideal for social media analytics, brand monitoring, and competitor research.
n8n$9.99Health Check Websites with Google Sheets & Telegram Alerts
## What does this template do? This workflow performs scheduled health checks on a list of URLs stored in a Google Sheet. Every X minutes, it retrieves the URLs, sends HTTP requests to check their availability, and notifies a Telegram chat if any request fails. You can easily replace Telegram with any other notification service supported by n8n, such as Slack, Discord, Email, or Microsoft Teams. ## Use Case Ideal for monitoring internal or external services, ensuring uptime and responsiveness. Integrate with your preferred messaging platform for real-time failure notifications without setting up complex infrastructure. ## What the Workflow Does - Triggers at regular intervals using **Schedule Trigger** - Reads URLs from a **Google Sheet** - Sends HTTP requests to check URL health - Sends failure alerts (including error code and URL) to **Telegram (or any service of your choice)** ## Apps & Services Used - Google Sheets - Telegram (or alternative notification service) - HTTP Request ## Pre-requisites - Telegram bot and chat ID (if using Telegram) - Connected Google Sheet with a `URLS` column ([template](https://docs.google.com/spreadsheets/d/17-tY9_wn-D2FV627Sx3-Z3abqFYvz794edej7es5J6w/edit?usp=sharing)) ## Customization Tips - Adjust the schedule interval in the trigger node - Replace Telegram with Slack, Email, Discord, or any other notification node - Customize alert messages with more context or formatting - Add filters, retries, or logging as needed
n8n$4.99Automate AI-Driven Reddit Engagement with Google Sheets Tracking
This workflow automates Reddit engagement by monitoring posts, analyzing content with OpenAI, and responding intelligently. It tracks interactions in Google Sheets for transparency and ensures relevance and value in community participation.
n8n$14.99Extract and Structure Hair Documents to Google Sheets using Typhoon OCR and Llama 3.1
 **Note:** This template requires a community node and works **only on self-hosted** n8n installations. It uses the Typhoon OCR Python package and custom command execution. Make sure to install required dependencies locally. --- ## Who is this for? This template is for developers, operations teams, and automation builders in Thailand (or any Thai-speaking environment) who regularly process PDFs or scanned documents in Thai and want to extract structured text into a Google Sheet. ### It is ideal for: * Local government document processing * Thai-language enterprise paperwork * AI automation pipelines requiring Thai OCR --- ## What problem does this solve? Typhoon OCR is one of the most accurate OCR tools for Thai text. However, integrating it into an end-to-end workflow usually requires manual scripting and data wrangling. ### This template solves that by: * Running Typhoon OCR on PDF files * Using AI to extract structured data fields * Automatically storing results in Google Sheets --- ## What this workflow does 1. **Trigger**: Run manually or from any automation source 2. **Read Files**: Load local PDF files from a `doc/` folder 3. **Execute Command**: Run Typhoon OCR on each file using a Python command 4. **LLM Extraction**: Send the OCR markdown to an AI model (e.g., GPT-4 or OpenRouter) to extract fields 5. **Code Node**: Parse the LLM output as JSON 6. **Google Sheets**: Append structured data into a spreadsheet --- ## Setup ### 1. **Install Requirements** * Python 3.10+ * `typhoon-ocr`: `pip install typhoon-ocr` * Install [Poppler](https://github.com/oschwartz10612/poppler-windows/releases/) and add to system PATH (needed for `pdftoppm`, `pdfinfo`) ### 2. **Create folders** * Create a folder called `doc` in the same directory where n8n runs (or mount it via Docker) ### 3. **Google Sheet** Create a Google Sheet with the following column headers: | book_id | date | subject | detail | signed_by | signed_by2 | contact | download_url | | -------- | ---- | ------- | ------ | ---------- | ----------- | ------- | ------------- | You can use this [example Google Sheet](https://docs.google.com/spreadsheets/d/1h70cJyLj5i2j0Ag5kqp93ccZjjhJnqpLmz-ee5r4brU) as a reference. ### 4. **API Key** Export your `TYPHOON_OCR_API_KEY` and `OPENAI_API_KEY` in your environment (or set inside the command string in `Execute Command` node). --- ## How to customize this workflow * Replace the LLM provider in the `Basic LLM Chain` node (currently supports OpenRouter) * Change output fields to match your data structure (adjust the prompt and Google Sheet headers) * Add trigger nodes (e.g., Dropbox Upload, Webhook) to automate input --- ## About Typhoon OCR [Typhoon](https://docs.opentyphoon.ai/en/) is a multilingual LLM and toolkit optimized for Thai NLP. It includes `typhoon-ocr`, a Python OCR library designed for Thai-centric documents. It is open-source, highly accurate, and works well in automation pipelines. Perfect for government paperwork, PDF reports, and multilingual documents in Southeast Asia. ---
n8n$4.99Conversational Lead Capture with Gemini 2.0, Flash AI, and Google Sheets
## AI Lead Capture System - Complete Setup Guide ## Prerequisites - n8n instance (cloud or self-hosted) - Google AI Studio account (free tier available) - Google account for Sheets integration - Website with chat widget capability ## Phase 1: Core Infrastructure Setup **Step 1: Set Up Google AI Studio** - Go to Google AI Studio - Create an account or sign in with Google - Navigate to Get API Key - Create a new API key for your project - Copy and securely store the API key - Free tier limits: 15 requests/minute, 1 million tokens/month **Step 2: Configure Google Sheets** - Create a new Google Sheet for lead storage - Add column headers (exact names): - Full Name - Company Name - Email Address - Phone Number - Project Intent/Needs - Project Timeline - Budget Range - Preferred Communication Channel - How they heard about DAEX AI - Copy the Google Sheet ID from URL (between /d/ and /edit) - Ensure the sheet is accessible to your Google account **Step 3: Import n8n Workflow** - Open your n8n instance - Create a new workflow - Click ... menu → Import from JSON - Paste the provided workflow JSON - Workflow will appear with all nodes connected ## Phase 2: Credential Configuration **Step 4: Set Up Google Gemini API** - In n8n, go to Credentials → Add Credential - Search for Google PaLM API - Enter your API key from Step 1 - Test connection - Link to the Google Gemini Chat Model node **Step 5: Configure Google Sheets Access** - Go to Credentials → Add Credential - Select Google Sheets OAuth2 API - Follow OAuth flow to authorize your Google account - Test connection with your sheet - Link to the Google Sheets node ## Phase 3: Workflow Customization **Step 6: Update Company Information** - Open the AI Agent node - In the system message, replace all mentions of: - Company name and description - Service offerings and specializations - FAQ knowledge base - Typical project timelines and pricing ranges - Adjust conversation tone to match your brand voice **Step 7: Configure Lead Qualification Fields** - In the AI Agent system message, modify the required information list: - Add/remove qualification questions - Adjust budget ranges for your services - Customize timeline options - Update communication channel preferences - In Google Sheets node, update column mappings if you changed fields **Step 8: Set Up Sheet Integration** - Open Google Sheets node - Click on Document ID dropdown - Select your lead capture sheet - Verify all column mappings match your sheet headers - Test with sample data ## Phase 4: Website Integration **Step 9: Get Webhook URL** - Open Webhook node in n8n - Copy the webhook URL (starts with your n8n domain) - Note: URL format is https://your-n8n-domain.com/webhook/[unique-id] **Step 10: Connect Your Chat Widget** Choose your integration method: Option A: Direct JavaScript Integration ```javascript // Add to your website function sendMessage(message, sessionId) { fetch(YOUR_WEBHOOK_URL, { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ message: message, sessionId: sessionId || 'visitor-' + Date.now() }) }) .then(response => response.json()) .then(data => { // Display AI response in your chat widget displayMessage(data.message); }); } ``` Option B: Chat Platform Webhook - Open your chat platform settings (Intercom, Crisp, etc.) - Find the webhook/integration section - Add webhook URL pointing to your n8n endpoint - Configure to send message and session data Option C: Zapier/Make.com Integration - Create a new Zap/Scenario - Trigger: New chat message from your platform - Action: HTTP POST to your n8n webhook - Map message content and session ID ## Phase 5: Testing & Optimization **Step 11: Test Complete Flow** - Send a test message through your chat widget - Verify AI responds appropriately - Check conversation context is maintained - Confirm lead data appears in Google Sheets - Test with various conversation scenarios **Step 12: Monitor Performance** - Check n8n execution logs for errors - Monitor Google Sheets for data quality - Review conversation logs for improvement opportunities - Track response times and conversion rates **Step 13: Fine-tune Conversations** - Analyze real conversation logs - Update system prompts based on common questions - Add new FAQ knowledge to the AI agent - Adjust qualification questions based on lead quality - Optimize for your specific customer patterns ## Phase 6: Advanced Features (Optional) **Step 14: Add Lead Scoring** - Create a new column in Google Sheets for Lead Score - Update AI agent to calculate scores based on: - Budget range (higher budget = higher score) - Timeline urgency (sooner = higher score) - Project complexity (complex = higher score) - Add conditional formatting in Google Sheets to highlight high-value leads **Step 15: Set Up Notifications** - Add an email notification node after Google Sheets - Configure to send alerts for high-priority leads - Include lead details and conversation summary - Set up different notification rules for different lead scores **Step 16: Analytics Dashboard** - Connect Google Sheets to Google Data Studio
n8n$9.99Automatically Track New YouTube Videos and Save to Google Sheets
Efficiently monitor new YouTube videos based on custom search criteria and automatically log the details into Google Sheets. This workflow ensures you stay updated with the latest content relevant to your interests.
Make$2.99Generate Language Learning Flashcards with GPT-4, Telegram, and Google Sheets for Anki
## How it works - Use Telegram to send in new phrases (`flashcard front`) - You can also manually input phrases in the workflow itself - ChatGPT generates a provided phrase description (in English, but you can change it) including multiple meanings & generates examples of using the phrase in a sample sentence (`flashcard back`) ## Steps to setup - Provide your Telegram bot API key (optional) - Provide your OpenAI key - Provide Google Sheets credentials ## How to import flashcards from Google Sheets into Anki - Use the Google Sheets to Anki add-on: [1871608121](https://ankiweb.net/shared/info/1871608121) - In Anki, simply click `Sync Decks` and you're done :) Enjoy
n8n$9.99Automate File URL Retrieval via LINE Bot and Google Sheets with AI
This workflow uses a LINE Bot to process natural language queries, extract filenames with AI, and retrieve corresponding Google Drive URLs from Google Sheets.
n8n$4.99Automate AWS EC2 Instance Launch from Google Sheets
This n8n workflow automates the process of launching AWS EC2 instances based on data specified in a Google Sheets document. It extracts instance details, validates inputs, launches the instance via AWS API, updates the sheet with instance information, and sends confirmation emails.
n8n$4.99Automate Daily Real Estate Deal Alerts with Zillow, Google Sheets, and Gmail
This workflow automates the process of finding real estate deals, calculating investment metrics, and sending daily email alerts. It utilizes Zillow API for up-to-date listings and Google Sheets for data tracking.
n8n$9.99Automate AI Upwork Proposal Generation with Apify, Google Sheets & Gemini
## Disclaimer Community nodes are used, and the template can only be used on self-hosted n8n instances.  ## This n8n template from [Intuz](https://www.intuz.com/) provides a complete and automated solution for finding relevant Upwork jobs and generating highly-personalized, knowledge-base-driven proposals using AI. This workflow acts as an autonomous agent, handling everything from job discovery to drafting the final proposal text, ready for you to review and submit. ## Who's this workflow for? - Freelancers & Consultants - Digital Agencies - Business Development Teams - Sales Professionals ## How it works **1. Scrape Upwork for New Jobs**: The workflow starts by running an Apify actor to scrape Upwork based on your defined criteria (keywords, categories, payment verification, etc.). **2. Log Jobs to Google Sheets:** The newly found job opportunities are automatically saved as new rows in a Google Sheet, creating a central dashboard for tracking. A notification is sent confirming the new jobs found. **3. Trigger AI Proposal Generation:** The workflow then reads the new jobs from the sheet and, for each one that hasn't been applied for, triggers the AI. **4. Craft a Knowledge-Based Proposal:** It sends the job details to a Google Gemini AI model. The AI uses a detailed, built-in Company Knowledge Base (which you can customize) to write a comprehensive and relevant proposal. It addresses client questions, highlights relevant experience, and suggests a timeline. **5. Save the Proposal Draft:** The AI-generated proposal is saved back into the Google Sheet in the corresponding job row. **6. Final Notification:** A final email is sent to notify you that the proposals are ready, including a link to the sheet for final review and submission on Upwork. ## Setup Instructions **1. Apify Configuration:** - In the "Run Upwork Actor..." node, connect your Apify account. - We have used this Apify scraper- [Upwork Extractor](https://apify.com/jupri/upwork) - In the Custom Body field, customize the search parameters (like category, search.any keywords) to match the jobs you are looking for. **2. Google Gemini AI Configuration:** - In the Google Gemini Chat Model node, connect your Google Gemini (PaLM) API account. - Crucially: In the Proposal Crafting node, edit the prompt to replace the Company Knowledge Base with your own company's details, services, and project examples. This is essential for personalizing the proposals. **3. Google Sheets Setup:** - Connect your Google Sheets account. - In all three Google Sheets nodes, select your credentials and update the Document ID and Sheet Name to point to your Upwork tracking sheet. **4. Gmail Configuration:** - In both Gmail nodes, connect your account and update the sending email address to your own. **5. Execute the Workflow:** - Click "Execute workflow" to run the entire job scraping and proposal generation process. ## Key Requirements to Use This Template - n8n Instance: An active n8n account (Cloud or self-hosted). - Apify Account: An active Apify account with an API key and sufficient credits/subscription to run the Upwork Extractor actor. - Google Account & Sheet: A pre-made Google Sheet with columns for Title, URL, Description, Skills, Questions, Applied, and Proposal Template. - Google Gemini AI Account: A Google Cloud account with the Vertex AI API (for Gemini models) enabled and an associated API Key. - Gmail Account: A Gmail account to send and receive notifications about the workflow's progress. ## Connect with us - Website: https://www.intuz.com/services - Email: getstarted@intuz.com - LinkedIn: https://www.linkedin.com/company/intuz - Get Started: https://n8n.partnerlinks.io/intuz ## For Custom Workflow Automation Click here- [Get Started](https://www.intuz.com/get-started)
n8n$14.99Automate YouTube Video Summarization with Google Sheets and AI
Effortlessly convert YouTube videos into concise summaries using Google Sheets, Supadata.ai, and DeepSeek AI. Ideal for content creators, researchers, and educators.
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