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 E-commerce Platform Detection with Google Sheets
This n8n workflow automates the detection of e-commerce platforms, frameworks, and payment gateways by analyzing website data. It updates Google Sheets with structured results, aiding in lead generation, competitive analysis, and market research.
n8n$9.99Conduct AI-Enhanced Product Satisfaction Surveys via Telegram and Google Sheets
This workflow automates product satisfaction surveys using a Telegram chatbot to gather responses, which are then stored in Google Sheets. It leverages AI to ask follow-up questions, enhancing user engagement and insights.
n8n$24.99Automate Upwork Job Listings to Google Sheets
Streamline your freelance job search by automatically scraping Upwork job listings and logging them into Google Sheets for easy tracking and analysis.
n8n$4.99Automate Cold Lead Re-Engagement with AI, Outlook, and Google Sheets
This n8n workflow automates the re-engagement of cold leads by summarizing past emails and generating personalized outreach using OpenAI. It integrates with Google Sheets to pull contacts, fetches prior communications from Outlook, and drafts re-engagement emails for review.
n8n$9.99Automate 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.99Automate Solar Energy Monitoring and Alerts with Gmail, Google Sheets, and Slack
This workflow automates the monitoring of solar energy production every 2 hours, sending alerts via Gmail if output falls below a set threshold, logging data in Google Sheets, and posting daily summaries to Slack.
n8n$9.99Auto-Generate Instagram Content Schedule with GPT-4, Apify, and Google Sheets
## Try It Out! ### This n8n template creates a fully automated Instagram content schedule using AI and Google Sheets. It is perfect for content creators, marketing teams, or local businesses looking to organize and scale their social media posting. ### How it works The workflow starts by reading two sets of inputs from a Google Sheet: - Your content strategy inputs (Pillar, Objective, Frequency, Format, Structure, Examples). - A list of scraped blog posts with title, URL, and description (fetched from your website). - Blog posts are scraped using Apify and parsed to extract key fields, which are stored in a tab labeled Input (blog month). - You can assign a preferred posting month for each blog (e.g., fall blog posts get tagged for September). - The workflow then merges both inputs and extracts the relevant information for further information added by ChatGPT. ### AI Scheduling & Personalization Once merged, the workflow loops through each content item and: - Identifies if the scheduled post falls on or near a holiday (like Mother's Day) and adjusts the content accordingly. - A reference tool is attached to guide structure and tone, based on a library of post examples. - Sends the content to an AI Agent (using GPT-4, but customizable) that generates: 1. A compelling Instagram caption 2. A visual description 3. Hashtags 4. Suggested post date, day, content pillar, and format (carousel, reel, image, etc.) ### Output - All generated content including captions, structure, dates, hashtags, and pillar is exported into a tab titled Output in your Google Sheet. - The final schedule is ready for manual review, editing, or publishing to social media. ### How to use - The workflow uses a manual trigger to start, but you can replace it with a Webhook, cron job, or form submission. - Add/edit your content strategy in Google Sheets. ### How to Set-Up #### Initial Input Tab - Define your content pillars and structure - Create a tab named Input or Strategy Include these columns: - Pillar: e.g., Family images - Objective: e.g., Showcase images - Frequency: e.g., Bi-weekly - Content Form: e.g., Images, Reels - Structure: brief description of expected layout (e.g., carousel Q&A, singular photo) - Examples: prompts or questions to guide AI (e.g., Why do you think families should do a session?) #### Input (blog month) Tab - Store scraped blog content Include these columns: - URL: direct link to blog post - Title: blog post title - Description: short summary of the post - Preferred Month: month you want it posted (e.g., August, September) - This sheet is partially auto-filled by the workflow (except for Preferred Month) #### Output Tab - Final scheduled content Include these columns: - Date: scheduled posting date (YYYY-MM-DD) - Day: day of the week - Pillar: content category assigned - Format: e.g., Images, Reels, Carousel - Description: visual summary - Caption: Instagram-ready caption - Hashtags: complete hashtag block ### To use the Apify HTTP Request node: 1. Drag in an HTTP Request node into your n8n workflow. 2. Set the Method and URL based on how you're using Apify: - Use POST if you want to run an actor live with dynamic input (e.g., scrape blog posts in real time). - Use GET if you want to retrieve results from a completed or static dataset run (faster and cheaper if you're reusing previous data). 3. Configure query or body parameters. 4. Include your Apify API token for authentication (e.g., token=YOUR_API_KEY) - For POST: include an input object with any required actor settings (e.g., blog URL to scrape). - For GET: specify the dataset ID in the URL. 5. Test the node to ensure you're retrieving the blog titles, descriptions, and URLs as expected. ### Requirements - Apify account for scraping blog posts - OpenAI key (e.g., GPT-4) or another model of your choice - Google Sheets Credentials ### Example Use Cases - A photographer repurposing blogs into Instagram carousels - A nonprofit automatically generating seasonal posts - A small team managing multi-pillar content across weeks or months ### Need Help? Join the n8n Discord or ask in the n8n Forum! Happy Content Making!
n8n$14.99Automate Export of Google Search Console Data to Google Sheets
This workflow automates the extraction of data from Google Search Console and exports it to Google Sheets for easy visualization and analysis, streamlining SEO tasks.
n8n$14.99Live Airport Delay Dashboard with FlightStats, Google Sheets, & Slack Alerts
# Live Airport Delay Dashboard with FlightStats & Team Alerts ## Description - Automates live monitoring of airport delays using FlightStats API. - Stores and displays delay data, with Slack alerts for severe delays to operations/sales teams. ## Essential Information - Runs on a scheduled trigger (e.g., hourly or daily). - Fetches real-time delay data from FlightStats API. - Stores data in Google Sheets and alerts teams via Slack for severe delays. ## System Architecture - **Delay Monitoring Pipeline**: - **Set Schedule**: Triggers the workflow hourly or daily via Cron. - **FlightStats API**: Retrieves live airport delay data. - **Data Management Flow**: - **Set Output Data**: Prepares data for storage or display. - **Merge API Data**: Combines and processes delay data. - **Alert and Display**: - **Send Response via Slack**: Alerts ops/sales for severe delays. - **No Action for Minor Delays**: Skips minor delays with no action. ## Implementation Guide - Import the workflow JSON into n8n. - Configure Cron node for desired schedule (e.g., every 1 hr). - Set up FlightStats API credentials and endpoint (e.g., https://api.flightstats.com). - Configure Google Sheets or Notion for data storage/display. - Test with a sample API call and verify Slack alerts. - Adjust delay severity thresholds as needed. ## Technical Dependencies - Cron service for scheduling. - FlightStats API for real-time delay data. - Google Sheets API or Notion API for data storage/display. - Slack API for team notifications. - n8n for workflow automation. ## Database & Sheet Structure - **Delay Tracking Sheet** (e.g., AirportDelays): - Columns: `airport_code`, `delay_status`, `delay_minutes`, `timestamp`, `alert_sent` - Example: `JFK`, `Severe`, `120`, `2025-07-29 20:28:00Z`, `Yes` ## Customization Possibilities - Adjust Cron schedule for different frequencies (e.g., every 30 min). - Modify FlightStats API parameters to track specific airports. - Customize Slack alert messages in the `Send Response via Slack` node. - Integrate with a dashboard tool (e.g., Google Data Studio) for live display. - Add email alerts for additional notification channels.
n8n$4.99Automate WhatsApp Bulk Messaging from Google Sheets with Wasender API
Streamline your communication by automatically sending bulk WhatsApp messages from Google Sheets using the Wasender API. Ideal for marketers and small businesses seeking a cost-effective solution.
n8n$4.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 YouTube Trend Analysis and Data Collection in Google Sheets
Effortlessly track trending YouTube videos in your niche and compile essential data into Google Sheets for comprehensive analysis. Perfect for content creators and marketers.
Make$2.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 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 SEO Backlink Discovery and Outreach with AI and Google Sheets
This workflow automates the discovery and analysis of SEO backlinks using AI, categorizes them, and manages outreach campaigns through Google Sheets.
n8n$14.99Automate Event Registration & Follow-Ups with Gmail Reminders & Google Sheets
## How it works **Simplified registration**: Automatically captures sign-ups via optimized web forms. **Instant confirmations**: Immediately sends confirmation emails with event details and calendar invites. **Scheduled reminders**: Automatic reminder sequence before the event to maximize attendance. **Post-event follow-up**: Automatically collects feedback and nurtures participants. --- ## Set up steps 1. **Registration form**: Create or connect your event registration form. 2. **Calendar system**: Integrate with Google Calendar or Outlook to manage time slots. 3. **Email service**: Set up your sending platform (Gmail, SendGrid, Mailchimp). 4. **CRM integration**: Sync with your CRM for participant tracking. 5. **Feedback survey**: Prepare your post-event satisfaction questionnaire. 6. **Personalized sequences**: Tailor messages based on event type. --- ## Key Features **Optimized registration**: Responsive forms with real-time validation **Automatic calendar management**: Instantly adds to calendars and manages time slots **Smart reminders**: Progressive sequence (D-7, D-1, H-2) with personalized content **Complete tracking**: Monitors sign-ups, attendance, and participation rates **Multi-event support**: Manage multiple events and formats simultaneously **Mobile notifications**: Push alerts and SMS for urgent reminders **Automatic feedback**: Collects and analyzes participant feedback automatically **Detailed analytics**: Performance reports and improvement insights --- ## Supported Event Types - **Webinars**: Online sessions with auto-generated access links - **Conferences**: In-person events with seat and logistics management - **Trainings**: Learning sessions with progress tracking - **Meetings**: Internal meetings with invite coordination - **Workshops**: Practical sessions with materials and prerequisites --- ## Automated Sequence 1. **Sign-up** Immediate confirmation + calendar invitation 2. **D-7** Reminder email with detailed program 3. **D-1** Final reminder with practical info 4. **H-2** Last-minute notification with access links/details 5. **Post-event** Satisfaction survey + additional content
n8n$9.99Automate Competitor Backlink Analysis with Bright Data and Google Sheets
This workflow automates the extraction and analysis of competitor backlink data using Bright Data and OpenAI, storing the results in Google Sheets for easy access and further analysis.
n8n$14.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.33Automate Sentiment Analysis and Visualization of Google Sheets Reviews
Streamline your feedback process by automatically analyzing customer reviews from Google Sheets, categorizing sentiments, and visualizing the results with a chart sent via Gmail.
n8n$9.99Automate Daily Email Reminders from Google Sheets Using Gmail
Streamline your daily communication by automatically sending email reminders from Google Sheets using Gmail and n8n. Ideal for teams and businesses needing timely updates.
n8n$4.99Automate Domain Traffic Enrichment with SimilarWeb and Google Sheets
Automatically enhance your domain list in Google Sheets with traffic analytics from SimilarWeb, and optionally export the enriched data to Airtable for further analysis.
n8n$9.99Automate Background Removal for WooCommerce Product Images Using Google Sheets and BackgroundCut API
Streamline your eCommerce operations by automatically removing backgrounds from WooCommerce product images using the BackgroundCut API, updating images in WooCommerce and Google Sheets efficiently.
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.99Generate Business Leads with OpenStreetMap Data and Save to Google Sheets
## Who is this template for? This n8n lead generation workflow template is designed for business owners, marketers, sales professionals, and entrepreneurs who need to generate targeted business leads without paying for expensive APIs or third-party services. The template leverages the free Overpass API (powered by OpenStreetMap data) to gather comprehensive business information for any industry in almost any region worldwide. Perfect for: - Small businesses looking to expand their customer base - Real estate agents seeking potential clients - Marketing agencies needing targeted lead lists - Entrepreneurs researching potential markets - Sales teams building prospect databases You can watch the video tutorial here: https://youtu.be/6WVfAIXdwsE ## How it works This n8n lead generation template provides a powerful solution using n8n core nodes and the free OpenStreetMap Overpass API, allowing you to generate thousands of business leads with comprehensive contact information: ### Data Collection Process **1. Define Your Queries** - Create a list of search queries combining keywords (like real estate, dentist, etc.) with target locations - Use both inner areas (specific cities) and outer areas (broader regions) to precisely target your search **2. Iterative Query Execution** - The workflow processes each query in sequence, preventing API timeout issues - Each query triggers a sub-workflow that handles the data extraction process **3. Data Extraction via OpenStreetMaps Overpass API** - Searches for businesses matching your keywords in name, description, and relevant OpenStreetMap tags - Collects comprehensive business data including names, addresses, and contact details from the OpenStreetMap database - Searches using both regular expressions and exact tag matching for optimal n8n lead generation results **4. Website Scraping for Additional Information** - For businesses with websites but missing email addresses, the workflow visits their homepage - Extracts email addresses using regular expressions for more complete contact information - Filters out irrelevant emails using configurable patterns **5. Data Cleaning and Organization** - Removes duplicate contact information and standardizes data format - Filters results based on your specific requirements for contact details - Saves all extracted data to Google Sheets for easy access and management ## Setup **1. Configure Your Queries:** - Open the Run Workflow node and input your list of queries - Format queries with outer area, inner area, and keyword (e.g., California, Los Angeles, real estate) **2. Optimize Targeting:** - After initial runs, identify the specific tags used by your target industry - Update the HTTP Request node with these specific tags to improve result quality - Common tags include office, shop, and amenity with industry-specific values **3. Configure Data Filters:** - Customize the filter node to keep only results meeting your specific requirements - Adjust the email filtering regex to remove irrelevant email addresses **4. Set up Google Sheets Integration:** - Configure the Google Sheets node to save results to your preferred spreadsheet - Authorize the connection to your Google account **5. Run the Workflow:** - Start the workflow and watch as your Google Sheet fills with comprehensive business leads - The template automatically handles pagination and rate limiting to prevent API timeouts The resulting leads include comprehensive contact information such as: - Business names - Complete addresses (street, city, postal code) - Phone numbers - Email addresses (both from API and website scraping) - Website URLs - Social media accounts - Opening hours - And more!
n8n$14.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