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 Thai Government Document Processing with OCR and Google Sheets
This workflow automates the extraction and storage of data from Thai government documents received via LINE or Google Drive using Mistral OCR and OpenAI, saving the results in Google Sheets.
n8n$14.99Automate AI-Driven Reservation Reminder Calls with Twilio and Google Sheets
Streamline your reservation reminder process by automating AI-generated calls using Twilio and Google Sheets. This workflow ensures timely reminders, reducing no-shows and saving staff time.
n8n$9.99Automate AI Avatar Video Creation with HeyGen and Google Sheets
Streamline your AI Avatar video production by integrating Google Sheets with HeyGen API for seamless video generation and storage.
n8n$9.99Competitor Price Monitoring with Web Scraping, Google Sheets & Telegram
## How it works Download the Google sheet here and replace this with the Google Sheets node: [Google Sheet](https://www.dropbox.com/scl/fi/zaif45nt9uzgz8mrhht9n/competitor_price_drop_automation.xlsx?rlkey=4vj3wz6gqp16dc2hh9hw5o49z&st=i23h513p&dl=1), upload to Google Sheets and replace in the Google Sheets node. - Scheduled trigger: Runs once a day at 8 AM (server time). - Fetch product list: Reads your "master" sheet (product_url + last known price) from Google Sheets. - Loop with delay: Iterates over each row (product) one at a time, inserting a short pause (20 s) between HTTP requests to avoid blocking. - Scrape current price: Loads each product_url, extracts the current price via a simple CSS selector. - Compare & normalize: Compares the newly scraped price against the "last_price" from your sheet, calculates percentage change, and tags items where price_changed == true. **On price change:** - Send alert: Formats a Telegram message ("Price Drop" or "Price Hike") and pushes it to your configured chat. - Log history: Appends a new row to a separate "price_tracking" tab with timestamp, old price, new price, and % change. - Update master sheet: After a 1 min pause, writes the updated current_price back to your "master" sheet so future runs use it as the new baseline. ## Set up step 1. Google Sheets credentials (~5 min) 2. Create a Google Sheets OAuth credential in n8n. 3. Copy your sheets ID and ensure you have two tabs: 4. product_data (columns: product_url, price) 5. price_tracking (columns: timestamp, product_url, last_price, current_price, price_diff_pct, price_changed) 6. Paste the sheet ID into both Google Sheets nodes ("Read" and "Append/Update"). 7. Telegram credentials (~5 min) 8. Create a Telegram Bot token via BotFather. 9. Copy your chat_id (for your target group or personal chat). 10. Add those credentials to n8n and drop them into the "Telegram" node. ## Workflow parameters (~5 min) - Verify the schedule in the Schedule Trigger node is set to 08:00 (or adjust to your preferred run time). - In the Loop Over Items node, confirm "Batch Size" is 1 (to process one URL at a time). - Adjust the Delay to avoid Request Blocking node if your site requires a longer pause (default is 20 s). - In the Parse Data From the HTML Page node, double-check the CSS selector matches how prices appear on your target site. - Once credentials are in place and your sheet tabs match the expected column names, the flow should be ready to activate. Total setup time is under 15 minutes—detailed notes are embedded as sticky comments throughout the workflow to help you tweak selectors, change timeouts, or adjust sheet names without digging into code.
n8n$14.99Automate End-of-Day Recruitment Rejection Emails Using Google Sheets and Gmail
Streamline your recruitment process by automatically sending personalized rejection emails to candidates at the end of each day using Google Sheets and Gmail. This workflow ensures timely communication while preventing duplicate sends.
n8n$9.99Automate AI-Enhanced Product Photography with Google Sheets and OpenAI
Transform standard product images into professional photography with AI by automating image analysis, prompt creation, and photo generation.
n8n$14.99Automate Personalized Cold Emails with Google Sheets and Google Gemini
Streamline your cold outreach by integrating Google Sheets with Google Gemini to automatically generate personalized emails. Enhance engagement and response rates with AI-driven email content tailored to each lead.
n8n$4.99Automate Google Sheets with AI-Powered Data Management and Calculations
Leverage AI to manage and calculate data in Google Sheets efficiently. Ideal for businesses and teams needing AI-driven insights and automation.
n8n$9.99Automate News Scraping and Storage with AI and Google Sheets
Streamline the process of collecting and storing news articles using AI-powered scraping and Google Sheets integration for efficient analysis and tracking.
n8n$4.99Personal Budget & Expense Tracker with Google Sheets and Alerts MCP
This template provides a set of MCP tools to manage personal budgets and expenses. This MCP tools can be integrated into any AI client that supports MCP integration. ## How it works - It stores transaction records and budget in Google Sheets. - It will give a warning if the expense is above budget. ## How to setup - Sign in with Google in Google Sheets nodes. - Copy the Google Sheets template (link available in the sticky note). - Target Google Sheets nodes to the right sheet. - Integrate with AI client. - Enjoy!
n8n$24.99Automate Job Listings with JSearch API and Google Sheets
Streamline your job curation process by automatically retrieving job search inputs from Google Sheets, querying the JSearch API for relevant listings, and updating the results back to the sheet. This workflow reduces manual data entry and ensures efficient job discovery.
n8n$9.99Automate Business Email Responses Using ChatGPT and Google Sheets
Streamline your business communication by automating email responses with the power of ChatGPT and Google Sheets. This workflow categorizes incoming emails and drafts personalized responses, saving time and enhancing customer interaction.
Make$4.99Automated Customer Support Chatbot for Webshops Using GPT-4 and Google Sheets
This workflow automates customer and sales support for webshops using a chatbot powered by GPT-4 and Google Sheets. It efficiently handles customer queries, checks product availability, places orders, and updates stock levels.
n8n$4.99Automate Backlink Data Transfer from Semrush to Google Sheets
Streamline your SEO workflow by automatically exporting backlink data from Semrush to Google Sheets using n8n and RapidAPI. This automation saves time and centralizes data for easy access and analysis.
n8n$9.99Convert Natural Language to Google Sheets SQL Queries Using OpenAI
This n8n workflow transforms natural language questions into SQL queries for Google Sheets using OpenAI's models, enabling efficient data retrieval and real-time analysis.
n8n$9.99Automate Instagram Lead Generation from Hashtags Using Apify and Google Sheets
Streamline the process of identifying and qualifying Instagram leads by automating hashtag-based searches. This workflow retrieves hashtags from Google Sheets, scrapes Instagram posts using Apify, analyzes post captions, and filters users based on follower count to generate qualified leads.
n8n$14.99Hotel Guest Journey Automation with Gmail & Google Sheets
**Automate your entire guest communication journey from booking to post-stay with personalized welcome emails, review requests, and daily operational reports.** Perfect for hotels, B&Bs, and short-term rental properties looking to enhance guest experience while reducing manual work and improving operational efficiency. ## How it works 1. **Pre-arrival welcome emails** - Automatically sends personalized welcome emails 1-2 days before guest check-in with reservation details, hotel amenities, and contact information. 2. **Post-stay review requests** - Sends automated review request emails 24 hours after checkout with Google Reviews links and return guest discount codes. 3. **Daily staff reports** - Generates comprehensive arrival/departure reports every morning at 6 AM for front desk, housekeeping, and management teams. 4. **Smart tracking** - Prevents duplicate emails by automatically updating tracking status in your Google Sheets database. 5. **Professional templates** - Uses responsive HTML email templates that work across all devices and email clients. ## Set up steps 1. **Connect Google Sheets** - Link your hotel reservation spreadsheet (must include columns for guest details, check-in/out dates, and email tracking). 2. **Configure Gmail account** - Set up Gmail credentials for sending automated emails. 3. **Customize hotel information** - Update hotel name, contact details, and branding in the Edit Fields nodes. 4. **Set staff email addresses** - Configure recipient addresses for daily operational reports. 5. **Adjust timing** - Modify schedule triggers if you want different timing for emails and reports (currently set to every 6 hours for guest emails and 6 AM daily for staff reports). **Time investment:** ~30 minutes for initial setup, then fully automated operation.
n8n$14.99Extract Contacts from Business Cards to Google Sheets with GP4O
# Auto Extract Contacts from Business Cards to Sheet With GP4o [](https://www.youtube.com/watch?v=2EWgC5UKiBQ) > This smart workflow extracts names, phone numbers, emails, and more from uploaded name card photos using AI, then logs them neatly into your Google Sheet. No typing. No mess. Just upload and go. ## Who's it for - Sales & Business Development Teams - Recruiters & Talent Acquisition Specialists - Event Teams collecting business cards - Admins who manage contact databases manually ## How it works / What it does This workflow automates the extraction of contact details from uploaded name card (business card) images and stores them in a structured Google Sheet for easy tracking and follow-up. ### Workflow Steps: 1. User uploads one or more name card images through a web form. 2. The uploaded files are saved to a Google Drive folder for archiving. 3. A smart AI agent (with OCR and GP capabilities) scans each image and extracts relevant contact data into structured JSON format. 4. Data is transformed, cleaned (e.g., removing `+` from phone numbers), and filtered. 5. Valid contacts are appended to a Google Sheet for central tracking and future use. ## How to set up 1. **Create a Form** - Allow file upload (JPG/PNG format). - Label it as “Name Card Uploader” with a clear description. 2. **Upload to Google Drive** - Use the Google Drive node to store uploaded images. 3. **Configure Smart Agent** - Use GP-4o or similar model with OCR capability. - Apply a structured output parser to extract contact fields like name, phone, email, company, etc. 4. **Transform Data** - Use the Code node to clean and structure contact info. - Strip out unwanted characters from phone numbers (e.g., `+`). 5. **Filter Invalid Records** - Remove entries with no meaningful contact data. 6. **Append to Google Sheets** - Use the Google Sheets node with Append Sheet Row. - Map fields to columns like Name, Phone, Email, etc. ## Requirements - n8n workflow environment - Google Drive integration (for file storage) - Google Sheets integration (for storing contacts) - GP-4o or any image-capable LLM - Clear name card images (PNG/JPG, readable text) - (Optional) Slack/email integration for notifications ## How to customize the workflow - **CRM Sync**: Connect to platforms like HubSpot, Salesforce, or Zoho. - **Validation Logic**: Ensure records contain key fields like name or email before writing. - **Uploader Info**: Attach submitter metadata to each contact record. - **Language Adaptation**: Adjust extracted field labels/output to target your preferred language. - **Batch Upload**: Handle multiple cards in a single image or multiple uploads in one go.
n8n$14.99Automate Website Sitemap and Visual Tree Creation with Firecrawl and Google Sheets
This workflow automates the generation of comprehensive sitemaps and visual tree structures from website URLs, organizing them in Google Sheets for easy analysis and further processing.
n8n$4.99Medical Records Automation with Mistral OCR & Google Sheets
This plug-and-play n8n workflow automates medical record digitization using Mistral's OCR API and stores clean, structured data in Google Sheets. Whether you run a clinic or a healthtech product, this no-code solution simplifies data entry from scanned or uploaded medical documents. - Works seamlessly on both self-hosted and cloud-based n8n environments. **Who is this for?** - Hospitals and private clinics - Healthtech platforms & startups - Medical admin and document processing teams - Clinical researchers and labs **What problem does it solve?** - Manual entry from printed forms - Unstructured, scattered records - Errors in data transcription - Inconsistent document storage This automation brings consistency, structure, and speed to the way you handle medical documents. **What this workflow does** - Captures uploaded documents through a public form - Uploads file to Mistral for OCR processing - Extracts clean text from each page (PDF or image) - Parses patient fields (Name, DOB, Diagnosis, Medications, etc.) - Saves records into a structured Google Sheet **Setup Instructions** **Step 1: Google Sheet Prep** Create a Google Sheet with these columns (case-sensitive): Name, Date of Birth, Patient ID, Date of Visit, Referring Physician, Department, Symptoms, Blood Pressure, Heart Rate, Temperature, Lab Results, Diagnosis, Medications, Next Appointment, Notes **Step 2: Mistral API Access** - Sign up at Mistral AI - Get your API key - Ensure your plan supports file upload & OCR endpoints **Step 3: Google OAuth Credentials (Self-hosted or Cloud)** Go to n8n → Settings → Credentials, and add: - Google Sheets OAuth2 - Scopes needed: https://www.googleapis.com/auth/spreadsheets **Step 4: Import Workflow** Go to Workflows > Import from File Upload your JSON file Replace: - Google Sheet document ID in the Google Sheets node - Your Mistral API key in HTTP Header Auth **Step 5: (Optional) Make Form Public** In Cloud-based n8n: - You can expose the form as a public page - Otherwise, connect it to your website form via webhook **Customization Tips** - Extract More Fields Update the Data cleaning node and extend the list of fields: const fields = [Name, Diagnosis, Medications, Symptoms, ...]; - Add EHR or Database Integration After Google Sheets, chain your custom system: - PostgreSQL - Airtable - Supabase - MongoDB - Change Output Format Want JSON or Markdown output for internal tools? Use the Set or Code node before the final output step. **Troubleshooting** Issue | Fix --- | --- File upload fails | Check Mistral API key and file type Google Sheets not updating | Verify credentials and document ID No data parsed | Check OCR quality; verify field labels in document Workflow not triggering | Ensure webhook or form is configured correctly **Self-Hosted vs Cloud Comparison** Feature | Self-Hosted | n8n Cloud --- | --- | --- Public Form Access | Manual setup | Built-in OAuth App Config | Required | Pre-configured Storage Limits | Depends on server | Included with plan Scalability | Fully customizable | Scales automatically **Getting Support** - n8n Docs - Mistral API Docs - n8n Community Or reach out to: David Olusola (dimejicole21@gmail.com) **Like this template?** Give it a star in the template library and help other no-code builders discover it. Turn scanned documents into structured data with zero code.
n8n$4.99Automatically Log Telegram Messages to Google Sheets
Capture and store every new message from a specified Telegram chat or channel into a Google Sheets spreadsheet as a new row, ensuring you never miss any important information.
Make$2.99Automate Cold Email Outreach with Gmail and Google Sheets
Streamline your cold email outreach by automating lead retrieval from Google Sheets, sending personalized emails via Gmail, and updating contact statuses to prevent duplicate outreach.
n8n$4.99Automate Glassdoor Job Searches with Bright Data and Google Sheets Integration
Streamline your job search process by automatically scraping Glassdoor job listings using Bright Data and storing the results in Google Sheets for easy analysis.
n8n$9.99Automate Task Reminders and Daily Recaps with Google Sheets and Slack
This workflow leverages Google Sheets and Slack to automate task reminders and daily recaps, enhancing productivity without additional costs.
n8n$9.99
More integrations
Need a custom Google Sheets workflow?
Our automation experts build tailored Google Sheets integrations for your exact stack.
Request a Custom Workflow