by Sabrina Ramonov 🍄
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Description This fully automated AI Avatar Social Media system creates talking head AI clone videos, WITHOUT having to film or edit yourself. It combines n8n, AI agent, HeyGen, and Blotato to research, create, and distribute talking head AI clone videos to every social media platform every single day. This template is ideal for content creators, social media managers, social media agencies, small businesses, and marketers who want to to scale short-form video creation, without manually filming and editing every single video. Overview 1. Trigger: Schedule Configured to run once daily at 10am 2. AI News Research Research viral news from tech-focused forum, Hackernews Fetch the selected news item, plus discussion comments 3. AI Writer AI writes 30-second monologue script AI writes short video caption 4. Create Avatar Video Call Heygen API (requires paid API plan), specifying your avatar ID and voice ID Create avatar video, optionally passing in an image/video background if you have a green screen avatar (matte: true) 5. Get Video Wait awhile, then fetch completed avatar video Upload video to Blotato 6. Publish to Social Media via Blotato Connect your Blotato account Choose your social accounts Either post immediately or schedule for later" 📄 Documentation Full Tutorial Troubleshooting Check your Blotato API Dashboard to see every request, response, and error. Click on a request to see the details. Need Help? In the Blotato web app, click the orange button on the bottom right corner. This opens the Support messenger where I help answer technical questions.
by Malte Sohns
Monitor and manage Docker containers from Telegram with AI log analysis This workflow gives you a smart Telegram command center for your homelab. It lets you monitor Docker containers, get alerts the moment something fails, view logs, and restart services remotely. When you request logs, they're automatically analyzed by an LLM so you get a clear, structured breakdown instead of raw terminal output. Who it's for Anyone running a self-hosted environment who wants quick visibility and control without SSHing into a server. Perfect for homelab enthusiasts, self-hosters, and DevOps folks who want a lightweight on-call assistant. What it does Receives container heartbeat alerts via webhook Sends Telegram notifications for status changes or failures Lets you request logs or restart services from chat Analyzes logs with GPT and summarizes them clearly Supports manual “status” and “update all containers” commands Requirements Telegram Bot API credentials SSH access to your Docker host How to set it up Create a Telegram bot and add its token as credentials Enter your server SSH credentials in the SSH node Deploy the workflow and set your webhook endpoint Tailor container names or heartbeat logic to your environment Customize it Swap SSH commands for Kubernetes if you're on k8s Change the AI model to another provider Extend with health checks or auto-healing logic
by Ahmed Sherif
AI-Powered Lead Scraping Automation using APIFY Scraper and Gemini Filtering to Google Sheets This is a fully automated, end-to-end pipeline designed to solve the challenge of inconsistent and low-quality lead data from large-scale scraping operations. The system programmatically fetches raw lead information from sources like Apollo or via Apify, processes it through an intelligent validation layer, and delivers a clean, deduplicated, and ready-to-use dataset directly into Google Sheets. By integrating Google Gemini for data cleansing, it moves beyond simple presence checks to enforce data hygiene and standardization, ensuring that sales teams only engage with properly formatted and complete leads. This automation eliminates hours of manual data cleaning, accelerates the speed from lead acquisition to outreach, and significantly improves the integrity of the sales pipeline. Features Batch Processing**: Systematically processes up to 1000 leads per batch and automatically loops through the entire dataset. This ensures stable, memory-efficient operation even with tens of thousands of scraped contacts. AI Validation**: Google Gemini acts as a data quality gatekeeper. It validates the presence and plausible format of critical fields (e.g., First Name, Company Name) and cleanses data by correcting common formatting issues. Smart Deduplication**: Before appending a new lead, the system cross-references its email address against the entire Google Sheet to prevent duplicate entries, ensuring a single source of truth. Auto Lead IDs**: Generates a unique, sequential ID for every new lead in the format AP-DDMMYY-xxxx. This provides a consistent reference key for tracking and CRM integration. Data Quality Reports**: Delivers real-time operational visibility by sending a concise summary to a Telegram channel after each batch, detailing success, warning, and error counts. Rate Limiting**: Incorporates a 30-second delay between batches to respect Google Sheets API limits, preventing throttling and ensuring reliable, uninterrupted execution. How It Works The workflow is initiated by an external trigger, such as a webhook, carrying the raw scraped data payload. It authenticates and fetches the complete list of leads from the Apify or Apollo API endpoint. The full list is automatically partitioned into manageable batches of 1000 leads for efficient processing. Each lead is individually passed to the Gemini AI Agent, which validates that required fields like Name, Email, and Company are present and correctly formatted. Validated leads are assigned a unique Lead ID, and all data fields are standardized for consistency. The system performs a lookup in the target Google Sheet to confirm the lead's email does not already exist. Clean, unique leads are appended as a new row to the designated spreadsheet. A completion notice is sent via the Telegram Bot, summarizing the batch results with clear statistics. Requirements Apify/Apollo API access credentials. Google Cloud project with OAuth2 credentials for Google Sheets API access. A configured Telegram Bot with its API Token and a target Chat ID. A Google Gemini API Key for data validation and cleansing. This system is ideal for sales and marketing operations teams managing high-volume lead generation campaigns, providing automated data quality assurance and accelerating pipeline development.
by Rapiwa
Who Is This For? This n8n automation workflow is designed for customer support teams, business owners, or service providers who want to automate customer interactions on WhatsApp. If you regularly receive customer queries about your products, services, or technical issues — and need a system that can instantly respond, fetch data from Google Sheets or Docs, log support tickets, and send human-like replies — this workflow is for you. It’s perfect for teams using Rapiwa, Google Sheets, and Google Docs who want to provide a smart, AI-driven, yet personal support experience. What This Workflow Does This workflow is structured around a single intelligent AI assistant called Rapiwa that interacts with customers in real time through WhatsApp. Key Features AI-Driven Support Assistant (Rapiwa) WhatsApp Integration via Rapiwa API Dynamic Data Access (Google Sheets + Docs) Knowledge Base Search Conversation Memory Automatic Logging Multi-Product Support Workflow Overview Rapiwa Trigger (Start Node) Starts the workflow automatically whenever a new WhatsApp message is received in your Rapiwa account. Example: When a customer sends a message like “What’s the price of SocialVibe?” or “I can’t access my dashboard”, this node triggers the workflow. If (Check Text) Detects if the incoming message contains text (not just images, videos, or audio). If it’s text, the workflow continues; otherwise, it stops or handles it differently. AI Agent – Customer Support Agent This is the brain of the system — your AI Assistant (Rapiwa). Interprets the user’s question, retrieves information, and replies in a clear, WhatsApp-friendly format. Reads product details and company info from Google Sheets/Docs. Fetches documentation links from the connected “Support Desk” and product-specific HTTP tools. Logs customer issues to the support sheet for tracking and analysis. Memory (Session Context) Stores chat history per user session so Rapiwa remembers context during a conversation. Research (AI Support Tool) Acts as Rapiwa’s research assistant — gathers and organizes information from multiple sources. Sources: Google Sheets, Google Docs, HTTP Tools, and Support Desk. Replay (Rapiwa Send Message) Sends the AI’s final message back to the customer on WhatsApp using the Rapiwa API. WhatsApp-optimized plain text messages only. Data & Integrations 🔹 Google Sheets (Database) Product Data Sheet:** Holds product names, descriptions, and pricing. Service Data Sheet:** Lists offered services with details. Support Log Sheet:** Records each issue (Issue, Category, Solution). 🔹 Google Docs Provides company information when a user asks about your organization. Example Use Case User Message: > “Hi, I’m having a problem with my Faculty login.” Rapiwa’s AI Response: > “I’m sorry you’re having trouble logging in to Faculty. Please try resetting your password here: https://faculty.spagreen.net/docs/#reset-password > If the issue continues, I can log this for support. Would you like me to do that?” Useful Links install process:** how to install rapiwa Dashboard:** https://app.rapiwa.com Official Website:** https://rapiwa.com Documentation:** https://docs.rapiwa.com Support & Help WhatsApp**: Chat on WhatsApp Discord**: SpaGreen Community Facebook Group**: SpaGreen Support Website**: https://spagreen.net Developer Portfolio**: Codecanyon SpaGreen
by Zain Khan
AI Product Photography With Nano Banana and Jotform 📸✨ Automate your product visuals! This n8n workflow instantly processes new product photography requests from Jotform or Google Sheets, uses an AI agent (Gemini Nano Banana) to generate professional AI product photography based on your product details and reference images, saves the final image to Google Drive, and updates the photo link in your Google Sheet for seamless record keeping. How it Works This n8n workflow operates as a fully automated pipeline for generating and managing AI product photographs: Trigger: The workflow is triggered either manually, on a set schedule (e.g., hourly), or immediately upon a new submission from the connected Jotform (or when new "Pending" rows are detected in the Google Sheet on a scheduled or manual run). Data Retrieval: If triggered by a schedule or manually, the workflow fetches new rows with a "Status" of "Pending" from the designated Google Sheet. Data Preparation: The input data (Product Name, Description, Requirements, and URLs for the Product and Reference Images) is prepared. The Product and Reference Images are downloaded using HTTP Requests. AI Analysis & Prompt Generation: An AI agent (using the Gemini model) analyzes the product details and image requirements, then generates a refined, professional prompt for the image generation model. AI Photo Generation: The generated prompt, along with the downloaded product and reference images, is sent to the image generation model, referred to as "Gemini Nano Banana" (a powerful Google AI model for image generation), to create the final, high-quality AI product photograph. File Handling: The raw image data is converted into a binary file format. Storage: The generated photograph is saved with the Product Name as the filename to your specified Google Drive folder. Record Update: The workflow updates the original row in the Google Sheet, changing the "Status" to "Completed" and adding the public URL of the newly saved image in the "Generated Image" column. If the trigger was from Jotform, a new record is appended to the Google Sheet. Requirements To use this workflow, you'll need the following accounts and credentials configured in n8n: n8n Account:** Your self-hosted or cloud n8n instance. Google Sheets/Drive Credentials:* An *OAuth2* or *API Key** credential for the Google Sheets and Google Drive nodes to read input and save the generated image. Google Gemini API Key:* An API key for the Google Gemini nodes to access the AI agent for prompt generation and the image generation service (Gemini Nano Banana*). Jotform Credential (Optional):* A Jotform credential is only required if you want to use the Jotform Webhook trigger. *Sign up for Jotform here:** https://www.jotform.com/?partner=zainurrehman A Google Sheet and Jotform:** with columns/fields for: Product Name, Product Description, Product Image (URL), Requirement, Reference Image 1 (URL), Reference Image 2 (URL), Status, and a blank Generated Image column. How to Use 1. Set Up Your Integrations Add the necessary Credentials (Google Sheets, Google Drive, Gemini API, and optionally Jotform) in your n8n settings. Specify the Google Sheet Document ID and Sheet Name in the Google Sheet nodes. In the Upload to Drive node, select your desired Drive ID and Folder ID where the final images should be saved. 2. Prepare Input Data You can start the workflow either by: Submitting a Form:* Fill out and submit the connected *Jotform** with the product details and image links. Adding to a Sheet:* Manually add a new row to your Google Sheet with all the product and image details, ensuring the *Status* is set to *"Pending"**. 3. Run the Workflow For Jotform Trigger:* Once the workflow is *Active**, a Jotform submission will automatically start the process. For Scheduled/Manual Trigger:* Activate the *Schedule Trigger* for automatic runs (e.g., hourly), or click the *Manual Trigger* node and select *"Execute Workflow"** to process all current "Pending" requests in the Google Sheet. The generated photograph will be uploaded to Google Drive, and its link will be automatically recorded in the "Generated Image" column in your Google Sheet.
by Rahul Joshi
Description This workflow automates the tracking of deal stage updates in HighLevel CRM and syncs them with ClickUp for task management. It filters opportunities based on the most recent update date, creates actionable tasks in ClickUp for recent deals, and sends Slack alerts when older deal updates are detected. This ensures that your sales and operations teams stay aligned, reducing manual tracking and improving visibility of pipeline activity. What This Template Does (Step-by-Step) 📋 Fetch All Deals from HighLevel CRM Pulls a complete list of opportunities with contact details and deal stages. ⏱ Filter Recent Deal Updates Checks if a deal was updated on/after a specific date (e.g., Sept 30, 2025). 🔀 Route Deals via If Node ✅ Recent Updates → Proceed to get contact details & create a task in ClickUp. ❌ Older Updates → Trigger a Slack notification for awareness. 👤 Get Contact Information Retrieves full contact details (name, location ID, etc.) from HighLevel for better context in tasks. 🗂 Create ClickUp Task Generates a new ClickUp task containing deal and contact information, ensuring your team has actionable follow-up tasks. 💬 Send Slack Notification Notifies a specified Slack user when a deal update is older than the defined threshold, highlighting deals that may need attention. Prerequisites HighLevel CRM account & API credentials ClickUp account & API credentials Slack workspace & API credentials n8n instance (cloud or self-hosted) Step-by-Step Setup Connect HighLevel CRM → Fetch all opportunities. Apply Date Filter (If Node) → Split deals into recent vs. old updates. Recent Deals → Fetch contact details → Create task in ClickUp. Old Deals → Send Slack notification to assigned user. Customization Ideas 🎯 Adjust the date threshold for “recent updates.” 📢 Add Slack/Teams alerts for new deals as well. 📚 Sync ClickUp tasks into Notion or Airtable for reporting. 💡 Enrich ClickUp tasks with deal value, stage, or assigned salesperson. Key Benefits ✅ Keeps deal updates transparent and organized ✅ Ensures no recent deal activity is missed ✅ Automates ClickUp task creation for sales follow-ups ✅ Sends real-time Slack alerts for old updates ✅ 100% automated, customizable workflow Perfect For 👥 Sales teams managing multiple deals daily 🏢 Companies using HighLevel CRM & ClickUp 🎯 Teams wanting instant visibility into pipeline changes 📊 Managers tracking deal activity timelines
by Evoort Solutions
📥 TikTok to MP4 Converter with Google Drive & Sheets Convert TikTok videos to MP4 , MP3 (without watermark), upload to Google Drive, and log conversion attempts into Google Sheets automatically — powered by TikTok Download Audio Video API. 📝 Description This n8n automation accepts a TikTok video URL via a form, sends it to the TikTok Download Audio Video API, downloads the watermark-free MP4, uploads it to Google Drive, and logs the result (success/failure) into Google Sheets. 🧩 Node-by-Node Overview | # | Node | Functionality | |---|-------------------------------|-------------------------------------------------------------------------------| | 1 | 🟢 Form Trigger | Displays a form for user input of TikTok video URL. | | 2 | 🌐 TikTok RapidAPI Request | Calls the TikTok Downloader API to get the MP4 link. | | 3 | 🔍 If Condition | Checks if the API response status is "success". | | 4 | ⬇️ MP4 Downloader | Downloads the video file using the returned "no watermark" MP4 URL. | | 5 | ☁️ Upload to Google Drive | Uploads the video file to Google Drive root folder. | | 6 | 🔑 Set Google Drive Permission | Makes the file publicly shareable via link. | | 7 | 📄 Google Sheets (Success) | Logs TikTok URL + public Drive link into a Google Sheet. | | 8 | ⏱️ Wait Node | Delays to prevent rapid write operations on error. | | 9 | 📑 Google Sheets (Failure) | Logs failed attempts with Drive_URL = N/A. | ✅ Use Cases 📲 Social media managers downloading user-generated content 🧠 Educators saving TikTok content for offline lessons 💼 Agencies automating short-form video curation 🤖 Workflow automation demonstrations with n8n 🎯 Key Benefits ✔️ MP4 without watermark via TikTok Download Audio Video API ✔️ Automated Google Drive upload & shareable links ✔️ Centralized logging in Google Sheets ✔️ Error handling and retry-safe structure ✔️ Fully customizable and extendable within n8n 💡 Ideal for anyone looking to automate TikTok video archiving with full control over file storage and access. 🔐 How to Get Your API Key for the TikTok Download Audio Video API Go to 👉 TikTok Download Audio Video API - RapidAPI Click "Subscribe to Test" (you may need to sign up or log in). Choose a pricing plan (there’s a free tier for testing). After subscribing, click on the "Endpoints" tab. Your API Key will be visible in the "x-rapidapi-key" header. 🔑 Copy and paste this key into the httpRequest node in your workflow. Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n
by Open Paws
🎯 Who's it for ESG analysts, investors, procurement teams, activists and sustainability professionals who need comprehensive, objective assessments of companies' environmental impact and animal welfare policies. Perfect for: Due diligence and investment screening Supplier evaluation and ethical sourcing Compliance reporting and ESG benchmarking Consumer guidance for ethical purchasing decisions ⚡ How it works This workflow automates the entire research and analysis process for comprehensive sustainability and animal welfare assessment. Simply input a company name, and the system handles everything: 🔍 Multi-Source Research: Calls a specialized subworkflow that queries: Open Paws database for animal welfare data Web scraping for sustainability reports Search engines for recent developments Social media monitoring for real-time insights 🤖 Parallel AI Analysis: Two specialized chains process data simultaneously: Structured scoring** with percentages and letter grades (A+ to D) Detailed HTML reports** with narrative analysis and insights 📊 Complete Assessment: Final output combines both formats for actionable intelligence on: Environmental policies and carbon footprint Animal welfare practices and ethical sourcing Vegan accommodation and plant-based initiatives 📋 Requirements Prerequisites: Download the research subworkflow from **Multi-Tool Research Agent for Animal Advocacy with OpenRouter, Serper & Open Paws DB and save it in your n8n instance API key for OpenRouter or other AI service provider 🚀 How to set up Install Research Subworkflow: First download the Multi-Tool Research Agent for Animal Advocacy with OpenRouter, Serper & Open Paws DB and import it into your n8n instance Configure API Keys: Set up your AI service credentials in the LLM nodes Link Subworkflow: Connect the Research Agent node to reference your installed research subworkflow Test Connection: Verify the research tools and databases are accessible Run Test: Input a well-known company name to validate the complete pipeline 🛠️ How to customize the workflow Scoring Weights**: Adjust percentage weightings for environmental impact, animal welfare, and vegan accommodation Research Sources**: Modify the subworkflow to include additional databases or exclude certain sources Output Format**: Customize the HTML report template or JSON schema structure Grading Scale**: Change letter grade thresholds (A+, A, B+, etc.) in the scoring logic Assessment Focus**: Adapt prompts to emphasize specific sustainability or animal welfare aspects for your industry
by Yashraj singh sisodiya
Summarize YouTube Videos with Gemini AI, Google Sheets & WhatsApp/Telegram Aim The aim of the YouTube Video Summarizer Workflow is to automate the process of summarizing or extracting transcripts from YouTube videos with the help of Gemini AI, while optionally storing results and distributing them to users via WhatsApp, Telegram, or Google Sheets. This enables fast, consistent generation and sharing of English summaries or transcripts from public YouTube content. Goal The goal is to: Allow users to submit a YouTube link through various channels (Form Webhook, WhatsApp, Telegram). Use Gemini AI to either summarize the content or transcribe the complete video, always outputting in English. Return the output to the user via their original channel and optionally log it to Google Sheets for record-keeping. Requirements The workflow relies on specific integrations and configurations: n8n Platform**: Self-hosted or cloud n8n instance to host and automate the workflow. Node Requirements**: Form/Webhook Trigger: Web form for pasting the YouTube link. WhatsApp Trigger: Starts workflow from incoming WhatsApp messages (YouTube link as input). Telegram Trigger: Initiates workflow from Telegram chat messages containing YouTube links. Gemini AI Node: Consumes the YouTube link and processes it for summarization or transcription (always in English). Google Sheets Node: Writes the result (summary/transcript) into a Google Sheet for logging and future reference. WhatsApp/Telgram Send Message Nodes: Delivers summarized results or transcripts back to the user on the same platform where they triggered the workflow. Credentials**: Gemini/Google AI Platform account for AI summarization and transcription. Google Sheets account for storing output. WhatsApp Business API for WhatsApp automation. Telegram Bot API for Telegram automation. Input Requirements**: Publicly-accessible YouTube video link (max ~30 min, as per summarized logic). Output**: English video summary or full transcript, delivered via user’s requested channel and/or stored in Google Sheets. API Usage The workflow integrates several APIs for optimal automation: Gemini AI API**: Used in the main summarization node. Receives the YouTube link and a prompt with detailed instructions. Returns either a clear, concise English summary or a full transcript translated into English, handling Hindi, English, or mixed-language videos. [Ref: Workflow JSON] Google Sheets API**: Used to log the output for each processed video, making it easy to reference histories or track requests. [Ref: Workflow JSON] WhatsApp Business API**: Sends back the summary or transcript to the user who initiated via WhatsApp. [Ref: Workflow JSON] Telegram Bot API**: Sends results back to Telegram users directly in chat. [Ref: Workflow JSON] Output Formatting/Conversion The AI output is always in English, tailored to the option chosen (summary vs transcript). Structured output: Bulleted, neutral, and easy to read, suitable for sharing with users or for business documentation. Google Sheets node maps and writes each video’s results to a dedicated row for easy history review. How to Use By default, the workflow uses a manual trigger via a web form, but you may add triggers for WhatsApp or Telegram to suit your needs. Users paste a YouTube link, then select whether they want a summary or transcript (based on your implementation logic). Results are returned in their channel and optionally logged to your Google Sheet. All processing is handled securely using your Gemini API credentials. You can expand this logic by adding more integrations (email, Slack, etc.). Customising this Workflow Custom prompts can be written for different styles or output formats (e.g., SEO key points, step-by-step guides). Add logic for batch processing multiple videos or bulk export to different cloud drives. Integrate into central dashboards, CRMs, or content pipelines using n8n’s hundreds of available integrations. Good to Know Gemini pricing:** At the time of writing, each YouTube video summarization costs $0.039 USD. See official Gemini Pricing for current rates. Geo-restriction:** The Gemini video model may be geo-restricted (error: “model not found” outside some regions). Video Limits:** Intended for videos up to ~30 minutes for best processing reliability. Scaling:** Can be easily adapted for high-volume operations using n8n’s queue and scheduling features. Workflow Summary The YouTube Video Summarizer Workflow automates summarizing and transcribing YouTube videos using AI and n8n. Users send video links via web forms, WhatsApp, or Telegram. Results are generated via Gemini, sent back in-app, and logged to Google Sheets, enabling effortless knowledge sharing and organizational automation at scale. Timestamp: 12:37 PM IST, Wednesday, September 17, 2025
by iMan
Automated Instagram Stories from Google Sheets 🚀 What it Does This workflow automates posting Instagram Stories directly from a list of video URLs in a Google Sheet. Simply add a video link to the sheet, and this template will schedule and post it for you. It's designed to be a "set it and forget it" solution for your content strategy. Key Features: Fully Automated: Runs on a schedule to post new content without manual intervention. Simple Content Management: Manage your entire video queue from one Google Sheet. Smart & Safe: Automatically avoids posting duplicate content by tracking what has already been published. Randomized Posting: Shuffles the video list to ensure varied content is posted, not just the first one on the list. 📋 Pre-Setup Requirements Before you start, you'll need a few things. This is the most important part of the setup\! Instagram Business Account: A personal account won't work. It must be a Business or Creator account. Facebook Page: Your Instagram Business Account must be connected to a Facebook Page. Meta Developer Account: This is required to create an "App" that gives n8n permission to post on your behalf. A Publicly Accessible Place to Host Videos: This is critical. The video URLs you use must be direct links to the video file. ✅ Good Sources: Shopify file storage, Amazon S3, a WordPress site with a valid SSL certificate (https://...). ❌ Unreliable Sources: Google Drive and Dropbox share links will not work because they are not direct links to the video file itself. ⚙️ Step-by-Step Setup Guide Follow these three parts carefully. Once done, you won't have to touch the configuration again. Part 1: Meta (Facebook/Instagram) Configuration This section generates the keys and IDs you need to allow n8n to communicate with Instagram. Create a Meta App: Go to Meta for Developers and create a new app. Detailed Guide: Meta's Official Guide to Creating an App Configure App Permissions: In your new app's dashboard, add the "Instagram Graph API" product. Under "Permissions," you will need to grant instagram_basic, instagram_content_publish, pages_show_list, and pages_read_engagement. Find Your Instagram Business Account ID: You'll need this ID for the workflow. 3.1. Log in: to your Instagram account. 3.2. Click on your Profile: in the menu on the left. 3.3. Click: "Edit Profile" at the top. 3.4. Under the "Settings" heading, click "See more in Accounts Center". 3.5. Select: your intended Instagram profile. 3.6. In the URL, your Instagram Business Account ID will be displayed after /profiles in a numerical format. Example: https://accountscenter.instagram.com/profiles/[YOUR_ID]/?theme=dark Generate a Long-Lived Access Token: An access token is like a password for n8n to use. A standard one expires quickly, so you need a long-lived one. Official Guide: Meta's Guide to Generating a Long-Lived Token Part 2: Google Sheet Preparation This is where you'll manage your video content. Create a Google Sheet: You can make a new one or use our template to get started quickly. Download Template: Instagram Videos Template.xlsx Set Up Columns: Your sheet must have these two columns with these exact names: source_url: This is where you will paste the direct URL to your video file. posted_story: Leave this column empty. The workflow will automatically fill it with true after a video is successfully posted. Get the Sheet ID: In your Google Sheet URL, copy the long string of letters and numbers from the middle: https://docs.google.com/spreadsheets/d/[THIS_IS_THE_SHEET_ID]/edit Part 3: n8n Workflow Configuration Now, let's connect everything inside your n8n workflow. Fill the ⚙️ Configuration Hub Node: IG\_BUSINESS\_ID: Paste the Instagram ID you found in Part 1. SHEET\_DOC\_ID: Paste the Google Sheet ID you found in Part 2. SHEET\_TAB\_NAME: Enter the exact name of the tab in your Google Sheet (e.g., "Instagram Videos"). Connect Your Credentials: Google Sheets: In the 📊 Fetch Videos from Sheet node, create a new credential and connect your Google Account. Facebook Graph API: In the 📤 Create Story Container node, create a new credential. Use the App ID, App Secret, and the Long-Lived Access Token you generated in Part 1. You will use this same credential for the other Facebook/Instagram nodes. Activate the Workflow: First, test it by clicking the "Execute Workflow" button on the 🚀 Manual Start node. Once you confirm it works, activate the workflow using the toggle at the top of the screen. The ⏰ Auto Schedule node is set to run daily by default, but you can change the time to whatever you like. 🤔 Troubleshooting Error: "(\#10) This endpoint requires the 'instagram\_content\_publish' permission": Your Meta App is missing the correct permissions. Go back to the app settings in the Meta Developer dashboard and add it. Error: "Unsupported post request" or Video Processing Fails: This is almost always an issue with the video URL. Ensure it's a direct link and not from a service like Google Drive. Paste the URL into your browser—it should immediately start playing the video, not take you to a preview page. Error: "Sheet not found": Double-check that your SHEET_DOC_ID and SHEET_TAB_NAME in the Config node are perfectly correct (it's case-sensitive\!). Workflow runs but doesn't post: Make sure you have rows in your Google Sheet where the posted_story column is empty. If all are marked true, it has nothing new to post. @iMan https://imanetworks.ch/
by Oneclick AI Squad
This n8n workflow receives files sent in a Telegram chat, uploads them to Google Drive, extracts text using OCR (for images and PDFs), and stores the extracted content in Airtable for quick search and retrieval. Users can later search through documents using a Telegram /search command. Key Features Accepts images and documents from Telegram Uploads files to Google Drive automatically Detects file type and runs OCR if eligible Extracts text from images & PDFs via Google Vision Stores file metadata + text in Airtable Search documents using /search command in Telegram Sends result previews and file links Error handling & user notifications included Use Cases Personal document vault with search Team knowledge filing system Receipt & invoice OCR archive Legal documents store & retrieval Research papers & notes indexing Company file inbox for AI knowledge base Workflow Steps | Step | Action | Description | | ---- | --------------------- | ---------------------------------------------------------- | | 1 | Telegram Trigger | Detects incoming docs/images or /search command | | 2 | Filter File or Search | Routes based on whether message has file or search command | | 3 | Extract Metadata | Reads file info such as name, MIME type, user | | 4 | Download File | Downloads file via Telegram API | | 5 | Upload to Drive | Saves file in Google Drive | | 6 | OCR Check | Determines if file supports OCR | | 7 | Google OCR | Runs OCR for images/PDFs | | 8 | Extract Text | Pulls text output from OCR | | 9 | Merge OCR Text | Combines file data + text | | 10 | Save to Airtable | Indexes with metadata + text | | 11 | Success Reply | Sends link + success message | | 12 | /search Flow | Parse search query | | 13 | Airtable Search | Full-text search for records | | 14 | Send Results | Sends matches to Telegram | | 15 | Error Handler | Notifies user on failure | Input Formats File Messages Supported Images PDFs Documents Search Command /search keyword Example: /search invoice Output After Upload: ✅ File saved & indexed successfully! 🔗 Drive Link: <link> After Search: Returns structured result: File name Preview text snippet Google Drive link Data Stored in Airtable | Field | Description | | ------------- | ------------------------- | | File Name | Original name | | File Link | Google Drive link | | MIME Type | File type | | Telegram User | Sender info | | OCR Text | Extracted searchable text | | Uploaded Date | Timestamp | Technical Requirements Telegram Bot Token Google Drive API connection Google Vision API key Airtable API key & table Benefits Automatically organizes Telegram files Makes PDFs & images searchable Saves manual sorting and indexing time AI-ready data storage (future LLM integration) Fast search experience right in Telegram Enhancement Ideas Add Whisper for voice message transcription Add chat GPT summarization for large docs Build dashboard for uploaded files Auto-tag documents (invoice, ID, receipt etc.) Multi-language OCR support Status ✅ Ready for production ✅ Handles images, PDFs, and files ✅ End-to-end automation 🛠 Optional: add more AI enrichment later
by Michael Muenzer
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Fetch Instagram profile information with Apify and generate personalized DMs in Google Sheets. This is great for creator outreach, customer interviews, partnership prospecting, and streamlining your social Direct Messaging workflow. Saving hours per campaign or research study. How it works We read a list of Instagram accounts from a Google Sheet We trigger the Apify Instagram Post Scraper task to fetch the latest post data per account We pull the image URL of the newest post and analyze it with OpenAI Vision We use the analysis plus account metadata to generate a personalized DM We write the message back to the Google Sheet for easy sending and tracking Note: Both Apify and OpenAI provide free credits that can cover initial runs of this workflow (20.08.2025). Set up steps Copy Google Sheet template and add it in all Google Sheet nodes Make sure that n8n has read & write permissions for your Google sheet. Add your list of Instagram accounts in the first column in the Google sheet Add Apify credentials (e.g. API key) Create task for Instagram Post Scraper on Apify Add OpenAI API credentials What you can achieve How do I scale creator outreach while keeping messages personal? This workflow pulls each profile’s latest post and bio, then generates a DM that references those specifics. One consistent prompt, fresh data per profile. Personal at scale. How do I craft partnership or affiliate pitches that feel tailored to the creator’s audience? This n8n workflow spots niche, recent themes, and milestones, then inserts a targeted value prop like an affiliate code or UTM so the pitch mirrors their content and audience. How can I personalize interview invites using details from a recent post or bio? This workflow opens with a concrete reference from the newest post or bio, states your interview topic, and adds a short CTA. If there’s no recent post, it switches to a bio-based hook. How do I personalize at scale for thousands of profiles without duplicating outreach? This n8n workflow processes each handle once, logs status in Google Sheets, and skips already‑messaged rows, so you get unique, data-backed DMs across hundreds of profiles without repeats.