Fully automated AI video generation & multi-platform publishing
Description This comprehensive n8n automation template orchestrates a complete end-to-end workflow for generating engaging short-form Point-of-View (POV) style videos using multiple AI services and automatically publishing them across major social media platforms. It takes ideas from a Google Sheet and transforms them into finished videos with captions, voiceovers, and platform-specific descriptions, ready for distribution. Who Is This For? Content Creators & Agencies: Mass-produce unique short-form video content for various clients or channels with minimal manual effort. Digital Marketers: Automate video content pipelines to boost online presence and engagement across multiple platforms simultaneously. Social Media Managers: Schedule and distribute consistent video content efficiently without juggling multiple tools and manual uploads. Businesses: Leverage AI to create branded video content for marketing, reducing production time and costs. What Problem Does This Workflow Solve? Creating and distributing high-quality short-form video content consistently across multiple social networks is incredibly time-consuming and resource-intensive. This workflow tackles these challenges by: Automating Idea-to-Video Pipeline: Generates video concepts, image prompts, scripts, images, video clips, and voiceovers using AI. Streamlining Video Assembly: Automatically combines generated assets into a final video using a template. Generating Platform-Optimized Descriptions: Creates relevant descriptions for posts by transcribing the final video audio. Automating Multi-Platform Publishing: Uploads the final video and description to TikTok, Instagram, YouTube, Facebook, and LinkedIn simultaneously. Reducing Manual Workload: Drastically cuts down the time and effort required for video production and distribution. Centralized Tracking: Updates a Google Sheet with results, costs, and status for easy monitoring. How It Works Trigger & Input: Runs on a daily schedule (configurable) and fetches new video ideas from a designated Google Sheet. AI Content Generation: Uses OpenAI to generate video captions and image prompts based on the idea. Uses PiAPI (Flux) to generate images from prompts. Uses PiAPI (Kling) to generate video clips from the images (Image-to-Video). Uses OpenAI to generate a voiceover script based on the captions. Uses ElevenLabs to generate voiceover audio from the script and uploads it to Google Drive. Video Assembly: Combines the generated video clips, captions, and voiceover audio using a Creatomate template to render the final video. Description Generation: Uploads the final video to Google Drive, extracts the audio using OpenAI (Whisper), and generates a social media description using OpenAI (GPT). Multi-Platform Distribution: Uses upload-post.com to upload the final video and generated description to TikTok, Instagram, YouTube, Facebook, and LinkedIn. Tracking & Notification: Updates the original Google Sheet row with output details (video link, costs, tokens used) and sends a completion notification via Discord. Setup Accounts & API Keys: Obtain accounts and generate API keys/credentials for: n8n Google Cloud Platform (for Google Sheets & Google Drive APIs + OAuth Credentials) OpenAI PiAPI ElevenLabs Creatomate upload-post.com Discord (Webhook URL) Google Sheet: Make a copy of the provided Google Sheet Template and connect it in the Load Google Sheet node. Creatomate Template: Set up a video template in Creatomate (use the provided JSON source code as a base) and note its Template ID. Configure Nodes: Enter all API Keys/Credentials in the Set API Keys node and other relevant credential sections (Google nodes, upload-post nodes, etc.). Configure Google Drive nodes (Folder IDs, Permissions). Configure the upload-post.com nodes with your user identifier and necessary platform details (e.g., Facebook Page ID). Customize AI prompts within the OpenAI nodes (Generate Video Captions, Generate Image Prompts, Generate Script, Generate Description...) if desired. Set the Discord Webhook URL in the Notify me on Discord node. Enable Google APIs: Ensure Google Drive API and Google Sheets API are enabled in your Google Cloud Project. Requirements Accounts: n8n, Google (Sheets, Drive, Cloud Platform), OpenAI, PiAPI, ElevenLabs, Creatomate, The social media api Upload-Post, Discord. API Keys & Credentials: API Keys for OpenAI, PiAPI, ElevenLabs, Creatomate, upload-post.com. Google Cloud OAuth 2.0 Credentials. Discord Webhook URL. Templates: A configured Google Sheet based on the template, a configured Creatomate video template. (Potentially) Paid Plans: Some services (OpenAI, PiAPI, Creatomate, upload-post.com) may require paid plans depending on usage volume after free trials/credits are exhausted. Use this template to build a powerful, automated video content factory, scaling your production and distribution efforts across the social media landscape.
Generate AI viral videos with NanoBanana & VEO3, shared on socials via Blotato
Generate AI viral videos with NanoBanana & VEO3, shared on socials via Blotato Who is this for? This workflow is designed for content creators, marketers, and entrepreneurs who want to automate their video production and social media publishing process. If you regularly post promotional or viral-style content on platforms like TikTok, YouTube Shorts, Instagram Reels, LinkedIn, and more, this template will save you hours of manual work. --- What problem is this workflow solving? / Use case Creating viral short-form videos is often time-consuming: You need to generate visuals, write scripts, edit videos, and then manually upload them to multiple platforms. Staying consistent across TikTok, YouTube Shorts, Instagram Reels, LinkedIn, Twitter/X, and others requires constant effort. This workflow solves the problem by automating the entire pipeline from idea → video creation → multi-platform publishing. --- What this workflow does Collects an idea and image from Telegram. Enhances visuals with NanoBanana for user-generated content style. Generates a complete video script with AI (OpenAI + structured prompts). Creates the final video with VEO3 using your custom prompt and visuals. Rewrites captions with GPT to be short, catchy, and optimized for social platforms. Saves metadata in Google Sheets for tracking and management. Auto-uploads the video to all major platforms via Blotato (TikTok, YouTube, Instagram, LinkedIn, Threads, Pinterest, X/Twitter, Bluesky, Facebook). Notifies you on Telegram with a preview link once publishing is complete. --- Setup Connect your accounts: Google Sheets (for video tracking) Telegram (to receive and send media) Blotato (for multi-platform publishing) OpenAI API (for captions, prompts, and image analysis) VEO3 API (for video rendering) Fal.ai (for NanoBanana image editing) Google Drive (to store processed images) Set your credentials in the respective nodes. Adjust the Google Sheet IDs to match your own sheet structure. Insert your Telegram bot token in the Set: Bot Token (Placeholder) node. --- How to customize this workflow to your needs Platforms: Disable or enable only the Blotato social accounts you want to post to. Video style: Adjust the master prompt schema in the Set Master Prompt node to fine-tune tone, camera style, or video format. Captions: Modify the GPT prompt in the Rewrite Caption with GPT-4o node to control length and tone. Notifications: Customize the Telegram nodes to notify team members, not just yourself. Scheduling: Add a Cron trigger if you want automatic posting at specific times. --- ✨ With this workflow, you go from idea → AI-enhanced video → instant multi-platform publishing in just minutes, with almost no manual work. 📄 Documentation: Notion Guide --- Need help customizing? Contact me for consulting and support : Linkedin / Youtube
🎬 YouTube shorts automation tool 🚀
🎬 YouTube Shorts Automation Tool 🚀 Automate the creation of high-performing YouTube Shorts in minutes! Who is this for? 🎯 Content Creators: Generate engaging short videos effortlessly. Marketing Agencies: Produce client-ready content quickly. Business Owners: Promote products/services through viral short-form content. What problem does this solve? 🛠️ Creating short-form video content is time-consuming, complex, and skill-intensive. This workflow automates video creation, eliminating the need for video editing expertise while ensuring SEO optimization, high-quality visuals, and professional voiceovers. How it works 🌟 Enter your video idea into the chat interface. AI generates a script optimized for engagement and SEO. Voiceover is created with realistic AI narration. Relevant visuals are selected to match the script. The video is assembled and delivered via a shareable link. Setup ⚙️ (5-10 min) Connect required APIs (most have free tiers). Follow the guided setup (video tutorial included). Start generating professional YouTube Shorts instantly! Required APIs 🔗 Content Generation: OpenAI, ElevenLabs (script & voiceover) Media Processing: Cloudinary, Replicate (images & storage) Integration Tools: 0codekit, Creatomate (video assembly) Customization 🎨 Adjust script styles & voiceover preferences. Modify visuals to match your brand. Optimize video length and format. 🚀 Start automating your YouTube Shorts today and grow your audience effortlessly!
AI-powered lead generation with Apollo, GPT-4, and Telegram to database
AI-Powered Lead Generation with Apollo, GPT-4, and Telegram to Database Overview This intelligent lead generation workflow transforms voice commands or text input into verified prospect lists through automated Apollo.io scraping. The system processes natural language requests, extracts search parameters using AI, and delivers clean, verified contact data directly to your database. Key Features 🎤 Voice & Text Input Processing Voice Recognition: Converts audio messages to text using OpenAI's transcription API Natural Language Processing: AI agent interprets requests and extracts search criteria Flexible Input: Supports both voice commands and text messages 🔍 Smart Lead Scraping Apollo.io Integration: Automated scraping using official Apollo.io API Dynamic URL Generation: Builds search URLs based on extracted parameters Intelligent Parsing: Processes location, industry, and job title criteria ✅ Email Verification & Filtering Verified Emails Only: Filters results to include only verified email addresses Duplicate Prevention: Compares against existing database to avoid duplicates Data Quality Control: Ensures high-quality prospect data 📊 Automated Data Management Database Integration: Automatic storage in PostgreSQL/Supabase Structured Data: Organizes contacts with complete profile information Real-time Updates: Instant database updates with new prospects How It Works Input Processing: Receive voice message or text command AI Analysis: Extract search parameters (location, industry, job titles) URL Construction: Build Apollo.io search URL with extracted criteria Data Scraping: Retrieve prospect data via Apollo.io API Email Verification: Filter for verified email addresses only Duplicate Check: Compare against existing database records Data Storage: Save new prospects to database Confirmation: Send success notification with count of new leads Supported Search Parameters Location: City, state, country combinations Industry: Business sectors and verticals Job Titles: Executive roles, departments, seniority levels Company Size: Organization scale and employee count Data Fields Extracted Contact Information First Name & Last Name Email Address (verified only) LinkedIn Profile URL Phone Number (when available) Professional Details Current Job Title Company Name Industry Seniority Level Employment History Location Data City & State Country Full Location String Company Information Website URL Business Industry Organization Details Technical Architecture Core Components n8n Workflow Engine: Orchestrates the entire process OpenAI Integration: Powers voice transcription and AI analysis Apollo.io API: Source for prospect data PostgreSQL/Supabase: Database storage and management API Integrations OpenAI Whisper API for voice transcription OpenAI GPT for natural language processing Apollo.io API for lead data retrieval Supabase API for database operations Use Cases Sales Teams Quickly build prospect lists for outreach campaigns Target specific industries or job roles Maintain clean, verified contact databases Marketing Professionals Generate targeted lead lists for campaigns Research prospects in specific markets Build comprehensive contact databases Business Development Identify potential partners or clients Research competitive landscapes Generate contact lists for networking Recruitment Find candidates in specific locations Target particular job roles or industries Build talent pipeline databases Benefits ⚡ Speed & Efficiency Voice commands for instant lead generation Automated processing eliminates manual work Batch processing for large prospect lists 🎯 Precision Targeting AI-powered parameter extraction Flexible search criteria combinations Industry and role-specific filtering 📈 Data Quality Verified email addresses only Duplicate prevention Structured, consistent data format 🔄 Automation End-to-end automated workflow Real-time database updates Instant confirmation notifications Setup Requirements Prerequisites n8n workflow platform OpenAI API access Apollo.io API credentials PostgreSQL or Supabase database Messaging platform integration Configuration Steps Import workflow into n8n Configure API credentials Set up database connections Customize search parameters Test with sample voice/text input Customization Options Search Parameters Modify location formats Add custom industry categories Adjust job title variations Set result limits Data Processing Customize field mappings Add data validation rules Implement additional filters Configure output formats Integration Options Connect to CRM systems Add email marketing tools Integrate with sales platforms Export to various formats Success Metrics Processing Speed: Voice-to-database in under 30 seconds Data Accuracy: 95%+ verified email addresses Automation Level: 100% hands-free operation Scalability: Process 500+ leads per request --- Transform your lead generation process with intelligent automation that understands natural language and delivers verified prospects directly to your database.
Sync data between Google Drive and AWS S3
This workflow synchronizes files one-way from Google Drive to AWS S3. Google Drive Trigger node triggers the workflow when a new file is added to the drive. AWS S3 node gets all files stored in an S3 bucket. Merge node merges the files from Google Drive and AWS S3 by key (file name) and keeps only the new file. AWS S3 node uploads the new file in the S3 bucket.
Download recently liked songs automatically with Spotify
Purpose This workflow enables you to listen to your recent favorites in very hight quality offline without sacrificing all of your storage. How it works This workflow automatically creates a playlist in Spotify named "Downloads" which periodically gets updated so it always contains only a defined amount of the latest liked songs. This enables only the Downloads playlist to set for automatic downloading and thus free up space on the device. Setup The workflow is ready to go. Just select your Spotify credentials and activate the workflow. In Spotify just enable automatic downloads on the automatically created Downloads folder after the first workflow run. Current limitations This setup currently supports a maximum of 50 songs in the Downloads Playlist. This is due to the paylod limits defined by Spotify encountered in the Get liked songs node. Implementing batching would solve the issue.
Extract business contact leads from Google Maps with RapidAPI and Google Sheets
Follow me on LinkedIn for more! Category: Lead Generation, Data Collection, Business Intelligence Tags: lead-generation, google-maps, rapidapi, business-data, contact-extraction, google-sheets, duplicate-prevention, automation Difficulty Level: Intermediate Estimated Setup Time: 15-20 minutes Template Description Overview This powerful n8n workflow automates the extraction of comprehensive business information from Google Maps using keyword-based searches via RapidAPI's Local Business Data service. Perfect for lead generation, market research, and competitive analysis, this template intelligently gathers business data including contact details, social media profiles, and location information while preventing duplicates and optimizing API usage. Key Features 🔍 Keyword-Based Google Maps Scraping: Search for any business type in any location using natural language queries 📧 Contact Information Extraction: Automatically extracts emails, phone numbers, and social media profiles (LinkedIn, Instagram, Facebook, etc.) 🚫 Smart Duplicate Prevention: Two-level duplicate detection saves 50-80% on API costs by skipping processed searches and preventing duplicate business entries 📊 Google Sheets Integration: Seamless data storage with automatic organization and structure 🌍 Multi-Location Support: Process multiple cities, regions, or countries in a single workflow execution ⚡ Rate Limiting & Error Handling: Built-in delays and error handling ensure reliable, uninterrupted execution 💰 Cost Optimization: Intelligent batching and duplicate prevention minimize API usage and costs 📱 Comprehensive Data Collection: Gather business names, addresses, ratings, reviews, websites, verification status, and more Prerequisites Required Services & Accounts RapidAPI Account with subscription to "Local Business Data" API Google Account for Google Sheets integration n8n Instance (cloud or self-hosted) Required Credentials RapidAPI HTTP Header Authentication for Local Business Data API Google Sheets OAuth2 for data storage and retrieval Setup Instructions Step 1: RapidAPI Configuration Create RapidAPI Account Sign up at RapidAPI.com Navigate to "Local Business Data" API Subscribe to a plan (Basic plan supports 1000 requests/month) Get API Credentials Copy your X-RapidAPI-Key from the API dashboard Note the host: local-business-data.p.rapidapi.com Configure n8n Credential In n8n: Settings → Credentials → Create New Type: HTTP Header Auth Name: RapidAPI Local Business Data Add headers: X-RapidAPI-Key: YOURAPIKEY X-RapidAPI-Host: local-business-data.p.rapidapi.com Step 2: Google Sheets Setup Enable Google Sheets API Go to Google Cloud Console Enable Google Sheets API for your project Create OAuth2 credentials Configure n8n Credential In n8n: Settings → Credentials → Create New Type: Google Sheets OAuth2 API Follow OAuth2 setup process Create Google Sheet Structure Create a new Google Sheet with these tabs: keyword_searches sheet: | select | query | lat | lon | countryisocode | |--------|-------|-----|-----|------------------| | X | Restaurants Madrid | 40.4168 | -3.7038 | ES | | X | Hair Salons Brooklyn | 40.6782 | -73.9442 | US | | X | Coffee Shops Paris | 48.8566 | 2.3522 | FR | stores_data sheet: The workflow will automatically create columns for business data including: businessid, name, phonenumber, email, website, full_address, rating, review_count, linkedin, instagram, query, lat, lon, and 25+ more fields Step 3: Workflow Configuration Import the Workflow Copy the provided JSON In n8n: Import from JSON Update Placeholder Values Replace YOURGOOGLESHEET_ID with your actual Google Sheet ID Update credential references to match your setup Configure Search Parameters (Optional) Adjust limit: 1-100 results per query (default: 100) Modify zoom: 10-18 search radius (default: 13) Change language: EN, ES, FR, etc. (default: EN) How It Works Workflow Process Load Search Criteria: Reads queries marked with "X" from keyword_searches sheet Load Existing Data: Retrieves previously processed data for duplicate detection Filter New Searches: Smart merge identifies only new query+location combinations Process Each Location: Sequential processing prevents API overload Configure Parameters: Prepares search parameters from sheet data API Request: Calls RapidAPI to extract business information Parse Data: Structures and cleans all business information Save Results: Stores new leads in stores_data sheet Rate Limiting: 10-second delay between requests Loop: Continues until all new searches are processed Duplicate Prevention Logic Search Level: Compares new queries against existing data using query+latitude combination, skipping already processed searches. Business Level: Each business receives a unique business_id to prevent duplicate entries even across different searches. Data Extracted Business Information Business name, full address, phone number Website URL, Google My Business rating and review count Business type, price level, verification status Geographic coordinates (latitude/longitude) Detailed location breakdown (street, city, state, country, zip) Contact Details Email addresses (when publicly available) Social media profiles: LinkedIn, Instagram, Facebook, Twitter, YouTube, TikTok, Pinterest Additional phone numbers Direct Google Maps and reviews links Search Metadata Original search query and parameters Extraction timestamp and geographic data API response details for tracking Use Cases Lead Generation Generate targeted prospect lists for B2B sales Build location-specific customer databases Create industry-specific contact lists Develop territory-based sales strategies Market Research Analyze competitor density in target markets Study business distribution
E-commerce assistant for Shopify & WooCommerce with GPT-4o, Gemini & RAG
🤖 Universal E-Commerce AI Assistant (Shopify, WooCommerce & RAG) This powerful n8n workflow deploys a sophisticated, multi-talented AI chatbot designed to streamline your e-commerce and customer support operations. The AI assistant can intelligently understand user queries and route them to the correct specialized agent, whether it's for Shopify, WooCommerce, or general knowledge questions answered by a Retrieval-Augmented Generation (RAG) system. This template automates responses to a wide range of inquiries, from checking Shopify order statuses with GraphQL to fetching product lists from WooCommerce, and even answering general questions by looking up information in a Pinecone vector database. How It Works ⚙️ The workflow operates in a series of logical steps, starting from the moment a user sends a message. 💬 Chat Trigger: The workflow activates when a user sends a message in the n8n chat interface. It captures the user's input and a unique session ID to track the conversation. 🧠 Intelligent Routing: The user's query is first sent to a Router Agent powered by GPT-4o-mini. This agent's sole purpose is to classify the intent of the message and output one of three keywords: SHOPIFY, WOOCOMMERCE, or None of them. 🔀 Conditional Branching: Based on the Router's output, a series of IF nodes direct the conversation down one of three paths: General Queries Path Shopify Path WooCommerce Path 📚 General Queries (RAG): If the query is not about e-commerce, it's handled by a RAG agent. Embedding: The user's question is converted into a vector embedding using AWS Bedrock. Retrieval: The workflow searches a Pinecone Vector Store to find the most relevant information from your knowledge base. Generation: A GPT-4o-mini agent receives the context from Pinecone and generates a comprehensive, helpful answer. 🛍️ E-Commerce Specialists: If the query is about Shopify or WooCommerce, it's passed to a dedicated agent. Shopify Agent: This agent uses Google Gemini and has a suite of tools to manage Shopify tasks. It can Get Order info, Fetch All Products, or run complex queries using the powerful GraphQL tool. WooCommerce Agent: This agent also uses Google Gemini and is equipped with tools to Fetch Order Details and Fetch All Products from a WooCommerce store. 🗣️ Conversation Memory: Each agent (Router, General, Shopify, WooCommerce) is connected to its own Memory node. This allows the chatbot to remember previous parts of the conversation for a more natural and context-aware interaction. 🏁 Merge & Respond: All three paths converge at a final Merge node. This ensures that no matter which agent handled the request, the final answer is streamlined into a single output and sent back to the user in the chat. Nodes Used 🔗 Triggers: Chat Trigger: Starts the workflow when a chat message is received. AI & Agents: AI Agent: Four separate agents for Routing, Shopify, WooCommerce, and General Queries. OpenAI Chat Model: Uses GPT-4o-mini for the Router and General Queries agent. Google Gemini Chat Model: Uses Google Gemini for the Shopify and WooCommerce agents. Tools & Data: Shopify Tool: To get products and order information from Shopify. WooCommerce Tool: To get products and order information from WooCommerce. GraphQL Tool: For advanced, custom queries to the Shopify API. Pinecone Vector Store: To retrieve context for the RAG agent. AWS Bedrock Embeddings: To create vector embeddings for Pinecone. Logic & Memory: IF Node: To conditionally route the workflow. Merge Node: To consolidate the different branches before ending. Window Buffer Memory: Four nodes to provide conversational memory to each agent. Setup Guide 🛠️ To use this workflow, you'll need to configure several nodes with your own credentials and settings. 1\. AI Model Credentials OpenAI: Create an API key in your OpenAI Platform dashboard. Add this credential to the Router Model and GPT-4o-mini nodes. Google Gemini: Create an API key in your Google AI Studio dashboard. Add this credential to the Shopify Chat Model and WooCommerce Chat Model nodes. 2\. E-Commerce Platform Credentials Shopify: You will need a Shopify Access Token. Follow the n8n documentation to generate one. Add the credential to the Fetch All Products and Get Order info nodes. WooCommerce: Create API credentials from your WordPress dashboard. Add the credential to the Fetch All Products2 and Fetch Order Details nodes. 3\. RAG System Credentials (Pinecone & AWS) Pinecone: Sign up for a Pinecone account and create an API key. Add your Pinecone credentials in n8n. In the Pinecone Vector Store node, set the pineconeIndex to the name of your index. You must have a pre-existing index with data for the RAG to work. AWS: Create an AWS account and an IAM user with programmatic access to Amazon Bedrock. Add your AWS credentials in n8n. Select your AWS credentials in the AWS Bedrock Embeddings node. 4\. GraphQL Node Configuration In the GraphQL node, you must update the endpoint URL. Replace the placeholder https://{subdomain}.myshopify.com/admin/api/2025-04/graphql.json with your own Shopify store's GraphQL API endpoint.
AI-powered Google Maps business scraper with enrichment & export to sheets
Overview This workflow automates the discovery, extraction, enrichment, and storage of business information from Google Maps search queries using AI tools, scrapers, and Google Sheets. It is ideal for: Lead generation agencies Local business researchers Digital marketing firms Automation & outreach specialists --- 🔧 Tools & APIs Used Google Maps Search (via HTTP) Custom JavaScript Parsing URL Filtering & De-duplication Google Sheets (Read/Write) APIFY Actor for business scraping LangChain AI Agent (OpenRouter - Gemini 2.5) n8n Built-in Logic (Loops, Conditions, Aggregators) --- 🧠 Workflow Summary Trigger The automation starts via schedule (every hour). Read Queries from Google Sheet Loads unprocessed keywords from a Google Sheet tab named keywords. Loop Through Keywords Each keyword is used to search Google Maps for relevant businesses. Extract URLs JavaScript parses HTML to find all external website URLs from the search results. Clean URLs Filters out irrelevant domains (e.g., Google-owned, example.com, etc.), and removes duplicates. Loop Through URLs For each URL: Checks if it already exists in the Google Sheet (to prevent duplication). Calls the APIFY Actor to extract full business data. Optionally uses AI Agent (Gemini) to provide detailed insight on the business, including: Services, About, Market Position, Weaknesses, AI suggestions, etc. Converts the AI result (text) to a structured JSON object. Save to Google Sheet Adds all extracted and AI-enriched business information to a separate tab (Sheet1). Mark Queries as Processed Updates the original row in keywords to avoid reprocessing. --- 🗃️ Output Fields Saved The following information is saved per business: Business Name, Website, Email, Phone Address, City, Postal Code, Country, Coordinates Category, Subcategory, Services About Us, Opening Hours, Social Media Links Legal Links (Privacy, Terms) Logo, Languages, Keywords AI-Generated Description Google Maps URL --- 📈 Use Cases Build a prospect database for B2B cold outreach. Extract local SEO insights per business. Feed CRMs or analytics systems with enriched business profiles. Automate market research for regional opportunity detection. --- 📩 Want a Similar Workflow? If you’d like a custom AI-powered automation like this for your business or agency, feel free to contact me: 📧 msaidwolfltd@gmail.com
Automate video creation from voice input with HeyGen, GPT-5 & social publishing
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Automate Video Creation from Voice Input with HeyGen & n8n --- 👥 Who is this for? This workflow is ideal for: Content creators who want to turn ideas into videos in minutes Marketers managing multi-platform video campaigns Agencies needing scalable video workflows for multiple clients Entrepreneurs looking to automate social media presence --- 💡 What problem is this workflow solving? Creating and publishing videos across TikTok, YouTube, Instagram and more is: Time-consuming (writing scripts, creating videos, uploading manually) Inconsistent (different platforms, formats, captions) Hard to scale without automation This workflow solves it by turning a voice note into a complete AI video — scripted, generated, and published automatically. --- ⚙️ What this workflow does Capture idea via Telegram voice note Transcribe audio to text using OpenAI Whisper Generate script, title, and caption with GPT-5 Create avatar video with HeyGen based on your script Save final video to Google Drive and log metadata in Google Sheets Upload video to Blotato Auto-publish to 9 platforms (TikTok, YouTube Shorts, Instagram, LinkedIn, Facebook, Twitter (X), Threads, Bluesky, Pinterest) Send Telegram notification once published --- 🧰 Setup Before you start, you’ll need: ✅ A Telegram Bot connected to n8n 🔑 An OpenAI API key (Whisper + GPT-5) 🎭 A HeyGen API key for avatar video generation 📂 Google Drive + Sheets integrations for storage & logs 🧩 A Blotato Pro account with API access enabled 📦 Verified Community Nodes enabled in n8n Admin Panel ⚙️ Blotato node installed + credentials configured 📄 A Google Sheet template to log titles, captions, and video links --- 🛠️ How to customize this workflow Change prompts → Adjust GPT-5 prompts to fit your tone or brand Select avatars → Configure HeyGen avatar and voice to match your style Choose platforms → Activate only TikTok, YouTube, Instagram, etc. Add approvals → Insert a Telegram or Slack approval step before publishing Extend reporting → Push analytics or engagement data into Sheets or Notion --- This workflow transforms a simple voice message into a ready-to-publish viral video — fully automated, consistent, and scalable. --- 📄 Documentation: Notion Guide --- Need help customizing? Contact me for consulting and support : Linkedin / Youtube
Find, scrape & analyze Twitter posts by name with Bright Data & Gemini
This n8n workflow template automates the process of collecting and analyzing Twitter (X) posts for any public profile, then generates a clean, AI-powered summary including key metrics, interests, and activity trends. 🚀 What It Does Accepts a user's full name and date range through a public form. Automatically finds the person’s X (formerly Twitter) profile using a Google search. Uses Bright Data to retrieve full post data from the X.com profile. Extracts key post metrics like views, likes, reposts, hashtags, and mentions. Uses Google Gemini (PaLM) to generate a personalized summary: tone, themes, popularity, and sentiments. Stores both raw data and the AI summary into a connected Google Sheet for further review or team collaboration. 🛠️ Step-by-Step Setup Deploy the public form to collect full name and date range. Build a Google search query using the name to find their X profile. Scrape the search results via Bright Data (Web Unlocker zone). Parse the page content using the HTML node. Use Gemini AI to extract the correct X profile URL. Pull full post data via Bright Data dataset snapshot API. Transform post data into clean structured fields: date_posted, description, hashtags, likes, views, quotedpost.dateposted, quoted_post.description, replies, reposts, quotes, and taggedusers.profilename. Analyze all posts using Google Gemini for interest detection and persona generation. Save results to a Google Sheet: structured post data + AI-written summary. Show success or fallback messages depending on profile detection or scraping status. 🧠 How It Works: Workflow Overview Trigger: When user submits form Search & Match: Google search → HTML parse → Gemini filters matching X profile Data Gathering: Bright Data → Poll for snapshot completion → Fetch post data Transformation: Extract and restructure key fields via Code node AI Summary: Use Gemini to analyze tone, interests, and trends Export: Save results to Google Sheet Fallback: Display custom error message if no X profile found 📨 Final Output A record in your Google Sheet with: Clean post-level data Profile-level engagement summary An AI-written overview including tone, common topics, and post popularity 🔐 Credentials Used Bright Data account (for search & post scraping) Google Gemini (PaLM) or Gemini Flash via - OpenAI/Google Vertex API Google Sheets (OAuth2) account (for result storage) ⚠️Community Node Dependency This workflow uses a custom community node: n8n-nodes-brightdata Install it via UI (Settings → Community Nodes → Install).
Automate stock trades with AI-driven technical analysis & Alpaca Trading
📊 AI-Powered Stock Analysis & Auto-Trading Workflow Supercharge your trading decisions with this end-to-end AI automation that connects market intelligence, technical analysis, and automated trade execution — all without manual intervention. --- My results so far: (100k paper trading account with the current template strategy) 🚀 What This Workflow Does Live AI-Driven Market Scanning Integrates with Danelfin’s AI scoring system to identify top stocks daily based on technical, fundamental, sentiment, and risk scores. Advanced Technical & Trend Analysis Combines chart patterns, Fibonacci retracements, Bollinger Bands, MACD, RSI, EMA trends, and support/resistance detection with real-time news sentiment to produce clear, professional-grade analysis reports. Chart Image AI Analysis Uses LLM-powered vision models to interpret candlestick charts visually and extract pattern, trend, and indicator insights. Automated Trade Execution Integrates with Alpaca Paper Trading API for secure, rule-based buy/sell execution. Includes: Risk management (position sizing, stop-loss/take-profit) Account balance & buying power checks No-repeat-loss policy Data Storage & Strategy Memory Logs trades, PnL, and objectives in PostgreSQL for ongoing strategy refinement. Automated Reporting Sends deep-dive market and trade reports directly to your email. --- 🔗 Integrated Services Danelfin API – AI-based stock ranking Supabase Vector Store – Strategy and knowledge retrieval TwelveData API – Market prices & indicators Chart-img API – TradingView chart generation Alphavantage – News sentiment feed Alpaca API – Automated order execution OpenAI, Anthropic, Cohere, OpenRouter – Multi-model AI reasoning --- 📥 Perfect For Quantitative analysts testing strategies Investors looking for data-backed, automated execution Educational environments for learning AI-based market strategies People that want to know Real results Results --- 💼 What You Get Full Setup Pre-configured n8n workflow with all nodes and logic ready to run Step-by-step API key integration guide for Danelfin, Alpaca, TwelveData, Alphavantage, Chart-img Database logging setup with PostgreSQL schema Automated email reporting template Detailed Description Explanation of every sub-agent and AI integration How the strategy agent selects stocks based on AI scores and past trades Deep technical indicators breakdown (EMA, RSI, MACD, Fibonacci, Bollinger, Support/Resistance) Risk management methodology and allocation rules Examples Daily Automated Analysis: Every morning the system emails you the top 3 stocks to watch, with price, chart, and sentiment score Trade Execution: System buys AAPL with a defined stop-loss and take-profit based on technical setup Chatbot Mode: Ask “What’s the trend on TSLA?” and get a concise, professional-grade market report instantly --- 💡 Why You’ll Love It This isn’t just an automation — it’s a full-stack AI trading assistant that thinks, analyzes, and executes while keeping risk in check. From sourcing the idea to placing the trade, it’s all covered. --- 🔑 Get Started Replace the placeholder API keys, set your trading preferences, and let the automation do the heavy lifting.