Workflow Templates

AI-Powered HR Candidate Evaluation Agent with LinkedIn Data Enrichment in CSV/XLSX Format 🎯 Overview Transform your manual hiring process into an intelligent evaluation system that saves 15-20 minutes per candidate! This workflow automates the entire candidate assessment pipeline - from CSV/XLSX upload to AI-powered scoring with LinkedIn insights. When you upload a candidate list, this workflow automatically: 📊 Converts your file into a formatted Google Sheet with RTL support 🔍 Researches each candidate's recent LinkedIn posts via Apify 🤖 Evaluates candidates using GPT-4.1 with context-aware scoring (0-100) 💬 Generates professional Hebrew explanations for each score 📈 Auto-sorts by score and applies professional formatting ⚠️ Sends error alerts to keep everything running smoothly Cost per candidate: ~$0.05 | Time saved: 15-20 minutes each 👥 Who's it for? HR teams drowning in candidate applications Recruitment agencies needing consistent evaluation criteria Hiring managers seeking data-driven candidate insights Companies looking to scale their team Anyone tired of manual spreadsheet juggling ⚡ How it works Form submission triggers with CSV/XLSX upload Google Drive stores the file and creates a new Sheet Data extraction processes the file content AI Agent loops through each candidate: Fetches up to 3 recent LinkedIn posts via Apify Analyzes qualifications against job requirements Generates evaluation score and Hebrew explanation Sheet formatting applies filters, sorting, and styling Error handling notifies admin of any issues 🛠️ Setup Instructions Time to deploy: 15 minutes Requirements: Google account (Drive + Sheets access) OpenAI API key (GPT-4.1 access) Apify API key (for LinkedIn scraping) Gmail account (for error notifications) Step-by-step: Import this template into your n8n instance Configure Google credentials: Connect Google Drive OAuth2 Connect Google Sheets OAuth2 Add OpenAI API key to the GPT-4.1 node Set up Apify credentials for LinkedIn scraping Configure Gmail for error alerts (update email in "Send a message" node) Update folder IDs in Google Drive nodes to your folders Test with a sample CSV containing 2-3 candidates Activate and share the form URL with your team! 📋 Input File Format Your CSV/XLSX should include these columns (Hebrew): שם פרטי (First name) שם משפחה (Last name) חשבון לינקדאין (LinkedIn URL) Your custom evaluation questions 🎨 Customization Options Easy tweaks: Scoring criteria**: Modify the AI agent's system message Language**: Switch from Hebrew to any language Scoring rubric**: Adjust the 50/25/15/10 weighting LinkedIn posts**: Change from 3 posts to more/fewer Sheet styling**: Customize colors and formatting Advanced modifications: Add integration with your ATS (Greenhouse, Lever, etc.) Connect to Slack for real-time notifications Add multiple evaluation agents for different roles Implement multi-language support Add candidate email automation 💡 Pro Tips Better LinkedIn data**: Ensure candidates provide complete LinkedIn URLs (not just usernames) Consistent scoring**: Run batches of similar roles together for normalized scoring Cost optimization**: Adjust Apify settings to fetch only essential data Scale smartly**: Process in batches of min 10-20 for optimal performance ⚠️ Important Notes LinkedIn scraping respects Apify's rate limits Scores are relative within each batch - don't compare across different job roles The workflow handles both CSV and XLSX formats automatically Error notifications help you catch issues before they cascade 📊 Expected Results After implementation, expect: Data-driven evaluation across candidates Professional explanation for hiring decisions Happy recruiters who can focus on human connection Built with ❤️ by Elay Guez

🚀 AI Facebook Post Generator - Complete Setup Guide > Transform your content ideas into viral Facebook posts with AI-powered automation in just 30 minutes! 📋 Prerequisites Checklist What you'll need before we start: ✅ n8n instance (cloud or self-hosted) ✅ Facebook Business Page (not personal profile) ✅ Google account with Sheets & Gmail access ✅ Basic understanding of API credentials ⏱️ Estimated Setup Time: 30-45 minutes 🎯 Difficulty Level: Intermediate 💰 Cost: Free tier available for all services 🎨 What You'll Build By the end of this guide, you'll have: 📝 Smart Content Form - Web form that captures your ideas 🤖 AI Content Optimizer - Gemini AI that polishes your writing 🖼️ Auto Image Generator - Custom visuals created automatically 📊 Content Tracker - Google Sheets logging for analytics 📱 Facebook Publisher - Direct posting to your page 📧 Success Notifications - Email confirmations with post links 🔧 Step-by-Step Setup Step 1: 📘 Facebook Integration Setup 🔸 1.1 Create Your Facebook App Why this matters: This gives your workflow permission to post on your behalf. Navigate to Facebook Developers 🌐 Click "My Apps" → "Create App" Select "Business" as your app type App Name: AI-Content-Poster (or your preferred name) Hit "Create App" > 💡 Pro Tip: Choose a descriptive name - you'll see this in your Facebook activity logs 🔸 1.2 Configure App Settings In your app dashboard: "Add a Product" Find "Facebook Login" → "Set Up" Navigate to Settings → Basic App Domains: Add app.n8n.cloud (for n8n cloud users) Save changes ✅ 🔸 1.3 Generate Your Page Access Token This is the key that unlocks posting powers! 🔑 Go to Tools → Graph API Explorer Select your newly created app Click "Generate Access Token" Required Permissions: pages_manage_posts pages_read_engagement pages_show_list Select your target Facebook page Copy the token (starts with EAAG...) ⚠️ Critical Step - Make Token Long-Lived: In Graph API Explorer, make a GET request to: /oauth/access_token?grant_type=fb_exchange_token&client_id=YOUR_APP_ID&client_secret=YOUR_APP_SECRET&fb_exchange_token=YOUR_SHORT_TOKEN 🔸 1.4 Find Your Page ID Two methods to get your Page ID: Method 1 - Direct from Facebook: Visit your Facebook page Click "About" tab Scroll to find "Page ID" Method 2 - API Explorer: Use Graph API Explorer GET request to: /me/accounts Find your page in the response Step 2: 🔍 Google Services Setup 🔸 2.1 Enable Required APIs Setting up your Google Cloud foundation: Visit Google Cloud Console ☁️ Create new project or select existing "APIs & Services" → "Library" Enable these APIs: ✅ Google Sheets API ✅ Gmail API ✅ Google Drive API (optional) 🔸 2.2 Create Service Account This creates a "robot" account for automated access: "APIs & Services" → "Credentials" "Create Credentials" → "Service Account" Name: ai-facebook-automation "Create and Continue" Skip role assignment → "Continue" "Done" ✅ 🔸 2.3 Download Credentials File Click your service account email "Keys" tab → "Add Key" → "Create New Key" Choose "JSON" format Download and save securely 📁 > 🔒 Security Note: This file contains sensitive credentials. Store it safely! 🔸 2.4 Prepare Your Google Sheets Create your data tracking system: 📊 Sheet 1: Content Log Purpose:** Track all generated content Columns:** A: Date (Ngày) B: Short Content (Nội dung ngắn) C: Full Content (Nội dung đầy đủ) 📝 Sheet 2: Input Tracking Purpose:** Log form submissions Columns:** A: Date B: Time C: Content 🔗 Important: Share both sheets with your service account email (found in the JSON file) Step 3: 🤖 AI Services Configuration 🔸 3.1 Get Your Gemini API Key Power up your AI content generation: Head to Google AI Studio 🎨 Sign in with Google account "Create API Key" Copy the key (starts with AIza...) > 💰 Cost Info: Gemini offers generous free tier limits - perfect for getting started! Step 4: ⚙️ n8n Workflow Configuration 🔸 4.1 Import the Magic ✨ Copy the workflow JSON from the template In n8n: "Import from JSON" Paste the workflow code "Import" to load your new automation 🔸 4.2 Configure Your Credentials 🔑 Facebook Graph API Setup: Settings → Credentials → "Add Credential" Search: "Facebook Graph API" Access Token: Your Page Access Token from Step 1.3 Test connection → Save as: Facebook Page Access 🔍 Google Services Setup: "Add Credential" → "Google Service Account" Upload your JSON file from Step 2.3 Test connection → Save as: Google Services 🧠 Gemini AI Setup: "Add Credential" → "Google PaLM API" Enter your Gemini key from Step 3.1 Save as: Gemini AI 🔸 4.3 Customize Node Settings 📱 Update Facebook Configuration: In "Facebook Graph API" node: Replace "113732581629527" with your Page ID from Step 1.4 In "Facebook Upload Img" node: Replace "113732581629527" with your Page ID from Step 1.4 📊 Update Google Sheets: In "save content" node: Replace Document ID with your Content Log Sheet ID In "Append row in sheet" node: Replace Document ID with your Input Tracking Sheet ID > 💡 Finding Sheet ID: It's the long string in your Google Sheets URL after /spreadsheets/d/ 📧 Update Notification Email: In "Send a message" node: Replace xxx@gmail.com with your email address Configure Gmail credentials Step 5: 🧪 Testing & Validation 🔸 5.1 Component Testing 📊 Test Google Sheets Connection: Right-click "Append row in sheet" node "Execute Node" ✅ Verify test row appears in your sheet 🤖 Test Gemini AI: Right-click "Basic LLM Chain" node "Edit Input Data" → Add test content Execute → ✅ Verify AI response quality 🖼️ Test Image Generation: Right-click "HTTP Request" node Ensure valid prompt from previous step Execute → ✅ Check for base64 image data 📱 Test Facebook Upload: Run full workflow with test content ✅ Check your Facebook page for new post ✅ Verify image uploaded correctly 🔸 5.2 End-to-End Victory Test 🎉 "Execute Workflow" on trigger node Submit test content through the form Monitor each node execution 🎊 Celebrate your first AI-generated post! 🎯 Success Indicators Your setup is complete when you see: ✅ Form accepts and processes content ✅ AI generates optimized text + image prompt ✅ Custom image appears in Facebook post ✅ Content logged in Google Sheets ✅ Success email in your inbox ✅ Professional-looking post on your Facebook page 🚨 Troubleshooting Quick Fixes Facebook Issues Token Expired?** → Generate new long-lived token Permission Denied?** → Check page admin rights Invalid Page ID?** → Double-check Page ID format Google Sheets Problems 403 Forbidden?** → Share sheet with service account Sheet Not Found?** → Verify Sheet ID in URL Column Errors?** → Match exact column names AI Content Issues Empty Responses?** → Check Gemini API quotas Poor Quality?** → Adjust AI prompts JSON Errors?** → Validate parsing logic 🎨 Customization Ideas Make it uniquely yours: 🎨 Brand Voice: Adjust AI prompts for your tone ⏰ Scheduling: Add time delays for strategic posting 📈 Analytics: Connect performance tracking tools 🔄 Multi-Platform: Extend to Instagram, LinkedIn 👥 Team Features: Add approval workflows 🎉 You Did It! Congratulations! You've built an AI-powered content machine that will save you hours every week. What's Next? Test with different content types Monitor performance in Google Sheets Refine AI prompts for better results Share your success with the community! Need Help? 🤝 Join n8n Discord Visit Community Forum Check n8n Documentation Ready to revolutionize your content creation? Your AI assistant is waiting! 🚀

Overview This comprehensive workflow transforms Excel spreadsheets into professional, AI-generated reports with automated analysis and insights. Whether you're dealing with financial data, customer tracking, sales metrics, inventory management, or any structured data in Excel format, this template leverages artificial intelligence to create detailed, actionable reports with visualizations and key findings. How It Works Automated Report Generation Pipeline: File Processing Trigger**: Workflow initiates when Excel files are uploaded through a web form or file system Data Extraction & Validation**: Automatically reads Excel sheets, validates data structure, and identifies key metrics AI-Powered Analysis**: Uses advanced language models to analyze data patterns, trends, and anomalies Report Generation**: Creates comprehensive reports with executive summaries, detailed analysis, and actionable recommendations Multi-Format Output**: Generates reports in various formats (PDF, HTML, Word) with embedded charts and visualizations Automated Distribution**: Sends completed reports via email or saves to designated cloud storage locations Setup Instructions Estimated Setup Time: 10-15 minutes Prerequisites n8n instance (v0.200.0 or higher) OpenAI/Claude API key for AI analysis Email service credentials (for report distribution) Cloud storage access (Google Drive, Dropbox, etc.) - optional Configuration Steps Configure File Input Trigger Set up webhook or file system trigger for Excel file uploads Configure accepted file formats (.xlsx, .xls, .csv) Add file size and validation checks Setup Data Processing Nodes Configure Excel file reader with sheet selection options Set up data validation and cleaning processes Define column mapping and data type recognition Configure AI Analysis Engine Add your AI service API credentials (OpenAI, Anthropic, etc.) Customize analysis prompts based on your data types Set up context-aware report generation parameters Setup Report Generation Configure report templates for different data types Set up chart generation and data visualization options Define output formats and styling preferences Configure Distribution Channels Set up email service for automated report delivery Configure cloud storage integration for report archiving Add notification systems for completion alerts Use Cases Financial Reporting Budget Analysis**: Analyze spending patterns and budget variance reports P&L Statements**: Generate profit and loss summaries with trend analysis Cash Flow Reports**: Create comprehensive cash flow analysis with forecasting Expense Tracking**: Automated expense categorization and spending insights Sales & CRM Analytics Sales Performance**: Generate sales team performance reports with KPIs Customer Analysis**: Create customer segmentation and lifetime value reports Lead Tracking**: Analyze conversion funnels and lead quality metrics Territory Management**: Regional sales analysis and market penetration reports Operations Management Inventory Reports**: Stock level analysis with reorder recommendations Project Tracking**: Progress reports with timeline and resource analysis Quality Metrics**: Performance dashboards with trend identification Resource Planning**: Capacity utilization and allocation reports HR & Administrative Employee Performance**: Generate comprehensive performance review reports Attendance Tracking**: Analyze attendance patterns and productivity metrics Training Records**: Skills gap analysis and training effectiveness reports Compliance Reporting**: Regulatory compliance status and audit reports Key Features Intelligent Data Recognition**: Automatically identifies data types and relationships Contextual Analysis**: AI provides industry-specific insights and recommendations Professional Formatting**: Clean, corporate-ready report layouts Interactive Visualizations**: Embedded charts, graphs, and data visualizations Executive Summaries**: AI-generated executive summaries highlighting key findings Trend Analysis**: Historical data comparison and future projections Anomaly Detection**: Automatically flags unusual patterns or outliers Multi-Language Support**: Generate reports in multiple languages Batch Processing**: Handle multiple files simultaneously Error Handling**: Robust error management with detailed logging Technical Requirements n8n instance with sufficient memory for Excel processing (minimum 2GB RAM recommended) AI service API access (OpenAI GPT-4, Claude, or similar) Email service (Gmail, Outlook, SendGrid, etc.) Optional: Cloud storage service credentials Stable internet connectivity for AI API calls Supported Data Types Financial Data**: Revenue, expenses, budgets, forecasts Sales Data**: Transactions, leads, customer information, pipeline data Operational Data**: Inventory, production metrics, quality scores HR Data**: Employee records, performance metrics, attendance Marketing Data**: Campaign metrics, conversion rates, ROI analysis Custom Data**: Any structured Excel data with clear column headers Output Options PDF Reports**: Professional PDF documents with embedded charts HTML Dashboards**: Interactive web-based reports Word Documents**: Editable Word reports with tables and charts Excel Summaries**: Enhanced Excel files with analysis sheets PowerPoint Presentations**: Executive presentation slides Advanced Features Custom Branding**: Add your company logo and branding to reports Scheduled Processing**: Set up automated report generation schedules Template Customization**: Create custom report templates for different data types Integration Ready**: Easy integration with existing business systems Audit Trail**: Complete logging of all processing steps and data changes Support & Troubleshooting For optimal performance, ensure your Excel files have clear column headers and consistent data formatting. The AI analysis works best with clean, well-structured data. For complex financial calculations, verify results against your existing systems during initial setup.

Description Automate your team's daily stand-ups with AI-powered morning briefs, directly pulled from ClickUp tasks and shared via Slack and Gmail every morning. ☀️📋💬 What This Template Does Triggers automatically at 9:15 AM each morning via cron. ⏰ Fetches the latest sprint and all active or due-today tasks from ClickUp. Categorizes tasks by status, priority, and assignee for clear visibility. Uses Azure OpenAI GPT-4o to generate a detailed, structured morning summary. Formats the AI summary into a clean HTML email and a Slack post. Sends automated updates to Gmail and Slack channels. Includes real-time error detection and Slack alerts for quick debugging. Key Benefits ✅ Eliminates manual stand-up prep by generating AI-driven daily reports. ✅ Keeps teams aligned with clear task summaries and blocker tracking. ✅ Automatically distributes updates across Slack and Gmail. ✅ Provides HTML-formatted emails and Slack markdown summaries. ✅ Reduces time spent on daily check-ins and sprint reviews. Features Fully automated daily scheduling using cron triggers. Real-time task fetching and categorization from ClickUp. GPT-4-powered summarization for executive-style briefs. Responsive HTML email builder for beautiful reports. Slack integration for quick, shareable updates. Error handling with dedicated Slack notifications. Requirements ClickUp OAuth2 credentials for task access. Azure OpenAI GPT-4o API credentials for summary generation. Slack API credentials for channel posting. Gmail OAuth2 credentials for sending email reports. Target Audience Project managers and team leads needing automated daily briefings 👩‍💼 Development teams using ClickUp for sprint and task tracking 💻 Agencies or operations teams coordinating across tools 🔄 Remote teams seeking quick alignment and productivity boosts 🌍 Step-by-Step Setup Instructions Connect your ClickUp account via OAuth2 and update Team, Space, and Folder IDs. ⚙️ Add Azure OpenAI GPT-4o credentials for AI summary generation. 🤖 Configure Slack OAuth2 credentials and set the target channel ID. 💬 Connect Gmail OAuth2 and define recipient email addresses. 📧 Customize the schedule trigger time (default: 9:15 AM). 🕒 Test the workflow to verify proper data retrieval and message delivery. 🚀

This n8n template demonstrates how to automatically generate and publish blog posts using trending keywords, AI-generated content, and watermarked stock images. Use cases include maintaining an active blog with fresh SEO content, scaling content marketing without manual writing, and automating the full publishing pipeline from keyword research to WordPress posting. Good to know At time of writing, each AI content generation step will incur costs depending on your OpenAI pricing plan. Image search is powered by Pexels, which provides free-to-use stock images. The workflow also applies a watermark for branding. Google Trends data may vary by region, and results depend on availability in your selected location. How it works The workflow begins with a scheduled trigger that fetches trending keywords from Google Trends. The XML feed is converted to JSON and filtered for relevant terms, which are logged into a Google Sheet for tracking. One random keyword is selected, and OpenAI is used to generate blog content around it. A structured output parser ensures the text is clean and well-formatted. The system then searches Pexels for a matching image, uploads it, adds metadata for SEO, and applies a watermark. Finally, the complete article (text and image) is published directly to WordPress. How to use The schedule trigger is provided as an example, but you can replace it with other triggers such as webhooks or manual inputs. You can also customize the AI prompt to match your niche, tone, or industry focus. For higher volumes, consider adjusting the keyword filtering and batching logic. Requirements OpenAI account for content generation Pexels API key for stock image search Google account with Sheets for keyword tracking WordPress site with API access for publishing Customising this workflow This automation can be adapted for different use cases. Try adjusting the prompts for technical blogs, fashion, finance, or product reviews. You can also replace the image source with other providers or integrate your own media library. The watermark feature ensures branding, but it can be modified or removed depending on your needs.

A fully autonomous, HTX Spot Market AI Agent (Huobi AI Agent) built using GPT-4o and Telegram. This workflow is the primary interface, orchestrating all internal reasoning, trading logic, and output formatting. ⚙️ Core Features 🧠 LLM-Powered Intelligence: Built on GPT-4o with advanced reasoning ⏱️ Multi-Timeframe Support: 15m, 1h, 4h, and 1d indicator logic 🧩 Self-Contained Multi-Agent Workflow: No external subflows required 🧮 Real-Time HTX Market Data: Live spot price, volume, 24h stats, and order book 📲 Telegram Bot Integration: Interact via chat or schedule 🔄 Autonomous Runs: Support for webhook, schedule, or Telegram triggers 📥 Input Examples | User Input | Agent Action | | --------------- | --------------------------------------------- | | btc | Returns 15m + 1h analysis for BTC | | eth 4h | Returns 4-hour swing data for ETH | | bnbusdt today | Full day snapshot with technicals + 24h stats | 🖥️ Telegram Output Sample 📊 BTC/USDT Market Summary 💰 Price: $62,400 📉 24h Stats: High $63,020 | Low $60,780 | Volume: 89,000 BTC 📈 1h Indicators: • RSI: 68.1 → Overbought • MACD: Bearish crossover • BB: Tight squeeze forming • ADX: 26.5 → Strengthening trend 📉 Support: $60,200 📈 Resistance: $63,800 🛠️ Setup Instructions Create your Telegram Bot using @BotFather Add Bot Token in n8n Telegram credentials Add your GPT-4o or OpenAI-compatible key under HTTP credentials in n8n (Optional) Add your HTX API credentials if expanding to authenticated endpoints Deploy this main workflow using: ✅ Webhook (HTTP Request Trigger) ✅ Telegram messages ✅ Cron / Scheduled automation 🎥 Live Demo 🧠 Internal Architecture | Component | Role | | ------------------ | -------------------------------------------------------- | | 🔄 Telegram Trigger | Entry point for external or manual signal | | 🧠 GPT-4o | Symbol + timeframe extraction + strategy generation | | 📊 Data Collector | Internal tools fetch price, indicators, order book, etc. | | 🧮 Reasoning Layer | Merges everything into a trading signal summary | | 💬 Telegram Output | Sends formatted HTML report via Telegram | 📌 Use Case Examples | Scenario | Outcome | | -------------------------------------- | ------------------------------------------------------- | | Auto-run every 4 hours | Sends new HTX signal summary to Telegram | | Human requests “eth 1h” | Bot replies with real-time 1h chart-based summary | | System-wide trigger from another agent | Invokes webhook and returns response to parent workflow | 🧾 Licensing & Attribution © 2025 Treasurium Capital Limited Company Architecture, prompts, and trade report structure are IP-protected. No unauthorized rebranding permitted. 🔗 For support: Don Jayamaha – LinkedIn

Try it out This n8n workflow template lets you chat with your Google Drive documents (.docx, .json, .md, .txt, .pdf) using OpenAI and Pinecone Assistant. It retrieves relevant context from your files in real time so you can get accurate, context-aware answers about your proprietary data—without the need to train your own LLM. What is Pinecone Assistant? Pinecone Assistant allows you to build production-grade chat and agent-based applications quickly. It abstracts the complexities of implementing retrieval-augmented (RAG) systems by managing the chunking, embedding, storage, query planning, vector search, model orchestration, reranking for you. Prerequisites A Pinecone account and API key A GCP project with Google Drive API enabled and configured Note: When setting up the OAuth consent screen, skip steps 8-10 if running on localhost An Open AI account and API key Setup Create a Pinecone Assistant in the Pinecone Console here Name your Assistant n8n-assistant and create it in the United States region If you use a different name or region, update the related nodes to reflect these changes No need to configure a Chat model or Assistant instructions Setup your Google Drive OAuth2 API credential in n8n In the File added node -> Credential to connect with, select Create new credential Set the Client ID and Client Secret from the values generated in the prerequisites Set the OAuth Redirect URL from the n8n credential in the Google Cloud Console (instructions) Name this credential Google Drive account so that other nodes reference it Setup Pinecone API key credential in n8n In the Upload file to assistant node -> PineconeApi section, select Create new credential Paste in your Pinecone API key in the API Key field Setup Pinecone MCP Bearer auth credential in n8n In the Pinecone Assistant node -> Credential for Bearer Auth section, select Create new credential Set the Bearer Token field to your Pinecone API key used in the previous step Setup the Open AI credential in n8n In the OpenAI Chat Model node -> Credential to connect with, select Create new credential Set the API Key field to your OpenAI API key Add your files to a Drive folder named n8n-pinecone-demo in the root of your My Drive If you use a different folder name, you'll need to update the Google Drive triggers to reflect that change Activate the workflow or test it with a manual execution to ingest the documents Chat with your docs! Ideas for customizing this workflow Customize the System Message on the AI Agent node to your use case to indicate what kind of knowledge is stored in Pinecone Assistant Change the top_k value of results returned from Assistant by adding "and should set a top_k of 3" to the System Message to help manage token consumption Configure the Context Window Length in the Conversation Memory node Swap out the Conversation Memory node for one that is more persistent Make the chat node publicly available or create your own chat interface that calls the chat webhook URL. Need help? You can find help by asking in the Pinecone Discord community, asking on the Pinecone Forum, or filing an issue on this repo.

Generate AI Viral Videos with VEO3 and Auto-Publish to TikTok Who is this for? This workflow is for content creators, marketers, and social media managers who want to consistently produce viral-style short videos and publish them automatically to TikTok — without manual editing or uploading. What problem is this workflow solving? / Use case Creating short-form video content that stands out takes time: ideation, scriptwriting, video generation, and publishing. This workflow automates the entire pipeline — from idea generation to TikTok upload — enabling you to scale your content strategy and focus on creativity rather than repetitive tasks. What this workflow does Generates viral video ideas** daily using GPT-5 Creates structured prompts** for before/after transformation videos Renders cinematic vertical videos** with VEO3 (9:16 format) Saves ideas and metadata** into Google Sheets for tracking Uploads videos automatically to TikTok** via Blotato integration Updates status in Google Sheets** once the video is live The result: a fully automated daily viral video publishing system. Setup Google Sheets Connect your Google Sheets account. Create a sheet with columns for idea, caption, environment, sound, production, and final_output. OpenAI Add your OpenAI API credentials (for GPT-5 mini / GPT-4.1 mini). VEO3 (Kie API) Set up your API key in the HTTP Request node (Generate Video with VEO3). Blotato Connect your Blotato account for TikTok publishing. Schedule Trigger Adjust the Start Daily Content Generation node to fit your preferred posting frequency. How to customize this workflow to your needs Platforms**: Extend publishing to YouTube Shorts or Instagram Reels by duplicating the TikTok step. Frequency**: Change the Schedule Trigger to post multiple times per day or only a few times per week. Creative Style**: Modify the system prompts to align with your brand’s style (cinematic, minimalist, neon, etc.). Tracking**: Enhance the Google Sheets logging with engagement metrics by pulling TikTok analytics via Blotato. This workflow helps you build a hands-free AI-powered content engine, turning raw ideas into published viral videos every day. 📄 🎥 Watch This Tutorial: Step by Step 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube

Transcript → AI Analysis → Formatted Doc This workflow automatically converts Fathom meeting transcripts into beautifully formatted Google Docs with AI-generated summaries, key points, decisions, and action items. Good to know Works fully with Fathom free account Webhook responds immediately to prevent Fathom timeout and duplicate triggers Validates transcript quality (3+ conversation turns) before AI processing to save costs Uses Google Gemini API (generous free tier and rate limits, typically enough to avoid paying for API requests, but check latest pricing at Google AI Pricing) Creates temporary HTML file that's auto-deleted after conversion Who's it for Individuals or teams using Fathom for meetings who want more control and flexibility with their AI meeting analysis and storage independently of Fathom, as well as automatic, formatted documentation without manual note-taking. Perfect for recurring syncs, client meetings, or interview debriefs. How it works Fathom webhook triggers when meeting ends and sends transcript data Validates transcript has meaningful conversation (3+ turns) Google Gemini AI analyzes transcript and generates structured summary (key points, decisions, actions, next steps) Creates formatted HTML with proper styling Uploads to Google Drive and converts to native Google Doc Reduces page margins for readability and deletes temporary HTML file Requirements Fathom account with API webhook access (available on free tier) Google Drive account (OAuth2) Google Docs account (OAuth2) Google Gemini API key (Get free key here) How to set up Add credentials: Google Drive OAuth2, Google Docs OAuth2, Google Gemini API Copy the webhook URL from the Get Fathom Meeting webhook node (Test URL first, change to Production URL when ready) In Fathom: Settings → API Access → Add → Add webhook URL and select all events including "Transcript" Test with a short meeting, verify Google Doc appears in Drive Activate workflow Customizing this workflow Change save location: Edit "Upload File as HTML" node → update "Parent Folder" Modify AI output: Edit "AI Meeting Analysis" node → customize the prompt to add/remove sections (e.g., risks, follow-ups, sentiment, etc) Adjust document margins: Edit "Reduce Page Margins" node → change margin pixel values Add notifications: E.g. add Slack/Email node after "Convert to Google Doc" to notify team when summary is ready Quick Troubleshooting "Transcript Present?" fails: Fathom must send transcript_merged with 3+ conversation turns (i.e. only send to Gemini for analysis if there's a genuine transcript) HTML as plain text: Check "Convert to Google Doc" uses POST to /copy endpoint 401/403 errors: Re-authorize Google credentials Inadequate meeting notes: Edit prompts in "AI Meeting Analysis" node Sample File and Storage Output Google Doc meeting notes - sample Google Drive sample folder output:

This n8n template from Intuz provides a complete end-to-end content factory to automate the entire lifecycle of creating and publishing AI-driven videos. It transforms a single text prompt into a fully scripted, visually rich video with AI-generated images and voiceovers, then distributes it across multiple social media platforms. Who's this workflow for? Content Creators & YouTubers Social Media Managers & Agencies Digital Marketers & Entrepreneurs Brands looking to scale video content production Objective Generate viral video scripts with Gemini AI (via LangChain). Break scripts into structured scenes(hooks, retention, CTA). Create image prompts and high-quality background visuals automatically. Store all scenes, prompts, images, and metadata into Airtable. Handle file formatting, uploads, and naming automatically. Add error handling and retry logic for smooth execution. Uploading into Social Media platforms. How it works 1. AI Script Generation: The workflow starts with a single command. A powerful Google Gemini AI model, acting as a "Content Brain," generates a complete, viral video script with a title, description, and multiple scenes. 2. Content Management in Airtable: The entire script is broken down and saved systematically into an Airtable base, which acts as the central Content Management System (CMS) for the video production pipeline. 3. AI Image Generation: The workflow loops through each scene in Airtable. It uses an AI agent to enhance the image prompts and sends them to an image generation API (like Pollinations.ai) to create a unique, high-quality image for each scene. These images are then automatically uploaded back into Airtable. 4. Automated Video Rendering: Once all images are ready, the workflow gathers the script text and the corresponding image URLs from Airtable and sends them to Creatomate. Creatomate uses a pre-defined template to assemble the final video, complete with AI-generated voiceovers for each scene. 5. Multi-Platform Publishing: After a brief wait for the video to render, the workflow retrieves the final video file and automatically publishes it across your connected social media channels, including YouTube and Instagram. Key Requirements to Use This Template Before you start, please ensure you have the following accounts and assets ready: 1. n8n Instance & Required Nodes: An active n8n account (Cloud or self-hosted). This workflow relies on the official n8n LangChain integration (@n8n/n8n-nodes-langchain). If you are using a self-hosted version of n8n, please ensure this package is installed on your instance. 2. AI & Video Accounts: Google Gemini AI Account: A Google Cloud account with the Vertex AI API enabled and an API Key. Creatomate Account: It's platform to generate videos. An account with Creatomate for video rendering, and your API key and a pre-designed video template ID. 3. Content & Social Media Accounts: Airtable Account: An Airtable base set up to manage the video content. Using the complementary Airtable template is highly recommended. YouTube Account: A YouTube channel with API access enabled via Google Cloud Console. Upload-Post.com Account: An account for posting to other platforms like Instagram. Workflow Steps 1.▶️ Trigger (Manual/Auto) Start workflow manually or via schedule. 2.🧠 Content Brain (Gemini + LangChain) Role-trained viral strategist prompt. Generates 6 scene scripts with: Hook → Retention → Value → CTA. Follows viral content rules (engagement triggers, curiosity gaps, shareable moments). 3.📑 Structured Output Parser Enforces JSON schema: video_id video_title description scenes[] → scene_number, text, image_prompt 4.📄 Airtable – Store Scenes Each scene stored with: Video ID, Title, Description Scene Number & Text Image Prompt & Generated Image link 5.🤖 AI Agent – Image Prompt Creator Transforms scene text →optimized image prompts using structured rules. 6.🎨 Pollination AI – Image Generation Generates vertical 9:16 visuals with parameters: Model: flux Resolution: 1080x1920 Steps: 12 Guidance Scale: 3.5 Safety Checker: Enabled Options: seed=42, nologo=true 7.📂 File Handling & Conversion Assigns filenames automatically (e.g., images_001.png). Converts binary image → base64 for Airtable storage. 8.📤 Airtable Upload – Store Images Attaches generated visuals directly into Generated Image field. 9.⚡ Switch & Error Handling Branches for: ✅ Success → continue ❌ Failed → stop with error message ⏳ Processing → wait/retry 10.Social Media Upload In YouTube via YouTube API from official documentation In Instagram Via Upload Post API Setup Instructions 1. AI Configuration: In the Google Gemini Chat Model nodes, connect your Google Gemini API account. In the Content Brain node, you can customize the core prompt to change the video's niche, style, or topic. 2. Airtable Setup (Crucial): Connect your Airtable account in the Airtable nodes. Set up your Airtable base using the provided template or ensure your base has identical table and field names. Update the Base ID and Table IDs in the Airtable nodes. Airtable Schema: 3. Video Rendering Setup (Creatomate): In the Video Rendering - Creatomate node, add your Creatomate API key to the header authorization. In the Template for Creatomate node, replace the template_id with the ID of your own video template from your Creatomate account. 4. Social Media Connections: In the Upload on YouTube node, connect your YouTube account via OAuth2. In the Upload on Instagram node, replace the API key in the header authorization with your key from Upload-Post.com. 5. Execute the Workflow: Click "Execute workflow" to kick off your automated video content factory. Connect with us Website: https://www.intuz.com/services Email: getstarted@intuz.com LinkedIn: https://www.linkedin.com/company/intuz Get Started: https://n8n.partnerlinks.io/intuz For Custom Worflow Automation Click here- Get Started

This n8n template drafts customer-ready email replies using Google Gemini, enriched with HubSpot context (contact, deals, companies, tickets). Each draft is routed to Slack for one-click approval before it’s sent from Gmail—so you move fast without losing control. Ideal for support and sales teams that want speedy, personalized responses while keeping humans in the loop. How it works Gmail Trigger** watches for new inbound emails. Sender filter** excludes internal domains (e.g., n8n.io) to avoid auto-replying to teammates. HubSpot contact lookup* finds the sender and fetches associated *deals/companies/tickets** via association + batch read. CRM context is normalized** into clean, LLM-friendly fields (no IDs or sensitive noise). Gemini (Google AI Studio)** generates a concise, friendly reply using: Sender name, subject, and message snippet Safe, relevant HubSpot context (e.g., top 1–2 deals or an open ticket) Style constraints (≤ \~150 words, single CTA, optional clarifying question) Slack approval* posts the draft to a channel; if *approved, n8n **replies via Gmail in the original thread. How to use Gmail: Connect the same account for the trigger and reply nodes. HubSpot: Connect OAuth on the search + HTTP request nodes. Gemini: Add your Google AI Studio API key to the Google Gemini Chat Model node. Slack: Connect and select the channel for draft approvals. (Optional) Filter: Adjust the Allowed Sender filter before going live. (Optional) Prompt: Edit “Draft Reply (AI Agent)” tone/length or how much CRM detail to include. Activate the workflow. New emails will produce Slack-approved replies automatically. Requirements Gmail** (trigger + send) HubSpot** (OAuth2) for contact + associations Slack** for approval step Google Gemini** (Google AI Studio API key) Notes & customization Safety rails:** The prompt avoids exposing IDs/raw JSON and caps CRM details to what’s useful. Auto-send mode:** Skip Slack if you want fully automated replies for specific senders/labels. Richer context:** Extend the batch read to pull more properties (e.g., next step, renewal date). Triage:** Branch on subject/labels to route billing vs. technical requests to different prompts. QA queue:* If the model asks a clarifying question, keep it to *one**—the node enforces that.

How it works This workflow enriches and personalizes your lead profiles by integrating HubSpot contact data, scraping social media information, and using AI to generate tailored outreach emails. It streamlines the process from contact capture to sending a personalized email — all automatically. The system fetches new or updated HubSpot contacts, verifies and enriches their Twitter/LinkedIn data via Phantombuster, merges the profile and engagement insights, and finally generates a customized email ready for outreach. Step-by-step 1. Trigger & Input HubSpot Contact Webhook: Fires when a contact is created or updated in HubSpot. Fetch Contact: Pulls the full contact details (email, name, company, and social profiles). Update Google Sheet: Logs Twitter/LinkedIn usernames and marks their tracking status. 2. Validation Validate Twitter/LinkedIn Exists: Checks if the contact has a valid social profile before proceeding to scraping. 3. Social Media Scraping (via Phantombuster) Launch Profile Scraper & 🎯 Launch Tweet Scraper: Triggers Phantombuster agents to fetch profile details and recent tweets. Wait Nodes: Ensures scraping completes (30–60 seconds). Fetch Profile/Tweet Results: Retrieves output files from Phantombuster. Extract URL: Parses the job output to extract the downloadable .json or .csv data file link. 4. Data Download & Parsing Download Profile/Tweet Data: Downloads scraped JSON files. Parse JSON: Converts the raw file into structured data for processing. 5. Data Structuring & Merging Format Profile Fields: Maps stats like bio, followers, verified status, likes, etc. Format Tweet Fields: Captures tweet data and associates it with the lead’s email. Merge Data Streams: Combines tweet and profile datasets. Combine All Data: Produces a single, clean object containing all relevant lead details. 6. AI Email Generation & Delivery Generate Personalized Email: Feeds the merged data into OpenAI GPT (via LangChain) to craft a custom HTML email using your brand details. Parse Email Content: Cleans AI output into structured subject and body fields. Sends Email: Automatically delivers the personalized email to the lead via Gmail. Benefits Automated Lead Enrichment — Combines CRM and real-time social media data with zero manual research. Personalized Outreach at Scale — AI crafts unique, relevant emails for each contact. Improved Engagement Rates — Targeted messages based on actual social activity and profile details. Seamless Integration — Works directly with HubSpot, Google Sheets, Gmail, and Phantombuster. Time & Effort Savings — Replaces hours of manual lookup and email drafting with an end-to-end automated flow.