The Ultimate n8n TemplatesLibrary & Marketplace

Discover 7000+ premium n8n templates with AI-powered generation. The largest n8n templates marketplace enabling anyone to have a running workflow in 5 minutes

Start AI Generation Browse Templates

Or browse our extensive n8n templates collection. Try the AI generator to create custom n8n templates instantly.

10710+

Templates

50+

Integrations

50k+

Downloads

Latest n8n Templates

Freshly updated automation workflows to keep your n8n stack current

View All

Notify on menu orders via ntfy and Home Assistant TTS with daily BAC tracking

Notify on menu orders via ntfy and Home Assistant TTS with daily BAC tracking Receive instant push notifications on your phone and voice announcements on your Google Home every time someone orders from your intranet menu — with cumulative BAC tracking per person. > Full documentation & step-by-step setup guides: > 📖 Notion Documentation > 💻 GitHub Repository What This Workflow Does Every time a customer submits an order from your intranet menu website, this workflow: Receives the order via Webhook Logs it to an n8n DataTable and reads all orders for that person today Calculates the cumulative BAC (Blood Alcohol Content) using the Widmark formula Sends a push notification via ntfy (with order history + BAC level) Triggers a Home Assistant script → voice announcement on Google Home No cloud TTS fees. No external AI services. Fully self-hosted. Flow Webhook → Prepare Order → DataTable (INSERT) → Read Today's Orders → BAC Calculator → ntfy Push Notification → Home Assistant TTS Example Output Push notification (ntfy app): 🛎 Order from Mario Mario: 1x Pizza, 2x Beer 33cl 🕐 12:30 📋 Ordered before: 1x Prosecco 🕐 11:45 🍸 BAC ~0.54 g/L 🔴 Google Home voice announcement: Mario has ordered Pizza Prerequisites Before importing this workflow, you need: A running n8n instance (self-hosted or cloud) reachable from the internet Home Assistant** on your local network (e.g. homeassistant.local:8123) At least one Google Home (or Chromecast-capable) device added to HA via the Google Cast integration ntfy** deployed via Docker (self-hosted push notification server) A public HTTPS URL for ntfy — recommended via Cloudflare Tunnel (no open ports needed) An Android or iOS device with the ntfy app installed Credentials Required | Credential | Used For | | ------------------------------------------------------ | ---------------------------------------- | | Home Assistant | Calling the annuncia_ordine TTS script | | Header Auth (Authorization: Bearer <ntfy_token>) | Sending authenticated requests to ntfy | n8n DataTable Schema Create a DataTable in n8n → Data → Tables with these columns: | Column | Type | Description | | -------------- | ------ | ------------------------------------------------------ | | item | Text | Full order string (e.g. "2x Negroni, 1x Messina 33cl") | | person | Text | Normalised person name | | alcol_grammi | Number | Total grams of alcohol for this order | | data | Text | ISO date (YYYY-MM-DD) | | orario | Text | Time string from the order | Copy the DataTable ID and paste it into the DataTable nodes inside the workflow. Webhook Payload Your menu website must POST this JSON to the Webhook Production URL: { "name": "Mario", "time": "26/03/2026, 12:30:00", "order": [ { "section": "Food", "name": "Pizza", "details": "", "quantity": 1 }, { "section": "Drinks", "name": "Beer", "details": "33cl", "quantity": 2 } ], "total": 3 } Setup Steps 1. Deploy ntfy (self-hosted push notifications) Add ntfy to your docker-compose.yml: ntfy: image: binwiederhier/ntfy command: serve volumes: ./ntfy/config:/etc/ntfy ./ntfy/data:/var/lib/ntfy ports: "8095:80" In server.yml, set auth-default-access: deny-all. Then create an admin user and generate a token: docker exec -e NTFY_PASSWORD="your_password" ntfy ntfy user add --role=admin admin docker exec ntfy ntfy token add admin 2. Expose ntfy over HTTPS (Cloudflare Tunnel) Add an ingress rule to your Cloudflare Tunnel config: hostname: ntfy.YOUR_DOMAIN.com service: http://localhost:8095 3. Configure Home Assistant TTS In HA, go to Settings → Automations & Scenes → Scripts → Add script → Edit in YAML and paste: alias: annuncia_ordine sequence: action: tts.speak target: entity_id: tts.google_translate_en_com data: media_player_entity_id: media_player.YOUR_GOOGLE_HOME_ENTITY message: "{{ message }}" language: it mode: single > Replace media_player.YOUR_GOOGLE_HOME_ENTITY with your actual entity ID. Then go to your HA profile → Security → Long-lived access tokens → create and copy a token. 4. Import and configure the workflow Import the workflow JSON into n8n Create the DataTable (columns listed above) — copy its ID Create the Header Auth credential for ntfy: Header Name: Authorization Header Value: Bearer YOUR_NTFY_TOKEN Create the Home Assistant credential: Host: http://homeassistant.local:8123 Access Token: your HA long-lived token In the ntfy notification node, replace YOUR_TOPIC in the URL In the Home Assistant TTS node, set the message attribute expression: ={{ $('Webhook').item.json.body.nome }} has ordered {{ $('Webhook').item.json.body.ordine[0].nome }} Activate the workflow and copy the Webhook Production URL 5. Configure your menu website Set the webhook URL in your menu site config: // menu-data.js "orderWebhook": "https://YOUR_N8N_DOMAIN/webhook/menu" BAC Calculation (Widmark Formula) BAC [g/L] = total_alcohol_grams_today / (70 × 0.68) Assumes ~70 kg body weight. Italian legal driving limit: 0.5 g/L | Emoji | Level | BAC | | ----- | ---------- | ------------- | | ⬜ | None | 0 g/L | | 🟢 | Low | < 0.2 g/L | | 🟡 | Warning | 0.2 – 0.5 g/L | | 🔴 | Over limit | > 0.5 g/L | BAC is cumulative per day per person and resets automatically the next day. Customization | What | How | | ----------------------------------------- | ------------------------------------------------------------ | | Change the TTS message | Edit the message expression in the HA TTS node | | Announce all ordered items | Use $json.body.ordine.map(i => i.quantita + ' ' + i.nome).join(', ') | | Change TTS language | Edit language in the annuncia_ordine HA script | | Announce on multiple Google Home devices | Add multiple media_player_entity_id entries to the HA script | | Disable TTS (keep only push notification) | Remove or deactivate the Home Assistant TTS node | Security | Layer | Mechanism | | -------------------- | ---------------------------------------------------- | | Transport (ntfy) | HTTPS via Cloudflare Tunnel | | ntfy access | auth-default-access: deny-all — no anonymous reads | | n8n → ntfy | Dedicated Bearer token (revokable, no expiry) | | n8n → Home Assistant | Long-lived access token | | Mobile app | Username/password on the ntfy server | Documentation & Source | | | | ------------------------ | ------------------------------------------------------------ | | 📖 Full documentation | Notion — step-by-step setup guides | | 💻 GitHub Repository | paoloronco/n8n-templates | Related Resources ntfy.sh documentation Home Assistant TTS documentation Home Assistant Scripts Google Cast integration n8n Home Assistant node

BeginnerManual Trigger

by Paolo Ronco

Extract brand identity markers from web pages using Google Gemini

Web Page to Brand Identity Markers This n8n template retrieves verbal brand identity markers from any web site. Customer Perception Review How does a customer coming to your web site perceive your content? Use this to check against the key messages you want the customer to understand after visiting your web site. Brand Identity Extraction Marketing Agencies need to understand for each customers their specific tone and communication style to replicate it for updates and new content. How it works Execute the workflow and enter any web site address The HTTP node retrieves the web page The core logic is the Gemini AI prompt to review the web page content and respond with a pre-defined JSON data structure containing the verbal brand identity markers The JSON structure returned from the AI node is parsed and displayed on a web page. How to customize Inject your own processing logic after the "Extract AI Response" node You can directly access the JSON fields returned. For an example see how the HTML node creates the web page with the JSON data. Requirements Gemini account for LLM Need Help? Join the Discord or ask in the Forum! For support reach out to the creator at blakewise.com Happy Hacking!

BeginnerManual Trigger

Generate AI music and publish to YouTube automatically with Blotato

💥 Generate AI Music & Publish to YouTube Automatically with Blotato This workflow automatically generates AI music, creates a thumbnail, converts everything into a video, and publishes it directly to YouTube — fully automated. Perfect for building faceless YouTube music channels, AI content automation, or passive content generation pipelines. Who is this for? This template is ideal for: YouTube creators building AI music channels Content creators creating faceless videos Automation enthusiasts using n8n for content pipelines Agencies generating bulk YouTube content Anyone wanting to automate music creation and publishing Whether you're creating lofi music, ambient tracks, meditation sounds, or background music, this workflow removes manual work entirely. What problem is this workflow solving? Creating AI music videos typically involves multiple manual steps: Generating music Creating thumbnails Converting audio into video Uploading to YouTube Writing titles and metadata This process is time-consuming and repetitive. This workflow automates everything into a single end-to-end pipeline, allowing you to: Generate unlimited AI music Automatically create thumbnails Convert audio into video Publish directly to YouTube What this workflow does This workflow performs the following steps: User submits a music request via form AI generates an optimized music prompt ElevenLabs generates AI music AI generates thumbnail prompt Atlas Cloud generates thumbnail image Cloudinary uploads generated assets Shotstack creates video (image + audio) Blotato uploads video to YouTube automatically SEO-optimized YouTube title is generated automatically Final result: AI-generated music video automatically published to YouTube The entire process runs fully automated. Setup To use this workflow, configure the following credentials: Required APIs OpenAI API Key — Prompt generation Elevenlabs** API Key — Music generation AtlasCloud** API Key — Thumbnail generation Cloudinary Account — Media hosting Shotstack API Key — Video creation Blotato** API Key — YouTube publishing Community Node Requirement This workflow uses the Blotato community node. 🎥 Watch This Tutorial 👋 Need help or want to customize this? 📩 Contact: LinkedIn 📺 YouTube: @DRFIRASS 🚀 Workshops: Mes Ateliers n8n Need help customizing? Contact me for consulting and support : Linkedin / Youtube / 🚀 Mes Ateliers n8n

Generate bulk Veo 3 videos from Google Sheets via Vertex AI

🎬 What This Workflow Does This workflow turns your Google Sheet into a fully automated AI video factory powered by Google Veo 3 via Vertex AI. Simply fill in your prompts, choose your video settings, tick a checkbox — and walk away. The workflow handles everything: sending the prompt to Veo 3, waiting for the video to generate, downloading it, uploading it to Google Drive, and writing the link back to your sheet automatically. No manual downloading. No checking APIs. No copy-pasting links. Just tick and go. Whether you need 5 videos or 500, this workflow runs each one through the same reliable pipeline — with full error handling so you always know what succeeded and what failed, and exactly why. 🧠 Why This Workflow Exists Google Veo 3 is one of the most powerful AI video generation models in the world — but the Google Cloud console only lets you generate videos one at a time. If you have a client who needs 50 product videos, or a content team producing videos at scale, doing it manually through the UI is completely impractical. This workflow solves that. It gives you a spreadsheet-driven production pipeline for Veo 3 — where each row is one video job, fully configurable with its own prompt, resolution, aspect ratio, and duration. ✅ What You Get ✅ Checkbox trigger — tick a row in Google Sheets to start generation ✅ Per-row settings — each video can have its own resolution, aspect ratio, and duration ✅ Smart polling loop — automatically checks every 60 seconds until the video is ready ✅ Google Drive upload — finished videos land in your Drive folder automatically ✅ Sheet auto-update — Drive link written back to the exact row when done ✅ Full error handling — content blocks and API errors are logged to the sheet with the exact reason ✅ No wasted credits — validation gate blocks empty or incomplete rows before any API call is made 🗂️ Google Sheet Template Use this ready-made Google Sheet template to get started immediately: 👉 Click here to open the Google Sheet Template (File → Make a copy) Your sheet must have these columns in this exact order: | Column | Description | |---|---| | prompt | Your video description — what Veo 3 should generate | | resolution | Video quality: 720p or 1080p | | aspectRatio | 16:9 for landscape, 9:16 for portrait/vertical | | durationSeconds | Video length: 4, 6, or 8 seconds only | | send_for_generation | Checkbox column — tick this to trigger the workflow | | video_drive_link | Auto-filled — Drive link on success, error reason on failure | | row_number | Auto-filled by Apps Script — do not edit manually | ⚙️ Full Setup Guide — Step by Step STEP 1 — Create a Google Cloud Project & Enable Vertex AI Go to console.cloud.google.com Click the project dropdown at the top → New Project Give it a name (e.g. veo-automation) → click Create Once created, make sure this project is selected In the left menu go to APIs & Services → Library Search for Vertex AI API → click it → click Enable Now go to Billing in the left menu Link a billing account to your project — Vertex AI requires billing to be enabled even if you're within free tier limits STEP 2 — Get Your Vertex AI API Key go on this url https://console.cloud.google.com/vertex-ai/studio in the vertex ai studio create the api key Save the key somewhere safe — you will paste it into the Data Collection node in n8n STEP 3 — Get Your Project ID In Google Cloud Console, look at the top bar — your Project ID is shown next to the project name It looks like: project-xxxxxxx-xxxx-xxxx-ada or similar Copy this — you will paste it into the Data Collection node in n8n STEP 4 — Set Up n8n Credentials In n8n you need two Google credential connections: Google Sheets OAuth2 In n8n go to Settings → Credentials → New Search for Google Sheets OAuth2 API Follow the OAuth flow to connect your Google account This credential is used by the Update video Link in sheet and Update Error in Sheet nodes Google Drive OAuth2 Same process — search for Google Drive OAuth2 API Connect the same or a different Google account This credential is used by the Upload Video to Drive node STEP 5 — Configure the Data Collection Node Open the Data Collection node in n8n and update these values: | Field | What to put | |---|---| | project_id | Your Google Cloud Project ID from Step 3 | | vertex_api | Your Vertex AI API Key from Step 2 | | veo_3_model | veo-3.0-generate-preview (or newer model if available) | | api_endpoint | Leave as us-central1-aiplatform.googleapis.com | | region | Leave as us-central1 | STEP 6 — Set Up the Google Drive Folder Go to drive.google.com Create a new folder where your videos will be saved (e.g. Veo Generated Videos) Open the folder — copy the folder ID from the URL: URL looks like: https://drive.google.com/drive/folders/xxxxxxxxxxxxxx-xxxxxxxxxxx The folder ID is the last part: xxxxxxxxx-xxxxxxxxx Paste this into the Upload Video to Drive node → Folder ID field STEP 7 — Connect Your Google Sheet Open the Update video Link in sheet node Click the Document field → select your copy of the Google Sheet template Make sure the sheet tab selected is VEO_3 Do the same in the Update Error in Sheet node Here is the full rewritten section in clean markdown without any code blocks around the URL: STEP 8 — Set Up the Apps Script Webhook Trigger This is what connects your Google Sheet checkbox to n8n. Without this, ticking the checkbox does nothing. 📄 Download the Apps Script file here How to install it: Open your Google Sheet Click Extensions → Apps Script Delete any existing code in the editor Paste the entire Apps Script code provided with this template Find the url field in the config block and replace YOUR_N8N_WEBHOOK_URL_HERE with your n8n webhook URL — found in the Google Sheet Trigger node in n8n. Use the Production URL, not the test URL. Click Save (floppy disk icon at the top) Now add the installable trigger — this step is critical: In Apps Script, click the clock icon on the left sidebar (Triggers) Click + Add Trigger in the bottom right corner Set these exact options: Choose which function to run: handleEdit Choose which deployment to run: Head Select event source: From spreadsheet Select event type: On edit Click Save Google will ask you to authorise the script — click through and allow all permissions Go back to your sheet and tick a checkbox in column E to test — open Apps Script Executions tab to confirm it fired successfully ⚠️ Why the installable trigger is required: The basic onEdit function that Google runs automatically does NOT have permission to make external HTTP requests. The installable trigger runs under your Google account permissions and can call external URLs like your n8n webhook. This is a Google limitation — not an n8n one. STEP 9 — Activate the Workflow in n8n In n8n open the workflow Toggle the workflow to Active using the switch in the top right corner Copy the Production webhook URL from the Google Sheet Trigger node Paste it into your Apps Script config in Step 8 where it says YOUR_N8N_WEBHOOK_URL_HERE 🔄 How the Workflow Runs — Full Flow Explained 🔄 How the Workflow Runs — Full Flow Explained Google Sheet checkbox ticked ↓ Apps Script fires webhook → n8n ↓ Validation Gate (If node) — checks prompt, resolution, aspectRatio are all filled — if anything missing → workflow stops, no API call made ↓ Data Collection node — bundles all settings into one clean item ↓ Vertex AI — Send for Generation — POST to predictLongRunning endpoint — returns an operation name (like a tracking number) ↓ Wait 60 seconds ↓ Fetch / Check Video — POST to fetchPredictOperation — checks if done: true ↓ IF raiMediaFilteredCount === 0 → TRUE: video exists → Convert Base64 to MP4 file → Upload to Google Drive → Write Drive link to sheet ✅ → FALSE: check for error → IF raiMediaFilteredCount > 0 OR error exists → Write error reason to sheet ❌ → ELSE: still processing → Wait 60 seconds → check again ⏳ ⚙️ Video Settings Reference Resolution 720p — standard quality, faster, lower cost 1080p — high quality, uses more credits Aspect Ratio 16:9 — landscape (YouTube, ads, presentations) 9:16 — vertical (Instagram Reels, TikTok, YouTube Shorts) Duration 4, 6, or 8 seconds — Veo 3 only accepts these exact values, no other numbers ❌ Error Handling — What Gets Logged If a video fails, the exact reason is written to the video_drive_link column: Prompt violates Veo safety policy,| Full AI reason from Google || This means your client can see exactly which rows failed and why — without needing to check any logs. 💡 Tips for Best Results Keep prompts on a single line — multi-line prompts are handled automatically by the workflow Use descriptive cinematic prompts: "Slow motion close-up of ocean waves at sunset, golden hour, 4K" Start with 720p to test — switch to 1080p for final production runs Use 9:16 for Instagram Reels, TikTok, YouTube Shorts Use 16:9 for YouTube, presentations, ads 🔧 Requirements n8n (self-hosted or cloud) — version 1.0+ Google Cloud account with billing enabled Vertex AI API enabled on your project Google Sheets + Google Drive OAuth credentials in n8n Google Apps Script access on your sheet

Extract invoice data from PDF with Claude AI and create vendor bill in Odoo 18

This workflow automates accounts payable: upload a PDF invoice, let Claude AI extract the key fields, and automatically create a vendor bill (incoming invoice) in Odoo 18. Who is this for? Small and medium businesses using Odoo 18 who want to automate invoice data entry. Finance teams, bookkeepers, or anyone processing incoming invoices manually. How it works Receive a PDF invoice via webhook (file upload) Convert the PDF to base64 for AI processing Claude AI extracts: vendor name, invoice number, date, amounts, tax rate Authenticate with Odoo 18 via JSON-RPC API Check for duplicate invoices (by invoice number) Find or create the vendor (res.partner) in Odoo Create a draft vendor bill (account.move) in Odoo Return a structured JSON response with the result The invoice is created in draft status so you can review and confirm it manually in Odoo before posting. Extracted fields vendor, invoice_number, invoice_date, total_amount, currency, net_amount, tax_rate, tax_amount Setup Open the Configuration node and enter your Odoo URL, database, user, and password Create an HTTP Header Auth credential named Anthropic API Key with header name x-api-key and your Anthropic API key as value Activate the workflow and send a test PDF Test with curl curl -X POST https://your-n8n-instance.com/webhook/invoice-process -F "data=@invoice.pdf" Requirements Odoo 18 with Invoicing module installed Anthropic API key (Claude Sonnet 4.5 recommended) n8n 2.x (self-hosted or cloud) How to customize Change the AI model in the Configuration node (e.g. claude-haiku-4-5-20251001 for lower cost) Modify the extraction prompt in Prepare Claude Request to add custom fields Add a file storage step after invoice creation (e.g. Google Drive, S3, WebDAV) Connect an email trigger instead of the webhook for fully automated processing Note on data privacy This workflow sends PDF documents to the Anthropic API for data extraction. Ensure you have a Data Processing Agreement (DPA) with Anthropic and comply with your local data protection regulations (e.g. GDPR) before processing documents containing personal data. Author: Florian Eiche — eiche-digital.de

Publish Google News–based SEO blog posts to WordPress with Claude, Gemini and RankMath

Stop writing blog posts manually. This workflow monitors Google News every 12 hours on any topic you choose, automatically selects the most relevant article, scrapes the source content, generates a 100% original SEO-optimized blog post using Claude AI, creates a featured image with Google Gemini, and publishes the complete post to WordPress with RankMath meta title and meta description fully automated, zero manual work. Perfect for bloggers, content marketers, digital agencies, WordPress site owners, and anyone who wants to keep their website updated with fresh, AI-written content without spending hours writing or publishing. What problem does this solve? Publishing fresh, well-written blog content consistently is one of the hardest parts of running a website. Finding relevant news, writing original articles, creating images, and publishing everything to WordPress takes hours every single time. This workflow eliminates all of that. It runs on a schedule, picks the best news story on your topic, writes a completely original article from scratch, and publishes it to your WordPress site, including featured image, meta title, and meta description while you focus on everything else. How it works Scheduled trigger runs every 12 hours automatically No manual action required. The workflow runs on its own twice a day. Fetch latest news via SerpAPI Google News SerpAPI fetches the freshest articles from Google News based on your search query. The default query is seo but you can change it to any topic - tech, finance, health, marketing, AI, real estate, or anything your blog covers. One parameter change is all it takes. Check already-published articles via Google Sheets A Google Sheets node reads all previously published news links from your tracking sheet. This ensures the same article is never processed twice - even if it keeps appearing in Google News days later. Remove duplicates with Merge node The Merge node compares incoming articles against your published history and removes any matches. Only genuinely new, unprocessed articles move forward. Sort by date and limit to top 10 Remaining articles are sorted by publish date, newest first. A Limit node keeps only the top 10 most recent items for evaluation. AI agent selects the single best article All 10 article titles and links are combined into one item and sent to an AI Agent powered by Claude (via OpenRouter). The agent reads every title and picks the one most relevant and valuable for your website's audience - filtering out off-topic, low-quality, or irrelevant results. It returns the winning article's title and link. Scrape the full source article An HTTP Request node fetches the complete HTML of the selected article. An HTML Extract node pulls only the meaningful content - headings (h1, h2, h3) and paragraphs (p) - stripping out ads, navigation menus, and everything else. An Aggregate node joins all extracted text into one clean block ready for the AI. Claude generates a 100% original article A second AI Agent (Claude via OpenRouter) receives the scraped content as research material only. It does not rewrite or paraphrase the source. It writes a completely new, original, SEO-optimized article based on the topic and ideas - with its own structure, wording, and insights. The output includes: Article title Meta title (under 60 characters) Meta description (under 160 characters) Full article body in Markdown format A featured image generation prompt Google Gemini generates the featured image The image prompt produced by Claude is sent to Google Gemini's image generation model. The image is created in 16:9 ratio, suitable as a WordPress featured image. Upload image to WordPress Media Library An HTTP Request node uploads the generated image binary directly to your WordPress site via the REST API. WordPress returns an image ID which is stored for the next step. Convert Markdown to HTML The article content is in Markdown format. A Markdown node converts it to clean HTML before publishing. Arrange all data in one place A Set node collects all required fields - title, HTML content, image ID, meta title, meta description, and original news source link - into one organised item. Create the WordPress post The WordPress node creates the post with title, content, author, and category. You can set the post to draft for review or publish directly. The category ID is configurable to match your site structure. Attach featured image and RankMath SEO meta An HTTP PUT request updates the post to attach the featured image using the stored image ID, and writes the RankMath SEO title and meta description using registered REST API meta fields. Log to Google Sheets The original news link and the published WordPress post URL are saved back to your Google Sheets tracking file. This is what prevents the same article from ever being processed again on future runs. What you need SerpAPI** — for Google News fetching OpenRouter** — to access Claude (anthropic/claude-sonnet-4.5) Google Gemini (PaLM API)** — for featured image generation WordPress** — with Application Password authentication Google Sheets** — with two columns: news_link and wp_post_link RankMath SEO plugin** on WordPress (or adapt for Yoast — see note below) One-time WordPress setup for RankMath meta fields Add this PHP snippet via the Code Snippets plugin or your theme's functions.php to enable writing RankMath SEO title and description through the REST API: add_action('rest_api_init', function () { register_post_meta('post', 'rank_math_title', [ 'show_in_rest' => true, 'single' => true, 'type' => 'string', 'auth_callback' => fn() => current_user_can('edit_posts'), ]); register_post_meta('post', 'rank_math_description', [ 'show_in_rest' => true, 'single' => true, 'type' => 'string', 'auth_callback' => fn() => current_user_can('edit_posts'), ]); }); Using Yoast SEO instead? Replace the meta keys with _yoast_wpseo_title and _yoast_wpseo_metadesc in the last HTTP node. How to customise it for your topic Change the q parameter in the SerpAPI node to any keyword -digital marketing, cryptocurrency, AI tools, content marketing, web design, or anything else. The entire workflow adapts automatically. The AI agent will select the most relevant article for your niche and write accordingly. For assistance and support: salmanmehboob1947@gmail.com Linkedin: https://www.linkedin.com/in/salman-mehboob-pro/

Generate overdue lead follow-up Gmail drafts with Google Sheets and Gemini

Automatically identifies overdue sales leads and generates personalized follow-up emails using AI. How it works Runs every weekday Reads leads from Google Sheets Filters leads with no contact for 5+ days Downloads last meeting transcript from Google Drive Uses Google Gemini to write a personalized email Saves the email as a Gmail Draft for review Updates lead status in the Sheet Setup Google Sheets with columns: Current Status, Last Contact, Name, Company, Email, Meeting Transcript, Sales Rep Google Drive access for transcript files Google Gemini API key (free from Google AI Studio) Gmail account Slack workspace Supported file types PDF TXT Notes Emails are saved as drafts only — not sent automatically Supported lead statuses: New Skips leads with status: Draft Created, Sent, Closed Inspiration This workflow was built to solve a real problem at an educational institute. The sales team needed someone to remind them about follow-ups and draft personalized emails — but hiring a personal assistant wasn't financially feasible. Based on that, this system acts as that assistant: it tracks overdue leads, reads meeting transcripts, and writes personalized follow-up emails automatically. I kept this stack free where possible — using Google Gemini's free tier for AI. For small sales teams, I believe the daily token limits are more than sufficient, making this a zero-cost automation.

IntermediateManual Trigger

Extract customer testimonial clips using WayinVideo AI and Google Drive

Paste any customer interview or testimonial video URL into a simple form — and the workflow handles everything from there. WayinVideo AI scans the full video and automatically cuts the most impactful moments into up to 5 vertical clips. Each clip is downloaded and saved directly to your Google Drive folder, named and ready to use. Built for marketing teams, agencies, and founders who collect customer stories and need polished clips for ads, websites, and social media — without video editing. What This Workflow Does Form-based input** — Collects the video URL, client name, industry, and intended usage through a hosted form anyone on your team can fill out AI clip detection** — Submits the testimonial video to WayinVideo, which automatically finds the highest-impact moments and creates export-ready clips Vertical video output** — Generates clips in 9:16 ratio with AI reframing enabled, making them ready for Instagram Reels, TikTok, and YouTube Shorts with no editing Caption generation** — Adds captions to every clip automatically using the original language and a styled caption template Batch file download** — Downloads each clip as an individual video file directly from the WayinVideo export link Auto-named Drive upload** — Saves every clip to your Google Drive folder using the AI-generated clip title as the filename — no manual renaming needed Setup Requirements Tools You'll Need Active n8n instance (self-hosted or n8n Cloud) WayinVideo account with API access (wayin.ai) Google account with Google Drive OAuth2 access Estimated Setup Time: 5–10 minutes Step-by-Step Setup 1. Get Your WayinVideo API Key WayinVideo is the AI engine that finds and extracts the best testimonial moments from your video. Go to WayinVideo and log in or create an account Navigate to your Dashboard → API section Copy your Bearer token Open the 2. WayinVideo — Submit Clipping Task node in n8n Find the Authorization header value and replace YOUR_WAYIN_API_KEY_HERE with your token Open the 4. WayinVideo — Get Clip Results node and replace the same placeholder there > ⚠️ This API key appears in two nodes — node 2 and node 4. You must replace it in both. If you only update one, the result-fetching step will fail with an authentication error. 2. Connect Google Drive (OAuth2) In n8n, go to Credentials → Add Credential → Google Drive OAuth2 API Follow the Google authentication flow to grant access Open the 7. Google Drive — Upload Clip node Select your newly created credential from the dropdown 3. Set Your Google Drive Folder ID Open Google Drive in your browser and navigate to the folder where you want clips saved Look at the URL bar — copy the string of characters that appears after /folders/ Open the 7. Google Drive — Upload Clip node in n8n Replace YOUR_GOOGLE_DRIVE_FOLDER_ID with the ID you just copied Update YOUR_FOLDER_NAME with a recognisable label for your own reference 4. Activate the Workflow Save the workflow in n8n Toggle it Active using the switch at the top of the editor Open the form URL shown in the 1. Form — Testimonial Video + Details node trigger settings Submit a test testimonial video URL to confirm everything runs correctly How It Works (Step by Step) Step 1 — Form: Collect Testimonial Details The workflow starts when someone fills out a hosted n8n form. You provide four pieces of information: the testimonial video URL, the client or customer name, the industry or niche, and where the clips will be used (such as ads, a website, or social media). All this data is passed automatically to the next step. Step 2 — Submit Clipping Task to WayinVideo The workflow sends your video URL to the WayinVideo API. Along with the URL, it sends settings including the client name as the project label, a target clip length of 30–60 seconds, a maximum of 5 clips, HD 720p resolution, captions turned on, and vertical 9:16 reframing enabled. WayinVideo processes these settings and returns a Job ID used to retrieve results later. Step 3 — Wait 90 Seconds The workflow pauses for 90 seconds. This gives WayinVideo time to analyse the video and generate clips before the next step attempts to retrieve them. Skipping or shortening this wait on longer videos may result in an empty response. > ⚠️ If your testimonial videos are longer than 20–30 minutes, 90 seconds may not be enough processing time. Increase the wait duration in 3. Wait — 90 Seconds to 180 or 240 seconds to account for longer videos. Step 4 — Fetch Clip Results Using the Job ID from Step 2, the workflow calls the WayinVideo results endpoint to retrieve the completed clips. If WayinVideo has finished processing, the response contains the full list of clips with titles, export links, engagement scores, descriptions, and timestamps. Step 5 — Extract Each Clip A code step reads the clips array from the API response and splits it into individual items — one per clip. For each clip, it extracts the title, export link, score, tags, description, and start and end timestamps. Each clip then flows through the remaining steps independently. Step 6 — Download the Clip File For each clip, the workflow fetches the export link and downloads the video file as a binary attachment. This happens one clip at a time, in sequence. Step 7 — Upload to Google Drive Each downloaded clip file is uploaded to your configured Google Drive folder. The filename is set automatically using the AI-generated clip title from Step 5. Your Drive folder stays organised without any manual work. Key Features ✅ Zero editing required — WayinVideo selects the best moments automatically using AI engagement scoring, no timeline scrubbing needed ✅ Vertical-ready output — AI reframing and 9:16 ratio are enabled by default, making every clip mobile and social media ready straight from Drive ✅ Auto-captioned clips — Captions are added to every clip in the original language using a styled caption template — no subtitle software required ✅ Form-based submission — Any team member can submit a testimonial video without accessing n8n or any other tool ✅ AI-generated filenames — Each clip is named using the WayinVideo-generated title, so your Drive folder is always easy to browse ✅ Client-labelled projects — The client name from the form is sent to WayinVideo as the project label, keeping clip jobs organised in your WayinVideo dashboard ✅ Batch clip processing — All clips from a single video are downloaded and uploaded in one workflow run — no manual repeat steps Customisation Options Increase the clip limit In the 2. WayinVideo — Submit Clipping Task node, change "limit": 5 to a higher number to extract more clips per video — useful for longer testimonial recordings. Switch to landscape output In the same Submit node, change "ratio": "RATIO_9_16" to "RATIO_16_9" and set "enable_ai_reframe" to false to generate widescreen clips for YouTube, website embeds, or sales decks. Change clip length Modify "target_duration" in node 2 from "DURATION_30_60" to "DURATION_15_30" for shorter clips suited to Instagram Stories or TikTok, or "DURATION_60_90" for longer testimonial segments. Organise clips by client in Drive Add a Google Drive node before the upload step to create a new subfolder named after the client — pulling the client name directly from the form — and point the upload to that folder instead of a single shared folder. Notify your team when clips are ready Add a Gmail or Slack node after the 7. Google Drive — Upload Clip step to send a message with the clip title and Drive link each time a new clip is saved. Add a retry loop for long videos Replace the single 90-second wait with a loop — using a Wait node, an HTTP Request poll, and an IF node — so the workflow keeps checking every 60 seconds until all clips are confirmed ready, regardless of video length. Troubleshooting API key not working / WayinVideo returns an authentication error: Confirm you have replaced YOUR_WAYIN_API_KEY_HERE in both node 2 and node 4 — not just one Check that the Authorization header value starts with Bearer followed by your key with no extra spaces or line breaks Verify your WayinVideo account is active and has available processing credits Clip files downloading but not saving correctly to Drive: Check n8n execution logs for binary data errors in the 6. HTTP — Download Clip File step — some WayinVideo export links have a short expiry window If the export link has expired, rerun the workflow with the same video URL to generate a fresh set of export links Support Need help setting this up or want a custom version built for your team or agency? 📧 Email: info@incrementors.com 🌐 Website: https://www.incrementors.com/contact-us/

Why Choose Us?

AI-Powered n8n Templates

GPT-4 powered intelligent engine that generates custom n8n templates from simple descriptions

Premium Quality n8n Templates

Every n8n template is tested and verified to ensure reliability and practical automation value

One-Click Import

Support one-click import to n8n, start using immediately

Ready to Get Started?

Start using AI to generate n8n templates now, or explore our comprehensive n8n templates library with 7000+ proven workflows

Start AI Generation Browse Templates