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 Receipt Processing with Google Vision OCR and Telegram to Google Sheets
Streamline your financial reporting by automatically extracting and organizing receipt data using Google Vision OCR and Telegram, with results saved to Google Sheets.
n8n$19.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.99Automated Cold Email Outreach with Gmail & Google Sheets
**Description:** Boost your sales pipeline with this fully automated Cold Email Outreach workflow in n8n, integrating Gmail and Google Sheets. This template sends cold emails daily at 2 PM to leads fetched from a Google Sheet. Once an email is sent, the workflow updates the lead's status to prevent duplicates. **Features:** - Daily scheduled trigger at 2 PM - Fetches leads with status not emailed from Google Sheets - Sends emails via Gmail - Updates lead status in Google Sheets post-email - Batch processing for efficient outreach Perfect for freelancers, agencies, and startups looking to automate lead engagement and track responses in real-time—all without writing a single line of code.
n8n$4.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.99Classify and Summarize WeChat Articles with GPT-4, Nano to Google Sheets, and Notion
## Who's it for ☀️ This template is perfect for content creators, marketers, and researchers managing WeChat public account articles! It's ideal for n8n newcomers or anyone wanting to save time on manual content analysis, especially if you use Google Sheets for tracking. Whether you're into AI, data analytics, or automation, this is for you! ➡️ ## How it works / What it does ⚙️ This workflow automates the retrieval, filtering, classification, and summarization of WeChat articles. It reads RSS feed links from a Google Sheet, filters articles from the last 10 days, cleans HTML content, classifies them as relevant or not, generates insightful Chinese summaries with AI, and saves results to Google Sheets and Notion. Outputs are Slack-formatted for team collaboration! ## How to set up 🛠️ 1. **Prepare Google Sheets**: Use your own documentId (replace the example) and set up sheets Save Initial Links (gid=198451233) and Save Processed Data (gid=1936091950). 2. **Configure Credentials**: Add Google Sheets and OpenAI API credentials—avoid hardcoding keys! 3. **Set RSS Feed**: Update the rss_feed_url in the RSS Read node with your WeChat RSS feed. 4. **Customize AI**: Tweak Relevance Classification and Basic LLM Chain prompts for your topics (e.g., data analytics, AI). 5. **Notion (Optional)**: Swap the databaseId (e.g., 22e79d55-2675-8055-a143-d55302c3c1b1) with your own. 6. **Run Workflow**: Trigger manually via the "Execute workflow" node. ## Requirements 📌 - n8n account with Google Sheets and OpenAI integrations. - Access to a WeChat public account RSS feed. - Basic JSON and node config knowledge. ## How to customize the workflow ⚒️ - **Topic Adjustment**: Update categories in Relevance Classification for new topics (e.g., technology, education). - **Summary Length**: Modify the LLM prompt in Basic LLM Chain to adjust length or style. - **Output Destination**: Add Slack or Email nodes for more outputs. - **Date Filter**: Change the IF (Filter by Date) condition (e.g., 7 days instead of 10). - **Scalability**: Use a Schedule Trigger node for automation.
n8n$14.99Automate PDF Document Creation and Distribution with Google Sheets and Gmail
This workflow automates the creation and distribution of personalized business documents in PDF format using data from Google Sheets. It integrates with CraftMyPDF for document generation, Google Drive for storage, and Gmail for email distribution.
n8n$9.99Automate TikTok Post Scraping by Keywords with Bright Data and Google Sheets
This workflow automates the process of scraping TikTok posts based on specific keywords using the Bright Data API and stores the extracted data in Google Sheets for easy analysis and monitoring.
n8n$9.99Automate Brazilian Company Data Enrichment with CNPJ API and Google Sheets
Enhance your Brazilian business databases by automatically fetching and updating CNPJ information from the MinhaReceita.org API into Google Sheets. Ideal for data analysts and sales teams needing comprehensive company data at scale.
n8n$9.99AI-Powered Information Monitoring with OpenAI, Google Sheets, Jina AI, and Slack
**Check Legal Regulations**: This workflow involves scraping, so ensure you comply with the legal regulations in your country before getting started. Better safe than sorry! ## Purpose This workflow enables **automated and AI-driven topic monitoring**, delivering **concise article summaries** directly to a **Slack channel** in a structured and easy-to-read format. It allows users to stay informed on specific topics of interest effortlessly, without manually checking multiple sources, ensuring a **time-efficient and focused** monitoring experience. **To get started, copy the Google Sheets template required for this workflow from [here](https://docs.google.com/spreadsheets/d/1F2FzWt9FMkA5V5i9d_hBJRahLDvxs3DQBOLkLYowXbY).** ## Target Audience This workflow is designed for: - **Industry professionals** looking to track key developments in their field. - **Research teams** who need up-to-date insights on specific topics. - **Companies** aiming to keep their teams informed with relevant content. ## How It Works 1. **Trigger:** A **Scheduler** initiates the workflow at regular intervals (default: every hour). 2. **Data Retrieval:** - RSS feeds are fetched using the **RSS Read** node. - Previously monitored articles are checked in **Google Sheets** to avoid duplicates. 3. **Content Processing:** - The article relevance is assessed using **OpenAI (GPT-4-mini)**. - Relevant articles are scraped using **Jina AI** to extract content. - Summaries are generated and formatted for Slack. 4. **Output:** - Summaries are posted to the specified Slack channel. - Article metadata is stored in **Google Sheets** for tracking. ## Key APIs and Nodes Used - **Scheduler Node:** Triggers the workflow periodically. - **RSS Read:** Fetches the latest articles from defined RSS feeds. - **Google Sheets:** Stores monitored articles and manages feed URLs. - **OpenAI API (GPT-4-mini):** Classifies article relevance and generates summaries. - **Jina AI API:** Extracts the full content of relevant articles. - **Slack API:** Posts formatted messages to Slack channels. --- This workflow provides an **efficient and intelligent way** to stay informed about your topics of interest, directly within Slack.
n8n$24.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.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.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.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 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.99Automate Calorie Logging from Food Images to Google Sheets via LINE and OpenAI
This workflow enables LINE users to send food images or text to a LINE bot, which then analyzes the images using OpenAI's Vision model to estimate calories and logs the results into Google Sheets.
n8n$14.99Automate Web Data Extraction Using Vision-Based AI with Google Sheets and ScrapingBee
Streamline your web scraping tasks with a vision-based AI agent that integrates with Google Sheets and ScrapingBee, enabling efficient data extraction from webpages.
n8n$14.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.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.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.99Extract Contacts from Business Cards to Google Sheets with GPT4O
# Auto Extract Contacts from Business Cards to Sheet With GPT-4o [](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 GPT-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) - GPT-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 AI-Driven Interviews with n8n and Google Sheets
Leverage n8n to automate interviews using AI agents and multi-page forms, capturing responses in Google Sheets for analysis.
n8n$19.99Generate Accessible Alt Text with Claude AI from Google Sheets to WordPress
# AI-powered alt text generation from Google Sheets to WordPress media ## Who's it for WordPress site owners, content managers, and accessibility advocates who need to efficiently add alt text descriptions to multiple images for better SEO and web accessibility compliance. ## What it does This workflow automates the process of generating and updating alt text for WordPress media files using AI analysis. It reads image URLs from a Google Sheet, analyzes each image with Claude AI to generate accessibility-compliant descriptions, updates the sheet with the generated alt text, and automatically applies the descriptions to the corresponding WordPress media files. The workflow includes error handling to skip unsupported media formats and continue processing. ## How it works - Input: Provide a Google Sheets URL containing image URLs and WordPress media IDs - Authentication: Retrieves WordPress credentials from a separate sheet and generates Base64 authentication - Processing: Loops through each image URL in the sheet - AI Analysis: Claude AI analyzes each image and generates concise, accessible alt text (max 125 characters) - Error Handling: Automatically skips unsupported media formats and continues with the next item - Update Sheet: Writes the generated alt text back to the Google Sheet - WordPress Update: Updates the WordPress media library with the new alt text via REST API ## Requirements - Google Sheets with image URLs and WordPress media IDs - WordPress site with Application Passwords enabled - Claude AI (Anthropic) API credentials - WordPress admin credentials stored in Google Sheets - Export Media URLs WordPress plugin for generating the media list ## How to set up ### Step 1: Export your WordPress media URLs - Install the Export Media URLs plugin on your WordPress site - Go to the plugin settings and check both ID and URL columns for export (these are mandatory for the workflow) - Export your media list to get the required data ### Step 2: Configure WordPress Application Passwords - Go to WordPress Admin → Users → Your Profile - Scroll down to the Application Passwords section - Enter application name (e.g., n8n API) - Click Add New Application Password - Copy the generated password immediately (it won't be shown again) ### Step 3: Set up Google Sheets [Duplicate this Google Sheets template](https://docs.google.com/spreadsheets/d/1BKGQRx_xDiuh3QD3ACOOJomsWFuPBjCHYMQX8UzBE/edit?usp=sharing) to get the correct structure. The template includes two sheets: Sheet 1: Export media - Paste your exported media data with columns: - ID (WordPress media ID) - URL (image URL) - Alt text (will be populated by the workflow) Sheet 2: Infos client - Add your WordPress credentials: - Admin Name: Your WordPress username - KEY: The application password you generated - Domain: Your site URL without https:// (format: example.com) ### Step 4: Configure API credentials - Add your Anthropic API credentials to the Claude node - Connect your Google Sheets account to the Google Sheets nodes ## How to customize - Language: The Claude prompt is in French - modify it in the Analyze image node for other languages - Alt text length: Adjust the 125-character limit in the Claude prompt - Batch processing: Change the batch size in the Split in Batches node - Error handling: The workflow automatically handles unsupported formats, but you can modify the error handling logic - Authentication: Customize for different WordPress authentication methods This workflow is perfect for managing accessibility compliance across large WordPress media libraries while maintaining consistent, AI-generated descriptions. It's built to be resilient and will continue processing even when encountering unsupported media formats.
n8n$9.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 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.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