by Ronalds Palacis
🚀 AI-Powered LinkedIn Post Automation with Figma Templates 🧩 How It Works This workflow automatically generates professional, branded LinkedIn posts using your custom Figma designs. Perfect for marketers, agencies, content creators, and businesses who want to maintain consistent branding while automating social media content creation. Key Features: Design-first approach using Figma templates AI-powered content generation (optional) High-quality image generation from templates Automatic LinkedIn publishing Telegram notifications for success/failure tracking High-Level Workflow: Template Selection: Fetch your pre-designed Figma templates from Templated Content Preparation: Set static content or configure the prompts in the agents to generate with AI (ChatGPT/Claude) Image Generation: Create branded images with dynamic content via Templated MCP server LinkedIn Publishing: Automatically post text and image to your LinkedIn profile or company page (single image or carousel post) Notification: Receive Telegram alert on success/failure (optional) ⚙️ Set Up Steps (Quick Overview) 🕐 Estimated Setup Time: ~15 minutes Create Templated Account: Sign up at templated.cometai.eu, import Figma designs, generate API key Configure LinkedIn OAuth: Set up LinkedIn Developer app with OAuth2 credentials for automatic posting Connect Templated MCP: Add API key authentication to MCP server nodes for template and image generation Set Up Telegram (Optional): Create bot for workflow notifications Customize Content: Add static fields or configure AI nodes for dynamic content generation Schedule & Activate: Set posting schedule (daily, weekly, etc.) and activate workflow 💡 Important Notes Figma Integration**: Uses real Figma files as templates - maintain professional design quality without manual recreation Template Variables**: Supports dynamic placeholders in Figma text layers for content replacement Character Limits**: Respects maxLength settings to ensure text fits your design Rate Limits**: LinkedIn allows 25 posts/day (personal), 100/day (company pages) AI-Ready**: Easily integrate ChatGPT, Claude, or other AI models for content generation Batch Generation**: Generate multiple posts at once with different templates 🛠 Detailed Node Breakdown 1. Schedule Trigger Action**: Triggers the workflow on a schedule (daily, weekly, custom cron) Configuration**: Set your desired posting frequency Alternative**: Use manual trigger for on-demand posts 2. LinkedIn Post Writer (OpenAI Chat Model) Action**: AI generates engaging LinkedIn post content based on your topic/prompt Tools**: Simple Memory, Think, Date & Time, Search latest news Output**: Professional post text ready for publication 3. Carousel Ideator (Templated MCP Client) Action**: Connects to Templated MCP server to fetch available templates Configuration**: Uses your Templated API key for authentication Output**: Available template IDs and configurations for carousel generation 4. Generate the Carousel (POST to Templated MCP) Action**: Sends content to Templated server with template ID and field data Input**: Template selection, content fields (title, subtitle, etc.) Output**: Encoded carousel images generated from Figma templates 5. Extract from File Action**: Extracts generated image data from the MCP response Process**: Parses the encoded image string for LinkedIn upload 6. Get LinkedIn User Info (HTTP Request) Action**: Fetches your LinkedIn profile URN for post attribution Authentication**: OAuth2 LinkedIn credentials Output**: User ID required for posting 7. Initialize Upload URN Action**: Requests upload URL from LinkedIn for carousel document upload Process**: Prepares LinkedIn's upload mechanism for multi-image posts 8. Edit Fields Action**: Maps and formats data for LinkedIn API requirements Process**: Structures image data and post metadata correctly 9. Convert to Binary Action**: Converts image data to binary format Key**: Required format for LinkedIn document upload API 10. Upload Posts as Binary Action**: Uploads the carousel document to LinkedIn's servers Process**: Multi-part upload of generated images 11. Get Uploaded File URN Action**: Retrieves LinkedIn's asset ID for the uploaded content Output**: Asset URN needed for post creation 12. Switch (Conditional Logic) Action**: Handles success/error routing Routes**: Directs to LinkedIn post creation on success, error notification on failure 13. Create LinkedIn Post (HTTP Request) Action**: Creates the final LinkedIn post with carousel and text Authentication**: OAuth2 with LinkedIn posting permissions Result**: Published carousel post on your LinkedIn feed 14. Success/Error Notifications (Telegram) Action**: Sends notification about workflow execution status Success**: Confirms post published with details Error**: Alerts you to failures with error message and debugging info ⏱ Execution Time Breakdown Total Estimated Execution Time: ~10–30 seconds per workflow run Template Fetch: ~1–2 seconds Content Preparation: ~1–2 seconds Image Generation: ~5–15 seconds LinkedIn Post Upload: ~2–5 seconds Telegram Notification: ~1–2 seconds Note: AI content generation (if added) adds ~5-10 seconds 🚀 Ready to Get Started? What You'll Need: Free Templated account at templated.cometai.eu Figma designs with placeholder text LinkedIn Developer app (free) n8n instance (cloud or self-hosted) Quick Start: Import this workflow to your n8n instance Follow the setup guide in the workflow notes Test with a single post Schedule for automatic posting Sit back and watch your LinkedIn feed grow! 🎉 📝 Notes & Customizations Template Customization Create multiple templates in Figma for different content types (quotes, announcements, tips, etc.) Rotate templates for visual variety Use template descriptions to guide AI content generation Set character limits per placeholder to prevent overflow Content Generation Options Static Mode**: Define fields manually for recurring post types AI Mode**: Connect ChatGPT/Claude for dynamic, topic-based content Hybrid Mode**: Mix static brand elements with AI-generated copy Scheduled Variety**: Rotate between templates and content styles Advanced Features Multi-Platform**: Duplicate workflow for Twitter, Instagram, Facebook A/B Testing**: Track performance across different templates Content Calendar**: Pull scheduled posts from Notion/Airtable Analytics Integration**: Log post IDs for engagement tracking
by Luan Correia
Who’s it for This workflow is ideal for marketers, content creators, agencies, and small businesses that want to streamline the process of creating and publishing platform-optimized posts across multiple social media channels. How it works / What it does From a single user prompt, the workflow uses a custom system prompt and schema to generate tailored social media content for LinkedIn, Instagram, Facebook, Twitter (X), Threads, and YouTube Shorts. It creates platform-specific captions, hashtags, calls to action, and even AI-generated image suggestions, then routes the content to the correct publishing channel. How to set up Connect your social media platform credentials in n8n. Add your Google Docs links for the system prompt and content schema. Configure the IMGBB_API_KEY and any other required API credentials. Optionally connect Gmail and Telegram for approval workflows and notifications. Requirements n8n instance (self-hosted or cloud) API credentials for desired platforms Google Docs and Google Drive accounts How to customize the workflow Edit the system prompt and schema in Google Docs to adjust tone, style, and content format for each platform. Modify routing logic or add new platform integrations as needed.
by Yang
Who’s it for This template is perfect for content marketers, social media managers, and creators who want to repurpose YouTube videos into platform-specific posts without manual work. If you spend hours brainstorming captions, resizing content, or creating images for different platforms, this workflow automates the entire process from video selection to ready-to-publish posts. What it does The workflow takes a topic from a Google Sheet, finds the most relevant and recent YouTube video using Dumpling AI and GPT-4o, then automatically generates unique posts for Instagram, Facebook, and LinkedIn. Each post comes with a tailored AI-generated image, and all content is saved back into a Google Sheet for easy scheduling and review. Here’s what happens step by step: Picks an unsearched topic from Google Sheets Searches YouTube via Dumpling AI and sorts videos Uses GPT-4o to select the most relevant video Extracts the video transcript using Dumpling AI Generates three platform-specific posts using GPT-4o Creates matching images for each post using Dumpling AI image generation Saves the final Instagram, Facebook, and LinkedIn posts into a Google Sheet Marks the topic as processed so it won’t repeat How it works Scheduled Trigger: Starts the workflow automatically on a set schedule Google Sheets: Retrieves one unprocessed topic from the YouTube Topics sheet Dumpling AI: Finds and filters YouTube videos matching the topic GPT-4o: Chooses the best video and turns the transcript into three unique posts Dumpling AI (Image): Generates platform-specific visuals for each post Google Sheets: Saves all posts and images to the Social Media Post sheet for publishing Requirements ✅ Dumpling AI API key stored as credentials ✅ OpenAI GPT-4 credentials ✅ Google Sheets connection with the following sheets: YouTube Topics with columns Youtube Topics and Searched? Social Media Post with columns platform, Content, Image How to customize Adjust the GPT prompt to match your brand voice or content style Add or remove platforms depending on your posting strategy Change the schedule trigger frequency to fit your content calendar Integrate with scheduling tools like Buffer or Hootsuite for auto-publishing Add review or approval steps before posts are finalized > This workflow helps you transform a single YouTube video into three polished, platform-ready posts with matching visuals, in minutes—not hours.
by Yang
Who's it for This workflow is perfect for marketers, social media managers, recruiters, sales teams, and researchers who need to collect and organize public profile data from TikTok and LinkedIn. Whether you're building influencer databases, enriching CRM data, conducting competitor research, or gathering prospect information, this workflow automates the entire data extraction and storage process. What it does This AI-powered Telegram bot automatically scrapes public profile data from TikTok and LinkedIn, then saves it directly to Google Sheets. Simply send a TikTok username or LinkedIn profile URL via text or voice message, and the workflow handles everything: For TikTok profiles: Username and verification status Follower, following, and friend counts Total hearts (likes) and video count Bio link and secure user ID For LinkedIn profiles: Full name and profile picture Location and follower count Bio/about section Recent posts activity link All data is automatically organized into separate Google Sheets tabs for easy reference and analysis. You receive an email notification when extraction is complete. How it works The workflow uses an AI Agent as an intelligent router that determines which platform to scrape based on your input. Here's the flow: Input Processing: Send a message via Telegram (text or voice) Voice Transcription: If you send a voice note, OpenAI Whisper transcribes it to text AI Routing: The agent identifies whether it's TikTok or LinkedIn Profile Scraping: Calls Dumpling AI's specialized scraper for that platform Data Extraction: Parses the profile metrics and details Database Storage: Saves all data to the appropriate Google Sheets tab Confirmation: Sends an email notification when complete The AI agent ensures proper tool pairing - it always scrapes first, then saves, preventing partial data or errors. Setup Requirements Accounts & Credentials Needed: Telegram Bot Token (create via @BotFather) OpenAI API Key (for voice transcription and AI routing) Dumpling AI API Key (for profile scraping) Google Sheets OAuth2 credentials Gmail OAuth2 credentials (for notifications) Google Sheets Structure: Create a spreadsheet with two tabs: TikTok Tab - Columns: Username verified secUid bioLink followerCount followingCount heartCount videoCount friendCount LinkedIn Tab - Columns: name image location followers about recentPosts link How to set up Step 1: Create Telegram Bot Open Telegram and message @BotFather Use /newbot command and follow prompts Save your bot token for later Step 2: Configure Credentials Add Telegram bot token to "Receive Telegram Message" node Add OpenAI API key to "OpenAI Chat Model" and "Transcribe Audio" nodes Add Dumpling AI credentials as HTTP Header Auth Connect Google Sheets OAuth2 Connect Gmail OAuth2 Step 3: Set Up Google Sheets Create a new Google Spreadsheet Create two tabs: "TikTok" and "LinkedIn" Add column headers as specified above Copy the spreadsheet ID from the URL Step 4: Update Workflow Replace Google Sheets document ID in both database saver nodes Update email address in "Send Completion Email" node Remove personal credential names ("Nneka") Step 5: Test the Workflow Activate the workflow Message your bot with: "Scrape TikTok profile: @charlidamelio" Or try: "Extract this LinkedIn: https://www.linkedin.com/in/example" Check your Google Sheets for the data How to customize Add More Social Platforms: Create new scraper/saver tool pairs for Instagram, Twitter/X, or YouTube by: Adding new HTTP Request Tool nodes for scraping Adding corresponding Google Sheets Tool nodes Updating the AI Agent's system prompt with new protocols Enhance Voice Input: Add language detection for multilingual voice notes Implement speaker identification for team usage Add voice response capability Advanced Data Enrichment: Chain multiple profile lookups for followers Add sentiment analysis on bios and recent posts Implement automatic categorization/tagging Notification Improvements: Send results directly to Telegram instead of email Add Slack notifications for team collaboration Create detailed extraction reports with statistics Batch Processing: Modify to accept CSV files with multiple profiles Add rate limiting to avoid API throttling Implement queue system for large-scale scraping
by Yaron Been
Amplify Social Media Presence with O3 and GPT-4 Multi-Agent Team 🌍 Overview This n8n workflow acts like a virtual social media department. A Social Media Director Agent coordinates multiple specialized AI agents (Instagram, Twitter/X, Facebook, TikTok, YouTube, and Analytics). Each agent creates or analyzes content for its platform, powered by OpenAI models. The result? A fully automated, cross-platform social media strategy—from content creation to performance tracking. 🟢 Section 1: Trigger & Director Setup 🔗 Nodes: When chat message received (Trigger)** → Starts the workflow whenever you send a request (e.g., “Plan a TikTok campaign for my product launch”). Social Media Director Agent* (connected to *OpenAI O3 model**) → Acts as the strategist. Think Tool** → Helps the Director “reason” before delegating. 💡 Beginner takeaway: This section makes your workflow interactive. You send a request → the Director decides the best approach → then it assigns tasks. 📈 Advantage: Instead of manually planning content per platform, you only send one command, and the AI Director handles the strategy. 🟦 Section 2: Specialized Social Media Agents 🔗 Nodes (each paired with GPT-4.1-mini): 📸 Instagram Content Creator → Visual storytelling, Reels, Hashtags 🐦 Twitter/X Strategist → Viral tweets, trends, engagement 👥 Facebook Community Manager → Audience growth, ads, group engagement 🎵 TikTok Video Creator → Short-form video, viral trends 🎬 YouTube Content Planner → Long-form strategy, SEO, thumbnails 📊 Analytics Specialist → Performance insights, cross-platform reporting 💡 Beginner takeaway: Each platform has its own AI expert. They receive the Director’s strategy and produce tailored content for their platform. 📈 Advantage: Instead of one-size-fits-all posts, you get optimized content per platform—increasing reach and engagement. 🟣 Section 3: Models & Connections 🔗 Nodes: OpenAI Chat Models** (O3 + multiple GPT-4.1-mini models) Each model is connected to its respective agent. 💡 Beginner takeaway: Think of these as the “brains” behind each specialist. The Director uses O3 for advanced reasoning, while the specialists use GPT-4.1-mini (cheaper, faster) for content generation. 📈 Advantage: This keeps costs low while maintaining quality output. 📊 Final Overview Table | Section | Nodes | Purpose | Benefit | | --------------------- | -------------------------------------------------------- | -------------------------------------- | ------------------------------ | | 🟢 Trigger & Director | Chat Trigger, Director, Think Tool | Capture requests & plan strategy | One command → full social plan | | 🟦 Specialists | Instagram, Twitter, Facebook, TikTok, YouTube, Analytics | Platform-specific content | Optimized posts per platform | | 🟣 Models | O3 + GPT-4.1-mini | Provide reasoning & content generation | High-quality, cost-efficient | 🚀 Why This Workflow is Powerful Multi-platform coverage**: All major platforms handled in one flow Human-like strategy**: Director agent makes real marketing decisions Scalable & fast**: Generate a full campaign in minutes Cost-effective**: O3 only for strategy, GPT-4.1-mini for bulk content Beginner-friendly**: Just type your request → get full campaign output
by Dr. Firas
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
by Dr. Firas
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Automate Social Media with HeyGen and GPT-5: Publish Videos to TikTok, YouTube & Instagram 👥 Who is this for? This workflow is designed for: Content creators who want to scale their short-form video production Marketing teams seeking consistent and automated publishing pipelines Agencies managing multiple social accounts for clients Entrepreneurs looking to save time by automating repetitive content tasks 💡 What problem is this workflow solving? Publishing on multiple platforms like YouTube Shorts, TikTok, and Instagram is often: Time-consuming (manual editing, caption writing, uploads) Inconsistent (different requirements for each platform) Prone to delays (switching between tools) This workflow solves these issues by creating a fully automated video pipeline powered by GPT-5, HeyGen, and Blotato. ⚙️ What this workflow does Capture voice idea via Telegram Transcribe voice to text using OpenAI Whisper Generate a catchy title and caption with GPT-5 Create an AI avatar video with HeyGen Save and organize assets in Google Drive and Google Sheets Upload final video to Blotato Auto-publish to: YouTube Shorts TikTok Instagram (Optional: Facebook, X/Twitter, LinkedIn, Pinterest, Threads, Bluesky) Update logs in Google Sheets Send a Telegram confirmation once published 🧰 Setup Before using this workflow, ensure you have: A Telegram Bot connected to n8n for voice input An OpenAI API key for transcription (Whisper) and GPT-5 processing A HeyGen account & API key for avatar video generation A Google Drive & Google Sheets integration for storing assets and logs A Blotato account (Pro plan) with API access enabled Verified Community Nodes enabled in n8n Admin Panel Blotato node installed and credentials configured 🛠️ How to customize this workflow Prompts** → Adjust GPT-5 prompts to match your brand voice and niche Avatars** → Use custom avatars or voices via HeyGen configuration Platforms** → Activate only the social nodes you need (e.g., focus on TikTok & YouTube Shorts) Approval steps** → Add Telegram or Slack confirmation before publishing Analytics** → Extend the workflow to track engagement data in Google Sheets, Airtable, or Notion This workflow turns a simple spoken idea into a viral-ready video — automatically generated, styled, and posted across your most important platforms. 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube
by Vasu Gupta
AI Video Generator & Social Media Publisher (Telegram Bot) Turn a single text message into a fully produced video and publish it across 5 social media platforms automatically. This workflow combines AI video generation (Fal.ai) with a "Human-in-the-loop" approval system via Telegram, ensuring you never post content without checking it first. Who is this for? Social Media Managers who want to automate Short/Reel creation. Content Creators looking to scale their output on Instagram, TikTok, and YouTube. Brands that need consistent, on-brand video content generated from simple text prompts. How it works Trigger: Send a text message to your Telegram bot (e.g., "A futuristic city with neon lights"). AI Drafting: An AI Agent (GPT-4o) converts your message into a detailed cinematic video prompt based on your brand guidelines. Generation: Fal.ai (Veo3 model) generates a high-quality 9:16 video. Approval Loop: The bot sends you the video preview. Reply "Great": The workflow proceeds to publishing. Reply with feedback (e.g., "Too dark, make it brighter"): The AI refines the prompt and regenerates the video. Publishing: Once approved, the workflow generates platform-specific captions and hashtags, logs the post to Google Sheets, and uploads the video to Blotato to publish on Instagram, Facebook, LinkedIn, TikTok, and YouTube Shorts. Requirements OpenAI API Key** Fal.ai API Key** (for video generation) Telegram Bot Token** Google Sheets** (for logging posts) Blotato Account** (for multi-channel publishing) How to set up Credentials: configure your credentials for OpenAI, Fal.ai, Telegram, Google Sheets, and Blotato. Fal.ai Setup: Create a Header Auth credential named Authorization with value Key <YOUR_FAL_KEY>. Google Sheets: In the "Log to Google Sheets" node, select the specific Sheet you want to use for tracking. Blotato: In the 5 publishing nodes (Instagram, Facebook, etc.), select your specific Account IDs from the dropdowns. Brand Customization: Open the "Draft Video Prompt" and "Generate Caption" nodes to edit the System Prompt with your specific brand voice and aesthetic guidelines.
by Dr. Firas
Convert Viral Videos into AI Avatar Swaps and Publish on TikTok with Blotato Who is this for? This workflow is designed for content creators, agencies, influencers, and automation builders who want to transform viral videos into personalized avatar-based edits — and automatically publish them on TikTok (and other platforms) without manual editing or video software. What problem is this workflow solving? Replacing a character in a video, transforming the voice, merging audio/video, and publishing to social networks typically requires multiple tools, editing skills, and a lot of time. This workflow automates the entire pipeline end-to-end: No manual video editing No audio processing No API debugging No uploading/publishing hassles It’s a full AI-powered transformation system that produces ready-to-post content in minutes. What this workflow does This workflow receives an avatar image + a viral video URL and automatically: Extracts the audio using Replicate Replaces the character in the video using FAL WAN Replace Transforms the voice using FAL Chatterbox Speech-to-Speech Merges the new video and audio using FAL FFmpeg Saves results to Google Sheets for tracking Publishes the final video to TikTok via Blotato (and optionally to Instagram, Facebook, LinkedIn, X, and YouTube) Sends a confirmation message when publishing is complete Everything runs automatically, in parallel, for maximum speed. Setup Telegram Bot Add your Telegram Bot credentials in the Telegram Trigger node. Send an avatar photo + video URL in one message (URL in the caption). Workflow Configuration Add your FAL API key Add your Replicate API key Add your targetVoiceAudioUrl (this is the voice the output will use) Google Sheets Connect your Google Sheets OAuth credentials Select your sheet and ensure columns exist (e.g. original URL, output URL) Blotato Publishing Install community node @blotato/n8n-nodes-blotato Connect your Blotato API credentials Select the TikTok account (and optional other accounts) Test the workflow Send a Telegram message with: A photo (avatar) Video URL in the caption The workflow will process everything automatically. How to customize this workflow to your needs Change platforms**: remove or add publishing outputs (TikTok, Instagram, LinkedIn, Facebook, YouTube, X). Change voice style**: update the targetVoiceAudioUrl in the Workflow Configuration node. Use your own avatar**: send any image in Telegram — the workflow automatically makes it public and ready for AI processing. Adjust video logic**: swap FAL models, update merg 👋 Need help or want to customize this? 📩 Contact: LinkedIn 📺 YouTube: @DRFIRASS 🚀 Workshops: Mes Ateliers n8n 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube / 🚀 Mes Ateliers n8n
by WeblineIndia
IPA Size Tracker with Trend Alerts – Automated iOS Apps Size Monitoring This workflow runs on a daily schedule and monitors IPA file sizes from configured URLs. It stores historical size data in Google Sheets, compares current vs. previous builds and sends email alerts only when significant size changes occur (default: ±10%). A DRY_RUN toggle allows safe testing before real notifications go out. Who’s it for iOS developers tracking app binary size growth over time. DevOps teams monitoring build artifacts and deployment sizes. Product managers ensuring app size budgets remain acceptable. QA teams detecting unexpected size changes in release builds. Mobile app teams optimizing user experience by keeping apps lightweight. How it works Schedule Trigger (daily at 09:00 UTC) kicks off the workflow. Configuration: Define monitored apps with {name, version, build, ipa_url}. HTTP Request downloads the IPA file from its URL. Size Calculation: Compute file sizes in bytes, KB, MB and attach timestamp metadata. Google Sheets: Append size data to the IPA Size History sheet. Trend Analysis: Compare current vs. previous build sizes. Alert Logic: Evaluate thresholds (>10% increase or >10% decrease). Email Notification: Send formatted alerts with comparisons and trend indicators. Rate Limit: Space out notifications to avoid spamming recipients. How to set up 1. Spreadsheet Create a Google Sheet with a tab named IPA Size History containing: Date, Timestamp, App_Name, Version, Build_Number, Size_Bytes, Size_KB, Size_MB, IPA_URL 2. Credentials Google Sheets (OAuth)** → for reading/writing size history. Gmail** → for sending alert emails (use App Password if 2FA is enabled). 3. Open “Set: Configuration” node Define your workflow variables: APP_CONFIGS = array of monitored apps ({name, version, build, ipa_url}) SPREADSHEET_ID = Google Sheet ID SHEET_NAME = IPA Size History SMTP_FROM = sender email (e.g., devops@company.com) ALERT_RECIPIENTS = comma-separated emails SIZE_INCREASE_THRESHOLD = 0.10 (10%) SIZE_DECREASE_THRESHOLD = 0.10 (10%) LARGE_APP_WARNING = 300 (MB) SCHEDULE_TIME = 09:00 TIMEZONE = UTC DRY_RUN = false (set true to test without sending emails) 4. File Hosting Host IPA files on Google Drive, Dropbox or a web server. Ensure direct download URLs are used (not preview links). 5. Activate the workflow Once configured, it will run automatically at the scheduled time. Requirements Google Sheet with the IPA Size History tab. Accessible IPA file URLs. SMTP / gmail account (Gmail recommended). n8n (cloud or self-hosted) with Google Sheets + Email nodes. Sufficient local storage for IPA file downloads. How to customize the workflow Multiple apps**: Add more configs to APP_CONFIGS. Thresholds**: Adjust SIZE_INCREASE_THRESHOLD / SIZE_DECREASE_THRESHOLD. Notification templates**: Customize subject/body with variables: {{app_name}}, {{current_size}}, {{previous_size}}, {{change_percent}}, {{trend_status}}. Schedule**: Change Cron from daily to hourly, weekly, etc. Large app warnings**: Adjust LARGE_APP_WARNING. Trend analysis**: Extend beyond one build (7-day, 30-day averages). Storage backend**: Swap Google Sheets for CSV, DB or S3. Add-ons to level up Slack Notifications**: Add Slack webhook alerts with emojis & formatting. Size History Charts**: Generate trend graphs with Chart.js or Google Charts API. Environment separation**: Monitor dev/staging/prod builds separately. Regression detection**: Statistical anomaly checks. Build metadata**: Log bundle ID, SDK versions, architectures. Archive management**: Auto-clean old records to save space. Dashboards**: Connect to Grafana, DataDog or custom BI. CI/CD triggers**: Integrate with pipelines via webhook trigger. Common Troubleshooting No size data** → check URLs return binary IPA (not HTML error). Download failures** → confirm hosting permissions & direct links. Missing alerts** → ensure thresholds & prior history exist. Google Sheets errors** → check sheet/tab names & OAuth credentials. Email issues** → validate SMTP credentials, spam folder, sender reputation. Large file timeouts** → raise HTTP timeout for >100MB files. Trend errors** → make sure at least 2 builds exist. No runs** → confirm workflow is active and timezone is correct. Need Help? If you’d like this to customize this workflow to suit your app development process, then simply reach out to us here and we’ll help you customize the template to your exact use case.
by Kevin Meneses
What this workflow does This workflow automatically audits web pages for SEO issues and generates an executive-friendly SEO report using AI. It is designed for marketers, founders, and SEO teams who want fast, actionable insights without manually reviewing HTML, meta tags, or SERP data. The workflow: Reads URLs from Google Sheets Scrapes page content using Decodo (reliable scraping, even on protected sites) Extracts key SEO elements (title, meta description, canonical, H1/H2, visible text) Uses an AI Agent to analyze the page and generate: Overall SEO status Top issues Quick wins Title & meta description recommendations Saves results to Google Sheets Sends a formatted HTML executive report by email (Gmail) Who this workflow is for This template is ideal for: SEO consultants and agencies SaaS marketing teams Founders monitoring their landing pages Content teams doing SEO quality control It focuses on on-page SEO fundamentals, not backlink analysis or technical crawling. Setup (step by step) 1. Google Sheets Create an input sheet with one URL per row Create an output sheet to store SEO results 2. Decodo Add your Decodo API credentials The URL is automatically taken from the input sheet 👉 Decodo – Web Scraper for n8n 3. AI Agent Connect your LLM credentials (OpenAI, Gemini, etc.) The prompt is already optimized for non-technical SEO summaries 4. Gmail Connect your Gmail account Set the recipient email address Emails are sent in clean HTML format Notes & disclaimer This is a community template Results depend on page accessibility and content structure It focuses on on-page SEO, not backlinks or rankings
by vinci-king-01
Property Listing Aggregator with Mailchimp and Notion ⚠️ COMMUNITY TEMPLATE DISCLAIMER: This is a community-contributed template that uses ScrapeGraphAI (a community node). Please ensure you have the ScrapeGraphAI community node installed in your n8n instance before using this template. This workflow scrapes multiple commercial-real-estate websites, consolidates new property listings into Notion, and emails weekly availability updates or immediate space alerts to a Mailchimp audience. It automates the end-to-end process so business owners can stay on top of the latest spaces without manual searching. Pre-conditions/Requirements Prerequisites n8n instance (self-hosted or n8n.cloud) ScrapeGraphAI community node installed Active Notion workspace with permission to create/read databases Mailchimp account with at least one Audience list Basic understanding of JSON; ability to add API credentials in n8n Required Credentials ScrapeGraphAI API Key** – Enables web scraping functionality Notion OAuth2 / Integration Token** – Writes data into Notion database Mailchimp API Key** – Sends campaigns and individual emails (Optional) Proxy credentials – If target real-estate sites block your IP Specific Setup Requirements | Resource | Requirement | Example | |----------|-------------|---------| | Notion | Database with property fields (Address, Price, SqFt, URL, Availability) | Database ID: abcd1234efgh | | Mailchimp | Audience list where alerts are sent | Audience ID: f3a2b6c7d8 | | ScrapeGraphAI | YAML/JSON config per site | Stored inside the ScrapeGraphAI node | How it works This workflow scrapes multiple commercial-real-estate websites, consolidates new property listings into Notion, and emails weekly availability updates or immediate space alerts to a Mailchimp audience. It automates the end-to-end process so business owners can stay on top of the latest spaces without manual searching. Key Steps: Manual Trigger / CRON**: Starts the workflow weekly or on-demand. Code (Site List Builder)**: Generates an array of target URLs for ScrapeGraphAI. Split In Batches**: Processes URLs in manageable groups to avoid rate limits. ScrapeGraphAI**: Extracts property details from each site. IF (New vs Existing)**: Checks whether the listing already exists in Notion. Notion**: Inserts new listings or updates existing records. Set**: Formats email content (HTML & plaintext). Mailchimp**: Sends a campaign or automated alert to subscribers. Sticky Notes**: Provide documentation and future-enhancement pointers. Set up steps Setup Time: 15-25 minutes Install Community Node Navigate to Settings → Community Nodes and install “ScrapeGraphAI”. Create Notion Integration Go to Notion Settings → Integrations → Develop your own integration. Copy the integration token and share your target database with the integration. Add Mailchimp API Key In Mailchimp: Account → Extras → API keys. Copy an existing key or create a new one, then add it to n8n credentials. Build Scrape Config In the ScrapeGraphAI node, paste a YAML/JSON selector config for each website (address, price, sqft, url, availability). Configure the URL List Open the first Code node. Replace the placeholder array with your target listing URLs. Map Notion Fields Open the Notion node and map scraped fields to your database properties. Save. Design Email Template In the Set node, tweak the HTML and plaintext blocks to match your brand. Test the Workflow Trigger manually, check that Notion rows are created and Mailchimp sends the message. Schedule Add a CRON node (weekly) or leave the Manual Trigger for ad-hoc runs. Node Descriptions Core Workflow Nodes: Manual Trigger / CRON** – Kicks off the workflow either on demand or on a schedule. Code (Site List Builder)** – Holds an array of commercial real-estate URLs and outputs one item per URL. Split In Batches** – Prevents hitting anti-bot limits by processing URLs in groups (default: 5). ScrapeGraphAI** – Crawls each URL, parses DOM with CSS/XPath selectors, returns structured JSON. IF (New Listing?)** – Compares scraped listing IDs against existing Notion database rows. Notion** – Creates or updates pages representing property listings. Set (Email Composer)** – Builds dynamic email subject, body, and merge tags for Mailchimp. Mailchimp* – Uses the *Send Campaign endpoint to email your audience. Sticky Note** – Contains inline documentation and customization reminders. Data Flow: Manual Trigger/CRON → Code (URLs) → Split In Batches → ScrapeGraphAI → IF (New?) True path → Notion (Create) → Set (Email) → Mailchimp False path → (skip) Customization Examples Filter Listings by Maximum Budget // Inside the IF node (custom expression) {{$json["price"] <= 3500}} Change Email Frequency to Daily Digests { "nodes": [ { "name": "Daily CRON", "type": "n8n-nodes-base.cron", "parameters": { "triggerTimes": [ { "hour": 8, "minute": 0 } ] } } ] } Data Output Format The workflow outputs structured JSON data: { "address": "123 Market St, Suite 400", "price": 3200, "sqft": 950, "url": "https://examplebroker.com/listing/123", "availability": "Immediate", "new": true } Troubleshooting Common Issues Scraper returns empty objects – Verify selectors in ScrapeGraphAI config; inspect the site’s HTML for changes. Duplicate entries in Notion – Ensure the “IF” node checks a unique ID (e.g., listing URL) before creating a page. Performance Tips Reduce batch size or add delays in ScrapeGraphAI to avoid site blocking. Cache previously scraped URLs in an external file or database for faster runs. Pro Tips: Rotate proxies in ScrapeGraphAI for heavily protected sites. Use Notion rollups to calculate total available square footage automatically. Leverage Mailchimp merge tags (|FNAME|) in the Set node for personalized alerts.