Loading page
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 1. 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). 2. Fetch Data: The "Get new video" node retrieves unfilled video requests from a Google Sheet (rows where the "VIDEO" column is empty). 3. 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. 4. 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. 5. 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. 6. 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. --- Set Up Steps 1. Google Sheet Setup: Create a Google Sheet with columns: PROMPT, DURATION, VIDEO, and YOUTUBE_URL. Share the Sheet link in the "Get new video" node. 2. API Keys: Obtain a Fal.run API key (for Veo3) and set it in the "Create Video" node (Header: Authorization: Key YOURAPIKEY). Get an Upload-Post API key (for YouTube uploads) and configure the "HTTP Request" node (Header: Authorization: Apikey YOUR_API_KEY). 3. YouTube Upload Configuration: Replace YOUR_USERNAME in the "HTTP Request" node with your Upload-Post profile name. 4. Schedule Trigger: Configure the "Schedule Trigger" node to run periodically (e.g., every 5 minutes). --- Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. --- Need help customizing? Contact me for consulting and support or add me on Linkedin.
by Davide BoizzaAutomate 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 1. Triggers daily to generate a new idea with OpenAI (or your custom prompt). 2. Creates a video prompt formatted specifically for Google Veo3. 3. Generates a cinematic video using the Veo3 API. 4. Logs the video data into a Google Sheet. 5. Retrieves the final video URL once Veo3 finishes rendering. 6. Uploads the video to Blotato for publishing. 7. Auto-posts the video to Instagram, TikTok, YouTube, Facebook, LinkedIn, Threads, Twitter (X), Pinterest, and Bluesky. Setup 1. Add your OpenAI API key to the GPT-4.1 nodes. 2. Connect your Veo3 API credentials in the video generation node. 3. Link your Google Sheets account and use a sheet with columns: Prompt, Video URL, Status. 4. Connect your Blotato API key and set your platform IDs in the Assign Social Media IDs node. 5. 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
by Dr. FirasWho is this for? This template is designed for internal support teams, product specialists, and knowledge managers in technology companies who want to automate ingestion of product documentation and enable AI-driven, retrieval-augmented question answering via WhatsApp. What problem is this workflow solving? Support agents often spend too much time manually searching through lengthy documentation, leading to inconsistent or delayed answers. This solution automates importing, chunking, and indexing product manuals, then uses retrieval-augmented generation (RAG) to answer user queries accurately and quickly with AI via WhatsApp messaging. What these workflows do Workflow 1: Document Ingestion & Indexing Manually triggered to import product documentation from Google Docs. Automatically splits large documents into chunks for efficient searching. Generates vector embeddings for each chunk using OpenAI embeddings. Inserts the embedded chunks and metadata into a MongoDB Atlas vector store, enabling fast semantic search. Workflow 2: AI-Powered Query & Response via WhatsApp Listens for incoming WhatsApp user messages, supporting various types: Text messages: Plain text queries from users. Audio messages: Voice notes transcribed into text for processing. Image messages: Photos or screenshots analyzed to provide contextual answers. Document messages: PDFs, spreadsheets, or other files parsed for relevant content. Converts incoming queries to vector embeddings and performs similarity search on the MongoDB vector store. Uses OpenAI’s GPT-4o-mini model with retrieval-augmented generation to produce concise, context-aware answers. Maintains conversation context across multiple turns using a memory buffer node. Routes different message types to appropriate processing nodes to maximize answer quality. Setup Setting up vector embeddings 1. Authenticate Google Docs and connect your Google Docs URL containing the product documentation you want to index. 2. Authenticate MongoDB Atlas and connect the collection where you want to store the vector embeddings. Create a search index on this collection to support vector similarity queries. 3. Ensure the index name matches the one configured in n8n (data_index). 4. See the example MongoDB search index template below for reference. Setting up chat 1. Authenticate the WhatsApp node with your Meta account credentials to enable message receiving and sending. 2. Connect the MongoDB collection containing embedded product documentation to the MongoDB Vector Search node used for similarity queries. 3. Set up the system prompt in the Knowledge Base Agent node to reflect your company’s tone, answering style, and any business rules, ensuring it references the connected MongoDB collection for context retrieval. Make sure Both MongoDB nodes (in ingestion and chat workflows) are connected to the same collection with: An embedding field storing vector data, Relevant metadata fields (e.g., document ID, source), and The same vector index name configured (e.g., data_index). Search Index Example: { "mappings": { "dynamic": false, "fields": { "_id": { "type": "string" }, "text": { "type": "string" }, "embedding": { "type": "knnVector", "dimensions": 1536, "similarity": "cosine" }, "source": { "type": "string" }, "doc_id": { "type": "string" } } } }
by NovaNodeHow it works This workflow is an interactive, hands-on tutorial designed to teach you the absolute basics of JSON (JavaScript Object Notation) and, more importantly, how to use it within n8n. It's perfect for beginners who are new to automation and data structures. The tutorial is structured as a series of simple steps. Each node introduces a new, fundamental concept of JSON: 1. Key/Value Pairs: The basic building block of all JSON. 2. Data Types: It then walks you through the most common data types one by one: String (text) Number (integers and decimals) Boolean (true or false) Null (representing "nothing") Array (an ordered list of items) Object (a collection of key/value pairs) 3. Using JSON with Expressions: The most important step! It shows you how to dynamically pull data from a previous node into a new one using n8n's expressions ({{ }}). 4. Final Exam: A final node puts everything together, building a complete JSON object by referencing data from all the previous steps. Each node has a detailed sticky note explaining the concept in simple terms. Set up steps Setup time: 0 minutes! This is a tutorial workflow, so there is no setup required. 1. Simply click the "Execute Workflow" button to run it. 2. Follow the instructions in the main sticky note: click on each node in order, from top to bottom. 3. For each node, observe the output in the right-hand panel and read the sticky note next to it to understand what you're seeing. By the end, you'll have a solid understanding of what JSON is and how to work with it in your own n8n workflows.
by Lucas PeyrinClone 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: 1. Downloads a TikTok video and extracts its thumbnail, audio, and caption 2. Transcribes the audio and saves original text into Google Sheets 3. Uses Perplexity AI to suggest a new content idea in the same niche 4. Rewrites the script, caption, and overlay using GPT-4o 5. Generates a new video with your avatar using Captions.ai 6. Adds subtitles and overlay text with JSON2Video 7. Saves metadata to Google Sheets for tracking 8. Sends the final video to Telegram for preview 9. Auto-publishes the video to Instagram, YouTube, TikTok, Facebook, LinkedIn, Threads, X (Twitter), Pinterest, and Bluesky via Blotato Setup 1. Connect your Telegram bot to the trigger node. 2. Add your OpenAI, Perplexity, Cloudinary, Captions.ai, and Blotato API keys. 3. Make sure your Google Sheet is ready with the appropriate columns. 4. Replace the default avatar name in the Captions.ai node with yours. 5. Fill in your social media account IDs in the "Assign Platform IDs" node. 6. 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
by Dr. FirasViral TikTok Video Machine: Auto-Create Videos with Your AI Avatar --- Who is this for? This workflow is for content creators, marketers, and agencies who want to use Veed.io’s AI avatar technology to produce short, engaging TikTok videos automatically. It’s ideal for creators who want to appear on camera without recording themselves, and for teams managing multiple brands who need to generate videos at scale. --- What problem this workflow solves Manually creating videos for TikTok can take hours — finding trends, writing scripts, recording, and editing. By combining Veed.io, ElevenLabs, and GPT-4, this workflow transforms a simple Telegram input into a ready-to-post TikTok video featuring your AI avatar powered by Veed.io — speaking naturally with your cloned voice. --- What this workflow does This automation links Veed.io’s video-generation API with multiple AI tools: Analyzes TikTok trends via Perplexity AI Writes a 10-second viral script using GPT-4 Generates your voiceover via ElevenLabs Uses Veed.io (Fabric 1.0 via FAL.ai) to animate your avatar and sync the lips to the voice Creates an engaging caption + hashtags for TikTok virality Publishes the video automatically via Blotato TikTok API Logs all results to Google Sheets for tracking --- Setup 1. Telegram Bot Create your bot via @BotFather Configure it as the trigger for sending your photo and theme 2. Connect Veed.io Create an account on Veed.io Get your FAL.ai API key (Veed Fabric 1.0 model) Use HTTPS image/audio URLs compatible with Veed Fabric 3. Other APIs Add Perplexity, ElevenLabs, and Blotato TikTok keys Connect your Google Sheet for logging results --- How to customize this workflow Change your Avatar: Upload a new image through Telegram, and Veed.io will generate a new talking version automatically. Modify the Script Style: Adjust the GPT prompt for tone (educational, funny, storytelling). Adjust Voice Tone: Tweak ElevenLabs stability and similarity settings. Expand Platforms: Add Instagram, YouTube Shorts, or X (Twitter) posting nodes. Track Performance: Customize your Google Sheet to measure your most successful Veed.io-based videos. --- Expected Outcome In just a few seconds after sending your photo and theme, this workflow — powered by Veed.io — creates a fully automated TikTok video featuring your AI avatar with natural lip-sync and voice. The result is a continuous stream of viral short videos, made without cameras, editing, or effort. --- Import the JSON file in n8n, add your API keys (including Veed.io via FAL.ai), and start generating viral TikTok videos starring your AI avatar today! Watch This Tutorial --- Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube
by Dr. FirasApply to jobs automatically from Google Sheets with status tracking Who's it for Job seekers who want to streamline their application process, save time on repetitive tasks, and never miss following up on applications. Perfect for anyone managing multiple job applications across different platforms. What it does This workflow automatically applies to jobs from a Google Sheet, tracks application status, and keeps you updated with notifications. It handles the entire application lifecycle from submission to status monitoring. Key features: Reads job listings from Google Sheets with filtering by priority and status Automatically applies to jobs on LinkedIn, Indeed, and other platforms Updates application status in real-time Checks application status every 2 days and notifies you of changes Sends email notifications for successful applications and status updates Prevents duplicate applications and manages rate limiting How it works The workflow runs on two main schedules: Daily Application Process (9 AM, weekdays): 1. Reads your job list from Google Sheets 2. Filters for jobs marked as "Not Applied" with Medium/High priority 3. Processes each job individually to prevent rate limiting 4. Applies to jobs using platform-specific APIs (LinkedIn, Indeed, etc.) 5. Updates the sheet with application status and reference ID 6. Sends confirmation email for each application Status Monitoring (Every 2 days at 10 AM): 1. Checks all jobs with "Applied" status 2. Queries job platforms for application status updates 3. Updates the sheet if status has changed 4. Sends notification emails for status changes (interviews, rejections, etc.) Requirements Google account with Google Sheets access Gmail account for notifications Resume stored online (Google Drive, Dropbox, etc.) API access to job platforms (LinkedIn, Indeed) - optional for basic version n8n instance (self-hosted or cloud) How to set up Step 1: Create Your Job Tracking Sheet Create a Google Sheet with these exact column headers: | Job_ID | Company | Position | Status | Applied_Date | Last_Checked | Application_ID | Notes | Job_URL | Priority | |--------|---------|----------|--------|--------------|--------------|----------------|-------|---------|----------| | JOB001 | Google | Software Engineer | Not Applied | | | | | https://careers.google.com/jobs/123 | High | | JOB002 | Microsoft | Product Manager | Not Applied | | | | | https://careers.microsoft.com/jobs/456 | Medium | Column explanations: Job_ID: Unique identifier (JOB001, JOB002, etc.) Company: Company name Position: Job title Status: Not Applied, Applied, Under Review, Interview Scheduled, Rejected, Offer Applied_Date: Auto-filled when application is submitted Last_Checked: Auto-updated during status checks Application_ID: Platform reference ID (auto-generated) Notes: Additional information or application notes Job_URL: Direct link to job posting Priority: High, Medium, Low (Low priority jobs are skipped) Step 2: Configure Google Sheets Access 1. In n8n, go to Credentials → Add Credential 2. Select Google Sheets OAuth2 API 3. Follow the OAuth setup process to authorize n8n 4. Test the connection with your job tracking sheet Step 3: Set Up Gmail Notifications 1. Add another credential for Gmail OAuth2 API 2. Authorize n8n to send emails from your Gmail account 3. Test by sending a sample email Step 4: Update Workflow Configuration In the "Set Configuration" node, update these values: spreadsheetId: Your Google Sheet ID (found in the URL) resumeUrl: Direct link to your resume (make sure it's publicly accessible) yourEmail: Your email address for notifications coverLetterTemplate: Customize your cover letter template Step 5: Customize Application Logic For basic version (no API access): The workflow includes placeholder HTTP requests that you can replace with actual job platform integrations. For advanced version (with API access): Replace LinkedIn/Indeed HTTP nodes with actual API calls Add your API credentials to n8n's credential store Update the platform detection logic for additional job boards Step 6: Test and Activate 1. Add 1-2 test jobs to your sheet with "Not Applied" status 2. Run the workflow manually to test 3. Check that the sheet gets updated and you receive notifications 4. Activate the workflow to run automatically How to customize the workflow Adding New Job Platforms 1. Update Platform Detection: Modify the "Check Platform Type" node to recognize new job board URLs 2. Add New Application Node: Create HTTP request nodes for new platforms 3. Update Status Checking: Add status check logic for the new platform Customizing Application Strategy Rate Limiting: Add "Wait" nodes between applications (recommended: 5-10 minutes) Application Timing: Modify the cron schedule to apply during optimal hours Priority Filtering: Adjust the filter conditions to match your criteria Multiple Resumes: Use conditional logic to select different resumes based on job type Enhanced Notifications Slack Integration: Replace Gmail nodes with Slack for team notifications Discord Webhooks: Send updates to Discord channels SMS Notifications: Use Twilio for urgent status updates Dashboard Updates: Connect to Notion, Airtable, or other productivity tools Advanced Features AI-Powered Personalization: Use OpenAI to generate custom cover letters Job Scoring: Implement scoring logic based on job requirements vs. your skills Interview Scheduling: Auto-schedule interviews when status changes Follow-up Automation: Send follow-up emails after specific time periods Important Notes Platform Compliance Always respect rate limits to avoid being blocked Follow each platform's Terms of Service Use official APIs when available instead of web scraping Don't spam job boards with excessive applications Data Privacy Store credentials securely using n8n's credential store Don't hardcode API keys or personal information in nodes Regularly review and clean up old application data Ensure your resume link is secure but accessible Quality Control Start with a small number of jobs to test the workflow Review application success rates and adjust strategy Monitor for errors and set up proper error handling Keep your job list updated and remove expired postings This workflow transforms job searching from a manual, time-consuming process into an automated system that maximizes your application efficiency while maintaining quality and compliance.
by VipinWWho this is for This workflow is for digital marketing agencies or sales teams who want to automatically find business leads based on industry & location, gather their contact details, and send personalized cold emails — all from one form submission. --- What this workflow does This workflow starts every time someone submits the Lead Machine Form. It then: Scrapes business data (company name, website, phone, address, category) using Apify based on business type & location. Extracts the best email address from each business website using Google Gemini AI. Stores valid leads in Google Sheets. Generates cold email content (subject + body) with AI based on your preferred tone (Friendly, Professional, Simple). Sends the cold email via Gmail. Updates the sheet with send status & timestamp. --- Setup To set this workflow up: 1. Form Trigger – Customize the “Lead Machine” form fields if needed (Business Type, Location, Lead Number, Email Style). 2. Apify API – Add your Apify Actor Endpoint URL in the HTTP Request node. 3. Google Gemini – Add credentials for extracting email addresses. 4. Google Sheets – Connect your sheet for storing leads & email status. 5. OpenAI – Add your credentials for cold email generation. 6. Gmail – Connect your Gmail account for sending cold emails. --- How to customize this workflow to your needs Change the AI email prompt to reflect your brand’s voice and offer. Add filters to only target leads that meet specific criteria (e.g., website must exist, email must be verified). Modify the Google Sheets structure to track extra info like “Follow-up Date” or “Lead Source”. Switch Gmail to another email provider if preferred. ---
by Rakin JakariaCreate AI Viral Videos using NanoBanana 2 PRO & VEO3.1 and Publish via Blotato Who is this for? This template is for content creators, marketers, agencies, and UGC studios who want to turn a simple Telegram message into AI-generated vertical videos, automatically published across multiple social platforms using Blotato. --- What problem is this workflow solving? / Use case Creating short-form video ads usually requires: Designing visuals Writing hooks and captions Generating or editing video Manually uploading to TikTok, Instagram, YouTube, Facebook, LinkedIn, X, etc. This workflow solves that by automating the full pipeline from image + idea → edited image → AI video → multi-platform post. --- What this workflow does 1. Create Image with NanoBanana 2 PRO User sends a photo + caption idea to a Telegram bot. OpenAI Vision analyzes the reference image. An LLM builds a UGC-style image prompt. NanoBanana 2 PRO generates an enhanced, UGC-friendly image. 2. Generate Video with VEO3.1 An AI Agent structures a detailed Veo prompt (scene, camera, lighting, audio). Prompt is optimized and sent to VEO3.1 reference-to-video. The result is a 9:16, ~8s vertical video downloaded back into n8n. 3. Publish with Blotato Video is uploaded to Blotato. Posts are created for TikTok, Instagram, YouTube, Facebook, LinkedIn, and X using the AI-generated caption, title, and hashtags. A final “Published” message is sent on Telegram. --- Setup 1. Create and configure: Telegram bot (token in Set: Bot Token (Placeholder) node). OpenAI credentials. Fal.ai API key (for NanoBanana 2 PRO + VEO3.1). Blotato account + API credentials and connected social accounts. 2. Import the template into n8n and update all credential references. 3. Test by sending a product image + short idea to your Telegram bot. --- How to customize this workflow to your needs Edit the UGC image prompt system message to change visual style (more cinematic, minimal, etc.). Adjust the VEO prompt optimizer to tweak duration, mood, or camera movement. Enable/disable specific Blotato platforms depending on where you want to publish. Modify the caption/hashtag generation logic to match your brand tone, language, or niche. --- Need help or want to customize this? Contact: LinkedIn YouTube: @DRFIRASS Workshops: Mes Ateliers n8n --- Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube / Mes Ateliers n8n
by Dr. FirasThis workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automatically monitors keyword rankings across search engines to track SEO performance and identify optimization opportunities. It saves you time by eliminating the need to manually check keyword positions and provides comprehensive ranking data for strategic SEO decision making. Overview This workflow automatically scrapes search engine results pages (SERPs) to track keyword rankings, competitor positions, and search features. It uses Bright Data to access search results without restrictions and AI to intelligently parse ranking data, track changes, and identify SEO opportunities. Tools Used n8n: The automation platform that orchestrates the workflow Bright Data: For scraping search engine results without being blocked OpenAI: AI agent for intelligent ranking analysis and SEO insights Google Sheets: For storing keyword ranking data and tracking changes How to Install 1. Import the Workflow: Download the .json file and import it into your n8n instance 2. Configure Bright Data: Add your Bright Data credentials to the MCP Client node 3. Set Up OpenAI: Configure your OpenAI API credentials 4. Configure Google Sheets: Connect your Google Sheets account and set up your ranking tracking spreadsheet 5. Customize: Define target keywords and ranking monitoring parameters Use Cases SEO Teams: Track keyword performance and identify ranking improvements Content Marketing: Monitor content ranking success and optimization needs Competitive Analysis: Track competitor keyword rankings and strategies Digital Marketing: Measure organic search performance and ROI Connect with Me Website: https://www.nofluff.online YouTube: https://www.youtube.com/@YaronBeen/videos LinkedIn: https://www.linkedin.com/in/yaronbeen/ Get Bright Data: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission) #n8n #automation #keywordrankings #seo #searchrankings #brightdata #webscraping #seotools #n8nworkflow #workflow #nocode #ranktracking #keywordmonitoring #seoautomation #searchmarketing #organicseo #seoresearch #rankinganalysis #keywordanalysis #searchengines #seomonitoring #digitalmarketing #serp #keywordtracking #seoanalytics #searchoptimization #rankingreports #keywordresearch #seoinsights #searchperformance
by Yaron BeenHow it works This template is an interactive, step-by-step tutorial designed to teach you the most important skill in n8n: using expressions to access and manipulate data. If you know what JSON is but aren't sure how to pull a specific piece of information from one node and use it in another, this workflow is for you. It starts with a single "Source Data" node that acts as our filing cabinet, and then walks you through a series of lessons, each demonstrating a new technique for retrieving and transforming that data. You will learn how to: 1. Access a simple value from a previous node. 2. Use n8n's built-in selectors like .last() and .first(). 3. Get a specific item from a list (Array). 4. Drill down into nested data (Objects). 5. Combine these techniques to access data in an array of objects. 6. Go beyond simple retrieval by using JavaScript functions to do math or change text. 7. Inspect data with utility functions like Object.keys() and JSON.stringify(). 8. Summarize data from multiple items using .all() and arrow functions. Set up steps Setup time: 0 minutes! This workflow is a self-contained tutorial and requires no setup or external credentials. 1. Click "Execute Workflow" to run the entire tutorial. 2. Follow the flow from the "Source Data" node to the "Final Exam" node. 3. For each lesson, click on the node to see how its expressions are configured in the parameters panel. 4. Read the detailed sticky note next to each lesson—it breaks down exactly how the expression works and why. By the end, you'll have the foundational knowledge to connect data and build powerful, dynamic workflows in n8n.
by Lucas PeyrinWho’s it for This template is designed for anyone who wants to use Telegram as a personal AI assistant hub. If you often juggle tasks, emails, calendars, and expenses across multiple tools, this workflow consolidates everything into one seamless AI-powered agent. What it does Jarvis listens to your Telegram messages (text or audio) and processes them with OpenAI. Based on your request, it can: Manage tasks (create, complete, or delete) Handle calendar events (schedule, reschedule, or check availability) Send, draft, or fetch emails with Gmail Retrieve Google Contacts Log and track expenses All responses are returned directly to Telegram, giving you a unified command center. How to set up 1. Clone this template into your n8n workspace. 2. Connect your accounts (Telegram, Gmail, Google Calendar, Contacts, etc.). 3. Add your OpenAI API key in the Credentials section. 4. Test by sending a Telegram message like “Create a meeting tomorrow at 3pm” or “Add expense $50 for lunch.” or "Draft a reply with a project proposal to that email from Steve" Requirements n8n instance (cloud or self-hosted) Telegram Bot API credentials Gmail, Google Calendar, and Google Contacts credentials (optional, if using those features) OpenAI API key ElevenLabs API Key (optional, if you need audio note support) How to customize Swap Gmail with another email provider by replacing the Gmail MCP node. Add additional MCP integrations (e.g., Notion, Slack, CRM tools). Adjust memory length to control how much context Jarvis remembers. With this template, you can transform Telegram into your all-in-one AI assistant, simplifying workflows and saving hours every week.
by Jitesh DugarTelegram Nutrition AI Assistant (Alternative to Cal AI App) > AI-powered nutrition assistant for Telegram — log meals, set goals, and get personalized daily reports with Google Sheets integration. Description This n8n template creates a Telegram-based Nutrition AI Assistant designed as an open-source alternative to the Cal AI mobile app. It allows users to interact with an AI agent via text, voice, or images to track meals, calculate macros, and monitor nutrition goals directly from Telegram. The system integrates Google Sheets as the database, handling both user profiles and meal logs, while leveraging Gemini AI for natural conversation, food recognition, and daily progress reports. Key Features Multi-input support: Text, voice messages (transcribed), and food images (AI analysis). Macro calculation: Automatic estimation of calories, proteins, carbs, and fats. User-friendly registration: Simple onboarding without storing personal health data (no weight/height required). Goal tracking: Users can set and update calorie and protein targets. Daily reports: Personalized progress messages with visual progress bars. Google Sheets integration: Profile table for user targets. Meals table for food logs. Advanced n8n nodes: Includes use of Merge, Subworkflow, and Code nodes for data processing and report generation. Acknowledgment Inspired by the Cal AI concept — this template demonstrates how to reproduce its main functionality with n8n, Telegram, and AI agents as a flexible, open-source automation workflow. Tags telegram ai-assistant nutrition meal-tracking google-sheets food-logging voice-transcription image-analysis daily-reports n8n-template merge-node subworkflow-node code-node telegram-trigger google-gemini Use Case Use this template if you want to: Log meals using text, images, or voice messages. Track nutrition goals (calories, proteins) with daily progress updates. Provide a chat-based nutrition assistant without building a full app. Store structured nutrition data in Google Sheets for easy access and analysis. Example User Interactions User sends a photo of a meal → AI analyzes the food and logs calories/macros. User sends a voice message → AI transcribes and logs the meal. User types “report” → AI returns a daily nutrition summary with progress bars. User says “update my protein goal” → AI updates profile in Google Sheets. Required Credentials Telegram Bot API (Bot Token) Google Sheets API credentials AI Provider API (Google Gemini or compatible LLM) Setup Instructions 1. Create two Google Sheets tables: Profile: User_ID, Name, Calories_target, Protein_target Meals: User_ID, Date, Meal_description, Calories, Proteins, Carbs, Fats 2. Configure the Telegram Trigger with your bot token. 3. Connect your AI provider credentials (Gemini recommended). 4. Connect Google Sheets with your credentials. 5. ▶ Deploy the workflow in n8n. 6. Start interacting with your nutrition assistant via Telegram. Extra Notes Green section: Handles Telegram trigger and user check. Red section: Registers new users and sets goals. Blue section: Processes text, voice, and images. Yellow section: Generates nutrition reports. Purple section: Main AI agent controlling tools and logic. --- Need Assistance? If you’d like help customizing or extending this workflow, feel free to reach out: Email: johnsilva11031@gmail.com LinkedIn: John Alejandro Silva Rodríguez
by John Alejandro SIlvaAutomate AI Video Creation & Multi-Platform Publishing with Veo 3.1 & Blotato Who is this for? This workflow is designed for content creators, marketers, and automation enthusiasts who want to produce professional AI-generated videos and publish them automatically on social media — without editing or manual uploads. Perfect for those using Veo 3.1, GPT-4, and Blotato to scale video creation. --- What problem is this workflow solving? Creating short-form content (TikTok, Instagram Reels, YouTube Shorts) is time-consuming — from writing scripts to video editing and posting. This workflow eliminates the manual steps by combining AI storytelling + video generation + automated publishing, letting you focus on creativity while your system handles production and distribution. --- What this workflow does 1. Reads new ideas from Google Sheets 2. Generates story scripts using GPT-4 3. Creates cinematic videos using Veo 3.1 (fal.ai/veo3.1/reference-to-video) with 3 input reference images 4. Uploads the final video automatically to Google Drive 5. Publishes the video across multiple platforms (TikTok, Instagram, Facebook, X, LinkedIn, YouTube) via Blotato 6. Updates Google Sheets with video URL and status (Completed / Failed) --- Setup Required accounts: OpenAI → GPT-4 API key fal.ai → Veo 3.1 API key Google Cloud Console → Sheets & Drive connection Blotato → API key for social media publishing Configuration steps: 1. Copy the Google Sheets structure: A: id_video B: niche C: idea D: url_1 E: url_2 F: url_3 G: url_final H: status 2. Add your API keys to the Workflow Configuration node. 3. Insert three image URLs and a short idea into your sheet. 4. Wait for the automation to process and generate your video. --- How to customize this workflow Change duration or aspect ratio → Edit the Veo 3.1 node JSON body (duration, aspect_ratio) Modify prompt style → Adjust the “Optimize Prompt for Veo” node for your desired tone or cinematic look Add more platforms → Extend Blotato integration to publish on Pinterest, Reddit, or Threads Enable Telegram Trigger → Allow users to submit ideas and images directly via Telegram --- Expected Outcome Within 2–3 minutes, your idea is transformed into a full cinematic AI video — complete with storytelling, visuals, and automatic posting to your social media channels. Save hours of editing and focus on strategy, creativity, and growth. --- Need help or want to customize this? Contact: LinkedIn YouTube: @DRFIRASS Workshops: Mes Ateliers n8n --- Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube / Mes Ateliers n8n
by Dr. FirasDescription This workflow automates the process of scraping the latest discussions from HackerNews, transforming raw threads into human readable content using Google Gemini, and exporting the final content into a well-formatted Google Doc. Overview This n8n workflow is responsible for extracting trending posts from the HackerNews API. It loops through each item, performs HTTP data extraction, utilizes Google Gemini to generate human-readable insights, and then exports the enriched content into Google Docs for distribution, archiving, or content creation. Who this workflow is for Tech Newsletter Writers: Automate the collection and summarization of trending HackerNews posts for inclusion in weekly or daily newsletters. Content Creators & Bloggers: Quickly generate structured summaries and insights from HackerNews threads to use as inspiration or supporting content for blog posts, videos, or social media. Startup Founders & Product Builders: Monitor HackerNews for discussions relevant to your niche or competitors, and keep a pulse on the community’s opinions. Investors & Analysts: Surface early signals from the tech ecosystem by identifying what’s trending and how the community is reacting. Researchers & Students: Analyze popular discussions and emerging trends in technology, programming, and startups—enriched with AI-generated insights. Digital Agencies & Consultants: Offer HackerNews monitoring and insight reports as a value-added service to clients interested in the tech space. Tools Used n8n: The core automation engine that manages the trigger, transformation, and export. HackerNews API: Provides access to trending or new HN posts. Google Gemini: Enriches HackerNews content with structured insights and human-like summaries. Google Docs: Automatically creates and updates a document with the enriched content, ready for sharing or publishing. How to Install Import the Workflow: Download the .json file and import it into your n8n instance. Set Up HackerNews Source: Choose whether to use the HN API (via HTTP Request node) or RSS Feed node. Configure Gemini API: Add your Google Gemini API key and design the prompt to extract pros/cons, key themes, or insights. Set Up Google Docs Integration: Connect your Google account and configure the Google Docs node to create/update a document. Test and Deploy: Run a test job to ensure data flows correctly and outputs are formatted as expected. Use Cases Tech Newsletter Authors: Generate ready-to-use summaries of trending HackerNews threads. Startup Founders: Stay informed on key discussions, product launches, and community feedback. Investors & Analysts: Spot early trends, technical insights, and startup momentum directly from HN. Researchers: Track community reactions to new technologies or frameworks. Content Creators: Use the enriched data to spark blog posts, YouTube scripts, or LinkedIn updates. Connect with Me Email: ranjancse@gmail.com LinkedIn: https://www.linkedin.com/in/ranjan-dailata/ Get Bright Data: Bright Data (Supports free workflows with a small commission) #n8n #automation #hackernews #contentcuration #aiwriting #geminiapi #googlegemini #techtrends #newsletterautomation #googleworkspace #rssautomation #nocode #structureddata #webscraping #contentautomation #hninsights #aiworkflow #googleintegration #webmonitoring #hnnews #aiassistant #gdocs #automationtools #gptlike #geminiwriter
by Ranjan DailataHow it works The automation loads rows from a Google Sheet of leads that you want to contact. It makes a Google search via Apify for LinkedIn links based on the First name / Last name / Company. Another Apify actor fetches the right LinkedIn profile based on the first profile which is retuned The same process is done for the company that the lead works for, giving extra context. If the lead has a current company listed on their LinkedIn, we use that URL to do the lookup, rather than doing a separate Google search. A call is made to OpenRouter to get an LLM to generate an email based on a prompt designed to do personalized outreach. An email is sent via a Gmail node. Set up steps Connect your Google Sheets + Gmail accounts to use these APIs. Make an account with Apify and enter your credentials. Set your details in the "Set My Data" node to customize the workflow to revolve around your company + value proposition. I would recommend changing the prompt in the "Generate Personalized Email" node to match the tone of voice that you want your agent to have. You can change the guidelines to e.g. change whether the agent introduces itself, and give more examples in the style you want to make the output better.
by Adam JanesA hands-on starter workflow that teaches beginners how to: Pull rows from a Google Sheet Append a new record that mimics a form submission Generate AI-powered text with GPT-4o based on a “Topic” column Write the AI output back into the correct row using an update operation Along the way you’ll learn the three essential Google Sheets operations in n8n (read → append → update), see how to pass sheet data into an OpenAI node, and document each step with sticky-note instructions—perfect for anyone taking their first steps in no-code automation. 0 Prerequisites Google Sheets 1. Open Google Cloud Console → create / select a project. 2. Enable Google Sheets API under APIs & Services. 3. Create an OAuth Desktop credential and connect it in n8n. 4. Share the spreadsheet with the Google account linked to the credential. OpenAI 1. Create a secret key at <https://platform.openai.com/account/api-keys>. 2. In n8n → Credentials → New → choose OpenAI API and paste the key. Sample sheet to copy (make your own copy and use its link) <https://docs.google.com/spreadsheets/d/15i9WIYpqc5lNd5T4VyM0RRptFPdi9doCbEEDn8QglN4/edit?usp=sharing> --- 1 Trigger Manual Trigger – lets you run on demand while learning. (Swap for a Schedule or Webhook once you automate.) --- 2 Read existing rows Node: Get Rows from Google Sheets Reads every row from Sheet1 of your copied file. --- 3 Generate a demo row Node: Generate 1 Row of Data (Set node) Pretends a form was submitted: Name, Email, Topic, Submitted = "Yes" --- 4 Append the new row Node: Append Data to Google Operation append → writes to the first empty line. --- 5 Create a description with GPT-4o 1. OpenAI Chat Model – uses your OpenAI credential. 2. Write description (AI Agent) – prompt = the Topic. 3. Structured Output Parser – forces JSON like: { "description": "…" }. --- 6 Update that same row Node: Update Sheets data Operation update. Matches on column Email to update the correct line. Writes the new Description cell returned by GPT-4o. --- 7 Why this matters Demonstrates the three core Google Sheets operations: read → append → update. Shows how to enrich sheet data with an AI step and push the result right back. Sticky Notes provide inline docs so anyone opening the workflow understands the flow instantly. --- Need help? Robert Breen – Automation Consultant robert.j.breen@gmail.com <https://www.linkedin.com/in/robert-breen-29429625/>
by Robert BreenThis workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automatically monitors competitor pricing changes and website updates to keep you informed of market movements. It saves you time by eliminating the need to manually check competitor websites and provides alerts only when actual changes occur, preventing information overload. Overview This workflow automatically scrapes competitor pricing pages (like ClickUp) and compares current pricing with previously stored data. It uses Bright Data to access competitor websites without being blocked and AI to intelligently extract pricing information, updating your tracking spreadsheet only when changes are detected. Tools Used n8n: The automation platform that orchestrates the workflow Bright Data: For scraping competitor websites without being blocked OpenAI: AI agent for intelligent pricing data extraction and parsing Google Sheets: For storing and comparing historical pricing data How to Install 1. Import the Workflow: Download the .json file and import it into your n8n instance 2. Configure Bright Data: Add your Bright Data credentials to the MCP Client node 3. Set Up OpenAI: Configure your OpenAI API credentials 4. Configure Google Sheets: Connect your Google Sheets account and set up your pricing tracking spreadsheet 5. Customize: Set your competitor URLs and pricing monitoring schedule Use Cases Product Teams: Monitor competitor feature and pricing changes for strategic planning Sales Teams: Stay informed of competitor pricing to adjust sales strategies Marketing Teams: Track competitor messaging and positioning changes Business Intelligence: Build comprehensive competitor analysis databases Connect with Me Website: https://www.nofluff.online YouTube: https://www.youtube.com/@YaronBeen/videos LinkedIn: https://www.linkedin.com/in/yaronbeen/ Get Bright Data: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission) #n8n #automation #competitoranalysis #pricingmonitoring #brightdata #webscraping #competitortracking #marketintelligence #n8nworkflow #workflow #nocode #pricetracking #businessintelligence #competitiveanalysis #marketresearch #competitormonitoring #pricingdata #websitemonitoring #competitorpricing #marketanalysis #competitorwatch #pricingalerts #businessautomation #competitorinsights #markettrends #pricingchanges #competitorupdates #strategicanalysis #marketposition #competitiveintelligence
by Yaron BeenAutomate video ads with NanoBanana, Seedream 4, ChatGPT Image and Veo 3 Who is this for? This template is designed for marketers, content creators, and e-commerce brands who want to automate the creation of professional ad videos at scale. It’s ideal for teams looking to generate consistent, high-quality video ads for social media without spending hours on manual design, editing, or publishing. What problem is this workflow solving? / Use case Creating video ads usually requires multiple tools and a lot of time: writing scripts, designing product visuals, editing videos, and publishing them across platforms. This workflow automates the entire pipeline — from idea to ready-to-publish ad video — ensuring brands can quickly test campaigns and boost engagement without production delays. What this workflow does 1. Generates ad ideas from Telegram input (text + product image). 2. Creates product visuals using multiple AI image engines: Seedream 4.0 (realistic visuals) NanoBanana (image editing & enhancement) ChatGPT Image / GPT-4o (creative variations) 3. Produces cinematic video ads with Veo 3 based on AI-generated scripts. 4. Merges multiple short clips into a polished final ad. 5. Publishes automatically to multiple platforms (TikTok, Instagram, LinkedIn, X, Threads, Facebook, Pinterest, Bluesky, YouTube) via Blotato. 6. Stores metadata and results in Google Sheets & Google Drive for easy tracking. 7. Notifies you via Telegram with the video link and copy. Setup 1. Connect your accounts in n8n: Telegram API (for input and notifications) Google Drive + Google Sheets (storage & tracking) Kie AI API (Seedream + Veo 3) Fal.ai API (NanoBanana + video merging) OpenAI (for script and prompt generation) Blotato API (for social publishing) 2. Prepare a Google Sheet with brand info and settings (product name, category, features, offer, website URL). 3. Deploy the workflow and connect your Telegram bot to start sending ad ideas (photo + caption). 4. Run the workflow — it will automatically generate images, create videos, and publish to your chosen channels. How to customize this workflow to your needs Brand customization: Adjust the Google Sheet values to reflect your brand’s offers and product features. Platforms: Enable/disable specific Blotato nodes depending on which platforms you want to publish to. Video style: Edit the AI agent’s system prompt to control tone, format, and transitions (cinematic, playful, modern, etc.). Notifications: Adapt Telegram nodes to send updates to different team members or channels. Storage: Change the Google Drive folder IDs to store generated videos and images in your preferred location. This workflow lets you go from idea → images → cinematic ad video → auto-published content in minutes, fully automated. --- Watch This Tutorial: Step by Step --- Documentation: Notion Guide --- Need help customizing? Contact me for consulting and support : Linkedin / Youtube
by Dr. FirasCreate viral Ads with NanoBanana & Seedance, publish on socials via upload-post Who is this for? This workflow is designed for marketers, content creators, and small businesses who want to automate the creation of engaging social media ads without spending hours on manual design, video editing, or publishing. --- What problem is this workflow solving? / Use case Manually creating ads for multiple platforms is time-consuming and repetitive. You need to generate visuals, edit videos, add music, and then publish them across social channels. This workflow automates the end-to-end ad production pipeline, saving time while ensuring consistent, professional-quality output. --- What this workflow does Receives ad ideas via Telegram. Uses NanoBanana to generate and edit realistic product images. Transforms images into engaging short videos with Seedance. Generates background music with Suno. Merges video and audio into a polished final ad. Reads brand info and generates ad copy with AI (OpenAI). Publishes ads to Instagram, TikTok, YouTube, Facebook, and X via upload-post. Stores media and campaign data in Google Drive and Google Sheets for tracking. Sends back notifications and previews via Telegram. --- Setup 1. Connect your accounts: Telegram Google Drive Google Sheets OpenAI API NanoBanana API Seedance API Suno API Upload-post 2. Prepare Google Sheets: Add a sheet for brand details (name, category, features, website). Add another sheet for video logs (status, links, captions). 3. Configure upload-post: Ensure your social accounts (TikTok, Instagram, YouTube, Facebook, X) are linked to upload-post. --- How to customize this workflow to your needs Prompts → Adjust the image/video/music prompts to better reflect your brand’s tone and products. Ad copy → Modify the AI prompt inside the Ads Copywriter Generator to control wording, style, and structure. Publishing scope → Choose only the platforms you want (TikTok, Instagram, etc.) inside the upload-post node. Storage → Update Google Drive folder IDs and Google Sheets document IDs to match your own workspace. --- With this template, you get a fully automated viral ad production system powered by AI visuals, video rendering, and auto-publishing across social platforms. Perfect for scaling your content strategy while saving time. Documentation: Notion Guide Demo Video Watch the full tutorial here: YouTube Demo Need help customizing? Contact me for consulting and support : Linkedin / Youtube
by Dr. FirasThis workflow automates the creation of AI-generated virtual try-on images for fashion eCommerce stores. Instead of relying on expensive and time-consuming photoshoots, the system uses AI to generate realistic images of models wearing selected clothing items. This n8n workflow automates the process of generating AI-powered virtual try-on images for a WooCommerce store. It fetches product data from a Google Sheet, uses the Fal.ai Nano Banana model to create an image of a model wearing the clothing item, and then updates both the Google Sheet and the WooCommerce product with the final generated image. --- Advantages Cost Reduction: Eliminates the need for professional photo shoots, saving on models, photographers, and studio expenses. Time Efficiency: Automates the entire workflow—from data input to product update—minimizing manual work. Scalability: Works seamlessly across large product catalogs, making it easy to update hundreds of products quickly. Enhanced eCommerce Experience: Provides shoppers with realistic previews of clothing on models, boosting trust and conversion rates. Marketing Flexibility: The generated images can also be repurposed for ads, social media, and promotional campaigns. Centralized Management: Google Sheets acts as the control center, making it easy to manage inputs and track results. --- How It Works The workflow operates in a sequential, loop-based manner to process multiple products from a spreadsheet. Here is the logical flow: 1. Manual Trigger & Data Fetch: The workflow starts manually (e.g., by clicking "Test workflow"). It first reads data from a specified Google Sheet, looking for rows where the "IMAGE RESULT" column is empty. 2. Loop Processing: It loops over each row of data fetched from the sheet. Each row should contain URLs for a model image and a product image, along with a WooCommerce product ID. 3. API Request to Generate Image: For each item in the loop, the workflow sends a POST request to the Fal.ai Nano Banana API. The request includes the two image URLs and a prompt instructing the AI to create a photo of the model wearing the submitted clothing item. 4. Polling for Completion: The AI processing is asynchronous. The workflow enters a polling loop: it waits for 60 seconds and then checks the status of the processing request. If the status is not COMPLETED, it waits and checks again. This loop continues until the image is ready. 5. Fetching and Storing the Result: Once the status is COMPLETED, the workflow retrieves the URL of the generated image, downloads the image file, and uploads it to a designated folder in Google Drive. 6. Updating Systems: The workflow then performs two crucial update steps: It updates the original Google Sheet row, writing the URL of the final generated image into the "IMAGE RESULT" column. It updates the corresponding product in WooCommerce, adding the generated image to the product's gallery. 7. Loop Continuation: After processing one item, the workflow loops back to process the next row in the Google Sheet until all items are complete. --- Set Up Steps To make this workflow functional, you need to configure three main connections: Step 1: Prepare the Google Sheet Create a Google Sheet with the following columns: IMAGE MODEL, IMAGE PRODUCT, PRODUCT ID, and IMAGE RESULT. Populate the first three columns for each product. The IMAGE RESULT column must be left blank; the workflow will fill it automatically. In the n8n workflow, configure the "Google Sheets" node to point to your specific Google Sheet and worksheet. Step 2: Configure the Fal.ai API Key Create an account at fal.ai and obtain your API key. In the n8n workflow, locate the three "HTTP Request" nodes named "Get Url image", "Get status", and "Create Image". Edit the credentials for these nodes (named "Fal.run API") and update the Value field in the Header Auth to be Key YOURAPIKEY (replacing YOURAPIKEY with your actual key). Step 3: Set Up WooCommerce API Ensure you have the API keys (Consumer Key and Consumer Secret) for your WooCommerce store's REST API. In the n8n workflow, locate the "WooCommerce" node. Edit its credentials and provide the required information: your store's URL and the API keys. This allows the workflow to authenticate and update your products. --- Need help customizing? Contact me for consulting and support or add me on Linkedin.
by Davide BoizzaHow it Works This workflow automatically monitors your Google Ads campaigns every day, analyzing performance with AI-powered scoring to identify scaling opportunities and catch issues before they drain your budget. Each morning at 9 AM, it fetches all active campaign data including clicks, impressions, conversions, costs, and conversion rates from your Google Ads account. The AI analysis engine evaluates four critical dimensions: CTR (click-through rate) to measure ad relevance, conversion rate to assess landing page effectiveness, cost per conversion to evaluate profitability, and traffic volume to identify scale-readiness. Each campaign receives a performance score (0-100 points) and is automatically categorized as Excellent (75+), Good (55-74), Fair (35-54), or Underperforming (0-34). High-performing campaigns trigger instant Slack alerts to your PPC team with detailed scaling recommendations and projected ROI improvements, while underperforming campaigns generate urgent alerts with specific optimization actions. Every campaign is logged to your Google Sheets dashboard with daily metrics, and the system generates personalized email reports—action-oriented scaling plans for top performers and troubleshooting guides for campaigns needing attention. The entire analysis takes minutes, providing your team with daily intelligence reports that would otherwise require hours of manual spreadsheet work and data analysis. --- Who is this for? PPC managers and paid media specialists drowning in campaign data and manual reporting Marketing agencies managing multiple client accounts needing automated performance monitoring E-commerce brands running high-spend campaigns who can't afford budget waste Growth teams looking to scale winners faster and pause losers immediately Anyone spending $5K+ monthly on Google Ads who needs data-driven optimization decisions --- Setup Steps Setup time: Approx. 15-25 minutes (credential configuration, dashboard setup, alert customization) Requirements: Google Ads account with active campaigns Google account with a tracking spreadsheet Slack workspace SMTP email provider (Gmail, SendGrid, etc.) Create a Google Sheets dashboard with two tabs: "Daily Performance" and "Campaign Log" with appropriate column headers. Set up these nodes: Schedule Daily Check: Pre-configured to run at 9 AM daily (adjust timing if needed). Fetch Google Ads Data: Connect your Google Ads account and authorize API access. AI Performance Analysis: Review scoring thresholds (CTR, conversion rate, cost benchmarks). Route by Performance: Automatically splits campaigns into high-performers vs. issues. Update Campaign Dashboard: Connect Google Sheets and select your "Daily Performance" tab. Log All Campaigns: Select your "Campaign Log" tab for historical tracking. Slack Alerts: Connect workspace and configure separate channels for scaling opportunities and performance issues. Generate Action Plan: Customize email templates with your brand voice and action items. Email Performance Report: Configure SMTP and set recipient email addresses. Credentials must be entered into their respective nodes for successful execution. --- Customization Guidance Scoring Weights: Adjust point values for CTR (30), conversion rate (35), cost efficiency (25), and volume (10) in the AI Performance Analysis node based on your business priorities. Performance Thresholds: Modify the 75-point Excellent threshold and 55-point Good threshold to match your campaign quality distribution and industry benchmarks. Benchmark Values: Update CTR benchmarks (5% excellent, 3% good, 1.5% average) and conversion rate targets (10%, 5%, 2%) for your industry. Alert Channels: Create separate Slack channels for different alert types or route critical alerts to Microsoft Teams, Discord, or SMS via Twilio. Email Recipients: Configure different recipient lists for scaling alerts (executives, growth team) vs. optimization alerts (campaign managers). Schedule Frequency: Change from daily to hourly monitoring for high-spend campaigns, or weekly for smaller accounts. Additional Platforms: Duplicate the workflow structure for Facebook Ads, Microsoft Ads, or LinkedIn Ads with platform-specific nodes. Budget Controls: Add nodes to automatically pause campaigns exceeding cost thresholds or adjust bids based on performance scores. --- Once configured, this workflow will continuously monitor your ad spend, identify opportunities worth thousands in additional revenue, and alert you to issues before they waste your budget—transforming manual reporting into automated intelligence. --- Built by Daniel Shashko Connect on LinkedIn
by Daniel ShashkoThis workflow contains community nodes that are only compatible with the self-hosted version of n8n. Description See the transformation in action! Here's an example of what this workflow can achieve: This automation template is designed for content creators, social media managers, and anyone looking to breathe new life into old family photos and historical images. It transforms any old black and white or sepia photograph into a colorized, animated video using cutting-edge AI technology, then automatically publishes the results across multiple social media platforms including Facebook, Instagram, YouTube, and X (Twitter). The workflow combines powerful AI services to create engaging content from vintage photographs: first enhancing and colorizing the image using FLUX Kontext, then bringing it to life with realistic animations using Kling Video AI, and finally distributing the results across your social media channels automatically. Note: The estimated cost per workflow execution is approximately $0.29 USD, covering the AI processing for both image colorization and video animation. The upload-post node only works for self-hosted n8n instances, but you can use the standard HTTP request node for uploading content on n8n Cloud. Who Is This For? Content Creators & Social Media Managers: Transform historical content into engaging videos that capture audience attention and drive engagement across platforms. Family History Enthusiasts: Bring old family photos to life by adding color and motion, creating emotional connections with your audience. Marketing Professionals: Leverage nostalgic content for brand storytelling, using vintage aesthetics to create compelling social media campaigns. Digital Artists & Photo Restorers: Streamline the process of enhancing and sharing restored vintage photographs with automated AI enhancement. Social Media Influencers: Create unique, eye-catching content from historical images that stands out in crowded social feeds. What Problem Does This Workflow Solve? Creating engaging social media content from old photos typically requires multiple manual steps: photo restoration, colorization, animation, and then individual posting to each platform. This workflow addresses these challenges by: Automating Photo Enhancement: Uses advanced AI (FLUX Kontext) to automatically colorize and enhance old photographs, removing artifacts and improving quality. Creating Dynamic Content: Transforms static images into animated videos using Kling Video AI, making historical photos come alive with natural movements. Streamlining Multi-Platform Publishing: Automatically distributes the final animated videos across Facebook, Instagram, YouTube, and X with a single workflow execution. Saving Time & Effort: Eliminates the need for manual photo editing, video creation, and individual social media posting. How It Works 1. Photo Upload: Users submit old photographs through a simple web form, with optional custom animation descriptions. 2. Image Enhancement: The workflow uploads the photo to imgbb, then sends it to FLUX Kontext AI for colorization and quality enhancement. 3. Animation Creation: The colorized image is processed by Kling Video AI to create a 5-second animated video with natural movements. 4. Cloud Storage: The final video is automatically saved to Google Drive for backup and easy access. 5. Multi-Platform Publishing: The animated video is simultaneously posted to Facebook, Instagram, YouTube, and X using the upload-post service. Setup 1. FAL.AI API Key: Sign up at fal.ai and add your API key to the HTTP Request nodes for both FLUX Kontext and Kling Video AI services. 2. ImgBB API Token: Create a free account at api.imgbb.com to get an API token for image hosting, then update the "Upload Image to imgbb" node. 3. Google Drive Connection: Connect your Google Drive account to enable automatic video storage and backup. 4. Upload-Post Service: Create an account at upload-post.com to get your API credentials for multi-platform social media posting. Important: The upload-post node currently only works with self-hosted n8n instances. For n8n Cloud users, replace the upload-post node with standard HTTP request nodes to publish to each social media platform individually. 5. Form Customization: (Optional) Modify the form fields in the "Photo Upload Form" node to collect additional information or customize the user experience. Requirements Accounts: n8n, FAL.AI, ImgBB, Google Drive, upload-post.com API Keys & Credentials: FAL.AI API Key, ImgBB API Token, Google Drive OAuth2, Upload-post.com API Token & User ID File Types: Supports JPG, PNG image formats for photo uploads Cost: Approximately $0.29 USD per workflow execution for AI processing Transform your old photographs into viral social media content with this powerful AI-driven workflow that handles everything from restoration to distribution automatically.
by Juan Carlos Cavero GraciaGenerate product images with NanoBanana Pro to Veo videos and Blotato Who is this for? This workflow is designed for: Content creators and marketers E-commerce and product-based businesses Agencies producing social media visuals and videos Automation builders looking for AI-powered creative pipelines It is ideal for anyone who wants to automate product image and video creation using AI and publish content without manual work. --- What problem is this workflow solving? / Use case Creating product visuals and marketing videos usually requires multiple tools, manual prompt writing, and repetitive steps. This workflow solves: Manual image and video creation Inconsistent visual quality across assets Time-consuming prompt iteration Manual video publishing to social platforms The workflow automates the entire process from image generation to video publishing using AI. --- What this workflow does This workflow provides an end-to-end automation pipeline: 1. Generates high-quality product images using NanoBanana Pro 2. Applies Contact Sheet Prompting to explore multiple visual variations 3. Converts selected images into short marketing videos using Veo 3.1 4. Automatically publishes the final videos via BLOTATO The result is a fully automated creative workflow that turns AI prompts into ready-to-publish video content. --- Setup To use this workflow, you need the following services and credentials: OpenAI API Used for image analysis and prompt generation NanoBanana Pro (fal.ai) Product image generation API: https://fal.ai/models/fal-ai/nano-banana-pro/edit/api Veo 3.1 (fal.ai) Video generation API: https://fal.ai/models/fal-ai/veo3.1/first-last-frame-to-video Blotato Video publishing to social platforms Sign up at BLOTATO All credentials must be added in n8n before running the workflow. --- How to customize this workflow to your needs You can easily adapt this workflow by: Modifying AI prompts to match your brand style Adjusting image composition and realism parameters in NanoBanana Pro Changing video motion, pacing, and aspect ratio in Veo 3.1 Selecting different social platforms or publishing rules in Blotato Replacing or extending individual steps while keeping the same architecture The workflow is modular and can be reused for multiple products or campaigns. Watch This Tutorial --- Need help or want to customize this? Contact: LinkedIn YouTube: @DRFIRASS Workshops: Mes Ateliers n8n --- Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube / Mes Ateliers n8n
by Dr. FirasThis workflow pulls news articles from NewsAPI, Mediastack, and CurrentsAPI on a scheduled basis. Each provider’s results are normalized into a consistent schema, then written into your database (NocoDB by default). Use case: automated aggregation of categorized news for content pipelines, research agents, or editorial queues. What You Must Update Before Running 1. API Keys Replace all placeholder keys: call newsapi.org - Top Headlines → update API_KEY in URL call newsapi.org - categories → update API_KEY call mediastack → update "ACCESS_KEY" in JSON call currentsapi → update "API_KEY" param 2. Database Connection Workflow uses NocoDB to store results. You must: Update the NocoDB API Token credential to your own Ensure your table includes the fields used in the create operations (source_category, title, summary, author, sources, content, images, publisher_date, etc.) If you prefer Google Sheets, Airtable, or another DB: Replace each NocoDB node with your equivalent “create row” operation The Set nodes already provide all normalized fields you need 3. Scheduling All schedulers are disabled by default. Enable the following so the workflow runs automatically: NewsAPI – Top Headlines NewsAPI – Categories Mediastack CurrentsAPI You may change the run times, but all four must be scheduled for the workflow to function as designed. What You Can Configure 1. Categories Defined in: newsapi.org categories mediastack categories Edit these arrays to pull only the categories you care about or to match your API plan limits. 2. Article Limits Adjust article_limit in: newsapi.org categories mediastack categories currentsapi config
by Joel GambleThis workflow automates the entire process of creating, managing, and publishing AI-generated videos using OpenAI Sora2 Pro, Google Sheets, Google Drive, and YouTube. --- Advantages Fully Automated Video Pipeline From idea to YouTube publication with zero manual intervention after setup. Centralized Control via Google Sheets Simple spreadsheet interface — no need to use APIs or dashboards directly. AI-Powered Video Creation Uses OpenAI Sora2 Pro for generating professional-quality videos from text prompts. SEO-Optimized Titles with GPT-5 Automatically creates catchy, keyword-rich titles optimized for YouTube engagement. Cloud Integration Seamless use of Google Drive for file management and YouTube for publishing. Scalable and Repeatable Can handle multiple videos in sequence, triggered manually or at regular intervals. Error-Resilient and Transparent Uses conditional checks (“Completed?” node) and real-time updates in Google Sheets to ensure reliability and visibility. --- How it Works This workflow automates the entire process of generating AI videos and publishing them to YouTube, using a Google Sheet as the central control panel. 1. Trigger & Data Fetch: The workflow is triggered either manually or on a schedule. It starts by reading a specific Google Sheet to find new video requests. A new request is identified as a row where the "PROMPT" and "DURATION" columns are filled, but the "VIDEO" column is empty. 2. AI Video Generation: For each new request, it takes the prompt and duration, then sends a request to the Fal.ai Sora-2 Pro model via its API to generate the video. The system then enters a polling loop, checking the video generation status every 60 seconds until it is COMPLETED. 3. Post-Processing & Upload: Once the video is ready, the workflow performs three parallel actions: Fetch Video & Upload to Drive: It retrieves the generated video file and uploads it to a specified folder in Google Drive for archiving. Generate YouTube Title: It sends the original prompt to OpenAI's GPT-5 (or another specified model) to generate an optimized, SEO-friendly title for the YouTube video. Publish to YouTube: It takes the generated video file and the AI-created title and uses the Upload-Post.com service to automatically publish the video to a connected YouTube channel. 4. Update & Log: Finally, the workflow updates the original Google Sheet row with the URL of the archived video in Google Drive and the newly created YouTube video URL, providing a complete audit trail. --- Set up Steps To configure this workflow, follow these steps: 1. Prepare the Google Sheet: Create a Google Sheet with at least these columns: PROMPT, DURATION, VIDEO, and YOUTUBE_URL. In the n8n "Get new video" and update nodes, configure the documentId and sheetName to point to your specific Google Sheet. 2. Configure Fal.ai API Key: Create an account on fal.ai and obtain your API key. In both the "Create Video" and "Get status" HTTP Request nodes, set up the HTTP Header Authentication. Set the Name to Authorization and the Value to Key YOUR_API_KEY. 3. Set up Upload-Post.com for YouTube: Create an account on Upload-Post.com and get your API key. Connect your YouTube channel as a "profile". In the "HTTP Request" node (for uploading), configure the Header Auth with Name: Authorization and Value: Apikey YOUR_UPLOAD_POST_API_KEY. Replace YOUR_USERNAME in the node's body parameters with the profile name you created on Upload-Post.com (e.g., test1). 4. Configure OpenAI (Optional but Recommended): The "Generate title" node uses an OpenAI model. Ensure you have valid OpenAI API credentials set up in n8n for this node to function and create optimized titles. 5. Finalize Paths and Activate: In the "Upload Video" node, specify the correct Google Drive folder ID where you want the videos to be saved. Once all credentials and paths are set, you can activate the workflow and set the "Schedule Trigger" node to run at your desired interval (e.g., every 5 minutes). --- Need help customizing? Contact me for consulting and support or add me on Linkedin.
by Davide BoizzaAI-Enriched Cold Outreach: Research → Draft → QA → Write-back ============================================================ What this template does ----------------------- Automates cold email drafting from a lead list by: 1. Enriching each lead with LinkedIn profile, LinkedIn company, and Crunchbase data 2. Generating a personalized subject + body with Gemini 3. Auto-reviewing with a Judge agent and writing back only APPROVED drafts to your Data Table Highlights ----------- Hands-off enrichment via RapidAPI; raw JSON stored back on each row Two-agent pattern: Creative Outreach Agent (draft) + Outreach Email Judge (QA) Structured outputs guaranteed by LangChain Structured Output Parsers Data Table–native: reads “unprocessed” rows, writes results to the same row Async polling with Wait nodes for scraper task results How it works (flow) ------------------- 1. Trigger: Manual (replace with Cron if needed) 2. Fetch leads: Data Table “Get row(s)” filters rows where email_subject is empty (pending) 3. Loop: Split in Batches iterates rows 4. Enrichment (runs in parallel): LinkedIn profile: HTTP (company_url) → Wait → Results → Data Table update → linkedin_profile_scrape LinkedIn company: HTTP (company_url) → Wait → Results → Data Table update → linkedin_company_scrape Crunchbase company: HTTP (url_search) → Wait → Results → Data Table update → crunchbase_company_scrape (All calls use host cold-outreach-enrichment-scraper with a RapidAPI key.) 5. Draft (Gemini): “Agent One” composes a concise, personalized email using row fields + enrichment + ABOUT ME block. Structured Output Parser enforces: ``json { "email_subject": "text", "email_content": "text" } ` 6. Prep for QA: “Email Context” maps email_subject, email_content, and email for the judge. 7. QA (Judge): “Judge Agent” returns APPROVED or REVISE (brief feedback allowed). 8. Route: If APPROVED → Data Table “Update row(s)” writes email_subject + email_body (a.k.a. email_content) back to the row. If REVISE → Skipped; loop continues. Required setup --------------- Data Table: “email_linkedin_list” (or your own) with at least: email, First_name, Last_name, Title, Location, Company_Name, Company_site, Linkedin_URL, company_linkedin (if used), Crunchbase_URL, email_subject, email_body, linkedin_profile_scrape, linkedin_company_scrape, crunchbase_company_scrape (string fields for JSON). Credentials: RapidAPI key for cold-outreach-enrichment-scraper (store securely as credential, not hardcoded) Google Gemini (PaLM) API configured in the Google Gemini Chat Model node ABOUT ME block: Replace the sample persona (James / CEO / Company Sample / AI Automations) with your own. Nodes used ----------- Data Table HTTP Request: AI Agent: Google Gemini Chat Model Split in Batches: Main Loop Set: RapidAPI-Key Customization ideas ------------------- Process flags: Add email_generated_at or processed` boolean to prevent reprocessing. Human-in-the-loop: Send drafts to Slack/Email for spot check before write-back. Delivery: After approval, optionally email the draft to the sender for review. Quotas & costs --------------- RapidAPI: Multiple calls per row (three tasks + result polls). Gemini: Token usage for generator + judge per row. Tune batch size and schedule accordingly. Privacy & compliance -------------------- You are scraping and storing person/company data. Ensure lawful basis, respect ToS, and minimize stored data.
by Johnny RafaelUse the n8n Data Tables feature to store, retrieve, and analyze survey results — then let OpenAI automatically recommend the most relevant course for each respondent. --- What this workflow does This workflow demonstrates how to use n8n’s built-in Data Tables to create an internal recommendation system powered by AI. It: Collects survey responses through a Form Trigger Saves responses to a Data Table called Survey Responses Fetches a list of available courses from another Data Table called Courses Passes both Data Tables into an OpenAI Chat Agent, which selects the most relevant course Returns a structured recommendation with: course: the course title reasoning: why it was selected > Trigger: Form submission (manual or public link) --- Who it’s for Perfect for educators, training managers, or anyone wanting to use n8n Data Tables as a lightweight internal database — ideal for AI-driven recommendations, onboarding workflows, or content personalization. --- How to set it up 1 Create your n8n Data Tables This workflow uses two Data Tables — both created directly inside n8n. Table 1: Survey Responses Columns: Name Q1 — Where did you learn about n8n? Q2 — What is your experience with n8n? Q3 — What kind of automations do you need help with? To create: 1. Add a Data Table node to your workflow. 2. From the list, click “Create New Data Table.” 3. Name it Survey Responses and add the columns above. --- Table 2: Courses Columns: Course Description To create: 1. Add another Data Table node. 2. Click “Create New Data Table.” 3. Name it Courses and create the columns above. 4. Copy course data from this Google Sheet: https://docs.google.com/spreadsheets/d/1Y0Q0CnqN0w47c5nCpbA1O3sn0mQaKXPhql2Bc1UeiFY/edit?usp=sharing This Courses Data Table is where you’ll store all available learning paths or programs for the AI to compare against survey inputs. --- 2 Connect OpenAI 1. Go to OpenAI Platform 2. Create an API key 3. In n8n, open Credentials → OpenAI API and paste your key 4. The workflow uses the gpt-4.1-mini model via the LangChain integration --- Key Nodes Used | Node | Purpose | n8n Feature | |------|----------|-------------| | Form Trigger | Collect survey responses | Forms | | Data Table (Upsert) | Stores results in Survey Responses | Data Tables | | Data Table (Get) | Retrieves Courses | Data Tables | | Aggregate + Set | Combines and formats table data | Core nodes | | OpenAI Chat Model (LangChain Agent) | Analyzes responses and courses | AI | | Structured Output Parser | Returns structured JSON output | LangChain | --- Tips for customization Add more Data Table columns (e.g., email, department, experience years) Use another Data Table to store AI recommendations or performance results Modify the Agent system message to customize how AI chooses courses Send recommendations via Email, Slack, or Google Sheets --- Why Data Tables? This workflow shows how n8n’s Data Tables can act as your internal database: Create and manage tables directly inside n8n No external integrations needed Store structured data for AI prompts Share tables across multiple workflows All user data and course content are stored securely and natively in n8n Cloud or Self-Hosted environments. --- Contact Need help customizing this (e.g., expanding Data Tables, connecting multiple surveys, or automating follow-ups)? robert@ynteractive.com Robert Breen ynteractive.com
by Robert BreenScrape physician profiles from BrowserAct to Google Sheets This workflow automates the process of building a targeted database of healthcare providers by scraping physician details for a specific location and syncing them to your records. It leverages BrowserAct to extract data from healthcare directories and ensures your database stays clean by preventing duplicate entries. Target Audience Medical recruiters, pharmaceutical sales representatives, lead generation specialists, and healthcare data analysts. How it works 1. Define Location: The workflow starts by setting the target Location and State in a Set node. 2. Scrape Data: A BrowserAct node executes a task (using the "Physician Profile Enricher" template) to search a healthcare directory (e.g., Healow) for doctors matching the criteria. 3. Parse JSON: A Code node takes the raw string output from the scraper and parses it into individual JSON objects. 4. Update Database: The workflow uses a Google Sheets node to append new records or update existing ones based on the physician's name, preventing duplicates. 5. Notify Team: A Slack node sends a message to a specific channel to confirm the batch job has finished successfully. How to set up 1. Configure Credentials: Connect your BrowserAct, Google Sheets, and Slack accounts in n8n. 2. Prepare BrowserAct: Ensure the Physician Profile Enricher template is saved in your BrowserAct account. 3. Setup Google Sheet: Create a new Google Sheet with the required headers (listed below). 4. Select Spreadsheet: Open the Google Sheets node and select your newly created file and sheet. 5. Set Variables: Open the Define Location node and input your target Location (City) and State. 6. Configure Notification: Open the Slack node and select the channel where you want to receive alerts. Google Sheet Headers To use this workflow, create a Google Sheet with the following headers: Name Specialty Address Requirements BrowserAct account with the Physician Profile Enricher template. Google Sheets account. Slack account. How to customize the workflow 1. Change the Data Source: Modify the BrowserAct template to scrape a different directory (e.g., Zocdoc or WebMD) and update the Google Sheet columns accordingly. 2. Switch Notifications: Replace the Slack node with a Microsoft Teams, Discord, or Email node to suit your team's communication preferences. 3. Enrich Data: Add an AI Agent node after the Code node to format addresses or research the specific clinics listed. Need Help? How to Find Your BrowserAct API Key & Workflow ID How to Connect n8n to BrowserAct How to Use & Customize BrowserAct Templates --- Workflow Guidance and Showcase Video #### Automate Medical Lead Gen: Scrape Healow to Google Sheets & Slack
by Madame AI Team | KaiAutomate Your ETF Comparison: Real-Time Data & Analysis Automate ETF research in Excel with one click. This n8n workflow pulls live data from justetf.com using ISIN codes from your Excel table, extracts key metrics (dividends, fees, 5-year performance), and updates your “Div study” sheet instantly — all triggered by a button in Excel. Perfect for dividend investors, ETF screeners, or portfolio trackers who want fresh, accurate data without manual copy-paste. --- How it works 1. Trigger: Click “Update Table” in Excel → calls n8n via webhook 2. Excel: Logs current time (GMT-2) and reads all rows from “DivComp” table 3. HTTP Request: Fetches ETF profile page from justetf.com using ISIN 4. HTML Extraction: Parses page with CSS selectors to grab dividends, fees, 5Y performance 5. Code Node: Cleans & structures data (e.g., last 5 years of dividends, yield, growth) 6. Update Excel: Writes clean values back to your table (fees, yield, performance, name) --- Setup steps 1. In Excel: Add a button → assign macro that calls your n8n webhook URL (path: /ETF) Ensure table “DivComp” has: ISIN, Dernière mise à jour, Frais, Performance depuis 5 ans, etc. 2. In n8n: Connect Microsoft Excel (OneDrive) credential Update workbook/worksheet/table references if needed Test with 1–2 ISINs first 3. Click “Update Table” → watch data refresh in real time! --- Tags: ETF, Excel, Web Scraping, Investing, Finance, Automation, justetf, Dividend Tracking
by LouisThis n8n template automates the collection, storage, and summarization of technology news and discussions from the n8n Community and Reddit (r/n8n). If you like staying informed but want to reduce daily manual browsing distractions, this workflow is perfect for you. How it works User Intent Detection: The workflow receives your Telegram message and uses an AI Agent (powered by Gemini/Groq) to intelligently classify your intent (Search, Deep-dive, or Casual Chat). Multi-Platform Scraping: Automatically fetches the latest discussions, topics, and comments from the official n8n Community and Reddit via HTTP Requests. Smart Summarization: Extracts complex HTML content and uses the AI to provide concise overviews, or deep-dives into specific forum threads with full contextual history. Seamless Delivery: Formats the AI's response into clean, chunked Telegram messages (handling limits smoothly) and delivers it straight to your chat. Daily Pulse: A scheduled trigger automatically aggregates the hottest topics every morning to keep you updated. How to use 1. Connect your Telegram Bot account to n8n. 2. Connect your Google Gemini and Groq API credentials. 3. (Optional) Connect your MongoDB instance if you want to enable long-term persistent chat memory. 4. Update the Chat ID in the Telegram nodes to route the scheduled Daily Pulse directly to your personal account or group. 5. Activate the workflow and start messaging your new AI assistant. Requirements n8n Version: Built and tested on n8n 2.9.4+. (Note: You may encounter errors on older versions. It is highly recommended to update to the latest n8n version to use this workflow effectively). Telegram Bot token. Google Gemini & Groq API keys. (Optional) MongoDB connection string. Customizing this workflow Change the AI Model: Swap the Gemini or Groq nodes for OpenAI, Claude, or any other supported LLM. Expand the Sources: Duplicate the HTTP Request nodes and adjust the HTML extractors to monitor other platforms like Discord or StackOverflow. Adjust the Schedule: Prefer chat over daily emails? Change the Cron expression to receive weekly summaries or disable it entirely to rely purely on on-demand Telegram queries. --- About the Author Created by: Nguyen Thieu Toan (Jay Nguyen) Email: me@nguyenthieutoan.com Website: nguyenthieutoan.com Company: CEO/Founder of GenStaff (genstaff.net) - AI Staffing Solutions Socials (Facebook / X / LinkedIn): @nguyenthieutoan More templates: n8n.io/creators/nguyenthieutoan
by Nguyễn Thiệu Toàn (Jay Nguyen)Setup & Instructions — fluidX: Create Session, Analyze & Notify Goal: This workflow demonstrates the full fluidX THE EYE integration — starting a live session, inviting both the customer (via SMS) and the service agent (via email), and then accessing the media (photos and videos) created during the session. Captured images are automatically analyzed with AI, uploaded to an external storage (such as Google Drive), and a media summary for the session is generated at the end. The agent receives an email with a link to join the live session. The customer receives an SMS with a link to start sharing their camera. Once both are connected, the agent can view the live feed, and the system automatically stores uploaded images and videos in Google Drive. When the session ends, the workflow collects all media and creates a complete AI-powered session summary (stored and updated in Google Drive). Below is an example screenshot from the customer’s phone: --- Prerequisites Developer account: https://live.fluidx.digital (activate the TEST plan, €0) API docs (Swagger): fluidX.digital API --- Required Credentials 1 fluidX API key (HTTP Header Auth) • Credential name in n8n: fluidx API key • Header name: x-api-key • Header value: YOUR_API_KEY 2 SMTP account (for outbound email) • Credential name in n8n: SMTP account • Configure host, port, username, and password according to your provider • Enable TLS/SSL as required 3 Google Drive account • Used to store photos, videos, and automatically update the session summary files. 4 OpenAI API (for AI analysis & summary) •Used in the Analyze Images (AI) and Generate Summary parts of the workflow. • Credential type: OpenAI • Credential name (suggested): OpenAI account • API Key: your OpenAI API key • Model: e.g. gpt-4.1, gpt-4o, or similar (choose in the OpenAI node settings) --- Configuration (in the “Set Config” node) BASE_URL: https://live.fluidx.digital company / project / billingcode / sku: adjust as needed emailAgent: set before running (empty in template) phoneNumberUser: set before running (empty in template) --- Flow Overview Form Trigger → Create Session → Set Session Vars → Send SMS (User) → Send Email (Agent) → Monitor Media → Analyze Images (AI) → Upload Files to Google Drive → Generate Summary → Update Summary File The workflow starts automatically when a Form submission is received. Users enter the customer’s phone number and agent’s email, and the system creates a new fluidX THE EYE session. As media is uploaded during the session, the workflow automatically retrieves, stores, analyzes, and summarizes it — providing a complete end-to-end automation example for remote inspection, support, or field-service use cases. --- Notes Do not store real personal data inside the template. Manage API keys and secrets via n8n Credentials or environment variables. Log out of https://live.fluidx.digital in the agent’s browser before testing, to ensure a clean invite flow and session creation.
by Olaf TitelHow it works Customer submits your Typeform → instant personalised welcome SMS fires via Twilio Submission logged to Google Sheets with name, phone, timestamp, and nudge tracking Twilio listens 24/7 for replies → marks customer as responded, stops all future nudges Scheduler runs every 6 hours → finds non-responders and sends up to 2 follow-up nudges System stops contacting anyone who replies or hits the 2-nudge limit The three branches | Branch | Trigger | What it does | |--------|---------|--------------| | New Submission | Typeform form submit | Welcome SMS + log to Sheets | | Reply Handler | Incoming Twilio SMS | Mark replied, stop nudges | | Nudge Engine | Schedule every 6hrs | Nudge 1 at 24h, Nudge 2 at 48h | Why this matters | Metric | Manual | This workflow | |--------|--------|---------------| | Speed to lead | Hours or days | Under 10 seconds | | Follow-up consistency | Whoever remembers | 100% automated | | Lead drop-off | High — people go cold fast | Nudges catch non-responders | | Staff time per lead | 5–15 min | Zero | | Revenue at risk | Every ignored inquiry | Recovered automatically | Studies show leads contacted within 5 minutes are 9x more likely to convert. This workflow makes that the default — not the exception. What you need | Tool | Cost | Why | |------|------|-----| | Typeform | Free tier works | Intake/booking form | | Twilio | ~$1/mo + $0.0075/SMS | Send and receive SMS | | Google Sheets | Free | Track submissions and nudge state | A2P 10DLC notice: Twilio requires business registration for production SMS in the US. Allow 2-4 weeks. Your signup form needs opt-in language, terms, and a privacy policy. Set up steps Takes about 15 minutes Create a Google Sheet with columns: customerName · customerPhone · submittedAt · repliedAt · nudgeCount · lastNudgeAt Branch 1 — connect Typeform, select your form, connect Twilio + Google Sheets Branch 2 — connect Twilio trigger for inbound SMS, connect Google Sheets to mark replied Branch 3 — connect Google Sheets to read non-responders, connect Twilio to send nudges Verify Typeform field names match the Extract node exactly (case-sensitive) Submit a test entry with your own phone, reply to it, confirm Sheets updates correctly Toggle workflow Active Learn more at SMB Excel
by David SchreiberDaily Crypto AI Market Insight to Telegram This workflow generates a daily AI-powered crypto market insight and sends it to Telegram using Binance public market data, the Crypto Fear & Greed Index, and Google Gemini. It fetches BTC/USDT daily OHLCV data, calculates technical indicators, builds a structured analysis payload, asks Gemini for a buy/hold/sell confidence breakdown, and delivers the result as a clean Telegram report. It is useful for traders, builders, and crypto enthusiasts who want an automated daily technical summary without manually checking charts. Common use cases: Send a daily BTC market insight to your Telegram Monitor crypto technical indicators automatically Build a personal AI crypto analyst bot Create a lightweight daily trading signal workflow Learn how to combine market data, technical indicators, LLMs, and Telegram in n8n How it works Starts from a Schedule Trigger, which you can customize Sets the trading pair, for example BTCUSDT Fetches 300 daily OHLCV candles from Binance public API Normalizes Binance candle data into readable fields Fetches the latest market price and merges it into the latest candle Fetches the Crypto Fear & Greed Index from Alternative.me Calculates EMA(20), EMA(50), EMA(100), RSI(14), MACD histogram, ADX(14), +DI, and -DI Builds a structured technical payload Sends the payload to Google Gemini Parses Gemini’s response into structured JSON Formats the result into a Telegram message Sends the AI-generated insight to Telegram Setup steps Choose your trading pair in the Set Trading Pair node Connect your Google Gemini credentials Connect your Telegram credentials Set your Telegram chat ID in the Telegram node Adjust the Schedule Trigger if you want a different run time Test the workflow manually Activate the workflow Notes This workflow uses Binance public API data and does not require a Binance API key. The AI insight is generated only from the provided technical payload and should not be treated as financial advice. Need Help? Have questions or want to connect? Reach me on LinkedIn.
by Atha Ahsan Xavier HarisQuick Overview This workflow lets users manage Google Calendar by sending text or voice messages to a Zalo Official Account bot, transcribing voice notes with Google Gemini and using an OpenAI-powered agent to create, update, list, or delete events, then replying in Zalo with the result. How it works 1. Receives an incoming text or voice message through a Zalo Bot trigger. 2. Sends a typing indicator back to the Zalo chat and normalizes key message fields (chat ID, type, text, and voice URL). 3. If the message is a voice note, sends the audio URL to Google Gemini to transcribe it into text. 4. Sends the combined text/transcription to an OpenAI chat model agent that interprets the request in Vietnamese and decides whether to list, create, update, or delete a Google Calendar event. 5. Uses Google Calendar tools to get events and then create, update, or delete the targeted event based on the agent’s extracted parameters. 6. Sends the agent’s Markdown-formatted response back to the user in Zalo, and posts an error message to Zalo if the agent run fails. Setup 1. Install the community node package n8n-nodes-zalo-bot-official and restart n8n if required. 2. Connect your Zalo Bot API credentials and configure the Zalo webhook URL in your Zalo Official Account so incoming messages reach this workflow. 3. Add a Google Calendar OAuth2 credential and set the target calendar account (currently configured as toannguyen96vn@gmail.com) for all calendar operations. 4. Add a Google Gemini (PaLM) API credential for audio transcription and ensure voice messages include a reachable voice_url. 5. Add an OpenAI API credential, select the chat model you want to use (currently gpt-5-mini), and adjust the system prompt/tone if needed.
by Nguyễn Thiệu Toàn (Jay Nguyen)