4,580 n8n Google Sheets workflow templates

The Google Sheets node reads ranges, appends rows and updates cells through the Sheets API, which makes a spreadsheet the simplest durable store an n8n workflow can use — nothing to provision, and the data stays inspectable by hand. The templates below use it at both ends: as the trigger that fires when a row is added or changed, and as the sink that records whatever the rest of the workflow produced. Each entry keeps its author and node count, so the setup cost is visible before you import it.

• Generate AI Viral Videos with Seedance and Upload to TikTok, YouTube & Instagram

  by Dr. Firas · web · 214,907 clicks

  Generate AI videos with Seedance & Blotato, upload to TikTok, YouTube & Instagram Who is this for? This template is ideal for creators, content marketers, social media managers, and AI enthusiasts who want to automate the production of short-form, visually captivating videos for platforms like TikTok, YouTube Shorts, and Instagram Reels — all without manual editing or publishing. What problem is this workflow solving? Creating engaging videos requires: Generating creative ideas Writing detailed scene prompts Producing realistic video clips and sound effects Editing and stitching the final video Publishing across multiple platforms This workflow automates the entire process, saving hours of manual work and ensuring consistent, AI-driven content output ready for social distribution. What this workflow does This end-to-end AI video automation workflow: Generates a creative idea using OpenAI and LangChain Creates detailed video prompts with Seedance AI Generates video clips via Wavespeed AI Generates sound effects with Fal AI Stitches the final video using Fal AI’s ffmpeg API Logs metadata and video links to Google Sheets Uploads the video to Blotato Auto-publishes to TikTok, YouTube, Instagram, and other platforms Setup Add your OpenAI API key in the LLM nodes Set up Seedance and Wavespeed AI credentials for video prompt and clip generation Add your Fal AI API key for sound and stitching steps Connect your Google Sheets account for tracking ideas and outputs Set your Blotato API key and fill in the platform account IDs in the Assign Social Media IDs node Adjust the Schedule Trigger to control when the automation runs How to customize this workflow to your needs Change the AI prompts** to target your niche (e.g., ASMR, product videos, humor) Add a Telegram or Slack step** for video preview before publishing Tweak scene structure** or video duration to match your style Disable platforms** you don’t want by turning off specific HTTP Request nodes Edit the sound generation prompts** for different moods or effects 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube. An n8n automation workflow template by Dr. Firas.

  • 7 nodes
  • 214,907 views

  Workflow detailsImport from n8n.ioAutomation, AI

• Fully Automated AI Video Generation & Multi-Platform Publishing

  by Juan Carlos Cavero Gracia · web · 191,045 clicks

  Description This comprehensive n8n automation template orchestrates a complete end-to-end workflow for generating engaging short-form Point-of-View (POV) style videos using multiple AI services and automatically publishing them across major social media platforms. It takes ideas from a Google Sheet and transforms them into finished videos with captions, voiceovers, and platform-specific descriptions, ready for distribution. Who Is This For? Content Creators & Agencies:** Mass-produce unique short-form video content for various clients or channels with minimal manual effort. Digital Marketers:** Automate video content pipelines to boost online presence and engagement across multiple platforms simultaneously. Social Media Managers:** Schedule and distribute consistent video content efficiently without juggling multiple tools and manual uploads. Businesses:** Leverage AI to create branded video content for marketing, reducing production time and costs. What Problem Does This Workflow Solve? Creating and distributing high-quality short-form video content consistently across multiple social networks is incredibly time-consuming and resource-intensive. This workflow tackles these challenges by: Automating Idea-to-Video Pipeline:** Generates video concepts, image prompts, scripts, images, video clips, and voiceovers using AI. Streamlining Video Assembly:** Automatically combines generated assets into a final video using a template. Generating Platform-Optimized Descriptions:** Creates relevant descriptions for posts by transcribing the final video audio. Automating Multi-Platform Publishing:** Uploads the final video and description to TikTok, Instagram, YouTube, Facebook, and LinkedIn simultaneously. Reducing Manual Workload:** Drastically cuts down the time and effort required for video production and distribution. Centralized Tracking:** Updates a Google Sheet with results, costs, and status for easy monitoring. How It Works Trigger & Input: Runs on a daily schedule (configurable) and fetches new video ideas from a designated Google Sheet. AI Content Generation: Uses OpenAI to generate video captions and image prompts based on the idea. Uses PiAPI (Flux) to generate images from prompts. Uses PiAPI (Kling) to generate video clips from the images (Image-to-Video). Uses OpenAI to generate a voiceover script based on the captions. Uses ElevenLabs to generate voiceover audio from the script and uploads it to Google Drive.

  • 6 nodes
  • 191,045 views

  Workflow detailsImport from n8n.ioAutomation, AI

• Generate AI Videos with Google Veo3, Save to Google Drive and Upload to YouTube

  by Davide Boizza · web · 155,914 clicks

  This workflow allows users to generate AI videos using Google Veo3, save them to Google Drive, generate optimized YouTube titles with GPT-4o, and automatically upload them to YouTube with Upload-Post. The entire process is triggered from a Google Sheet that acts as the central interface for input and output. IT automates video creation, uploading, and tracking, ensuring seamless integration between Google Sheets, Google Drive, Google Veo3, and YouTube. Benefits of this Workflow 💡 No Code Interface**: Trigger and control the video production pipeline from a simple Google Sheet. ⚙️ Full Automation**: Once set up, the entire video generation and publishing process runs hands-free. 🧠 AI-Powered Creativity**: Generates engaging YouTube titles using GPT-4o. Leverages advanced generative video AI from Google Veo3. 📁 Cloud Storage & Backup**: Stores all generated videos on Google Drive for safekeeping. 📈 YouTube Ready**: Automatically uploads to YouTube with correct metadata, saving time and boosting visibility. 🧪 Scalable**: Designed to process multiple video prompts by looping through new entries in Google Sheets. 🔒 API-First**: Utilizes secure API-based communication for all services. How It Works Trigger: The workflow can be started manually ("When clicking ‘Test workflow’") or scheduled ("Schedule Trigger") to run at regular intervals (e.g., every 5 minutes). Fetch Data: The "Get new video" node retrieves unfilled video requests from a Google Sheet (rows where the "VIDEO" column is empty). Video Creation: The "Set data" node formats the prompt and duration from the Google Sheet. The "Create Video" node sends a request to the Fal.run API (Google Veo3) to generate a video based on the prompt. Status Check: The "Wait 60 sec." node pauses execution for 60 seconds. The "Get status" node checks the video generation status. If the status is "COMPLETED," the workflow proceeds; otherwise, it waits again. Video Processing: The "Get Url Video" node fetches the video URL. The "Generate title" node uses OpenAI (GPT-4.1) to create an SEO-optimized YouTube title. The "Get File Video" node downloads the video file. Upload & Update: The "Upload Video" node saves the video to Google Drive. The "HTTP Request" node uploads the video to YouTube via the Upload-Post API. The "Update Youtube URL" and "Update result" nodes update the Google Sheet with the video URL and YouTube link.

  • 4 nodes
  • 155,914 views

  Workflow detailsImport from n8n.ioAutomation, AI

• Scrape business emails from Google Maps without the use of any third party APIs

  by Akram Kadri · web · 150,209 clicks

  Who is this template for? This workflow template is designed for sales, marketing, and business development professionals who want a cost-effective and efficient way to generate leads. By leveraging n8n core nodes, it scrapes business emails from Google Maps without relying on third-party APIs or paid services, ensuring there are no additional costs involved. Ideal for small business owners, freelancers, and agencies, this template automates the process of collecting contact information for targeted outreach, making it a powerful tool for anyone looking to scale their lead generation efforts without incurring extra expenses. You can watch the video tutorial here: https://youtu.be/HaiO-UeiKBA How it works This template streamlines email scraping from Google Maps using only n8n core nodes, ensuring a completely free and self-contained solution. Here’s how it operates: Input Queries You provide a list of queries, each consisting of keywords related to the type of business you want to target and the specific region or subregion you’re interested in. Iterates through Queries The workflow processes each query one at a time. For each query, it triggers a sub-workflow dedicated to handling the scraping tasks. Scrapes Google Maps for URLs Using these queries, the workflow scrapes Google Maps to collect URLs of business listings matching the provided criteria. Fetches HTML Content The workflow then fetches the HTML pages of the collected URLs for further processing. Extracts Emails Using a Code Node with custom JavaScript, the workflow runs regular expressions on the HTML content to extract business email addresses. Setup Add Queries: Open the first node, "Run Workflow" and input a list of queries, each containing the business keywords and the target region. Configure the Google Sheets Node: Open the Google Sheets node and select a document and specific sheet where the scraped results will be saved. Run the workflow: Click on "Test workflow" and watch your Google Sheets document gradually receive business email addresses. Customize as Needed: You can adjust the regular expressions in the Code Node to refine the email extraction logic or add logic to extract other kinds of information. An n8n automation workflow template by Akram Kadri.

  • 3 nodes
  • 150,209 views

  Workflow detailsImport from n8n.ioAutomation

• Automated Web Scraping: email a CSV, save to Google Sheets & Microsoft Excel

  by Mihai Farcas · web · 99,001 clicks

  How it works: The workflow starts by sending a request to a website to retrieve its HTML content. It then parses the HTML extracting the relevant information The extracted data is storted and converted into a CSV file. The CSV file is attached to an email and sent to your specified address. The data is simultaneously saved to both Google Sheets and Microsoft Excel for further analysis or use. Set-up steps: Change the website to scrape in the "Fetch website content" node Configure Microsoft Azure credentials with Microsoft Graph permissions (required for the Save to Microsoft Excel 365 node) Configure Google Cloud credentials with access to Google Drive, Google Sheets and Gmail APIs (the latter is required for the Send CSV via e-mail node). An n8n automation workflow template by Mihai Farcas.

  • 5 nodes
  • 99,001 views

  Workflow detailsImport from n8n.ioAutomation

• AI-Powered Short-Form Video Generator with OpenAI, Flux, Kling, and ElevenLabs

  by Cameron Wills · web · 92,907 clicks

  Who is this for? Content creators, digital marketers, and social media managers who want to automate the creation of short-form videos for platforms like TikTok, YouTube Shorts, and Instagram Reels without extensive video editing skills. What problem does this workflow solve? Creating engaging short-form videos consistently is time-consuming and requires multiple tools and skills. This workflow automates the entire process from ideation to publishing, significantly reducing the manual effort needed while maintaining content quality. What this workflow does This all-in-one solution transforms ideas into fully produced short-form videos through a 5-step process: Generate video captions from ideas stored in a Google Sheet Create AI-generated images using Flux and the OpenAI API Convert images to videos using Kling's API Add voice-overs to your content with Eleven Labs Complete the video production with Creatomate by adding templates, transitions, and combining all elements The workflow handles everything from sourcing content ideas to rendering the final video, and even notifies you on Discord when videos are ready. Setup (Est. time: 20-30 minutes) Before getting started, you'll need: n8n installation (tested on version 1.81.4) OpenAI API Key (free trial credits available) PiAPI (free trial credits available) Eleven Labs (free account) Creatomate API Key (free trial credits available) Google Sheets API enabled in Google Cloud Console Google Drive API enabled in Google Cloud Console OAuth 2.0 Client ID and Client Secret from your Google Cloud Console Credentials How to customize this workflow to your needs Adjust the Google Sheet structure to include additional data like video length, duration, style, etc. Modify the prompt templates for each AI service to match your brand voice and content style Update the Creatomate template to reflect your visual branding Configure notification preferences in Discord to manage your workflow This workflow combines multiple AI technologies to create a seamless content production pipeline, saving you hours of work per video and allowing you to focus on strategy rather than production. An n8n automation workflow template by Cameron Wills.

  • 6 nodes
  • 92,907 views

  Workflow detailsImport from n8n.ioAutomation, AI

• Clone Viral TikToks with AI Avatars & Auto-Post to 9 Platforms using Perplexity & Blotato

  by Dr. Firas · web · 84,076 clicks

  Clone a viral TikTok with AI and auto-post it to 9 platforms using Perplexity & Blotato Who is this for? This workflow is perfect for: Content creators looking to repurpose viral content Social media managers who want to scale short-form content across multiple platforms Entrepreneurs and marketers aiming to save time and boost visibility with AI-powered automation What problem is this workflow solving? Reproducing viral video formats with your own branding and pushing them to multiple platforms is time-consuming and hard to scale. This workflow solves that by: Cloning a viral TikTok video’s structure Generating a new version with your avatar Rewriting the script, caption, and overlay text Auto-posting it to 9 social media platforms — without manual uploads What this workflow does From a simple Telegram message with a TikTok link, the workflow: Downloads a TikTok video and extracts its thumbnail, audio, and caption Transcribes the audio and saves original text into Google Sheets Uses Perplexity AI to suggest a new content idea in the same niche Rewrites the script, caption, and overlay using GPT-4o Generates a new video with your avatar using Captions.ai Adds subtitles and overlay text with JSON2Video Saves metadata to Google Sheets for tracking Sends the final video to Telegram for preview Auto-publishes the video to Instagram, YouTube, TikTok, Facebook, LinkedIn, Threads, X (Twitter), Pinterest, and Bluesky via Blotato Setup Connect your Telegram bot to the trigger node. Add your OpenAI, Perplexity, Cloudinary, Captions.ai, and Blotato API keys. Make sure your Google Sheet is ready with the appropriate columns. Replace the default avatar name in the Captions.ai node with yours. Fill in your social media account IDs in the "Assign Platform IDs" node. Test by sending a TikTok URL to your Telegram bot. How to customize this workflow to your needs Change avatar output style**: adjust resolution, voice, or avatar ID. Refine script structure**: tweak GPT instructions for different tone/format. Swap Perplexity with ChatGPT or Claude** if needed. Filter by platform**: disable any Blotato nodes you don’t need. Add approval step**: insert a Telegram confirmation node before publishing. Adjust subtitle style or overlay text font** in JSON2Video. 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube. An n8n automation workflow template by Dr. Firas.

  • 5 nodes
  • 84,076 views

  Workflow detailsImport from n8n.ioAutomation, AI

• Generate Leads with Google Maps

  by Alex Kim · web · 82,097 clicks

  This workflow leverages n8n to perform automated Google Maps API queries and manage data efficiently in Google Sheets. It's designed to extract specific location data based on a given list of ZIP codes and categories. Features Queries the Google Maps API for location data using predefined ZIP codes and subcategories. Filters, de-duplicates, and organizes data into structured rows in Google Sheets. Implements exponential backoff retries to handle API rate limits. Logs and updates statuses directly in Google Sheets for easy tracking. Prerequisites Google OAuth Credentials: A configured Google Cloud project for Google Maps API and Sheets API access. Google Sheets: A sheet with ZIP codes and categories defined (e.g., "AZ Zips"). n8n Setup: A running instance of n8n with credentials configured for Google OAuth. Setup Instructions 1. Prepare Google Sheets Add the ZIP codes to the "AZ Zips" sheet. Define subcategories in another sheet (e.g., "Google Maps Categories"). Provide the sheet's URL in the Settings node of the workflow. 2. Configure API Access Set up Google OAuth credentials for Maps and Sheets APIs in n8n. Ensure your API key has access to the places.searchText endpoint. 3. Workflow Customization Modify textQuery parameters in the GMaps API node to match your query needs. Adjust trigger intervals as required (e.g., manual or scheduled execution). 4. Run the Workflow Execute the workflow manually or schedule periodic runs to keep your data updated. Notes This workflow includes robust error handling to retry failed API calls with exponential backoff. All data is organized and logged directly in Google Sheets for easy reference and updates. For more information or issues, feel free to reach out!. An n8n automation workflow template by Alex Kim.

  • 3 nodes
  • 82,097 views

  Workflow detailsImport from n8n.ioAutomation

• OpenAI GPT-3: Company Enrichment from website content

  by Lucas Perret · web · 72,240 clicks

  Enrich your company lists with OpenAI GPT-3 ↓ You’ll get valuable information such as: Market (B2B or B2C) Industry Target Audience Value Proposition This will help you to: add more personalization to your outreach make informed decisions about which accounts to target I've made the process easy with an n8n workflow. Here is what it does: Retrieve website URLs from Google Sheets Extract the content for each website Analyze it with GPT-3 Update Google Sheets with GPT-3 data. An n8n automation workflow template by Lucas Perret.

  • 4 nodes
  • 72,240 views

  Workflow detailsImport from n8n.ioAutomation

• Generate & Auto-post AI Videos to Social Media with Veo3 and Blotato

  by Dr. Firas · web · 71,279 clicks

  Automate video creation with Veo3 and auto-post to Instagram, TikTok via Blotato Who is this for? This template is ideal for content creators, social media managers, YouTubers, and digital marketers who want to generate high-quality videos daily using AI and distribute them effortlessly across multiple platforms. It’s perfect for anyone who wants to scale short-form content creation without video editing tools. What problem is this workflow solving? Creating and distributing consistent video content requires: Generating ideas Writing scripts and prompts Rendering videos Manually posting to platforms This workflow automates all of that. It transforms one prompt into a professional AI-generated video and publishes it automatically — saving time and increasing reach. What this workflow does Triggers daily to generate a new idea with OpenAI (or your custom prompt). Creates a video prompt formatted specifically for Google Veo3. Generates a cinematic video using the Veo3 API. Logs the video data into a Google Sheet. Retrieves the final video URL once Veo3 finishes rendering. Uploads the video to Blotato for publishing. Auto-posts the video to Instagram, TikTok, YouTube, Facebook, LinkedIn, Threads, Twitter (X), Pinterest, and Bluesky. Setup Add your OpenAI API key to the GPT-4.1 nodes. Connect your Veo3 API credentials in the video generation node. Link your Google Sheets account and use a sheet with columns: Prompt, Video URL, Status. Connect your Blotato API key and set your platform IDs in the Assign Social Media IDs node. Adjust the Schedule Trigger to your desired posting frequency. How to customize this workflow to your needs Edit the AI prompt** to align with your niche (fitness, finance, education, etc.). Add your own branding overlays** using JSON2Video or similar tools. Change platform selection** by enabling/disabling specific HTTP Request nodes. Add a Telegram step** to preview the video before auto-posting. Track performance** by adding metrics columns in Google Sheets. 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube. An n8n automation workflow template by Dr. Firas.

  • 6 nodes
  • 71,279 views

  Workflow detailsImport from n8n.ioAutomation, AI

• AI web researcher for sales

  by Lucas Perret · web · 68,630 clicks

  Who is this for? This workflow is for all sales reps and lead generation manager who need to prepare their prospecting activities, and find relevant information to personalize their outreach. Use Case This workflow allows you to do account research with the web using AI. It has the potential to replace manual work done by sales rep when preparing their prospecting activities by searching complex information available online. What this workflow does The advanced AI module has 2 capabilities: Research Google using SerpAPI Visit and get website content using a sub-workflow From an unstructured input like a domain or a company name. It will return the following properties: domain company Linkedin Url cheapest plan has free trial has entreprise plan has API market (B2B or B2C) The strength of n8n here is that you can adapt this workflow to research whatever information you need. You just have to precise it in the prompt and to precise the output format in the "Strutured Output Parser" module. Detailed instructions + video guide can be found by following this link. An n8n automation workflow template by Lucas Perret.

  • 6 nodes
  • 68,630 views

  Workflow detailsImport from n8n.ioAutomation, AI

• Preparing data to be sent to a service

  by Jonathan · web · 63,641 clicks

  Task: Make sure that data is in the right format before injecting it into a database/spreadsheet/CRM/etc. Why: Spreadsheets and databases require the incoming data to have the same fields as the headers of the destination table. You can decide which fields you would like to send with the database and rename them by using the set node Main use cases: Change fields names to match a database or a spreadsheet table structure Keep only the fields that are needed at the destination table. An n8n automation workflow template by Jonathan.

  • 2 nodes
  • 63,641 views

  Workflow detailsImport from n8n.ioAutomation

All n8n workflow automations — every integration, filterable by platform and complexity.