Workflow Templates

About this Workflow This workflow helps you repurpose your YouTube videos across multiple social media platforms with zero manual effort. It’s designed for creators, businesses, and marketers who want to maximize reach without spending hours re-uploading content everywhere. How It Works Trigger from YouTube The workflow checks your YouTube channel every 10 minutes via RSS feed. It compares the latest video ID with the last saved one to detect if a new video was uploaded. Tutorial: How to get YouTube Channel RSS Feed Generate Descriptions with AI Uses Gemini 2.5 Flash to automatically generate fresh, engaging descriptions for your posts. Create Images with ContentDrips ContentDrips offers multiple templates (carousel, single image, branding templates, etc.). The workflow generates a custom promotional image using your video description and thumbnail. Install node: npm install n8n-nodes-contentdrips Docs: ContentDrips Blog Tutorial Publish Across Social Platforms with SocialBu Instead of manually connecting each social media API, this workflow uses SocialBu. From a single connection, you can post to: Facebook, Instagram, TikTok, YouTube, Twitter (X), LinkedIn, Threads, Pinterest, and more. Website: SocialBu Get Real-Time Notifications via Discord After each run, the workflow sends updates to your Discord channel. You’ll know if the upload was successful, or if an error occurred (e.g., API limits). Setup guide: Discord OAuth Credentials Why Use This Workflow? Saves time by automating the entire repurposing process. Ensures consistent branding and visuals across platforms. Works around platform restrictions by leveraging SocialBu’s integrations. Keeps you updated with Discord notifications—no guessing if something failed. Requirements YouTube channel RSS feed link ContentDrips API key, template ID, and branding setup SocialBu account with connected social media platforms Discord credentials (for webhook updates) Need Help? Message me on LinkedIn: Shayan Ali Bakhsh Happy Automation 🚀

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.

Who's it for Marketing teams, social media managers, content creators, and small businesses looking to maintain consistent social media presence across multiple platforms. Perfect for organizations that want to automate content creation while maintaining quality and brand consistency. How it works This workflow creates a complete social media automation system that generates platform-specific content using AI and schedules posts across Twitter, LinkedIn, and Instagram based on your content calendar in Google Sheets. The system runs daily at 9 AM, reading your content calendar to identify scheduled topics for the day. It uses OpenAI's GPT-4 to generate platform-optimized content that follows each platform's best practices - concise engaging posts for Twitter, professional thought leadership for LinkedIn, and visual storytelling for Instagram. DALL-E creates accompanying images that match your brand style and topic themes. Each piece of content is automatically formatted for optimal engagement, including appropriate hashtags, character limits, and platform-specific calls-to-action. The workflow then schedules posts through Buffer's API at optimal times and updates your spreadsheet with posting status, content previews, and generated image URLs for tracking and approval workflows. How to set up Prerequisites: Google account with Sheets access OpenAI API key with GPT-4 and DALL-E access Buffer account with connected social media profiles Slack workspace (optional for notifications) Setup steps: Create your content calendar: Copy the provided Google Sheets template Set up columns: Date, Topic, Platforms, Content Type, Keywords, Status, Generated Content, Image URL Fill in your content schedule with topics and target platforms Configure credentials in n8n: Add OpenAI API credential with your API key Set up Google Sheets OAuth2 for spreadsheet access Add Buffer API token from your Buffer dashboard Add Slack API credential for success notifications (optional) Update Configuration Variables: Set your Google Sheet ID from the spreadsheet URL Define your brand voice and company messaging Specify target audience for content personalization Set image style preferences for consistent visuals Configure Buffer integration: Connect your social media accounts to Buffer Get profile IDs for Twitter, LinkedIn, and Instagram Update the Schedule Post node with your specific profile IDs Set optimal posting times in Buffer settings Test the workflow: Add test content to tomorrow's date in your calendar Run the workflow manually to verify content generation Check that posts appear in Buffer's queue correctly Verify spreadsheet updates and Slack notifications work Requirements Google Sheets with template structure and editing permissions OpenAI API key with GPT-4 and DALL-E access (estimated cost: $0.10-0.30 per day for content generation) Buffer account (free plan supports up to 3 social accounts, paid plans for more) Social media accounts connected through Buffer (Twitter, LinkedIn, Instagram) n8n instance (cloud subscription or self-hosted) How to customize the workflow Adjust content generation: Modify AI prompts in the OpenAI node to match your industry tone and style Add custom content types (promotional, educational, behind-the-scenes, user-generated) Include seasonal or event-based content variations in your prompts Customize hashtag strategies per platform and content type Enhance scheduling logic: Add time zone considerations for global audiences Implement different posting schedules for weekdays vs weekends Create urgency-based posting for time-sensitive content Add approval workflows before scheduling sensitive content Expand platform support: Add Facebook, TikTok, or YouTube Shorts using their respective APIs Integrate with Hootsuite or Later as alternative scheduling platforms Include Pinterest for visual content with optimized descriptions Add LinkedIn Company Page posting alongside personal profiles Improve content intelligence: Integrate trending hashtag research using social media APIs Add competitor content analysis for inspiration and differentiation Include sentiment analysis to adjust tone based on current events Implement A/B testing for different content variations Advanced automation features: Add engagement monitoring and response workflows Create monthly performance reports sent via email Implement content recycling for evergreen topics Build user-generated content curation from brand mentions Add crisis communication protocols for sensitive topics Integration enhancements: Connect with your CRM to include customer success stories Link to email marketing for cross-channel content consistency Integrate with project management tools for campaign coordination Add analytics dashboards for content performance tracking

🚀 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

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.

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.

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

How it works: Daily Trigger: Every morning at 8 AM, the workflow is automatically triggered. Fetch Trending Topics: The workflow collects trending topics from external sources, such as news RSS feeds and Reddit popular posts. These trends are merged and summarized to provide up-to-date context for content generation. Read Active Campaigns: The workflow reads all rows from the “Active Campaigns” Google Sheet, but only processes campaigns with a status of "active" to avoid generating content for paused or inactive campaigns. Enrich Campaigns with Trends: Each active campaign is enriched with the latest trending topics, so the generated content can reference current events or popular themes. AI Content Generation: For each enriched campaign, Groq AI generates: An engaging post caption tailored to the platform and target audience Creative direction with visual suggestions Relevant hashtags (5-10) Best posting time recommendation for the platform Quality Scoring: The workflow calculates a quality score for each generated content idea, considering factors like caption length, hashtag count, and creative direction. Append to Google Sheets: The generated content ideas, along with their quality scores and other details, are appended to the “Daily Content Plan” Google Sheet for record-keeping and team collaboration. Schedule in Google Calendar: For each campaign, an event is created in Google Calendar with the content details and recommended posting time, ensuring the team is reminded to review or publish the content. Daily Email Summary (Optional): At the end of the process, a summary email can be sent to the team, including statistics such as the number of campaigns processed, average quality score, and a platform breakdown. Set up steps: Prepare Your Google Sheets: Create a sheet named “Active Campaigns” with columns: Project Name, Theme, Target Audience, Platform, and Status (to mark campaigns as active/inactive). Create another sheet named “Daily Content Plan” with columns for Project Name, Date, Platform, Caption, Creative Direction, Hashtags, and any other details you want to track. Connect Google Services to n8n: In n8n, set up and authenticate your Google Sheets and Google Calendar credentials. You can find authentication information in the n8n documentation for Google credentials. Add a Cron Node: Drag in a Cron node and set it to trigger every day at 8:00 AM. Read Campaigns from Google Sheets: Add a Google Sheets node. Set the operation to “Read Rows” and select your “Active Campaigns” sheet. (Optional) Use a Filter or IF node to process only rows where Status is “active”. (Optional) Fetch Trending Topics: If you want to enrich your content with trending topics, add nodes to fetch data from RSS feeds, Reddit, or other sources. Process Each Campaign: Use a SplitInBatches node to process each campaign row individually. Generate Content Ideas with Groq AI: Add a Groq AI node (or OpenAI node if Groq is not available). Configure the prompt to generate a content idea using the campaign’s theme, target audience, and platform. You can reference fields from the Google Sheets node using expressions like $("Google Sheets").item.json['Theme']. Append Results to “Daily Content Plan”: Add another Google Sheets node. Set the operation to “Append” and select your “Daily Content Plan” sheet. Map the generated content fields to the appropriate columns. Schedule Events in Google Calendar: Add a Google Calendar node. Set the operation to “Create Event”. Use the project name and content idea for the event title and description, and set the event time as needed. (Optional) Send a Daily Summary Email: Add an Email node to send a summary of the day’s content plan to your team. Test the Workflow: Run the workflow manually to ensure all steps work as expected. Check that new content ideas appear in the “Daily Content Plan” sheet and that events are created in Google Calendar. Activate the Workflow: Once you’ve confirmed everything works, activate the workflow so it runs automatically every morning.

Introduction Automates stock market analysis using multiple AI models to predict trends, analyze sentiment, and generate consensus-based investment insights. For traders and analysts seeking data-driven forecasts by eliminating manual research and combining AI perspectives for accurate predictions. How It Works Daily trigger fetches stock data, news, ratings, and sentiment → AI models analyze each source → OpenAI generates report → Three AI validators (OpenAI, Anthropic, Gemini) cross-verify → Consensus evaluation → Telegram alert with insights. Workflow Template Schedule → Fetch Stock Data → Fetch News → Fetch Ratings → Fetch Sentiment → AI Analysis → Combine → Generate Report (GPT) → Validate (3 AIs) → Evaluate Consensus → Send Telegram Workflow Steps Data Collection: Scheduled trigger fetches prices, news, analyst ratings, and social trends AI Analysis: Separate models analyze stocks, news sentiment, ratings, and social discussions Report Generation: OpenAI GPT combines analyses into comprehensive market report Multi-AI Validation: Three AI models independently validate predictions for accuracy Consensus Building: Evaluates AI agreement to determine confidence levels Alert Delivery: Sends Telegram alerts with buy/sell/hold recommendations Setup Instructions Schedule: Configure daily trigger time Data Sources: Add API keys for stock data, news APIs, and social platforms AI Models: Configure OpenAI, Anthropic, and Google Gemini credentials Telegram: Create bot and add token Thresholds: Define consensus requirements for recommendations Prerequisites Stock data API (Alpha Vantage, Yahoo Finance) News API key Social media API OpenAI API key Anthropic API key Google Gemini API key Telegram bot token Use Cases Day Trading: Real-time volatile stock analysis with multiple AI perspectives. Portfolio Management: Daily consensus reports for rebalancing. Customization Add technical indicators (RSI, MACD). Include crypto analysis. Integrate portfolio tracking. Add email/Slack notifications. Configure sector-specific analysis. Benefits Eliminates hours of daily research. Reduces AI hallucination through multi-model validation. Provides 24/7 monitoring. Combines multiple data sources.

Automate Business Card Management with LINE, AI, and Google Sheets Who's it for This workflow is designed for business professionals and sales teams who receive business card images via LINE and want to quickly digitize contact information with minimal manual work. It is best suited for users who process business cards one image at a time and want a simple, reliable automation rather than a high-volume ingestion pipeline. What it does This workflow processes a single business card image sent via LINE, extracts text using Google Gemini AI, and stores the structured contact information in Google Sheets. The workflow focuses on simplicity and clarity: it receives an image, performs AI-based OCR, parses the extracted text, saves the result, uploads the original image for reference, sends a thank-you email, and replies with the extracted data on LINE. How it works A single business card image is sent to the LINE bot. The workflow is triggered via a LINE webhook. The image file is downloaded and sent to Google Gemini AI for OCR. The extracted text is parsed into structured fields. The data is appended to Google Sheets. The image is uploaded to Google Drive. A thank-you email is sent via Gmail. The extracted information is sent back as a LINE reply. This workflow is intentionally designed to handle one image per execution. Requirements To use this workflow, you will need: A LINE Messaging API account A Google Gemini API key A Google account with access to Google Sheets and Google Drive A Gmail account for sending thank-you emails A Google Sheets document with the following column names: Company Name Contact Name Department Address Email Address Phone Number Important limitations This workflow does not support multiple images sent in a single message. Sending images in quick succession may trigger multiple executions and lead to unexpected results. Only the first image in an event payload is processed. OCR accuracy depends on image quality, lighting, and card design. These limitations are intentional to keep the workflow simple and easy to understand. How to set up Create a LINE Messaging API channel and obtain a Channel Access Token. Generate a Google Gemini API key. Update the Config node with your LINE token, Google Sheets ID, and Google Drive folder ID. Configure credentials for LINE, Google Gemini, Google Sheets, Google Drive, and Gmail. Register the n8n webhook URL in your LINE channel settings. Activate the workflow in n8n and test it with a single business card image. How to customize Modify the AI prompt in the “Extract Card Info” node to support different languages or fields. Adjust the parsing logic to match different business card layouts. Replace Google Sheets with a CRM or database. Add queueing or locking logic if you want to support batch or sequential image uploads. Note: This workflow was tested using real business card images sent individually via the LINE Messaging API. For production use, testing with your own card samples is strongly recommended.

How It Works Automates revenue data validation and intelligent anomaly detection with scheduled weekly processing. Fetches revenue data, applies dual OpenAI models for categorization and anomaly detection, identifies outliers or suspicious patterns, and synchronizes clean data with accounting software. Includes correction workflow through Connection Agent for data quality remediation. System generates compliance summaries and automatically sends reports to tax agents via Gmail. Designed for accounting firms, tax professionals, and finance teams requiring enterprise-grade data validation, fraud detection, and regulatory compliance without manual review bottlenecks. Setup Steps Configure OpenAI API keys for categorization and anomaly detection models Connect revenue data source and accounting software via Connection Agent Define anomaly detection thresholds and categorization Set email templates for tax agent communication Configure weekly schedule trigger timing Prerequisites OpenAI API key, accounting software credentials, revenue data source connectivity, Gmail account Use Cases Accounting firm multi-client processing, monthly/quarterly tax compliance Customization Adjust anomaly thresholds per business rules, customize categorization rules for industry standards Benefits Reduces data validation time by 85%, eliminates manual categorization errors, detects fraud patterns