Workflow Templates

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

This automated workflow template turns any Telegram bot into a powerful AI-powered social media assistant that analyzes voice notes, images, videos, and text to generate platform-optimized descriptions and automatically posts to TikTok, Instagram, YouTube, Pinterest, LinkedIn, X (Twitter), and Threads. Simply send any content type to your Telegram bot, review AI-generated descriptions, approve with one tap, and publish across all platforms instantly. https://www.youtube.com/watch?v=9WskxNELBjo Note:* This workflow uses **OpenAI for voice transcription, Google Gemini for image/video analysis, and Upload-Post.com API for multi-platform publishing. All AI-generated content is sent for approval before posting, giving you full control. Who Is This For? Content Creators & Influencers:** Turn raw content into polished, multi-platform posts in seconds without switching apps. Social Media Managers:** Handle client content from any format and distribute across all platforms from one chat interface. Marketing Teams:** Streamline content workflows with AI-powered description generation and instant multi-platform publishing. Agencies & Freelancers:** Offer clients a branded, efficient content distribution system without manual copy-pasting. Busy Professionals:** Post to all your social channels while on the go, directly from Telegram. Why This Matters Creating platform-specific content is time-consuming. You record a video, take a photo, or have an idea, then spend 30+ minutes crafting unique descriptions for each platform, logging into multiple accounts, and manually posting. This template: Saves Hours Daily:** AI analyzes your content and generates optimized descriptions for every platform automatically. Handles Any Content Type:** Voice notes, photos, videos, or text—all processed intelligently with the right AI tool. Platform Optimization:** Each social network gets descriptions tailored to its character limits and best practices (TikTok hooks, LinkedIn tone, X threads, etc.). One-Tap Approval:** Review all descriptions in Telegram, approve, and publish everywhere instantly. No Context Switching:** Stay in Telegram—no logging into multiple apps or dashboards. How It Works Send Content to Telegram: Forward or create a voice note, photo, video, or text message to your bot. AI Analysis: Voice: OpenAI Whisper transcribes → generates text post descriptions Photos: Google Gemini analyzes image → creates TikTok, Instagram, Pinterest descriptions Videos: Google Gemini analyzes video → creates TikTok, Instagram, YouTube descriptions with titles Text: Processes directly → creates Threads, LinkedIn, and X (Twitter) posts/threads Structured Output: AI agents use schema-based output parsers to ensure consistent, platform-specific formatting. Review & Approve: Telegram sends you all generated descriptions with a simple approve/reject button. Automatic Publishing: Upon approval, Upload-Post publishes to all selected platforms simultaneously. Status Confirmation: Receive upload status for each platform (success/failure with URLs and error messages). Setup Telegram Bot Create a bot via @BotFather, generate an access token, and add it as credentials in the Telegram Trigger node. OpenAI API Sign up at OpenAI, purchase credits, and add your API key for voice transcription (Whisper). Google Gemini API Get a Gemini API key from Google AI Studio and add credentials for image/video analysis. Upload-Post Account Create an account at upload-post.com, connect your social media accounts, generate an API token, and add credentials. Configure Variables In the Edit Fields node, set: upload_post_user: Your Upload-Post profile name pinterest_board_id: Your Pinterest board ID (if using Pinterest) Customize AI Prompts (Optional) Edit system prompts in the AI Agent nodes to match your brand voice, tone, and content style. Requirements Accounts:** Telegram, OpenAI, Google Gemini, Upload-Post.com, social media accounts you want to publish to API Keys/Creds:** Telegram Bot Token, OpenAI API key, Google Gemini API key, Upload-Post API credentials Credits:** OpenAI credits for transcription, Gemini credits for vision analysis (both pay-as-you-go) Features Multimodal AI Processing:** Handles voice, images, videos, and text with the right AI model for each type. Smart Content Routing:** Switch node detects message type and routes to the appropriate analysis pipeline. Platform-Specific Optimization:** Character limits, hashtags, and formatting tailored per platform (TikTok 90 chars, X threads, etc.). Structured Output Parsing:** JSON schema ensures consistent, parsable AI responses for reliable automation. Human-in-the-Loop Approval:** Review and approve all AI-generated content before publishing. Multi-Platform Publishing:** Simultaneous posting to 7+ platforms: TikTok, Instagram, YouTube, Pinterest, LinkedIn, X, Threads. Real-Time Status Updates:** Get detailed upload confirmations with success status, post URLs, and error messages. Conversation History:** The bot processes each message independently, making it easy to manage multiple content pieces. Extensible Architecture:** Add new platforms, AI models, or processing steps easily thanks to modular design. Supported Platforms by Content Type Photos:** TikTok, Instagram, Pinterest Videos:** TikTok, Instagram, YouTube Text/Voice:** LinkedIn, X (Twitter), Threads Use this template to transform your Telegram into a complete social media command center—analyze any content with AI and publish everywhere in seconds.

Auto-Generate Social Media Videos with GPT-5 and Publish via Blotato > ⚠️ Disclaimer: This workflow uses Community Nodes (Blotato) and requires a self-hosted n8n instance with "Verified Community Nodes" enabled. 👥 Who is this for? This workflow is perfect for: Content creators and influencers who post regularly on social media Marketing teams that want to scale branded video production Solo entrepreneurs looking to automate their video marketing Agencies managing multi-client social media publishing 💡 What problem is this workflow solving? Creating high-quality video content and publishing consistently on multiple platforms is time-consuming. You often need to: Write compelling captions and titles Adapt content to fit each platform’s requirements Publish manually or across disconnected tools This workflow automates the entire process — from idea to publishing — so you can focus on growth and creativity, not logistics. ⚙️ What this workflow does Receives a video idea via Telegram Saves metadata to Google Sheets Transcribes the video using OpenAI Whisper Generates a catchy title and caption using GPT-5 Uploads the final media to Blotato Publishes the video automatically to: TikTok Instagram YouTube Shorts Facebook X (Twitter) Threads LinkedIn Pinterest Bluesky Updates the post status in Google Sheets Sends confirmation via Telegram 🧰 Setup Before launching the workflow, make sure to: Create a Blotato Pro account and generate your API Key Enable Verified Community Nodes in the n8n Admin Panel Install the Blotato community node in n8n Create your Blotato credential using the API key Make a copy of this Google Sheet template Ensure your Google Drive folder with videos is shared publicly (viewable by anyone with the link) Link your Telegram Bot and configure the trigger node Follow the sticky note instructions inside the workflow 🛠️ How to customize this workflow Modify the GPT-5 prompt to reflect your brand voice or campaign tone Add/remove social platforms depending on your strategy Include additional AI modules (e.g., for voiceover or thumbnails) Insert review/approval steps (via Slack, email, or Telegram) Connect Airtable, Notion, or your CRM to track results This is your all-in-one AI video publishing engine, built for automation, scale, and growth across the social web. 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. How it works • Publishes content to 9 social platforms (Instagram, YouTube, TikTok, Facebook, LinkedIn, Threads, Twitter/X, Bluesky, Pinterest) from a single Airtable base • Automatically uploads media to Blotato, handles platform-specific requirements (YouTube titles, Pinterest boards), and tracks success/failure for each post • Includes smart features like GPT-powered YouTube title optimization, Pinterest Board ID finder tool, and random delays to avoid rate limits Set up steps • Takes ~20–35 minutes to configure all 9 platforms (or less if you only need specific ones) • Requires Airtable personal access token, Blotato API key, and connecting your social accounts in Blotato dashboard • Workflow includes comprehensive sticky notes with step-by-step Airtable base setup, credential configuration, platform ID locations, and quick debugging links for each social network Pro tip: The workflow is modular - you can disable any platforms you don't use by deactivating their respective nodes, making it flexible for any social media strategy from single-platform to full omnichannel publishing.

Introduction Automates overseas conference approval requests to CEO. Generates emails with conference details, flight quotes, accommodation, expense breakdown, and admin procedures. Ensures consistency and saves time. How It Works Manual trigger initiates: fetches exchange rates/conference details, parses flight quotes, uses AI to calculate expenses and generate draft, checks budget, formats messages, merges versions, creates PDF, sends to CEO, logs to tracker. Workflow Template Manual Trigger → Configuration → [Exchange Rates + Conference Details + Flight Quotes] → AI Agent → [GPT-4 + Calculate + Extract + Generate Tools] → Total Expenses → Budget Check → [Format Approved + Warning] → Merge → PDF → Send CEO → Log Tracker Workflow Steps Initialization: Manual trigger with conference parameters, sets variables (name, dates, location, funding) Data Collection: Fetches/parses exchange rates, conference details via HTTP, aggregates 3 flight quotations AI Processing: AI Agent orchestrates GPT-4 with Calculate, Extract, Generate tools for expense analysis and email drafting Validation: Calculates total expenses, validates against budget threshold Formatting: Customizes approval/warning messages by status, merges content versions Delivery: Generates PDF breakdown, dispatches via Gmail to CEO, logs to Google Sheets tracker Setup Instructions APIs: Configure currency/conference endpoints with credentials OpenAI: Add GPT-4 API key in AI Agent AI Tools: Set Calculate, Extract, Generate parameters Gmail: Connect account, set CEO recipient Sheets: Link tracker with write permissions Budget: Set threshold (default: $5000) Prerequisites n8n instance, Currency API, Conference API, OpenAI GPT-4 key, Gmail with OAuth, Google Sheets, PDF generator, Travel agent API Use Cases Academic: Staff requests conference with grant, registration, 3 quotes, hotel, visa. AI generates email with PO/card procedures. Sales: Manager seeks client meeting approval with comparisons, per diem. Training: Employee requests certification with fees, accommodation, transport. Customization Modify thresholds by department. Add categories (insurance, baggage). Customize AI prompts for tone/branding. Integrate flight sources. Extend approval chain. Add travel restrictions. Benefits Time Efficient: Reduces prep from 60+ to 5 minutes. AI-Powered: Intelligent analysis and generation. Consistent: Ensures completeness. Accurate: Eliminates errors.

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Intelligent Document Monitoring and Alert System This workflow creates an automated monitoring system that watches for new PDF reports across multiple sources, extracts key insights using AI, and sends formatted alerts to your team via Slack or email. By combining PDF Vector's parsing capabilities with GPT-powered analysis, teams can stay informed about critical documents without manual review, ensuring important information never gets missed. Target Audience & Problem Solved This template is designed for: Finance teams** monitoring quarterly reports and regulatory filings Compliance officers** tracking policy updates and audit reports Research departments** alerting on new publications and preprints Operations teams** monitoring supplier reports and KPI documents Executive assistants** summarizing board materials and briefings It solves the problem of information overload by automatically processing incoming documents, extracting only the most relevant insights, and delivering them in digestible formats to the right people at the right time. Prerequisites n8n instance with PDF Vector node installed PDF Vector API credentials with parsing capabilities OpenAI API key for insight extraction Slack workspace admin access (for Slack alerts) SMTP credentials (for email alerts) FTP/Cloud storage access for document sources Minimum 50 API credits for continuous monitoring Step-by-Step Setup Instructions Configure Document Sources Set up FTP credentials in n8n for folder monitoring Or configure Google Drive/Dropbox integration Define the folder paths to monitor Set file naming patterns to watch (e.g., "report.pdf") Set Up API Integrations Add PDF Vector credentials in n8n Configure OpenAI credentials with appropriate model access Set up Slack app and add webhook URL Configure SMTP settings for email alerts Configure Monitoring Schedule Open the "Check Every 15 Minutes" node Adjust frequency based on your needs: // For hourly checks: "interval": 60 // For real-time monitoring (every 5 min): "interval": 5 Customize Alert Channels Slack Setup: Create dedicated channels (#reports, #alerts) Configure webhook for each channel Set up user mentions for urgent alerts Email Setup: Define recipient lists by document type Configure email templates Set up priority levels for subject lines Define Alert Rules Modify the "Extract Key Insights" prompt for your domain Set conditions for high-priority alerts Configure which metrics trigger notifications Define sentiment thresholds Implementation Details The workflow implements a comprehensive monitoring pipeline: Source Monitoring: Polls multiple sources for new PDFs Intelligent Parsing: Uses LLM-enhanced parsing for complex documents Insight Extraction: AI analyzes content for key information Priority Classification: Determines alert urgency based on content Multi-Channel Delivery: Sends formatted alerts via configured channels Audit Trail: Logs all processed documents for compliance Customization Guide Adding Custom Document Types: Extend the routing logic for specific document types: // In "Route by Document Type" node: const documentTypes = { 'invoice': /invoice|bill|payment/i, 'contract': /contract|agreement|terms/i, 'report': /report|analysis|summary/i, 'compliance': /audit|compliance|regulatory/i }; Customizing Insight Extraction: Modify the AI prompt for domain-specific analysis: // Financial documents: "Extract: 1) Revenue figures 2) YoY growth 3) Risk factors 4) Guidance changes" // Compliance documents: "Extract: 1) Policy changes 2) Deadlines 3) Required actions 4) Penalties" // Research papers: "Extract: 1) Key findings 2) Methodology 3) Implications 4) Future work" Advanced Alert Formatting: Create rich Slack messages with interactive elements: // Add buttons for quick actions: { "type": "actions", "elements": [ { "type": "button", "text": { "type": "plain_text", "text": "View Full Report" }, "url": documentUrl }, { "type": "button", "text": { "type": "plain_text", "text": "Mark as Read" }, "action_id": "mark_read" } ] } Implementing Alert Conditions: Add sophisticated filtering based on content: // Alert only if certain conditions are met: if (insights.metrics.revenue_change < -10) { priority = 'urgent'; alertChannel = '#executive-alerts'; } if (insights.findings.includes('compliance violation')) { additionalRecipients.push('legal@company.com'); } Adding Document Comparison: Track changes between document versions: // Compare with previous version: const previousDoc = await getLastVersion(documentType); const changes = compareDocuments(previousDoc, currentDoc); if (changes.significant) { alertMessage += \n⚠️ Significant changes detected: ${changes.summary}; } Alert Features: Monitor multiple document sources (FTP, cloud storage, email) Extract key metrics and findings with AI Send rich, formatted notifications Track document processing history Conditional alerts based on content analysis Multi-channel alert routing Use Cases: Financial report monitoring Compliance document tracking Research publication alerts Customer report distribution Board material summarization Regulatory filing notifications Advanced Configuration Performance Optimization: Implement caching to avoid reprocessing Use batch processing for multiple documents Set up parallel processing for different sources Security Considerations: Encrypt sensitive document storage Implement access controls for different alert channels Audit log all document access

🧠 Overview Generate empathetic, professional reply drafts for customer or user messages. The workflow detects sentiment, tone, and risk level, drafts a concise response, sanitizes PII/links/emojis, and auto-escalates risky or low-confidence cases to human review. ⚙️ How It Works Input — Manual Test or Webhook Trigger AI Agent (Empathy) — returns { sentiment, tone, reply, confidence, needs_handover } Post-Process & Sanitize — removes URLs/hashtags, masks PII, caps length Risk & Handover Rules — checks confidence threshold, risk words, and negativity Routing — auto-send safe replies or flag to Needs Review 🧩 Setup Instructions (3–5 min) Open Set Config1 and adjust: MAX_LEN (default 600) ADD_FOLLOWUP_QUESTION (true/false) FORMALITY (auto | casual | polite) EMOJI_ALLOWED (true/false), BLOCK_LINKS (true/false) RISK_WORDS (e.g., refund, lawsuit, self-harm) Connect Anthropic credential to Anthropic Chat Model (Optional) Replace Manual Trigger with Webhook Trigger for real-time use > Tip: If you need to show literal angle brackets in messages, use backticks like `<example>` (no HTML entities needed). 📚 Use Cases 1) SaaS Billing Complaints Input:** “I was billed after canceling. This is unacceptable.” Output:** Calm, apologetic reply with refund steps; escalates if refund is in RISK_WORDS or confidence < 0.45. 2) Product Bug Reports Input:** “Upload fails on large files since yesterday.” Output:** Acknowledges impact, requests logs, offers workaround; routes to auto-send if low risk and high confidence. 3) Delivery/Logistics Delays Input:** “My order is late again. Should I file a complaint?” Output:** Empathetic apology, ETA guidance, partial credit policy note; escalates if language indicates legal action. 4) Community Moderation / Abuse Input:** “Support is useless—you’re all scammers.” Output:** De-escalating, policy-aligned response; auto-flags due to negative sentiment + risk keyword match. 5) Safety / Self-harm Mentions Input:** “I feel like hurting myself if this isn’t fixed.” Output:* *Immediate escalation**, inserts approved resources; never auto-sends. 🚨 Auto-Escalation Rules (defaults) Negative** sentiment Message matches any RISK_WORDS confidence < 0.45 Mentions of legal, harassment, or self-harm context 🧪 Notes & Best Practices 🔐 No hardcoded API keys — use n8n Credentials 🧭 Tune thresholds and RISK_WORDS to your org policy 🧩 Works on self-hosted or cloud n8n ✅ Treat outputs as drafts; ship after human/policy review 🔗 Resources GitHub (template JSON):** https://github.com/yskmtb0714/n8n-workflows/blob/main/empathy-reply-assistant.json

🤖 Instagram Automation Suite: AI Chatbot & Content Powerhouse Workflow Overview This cutting-edge n8n workflow is a comprehensive automation solution designed to streamline various Instagram operations. It combines an intelligent AI chatbot for direct message management, automated user following, and an advanced content generation system, all integrated to enhance your Instagram presence and efficiency. This workflow automatically: Manages Instagram Direct Messages via Telegram Chatbot: Listens for new messages on Telegram. Routes messages from a specific Instagram user (Wolf23000) for processing. Utilizes an AI agent (powered by OpenRouter's cutting-edge models) to determine the intent of the message (e.g., chat back, run an Instagram-related action like getting profile info, posting, or following). Sends AI-generated responses back to the user via Telegram. Automates Instagram User Following: Scheduled to run at regular intervals (hourly). Processes a list of usernames (likely from a Google Sheet, though not explicitly shown in the provided JSON, it's a common pattern for "Auto Follow users from sheet" sticky note). Initiates following actions on Instagram for the specified users. Generates & Schedules Instagram Posts: Scheduled to run monthly. Leverages an AI agent (powered by OpenRouter) to generate 30 or 31 Instagram post ideas for the current month, based on a predefined "Instagram personality profile." Each post idea includes an imagePrompt (for AI image generation), a caption with emojis and hashtags, and a scheduledDate. Refines these post ideas by enhancing the imagePrompt to be more vivid and detailed for AI image generation, and polishing the caption for optimal engagement. Updates a Google Sheet ("posts generation plan") with the generated content, including the enhanced image prompts and the resulting image URLs (presumably from a separate image generation step not fully detailed in the provided JSON, but implied by image_url updates). Key Benefits Intelligent DM Management: Automate responses and actions for Instagram direct messages, ensuring timely and relevant interactions without manual effort. Effortless Audience Growth: Automatically follow target users, expanding your reach and potential engagement on Instagram. AI-Powered Content Creation: Generate a full month's worth of diverse, engaging Instagram post ideas tailored to a specific personality, complete with image prompts and captions. Content Optimization: Automatically enhance image prompts for better AI image generation and refine captions for maximum impact. Time-Saving: Significantly reduce the manual workload associated with Instagram management, from direct messages to content planning and execution. Consistent Brand Voice: Maintain a consistent and engaging presence on Instagram with AI-generated content aligned with your defined personality. Setup Requirements To set up and run this workflow, you'll need the following: n8n Installation: Install n8n (cloud or self-hosted). The latest stable version, as of July 2025, is v1.101.1. Import the workflow configuration. Configure API credentials for all integrated services. Set up scheduling preferences for continuous operation. System Requirements for Self-Hosting: A modern multi-core processor (2 cores minimum, 4 recommended), 2 GB RAM (4 GB or more recommended), and 20 GB of free SSD storage. Node.js version 16 or later (18.x LTS recommended) is required. PostgreSQL is the recommended database for production. Telegram API Access: Create a Telegram bot via BotFather and obtain your API token. Configure the Telegram Trigger node with your bot's API credentials to receive messages. Pricing: Telegram's API is free to use. OpenRouter API Access: Create an OpenRouter account and generate an API key. This key ({{your open router api key }} as seen in the code) is used to access their chat models (e.g., google/gemini-2.5-flash-preview) for AI agent operations. Pricing: OpenRouter offers a variety of models with different pricing structures, including some free models like DeepSeek R1. Most models operate on a pay-per-usage basis, with costs clearly displayed for each model and prompt. Instagram Session ID: You'll need a valid Instagram session ID ({{ your instagram session ID }} as seen in the code) for the workflow to interact with Instagram. This usually involves extracting it from your browser's cookies after logging into Instagram. Caution: Instagram's terms of service generally prohibit automated interactions, and using session IDs for scraping or automation can lead to account suspension. Use with extreme caution and at your own risk. Apify token setup: *You'll need to replace {{ your apify token }} with you apify token in https requests Google Sheets Credentials: A Google Cloud API key with access to Google Sheets. Set up OAuth2 authentication in n8n for read/write access to your "posts generation plan" spreadsheet (Document ID: 1XHNwAXR4USThaAzX1Y6M5PF2P8WqCBU8mi34FBLkV6M). This sheet is used to store and manage generated post ideas. Pricing: The Google Sheets API is generally free for most common use cases, with generous per-minute quotas (300 read and 300 write requests per minute per project, 60 per user per project). No additional charges are incurred for exceeding these limits. https://docs.google.com/spreadsheets/d/1Ze5SC1g6Q5VzMAKYx0zmqlT00Db1HOchUth1jrPyM2Y/edit?usp=sharing https://docs.google.com/spreadsheets/d/1XHNwAXR4USThaAzX1Y6M5PF2P8WqCBU8mi34FBLkV6M/edit?usp=sharing Predefined Instagram Personality JSON: The workflow relies on a detailed JSON object defining an "Instagram personality" (e.g., user_id, username, full_name, bio, content_preferences, personality_traits, unfulancer_attributes). This JSON needs to be correctly set within the Code nodes (Variables, Variables1, Variables2) to guide the AI content generation. Workflow Architecture [Telegram New Message Trigger] ⬇️ [Variables (Set OpenRouter API Key, Instagram Personality, Session ID)] ⬇️ [Switch (Filter messages from 'Wolf23000' and ensure message text exists)] ⬇️ [Edit Fields (Extract message text)] ⬇️ [AI Agent (Determine action based on message intent)] ⬇️ [Structured Output Parser (Parse AI agent's JSON output)] ⬇️ [Switch1 (Route based on AI agent's determined action: chat_back, run_agent, get_instagram_profile)] ⬇️ ┌─────────────┬─────────────┬─────────────┐ │ │ │ │ ▼ ▼ ▼ ▼ [Send a text message1 (Chat back)] [Send a text message (Run agent confirmation)] [Send a text message2 (Get profile confirmation)] ▲ │ [Schedule Trigger (Hourly for Instagram follow)] ⬇️ [Variables (Set OpenRouter API Key, Instagram Personality, Session ID)] ⬇️ [Code (Prepare usernames for following)] ⬇️ [Code1 (Process followed usernames)] ⬇️ [Schedule Trigger2 (Monthly for Instagram post generation)] ⬇️ [AI Agent1 (Generate monthly Instagram post ideas)] ⬇️ [OpenRouter Chat Model (AI Model for content generation)] ⬇️ [Code2 (Parse AI agent's JSON output)] ⬇️ [Schedule Trigger3 (Daily for post generation refinement and auto-posting)] ⬇️ [AI Agent2 (Enhance image prompts and captions)] ⬇️ [OpenRouter Chat Model2 (AI Model for prompt refinement)] ⬇️ [Update row in sheet1 (Update Google Sheet with enhanced content)] ⬇️ [Get row(s) in sheet2 (Retrieve data from Google Sheet)] Connect With Me Exploring AI-Powered Social Media Automation? 📧 Email: mohamedgb00714@gmail.com 💼 LinkedIn: Mohamed el Hadi Msaid Supercharge your Instagram presence with intelligent automation and AI-driven content\! 🚀

This automation workflow transforms Meta advertising data into executive ready presentation decks, eliminating manual report creation while ensuring stakeholders receive consistent performance insights. It generates professional Google Slides presentations from your ad campaigns and delivers them automatically via email to designated recipients. By combining scheduled data extraction with AI-powered analysis and automated presentation building, you'll receive polished, actionable reports that facilitate strategic advertising decisions and client communication Key Features: Scheduled automated summary deck generation (daily, weekly, or monthly) AI powered data analysis using advanced language models Intelligent presentation generation with actionable recommendations Direct email delivery of formatted summary decks Prerequisites: GoMarble MCP account and API access Anthropic account Google Slides, Google Drive & Gmail accounts n8n instance (cloud or self-hosted) Configuration Time: ~15-20 minutes Step By Step Setup: 1. Connect GoMarble MCP to n8n Follow the integration guide: GoMarble MCP Setup Configure your Meta Ads account credentials in GoMarble platform 2. Configure the Schedule Trigger 3.Customize the Ad Account Settings. Update the account name to match your ad account name. 4. Customise the Report Prompt (Although the workflow includes a pre configured template report prompt) Define specific metrics and KPIs to track Set analysis parameters and report format preferences 5. Set up AI Agent Configuration Configure Anthropic Claude model with your API credentials Connect the GoMarble MCP tools for Meta advertising data 6. Configure Google Services Integration Set up Google Slides OAuth2 API for presentation creation Configure Google Drive OAuth2 API for file management Link Gmail OAuth2 for automated email delivery 7. Customize Email Delivery Set recipient email addresses for stakeholders Customize email subject line and message content Advanced Configuration Modify report prompt to include specific metrics and KPIs Adjust slide content structure (5-slide format: Executive Snapshot, Channel KPIs, Top Campaigns, Under-performers, Action Recommendations) What You'll Get Automated Presentation Creation: Weekly Google Slides decks generated without manual intervention Professional Ads Analysis: Executive-ready performance summaries with key metrics and insights Structured Intelligence: Consistent 5-slide format covering spend, ROAS, campaign performance, and strategic recommendations Direct Stakeholder Delivery: Presentations automatically emailed as attachments to specified recipients Data-Driven Insights: AI-powered analysis of campaign performance with actionable next steps Scalable Reporting: Easy to modify timing, recipients, or content structure as business needs evolve Perfect for marketing teams, agencies, and business owners who need regular Meta advertising performance updates delivered professionally without manual report creation.

📌 Title (SEO-Friendly) Automate Facebook Messenger orders to Google Sheets and Google Calendar Introduction This workflow automates Facebook Messenger order management by connecting your Facebook Page with Google Sheets and Google Calendar. It’s designed to help small businesses save time, reduce errors, and streamline order-taking. Every time a customer messages your page, they receive a structured order form, their responses are parsed, and the details are saved directly to Google Sheets. The same workflow also creates a Google Calendar event, ensuring you never miss a delivery or pickup schedule. Who’s It For Small businesses** selling products through Facebook Messenger. Entrepreneurs** who want to eliminate manual order-taking. Teams** that need a centralized order tracker (Google Sheets) and automatic reminders (Google Calendar). How It Works Listen to incoming messages on Facebook Messenger. Send an automated greeting and order form to the customer. Parse their responses (items, quantity, payment method, etc.). Save order details into Google Sheets for easy tracking. Create a matching Google Calendar event for the order date/time. Send a confirmation message and an optional upsell suggestion. Requirements Facebook Page** with Messenger enabled. Meta for Developers account** to create a Facebook App and generate a Page Access Token. Google Sheets** account with a spreadsheet containing the following columns: Date, Customer Name, Order Details, Payment Method, Order Status, Notes Google Calendar** account for order scheduling. n8n instance** (cloud or self-hosted). 💡 Security Best Practice: Store your Page Access Token and Google credentials in n8n Credentials (not hardcoded in nodes). Setup Instructions 1. Facebook Messenger Connection Go to Meta for Developers. Create a Messenger App and generate a Page Access Token. Copy the Webhook URL from your n8n Webhook Trigger node. Add the webhook URL and verify it in your Facebook Page settings. 2. Google Sheets Setup Create a new spreadsheet named Messenger Orders. Add columns: Date, Customer Name, Order Details, Payment Method, Order Status, Notes. Share the sheet with the Google account connected in n8n. 3. Google Calendar Setup Connect your Google Calendar credentials in n8n. Select the calendar where orders should be added. 4. Import & Configure Workflow Download this workflow template. Replace placeholders ({{YOUR_PAGE_ACCESS_TOKEN}}, {{YOUR_GOOGLE_SHEET_ID}}, etc.). Test by sending a message to your Facebook Page. Customization Personalize messages** in the Messenger node (greeting, upsell suggestions). Add extra fields such as delivery address or contact number to both the form and the Google Sheet. Extend the workflow by adding Telegram, Email, or SMS notifications for customers or staff. Use Filter nodes to route VIP orders or high-value purchases to a separate workflow. ⚡ Final Flow: Facebook Messenger → Order Form → Google Sheets → Google Calendar → Customer Confirmation 💬 Call to Action: Clone this workflow, connect your accounts, and start automating your Messenger orders in minutes!

How it works This workflow automates the handling of new lead responses received in Gmail. It captures emails with a specific label, analyzes the message using AI to determine sentiment, intent, urgency, next action, and priority, and then decides whether follow-up is needed. If required, it creates tasks in HubSpot, notifies the sales team via Slack, and logs all details into Google Sheets for tracking. Step-by-step Trigger on New Lead Email Workflow starts whenever a new email with a defined Gmail label arrives. Captures the sender’s email, subject, message snippet, and timestamp. Normalize Email Data Standardizes Gmail fields into structured values: leadEmail (sender’s address) subject (email subject) message (email content snippet) source (Gmail) receivedAt (timestamp) AI-Powered Lead Analysis Uses OpenAI to analyze the lead’s message. Extracts: Sentiment (Positive / Neutral / Negative) Intent (Interested, Not Interested, Needs Info, Ready to Buy, Objection) Urgency (High / Medium / Low) Next Action (Call, Email, Demo, Quote, No Action) Summary (1–2 sentence description) Priority (Hot / Warm / Cold) Parsed results are merged with the original email data. Flags are added: needsFollowUp (true/false) isHighPriority (true/false) Decision: Needs Follow-Up? If AI suggests a follow-up action, the workflow continues. Otherwise, the process stops here. Create HubSpot Task Automatically creates a HubSpot CRM task for the sales team. Task includes email subject, body, and lead details. Notify Sales Team on Slack Sends a formatted message to Slack with key lead insights: Summary Lead email Priority Urgency Date of analysis Log Lead Data to Google Sheets Appends structured data to Google Sheets for record-keeping. Stores all fields: Email, Date, Subject, Message, Sentiment, Intent, Urgency, Next Action, Summary, and Priority. Why use this? Automates lead triage directly from Gmail. Saves time by using AI-powered analysis instead of manual review. Ensures no potential lead is missed by logging into Google Sheets. Provides instant sales team alerts on high-priority leads. Integrates seamlessly with HubSpot CRM for structured follow-up. Keeps your sales pipeline efficient, organized, and proactive.

Research meeting attendees and prepare daily agenda in Slack This workflow automatically researches your meeting attendees every morning and sends you a comprehensive brief in Slack with context about who you're meeting, their company, and key talking points. Who's it for Sales professionals who need quick context before meetings Executives with packed calendars who need meeting preparation Customer success teams managing multiple client relationships Account managers preparing for client calls Business development teams researching prospects Anyone who wants to be better prepared for their daily meetings How it works Daily Trigger: Runs every weekday morning at 6 AM (customizable) to analyze your Google Calendar Calendar Analysis: Fetches all meetings scheduled for today and filters for external meetings (those with attendees other than yourself) AI-Powered Research: For each external meeting, an AI agent researches attendees using multiple sources: Searches your CRM (Attio) for existing contact information Queries Gmail history for past email interactions Searches past calendar events for previous meetings with attendees Performs web searches for recent news about attendees and their companies Retrieves company data from Apollo.io including industry, size, and technologies CRM Updates: Automatically creates new contact records in Attio for unknown attendees and adds meeting preparation notes to existing contacts Brief Generation: Compiles all research into a scannable, actionable meeting brief with key talking points Slack Delivery: Sends the formatted brief to your designated Slack channel for easy mobile access Setup requirements Google Calendar** OAuth2 connection (for fetching meetings) Slack** workspace with bot permissions (for receiving briefs) Gmail** OAuth2 connection (for email history search) OpenRouter** API key (for AI processing) Attio CRM** account and API token (optional - for contact management) Apollo.io** API key (optional - for company research) Anthropic** API key (optional - for advanced web search) How to customize Adjust Schedule: Modify the Schedule Trigger node to run at your preferred time - change from 6 AM to whenever works best for your schedule Customize Research Sources: Remove CRM integration if you don't use Attio Remove Apollo.io if you don't need company research Add additional research tools as needed Modify Output Format: Edit the prompt in "Format Daily Meeting Brief" node to change how the information is structured and presented Change Delivery Method: Replace Slack with Microsoft Teams, email, or Discord Add multiple delivery channels if needed Send to different channels based on meeting type Filter Meetings: Adjust the filtering logic to include/exclude certain types of meetings based on keywords, attendees, or calendar properties Advanced customization Add VIP alerts**: Create special handling for meetings with executives or key clients Include preparation documents**: Automatically attach relevant files from Google Drive Time zone handling**: Adjust for meetings across different time zones Language support**: Modify prompts to generate briefs in different languages