Workflow Templates

Instagram Hashtag Lead Generation Automate the process of finding and qualifying Instagram leads based on hashtags. This workflow reads hashtags from Google Sheets, scrapes Instagram for posts using Apify, analyzes caption content and language, compiles unique usernames, gathers detailed user info, and filters leads based on follower count. How It Works Fetch Hashtags The workflow starts and pulls a list of hashtags from a Google Sheet. Scrape Instagram Posts For each hashtag, it builds Instagram explore URLs and scrapes posts using Apify. Analyze Captions Each caption is cleaned, hashtags and links are removed, and language/content is analyzed (English/French/Spanish). Extract & Filter Usernames Usernames are combined and deduplicated, their Instagram profiles scraped for follower counts and other details. Qualified Leads Only users with followers in your target range are kept as qualified leads for outreach or analysis. Requirements An n8n instance. Apify API key. Google account with a Sheet containing hashtags. Apify Instagram Scraper actor access. The Google Sheet should have a column with hashtags. Setup Instructions Add Credentials In n8n, add your Apify API key and Google Sheets credentials. Configure Google Sheets Nodes Choose your credentials, spreadsheet, and sheet name in the “Get list of Hashtags” node. Configure Apify Request Nodes Enter your Apify API key and select the Instagram scraper actors. Adjust Filtering Edit the min/max follower count in the relevant filter node to match your needs. Test & Run Manually execute the workflow or add a trigger to run on a schedule. Customization Options 💡 Trigger:** Add a schedule or webhook to automate execution. Language Filtering:** Modify keyword lists or add language detection logic. Lead Output:** Extend the workflow to save leads to a CRM or send notifications. Details Nodes used in workflow: Manual Trigger Google Sheets Code HTTP Request (Apify) IF (Conditional) Aggregate Remove Duplicates Sticky Note

Turn Your Reading Habit into a Content Creation Engine This workflow is built for one core purpose: to maximize the return on your reading time. It turns your passive consumption of articles and highlights into an active system for generating original content and rediscovering valuable ideas you may have forgotten. Why This Workflow is Valuable End Writer's Block Before It Starts:** This workflow is your personal content strategist. Instead of staring at a blank page, you'll start your week with a list of AI-generated content ideas—from LinkedIn posts and blog articles to strategic insights—all based on the topics you're already deeply engaged with. It finds the hidden connections between articles and suggests novel angles for your next piece. Rescue Your Insights from the Digital Abyss:** Readwise is fantastic for capturing highlights, but the best ones can get lost over time. This workflow acts as your personal curator, automatically excavating the most impactful quotes and notes from your recent reading. It doesn't just show them to you; it contextualizes them within the week's key themes, giving them new life and relevance. Create an Intellectual Flywheel:** By systematically analyzing your reading, generating content ideas, and saving those insights back into your "second brain," you create a powerful feedback loop. Your reading informs your content, and the process of creating content deepens your understanding, making every reading session more valuable than the last. How it works This workflow automates the process of generating a "Weekly Reading Insights" summary based on your activity in Readwise. Trigger:** It can be run manually or on a weekly schedule Fetch Data:** It fetches all articles and highlights you've updated in the last 7 days from your Readwise account. Filter & Match:** It filters for articles that you've read more than 10% of and then finds all the corresponding highlights for those articles. Generate Insights:** It constructs a detailed prompt with your reading data and sends it to an AI model (via OpenRouter) to create a structured analysis of your reading patterns, key themes, and content ideas. Save to Readwise:** Finally, it takes the AI-generated markdown, converts it to HTML, and saves it back to your Readwise account as a new article titled "Weekly Reading Insights". Set up steps Estimated Set Up Time:** 5-10 minutes. Readwise Credentials: Authenticate the two HTTP Request nodes and the two Fetch nodes with your Readwise API token Get from Reader API. Also check how to set up Header Auth AI Model Credentials: Add your OpenRouter API key to the OpenRouter Chat Model node. You can swap this for any other AI model if you prefer. Customize the Prompt: Open the Prepare Prompt Code node to adjust the persona, questions, and desired output format. This is where you can tailor the AI's analysis to your specific needs. Adjust Schedule: Modify the Monday - 09:00 Schedule Trigger to run on your preferred day and time.

SharePoint → Supabase → Google Drive Sync Workflow Overview This workflow is a multi-system document synchronization pipeline built in n8n, designed to automatically sync and back up files between Microsoft SharePoint, Supabase/Postgres, and Google Drive. It runs on a scheduled trigger, compares SharePoint file metadata against your Supabase table, downloads new or updated files, uploads them to Google Drive, and marks records as completed — keeping your databases and storage systems perfectly in sync. Workflow Structure Data Source:** SharePoint REST API for recursive folder and file discovery. Processing Layer:** n8n logic for filtering, comparison, and metadata normalization. Destination Systems:** Supabase/Postgres for metadata, Google Drive for file backup. SharePoint Sync Flow (Frontend Flow) Trigger:** Schedule Trigger Runs at fixed intervals (customizable) to start synchronization. Fetch Files:** Microsoft SharePoint HTTP Request Recursively retrieves folders and files using SharePoint’s REST API: /GetFolderByServerRelativeUrl(...)?$expand=Files,Folders,Folders/Files,Folders/Folders/Folders/Files Filter Files:** filter files A Code node that flattens nested folders and filters unwanted file types: Excludes system or temporary files (~$) Excludes extensions: .db, .msg, .xlsx, .xlsm, .pptx Normalize Metadata:** normalize last modified date Ensures consistent Last_modified_date format for accurate comparison. Fetch Existing Records:** Supabase (Get) Retrieves current entries from n8n_metadata to compare against SharePoint files. Compare Datasets:** Compare Datasets Detects new or modified files based on UniqueId, Last_modified_date, and Exists. Routes only changed entries forward for processing. File Processing Engine (Backend Flow) Loop:** Loop Over Items2 Iterates through each new or updated file detected. Build Metadata:** get metadata and Set metadata Constructs final metadata fields: file_id, file_title, file_url, file_type, foldername, last_modified_date Generates fileUrl using UniqueId and ServerRelativeUrl if missing. Upsert Metadata:** Insert Document Metadata Inserts or updates file records in Supabase/Postgres (n8n_metadata table). Operation: upsert with id as the primary matching key. Download File:** Microsoft SharePoint HTTP Request1 Fetches the binary file directly from SharePoint using its ServerRelativeUrl. Rename File:** rename files Renames each downloaded binary file to its original file_title before upload. Upload File:** Upload file Uploads the renamed file to Google Drive (My Drive → root folder). Mark Complete:** Postgres Updates the Supabase/Postgres record setting Loading Done = true. Optional Cleanup:** Supabase1 Deletes obsolete or invalid metadata entries when required. Integrations Used | Service | Purpose | Credential | |----------|----------|-------------| | Microsoft SharePoint | File retrieval and download | microsoftSharePointOAuth2Api | | Supabase / Postgres | Metadata storage and synchronization | Supabase account 6 ayan | | Google Drive | File backup and redundancy | Google Drive account 6 rn dbt | | n8n Core | Flow control, dataset comparison, batch looping | Native | System Prompt Summary > “You are a SharePoint document synchronization workflow. Fetch all files, compare them to database entries, and only process new or modified files. Download files, rename correctly, upload to Google Drive, and mark as completed in Supabase.” Workflow rule summary: > “Maintain data integrity, prevent duplicates, handle retries gracefully, and continue on errors. Skip excluded file types and ensure reliable backups between all connected systems.” Key Features Scheduled automatic sync across SharePoint, Supabase, and Google Drive Intelligent comparison to detect only new or modified files Idempotent upsert for consistent metadata updates Configurable file exclusion filters Safe rename + upload pipeline for clean backups Error-tolerant and fully automated operation Summary > A reliable, SharePoint-to-Google Drive synchronization workflow built with n8n, integrating Supabase/Postgres for metadata management. It automates file fetching, filtering, downloading, uploading, and marking as completed — ensuring your data stays mirrored across platforms. Perfect for enterprises managing document automation, backup systems, or cross-cloud data synchronization. Need Help or More Workflows? Want to customize this workflow for your organization? Our team at Digital Biz Tech can extend it for enterprise-scale document automation, RAGs and social media automation. We can help you set it up for free — from connecting credentials to deploying it live. Contact: shilpa.raju@digitalbiz.tech Website: https://www.digitalbiz.tech LinkedIn: https://www.linkedin.com/company/digital-biz-tech/ You can also DM us on LinkedIn for any help.

Quick Summary This workflow connects Telegram, Google Gemini AI, and Notion to make task creation effortless. Whenever you send a message to your Telegram bot, Gemini AI reads your message, understands what task you meant, and automatically creates it in your Notion database - complete with the task name and due date. If you approve, the task is added to Notion and you’ll get a confirmation in Telegram. If you decline, it simply replies that ❌ no task was created. Perfect for anyone who wants to capture ideas or to-dos directly from Telegram without opening Notion every time. Detailed Use Cases Quick task capture from Telegram Send a message like “Buy milk 25 May” to your Telegram bot. The AI extracts the task name and date, asks you to approve, and creates a Notion task once approved. Turn reminders into Notion tasks Message: “Pay rent next Monday” → Approve → Task added to Notion with the correct due date. Perfect for quickly saving reminders while on the go. Tip: For best results, include clear dates in your messages like 25 May or May 25, 2025 so the AI can extract them accurately. Prerequisites / Requirements Before using this workflow, make sure you have the following ready: Telegram Bot Setup Go to @BotFather on Telegram. Create a new bot using the /newbot command. Copy the Bot Token — you’ll need it to connect in the Telegram Trigger and Telegram nodes in n8n. Google Gemini API Key Sign up for a free Google AI Studio account. Create an API key and connect it in your n8n credentials under Google Gemini. This workflow uses the models/gemini-2.5-flash-lite model, which works perfectly on the free tier. Notion Database Setup Create a Notion database for storing tasks. It must have: A Title property — set this as the Task Name (type: Title / text). A Date property — set this as the Due Date (type: Date). Copy your Notion database ID and connect your Notion API credentials in n8n. Optional Security Note In the Telegram Trigger node, restrict the chatId to your own Telegram user ID if this workflow is for personal use. Customization Guide You can easily extend this workflow to capture more details from your Telegram messages using the AI Extract node. Here are a few simple ways to customize it: Add more extracted fields In the AI Extract: TaskName & TaskDue node, open the Attributes section. Add new fields like: Priority → text (e.g., High, Medium, Low) Duration → number or text (e.g., 30 mins, 1 hour) Notes → text (optional extra info) The Gemini model will automatically try to extract these from your message. Example messages you can send “Finish report by Friday — high priority, 2 hours.” “Workout tomorrow evening — medium priority.” Map extra fields to Notion In the Notion: Create Task (Page) node, scroll to the Properties section. Add matching Notion properties for each new field (e.g., Priority, Duration). Map the AI outputs (like output.Priority) to their respective fields. Send confirmation with extra data In the Send and Wait for Response (Approve/Decline) node, include the new extracted details in the Telegram message before approval. Example confirmation message: Task: {{ $json.output.TaskName }} Due: {{ $json.output.TaskDue }} Priority: {{ $json.output.Priority }} Duration: {{ $json.output.Duration }} By doing this, you can build a smarter task capture system that includes priority, time estimation, and other useful details, all directly from your Telegram chat.

Description: Keep your customer knowledge base up to date with this n8n automation template. The workflow connects Zendesk with Google Sheets, automatically fetching tickets tagged as “howto,” enriching them with requester details, and saving them into a structured spreadsheet. This ensures your internal or public knowledge base reflects the latest customer how-to queries—without manual copy-pasting. Perfect for customer support teams, SaaS companies, and service providers who want to streamline documentation workflows. What This Template Does (Step-by-Step) ⚡ Manual Trigger or Scheduling Run the workflow manually for testing/troubleshooting, or configure a schedule trigger for daily/weekly updates. 📥 Fetch All Zendesk Tickets Connects to your Zendesk account and retrieves all available tickets. 🔍 Filter for "howto" Tickets Only Processes only tickets that contain the “howto” tag, ensuring relevance. 👤 Enrich User Data Fetches requester details (name, email, profile info) to provide context. 📊 Update Google Sheets Knowledge Base Saves ticket data—including Ticket No., Description, Status, Tag, Owner Name, and Email. ✔️ Smart update prevents duplicates by matching on description. 🔁 Continuous Sync Each new or updated “howto” ticket is synced automatically into your knowledge base sheet. Key Features 🔍 Tag-based filtering for precise categorization 📊 Smart append-or-update logic in Google Sheets ⚡ Zendesk + Google Sheets integration with OAuth2 ♻️ Keeps knowledge base fresh without manual effort 🔐 Secure API credential handling Use Cases 📖 Maintain a live “how-to” guide from real customer queries 🎓 Build self-service documentation for support teams 📩 Monitor and track recurring help topics 💼 Equip knowledge managers with a ready-to-export dataset Required Integrations Zendesk API (for ticket fetch + user info) Google Sheets (for storing/updating records) Why Use This Template? ✅ Automates repetitive data entry ✅ Ensures knowledge base accuracy & freshness ✅ Reduces support team workload ✅ Easy to extend with more tags, filters, or sheet logic

This workflow pulls deals from Pipedrive, categorizes them by stage, and logs them into a Google Sheet for reporting and tracking. ⚙️ Setup Instructions 1️⃣ Connect Pipedrive In Pipedrive → Personal preferences → API → copy your API token URL shortcut: https://{your-company}.pipedrive.com/settings/personal/api In n8n → Credentials → New → Pipedrive API Company domain: {your-company} (the subdomain in your Pipedrive URL) API Token: paste the token from step 1 → Save In the Pipedrive Tool node, select your Pipedrive credential and (optionally) set filters (e.g., owner, label, created time). 2️⃣ Prepare Your Google Sheet Connect your Data in Google Sheets Use this format: Sample Sheet Row 1 = column names In n8n, create credentials: Google Sheets (OAuth2) Log in with your Google account and select your Spreadsheet + Worksheet 🧠 How it works Get many deals (Pipedrive)**: Fetches all deals with stage IDs. Categorize Stages**: Maps stage IDs → friendly stage names (Prospecting, Qualified, Proposal, Negotiation, Closed Won). Today's Date**: Adds a date stamp to each run. Set Fields**: Combines stage, deal name, and date into clean columns. Google Sheets (Append)**: Writes all rows to your reporting sheet. 📬 Contact Need help customizing this (e.g., pulling only active deals, calculating win-rates, or sending dashboards)? 📧 robert@ynteractive.com 🔗 Robert Breen 🌐 ynteractive.com

Query personal finance data in Notion via Telegram and WhatsApp Who’s it for This workflow is for individuals who track their finances in Notion and want quick answers via chat. Entrepreneurs, freelancers, and professionals can use it to check expenses, income, or budgets instantly without opening Notion. How it works The workflow acts as an Accountant Agent powered by Claude AI through OpenRouter. When you send a query like “Total expenses for August 2025” through Telegram or WhatsApp, the agent identifies the right Notion database, applies filters, and retrieves the requested data. It then replies with a summarized result directly to your phone. How to set up Clone the Personal Finance System Notion template into your workspace. Create a Telegram bot with BotFather and collect the bot token and chat ID. Get an API key from OpenRouter. Create a Notion integration token and connect it with your duplicated finance template. Set up WhatsApp Business credentials via Meta (WABA ID, Phone Number ID, and permanent access token). Requirements n8n instance (self-hosted or cloud) Accounts on Telegram, OpenRouter, Notion, and WhatsApp Business Your duplicated Personal Finance System Notion template How to customize the workflow You can extend the workflow to handle assets, liabilities, or budgets. Add more Notion databases, adjust query filters, or configure WhatsApp templates for automated financial updates.

🚀 Telegram Google Trends Bot Workflow This workflow creates a powerful, multi-country Google Trends bot on Telegram. Users can request the top trending search queries for any country by simply sending its two-letter country code (e.g., EG, US, SA). The bot fetches the latest data, formats it into a clean report, and sends it back to the chat. ✨ Key Features 🌍 Dynamic Country Selection:** Get trends for any country on the fly by providing its geo code 📡 Automated RSS Fetching:** Pulls the latest data directly from Google's official daily trends RSS feed 📊 Clean, Formatted Reports:** Uses a custom code node to generate a beautiful, Markdown-formatted message that is easy to read on mobile 📈 Rich Information:** Each trend includes: 🔍 The search query title 📊 Approximate search traffic volume (e.g., "20K+ searches") 📰 Links to the top 2 related news articles, complete with their sources 🌟 Optimized for Arabic:** The report headers and labels are in Arabic, making it perfect for users in the MENA region, but can be easily adapted ⚙️ How It Works 💬 Telegram Trigger: A user sends a message containing a two-letter country code (e.g., EG) 🌐 HTTP Request: The workflow uses this code as the geo parameter in a request to the trends.google.com/trending/rss endpoint 📄 XML Parser: The native XML node converts the raw RSS feed data into a structured JSON format 💻 Code (Format Report): A JavaScript function processes the JSON data. It extracts the top 5 trends, formats the titles, traffic, and news items, and constructs the final Markdown text for the report 📤 Send to Telegram: The final, formatted report is sent back to the user who requested it 🛠️ Setup 🔐 Telegram Credentials: Add your Telegram API credentials to the Telegram Trigger and Send a text message nodes 🌐 (Optional) Customize Language: The text and labels in the Code node can be easily translated to any language you prefer

📄 What this workflow does Every 3 hours, the workflow fetches 3 random English words, asks Gemini to generate a short Vietnamese vocabulary digest (word, Vietnamese meaning, and an example sentence), and sends it to a Telegram chat. Perfect for steady, low-effort vocab exposure in groups. 👤 Who is this for English learners who want a gentle, automated learning cadence. Teachers/tutors who share daily vocab in Telegram groups. Community admins who want lightweight, useful content for members. Anyone who prefers bite-sized language learning on autopilot. ✅ Requirements Gemini API access (configured in n8n). Telegram Bot token + chat ID (the chat you want to receive messages). Internet access to Random Word API (no API key required). n8n instance with outbound HTTPS access. ⚙️ How to set up Add your Gemini credentials in n8n (the Google Gemini/PaLM node). Add your Telegram credentials and set the chatId in the “Send a text message” node. (Optional) Adjust the schedule interval (default: every 3 hours). (Optional) Change the number of words by updating the HTTP Request URL param words=3. (Optional) Edit the Gemini prompt language/content to fit your style (currently Vietnamese output). Run once to test; confirm the message arrives in Telegram. 🔁 How it works Schedule Trigger → runs every 3 hours. HTTP Request → calls random-word-api to get 3 words. Edit Fields (Set) → wraps the API response under word. Aggregate → prepares the word field for the LLM. Message a model (Gemini) → creates a Vietnamese digest: English word, Vietnamese meaning, and example sentence for each word. Send a text message (Telegram) → posts the digest to your specified chat. 💡 About Margin AI Margin AI is an AI-services agency that acts as your AI Service Companion. We design intelligent, human-centric automation solutions—turning your team’s best practices into scalable, automated workflows and tools. Industries like marketing, sales, and operations benefit from our tailored AI consulting, automation tools, chatbot development, and more.

This workflow automatically enriches company domain lists with comprehensive business information using Perplexity AI's research capabilities and organizes the data in Google Sheets for easy analysis and use. Who's it for Sales teams** building prospect databases with accurate contact information Marketing professionals** researching target companies for campaigns Business development teams** gathering competitive intelligence Data analysts** enriching existing company datasets Researchers** collecting business information for market analysis How it works The workflow reads unprocessed company domains from a Google Sheets document, processes them in batches of 10 using Perplexity AI to research detailed business information, then saves the enriched data back to the spreadsheet. It focuses on German addresses but can be customized for any region. What it does Fetches unprocessed domains - Reads company domains from Google Sheets that haven't been processed yet Batches for efficiency - Groups domains into batches of 10 to optimize API costs and performance AI-powered research - Uses Perplexity AI to find comprehensive business data for each company Parses structured data - Converts AI responses into clean, structured JSON format Updates spreadsheet - Saves enriched data and marks domains as processed to prevent duplicates Requirements Perplexity AI API key** (Get one here) Google Sheets API access** (OAuth2 credentials) Google Sheets template** - Make a copy of this template How to set up Make a copy of the template Google Sheet and update the document ID in both Google Sheets nodes Configure Perplexity AI credentials in the HTTP Request node Set up Google Sheets OAuth2 authentication Add your company domains to the "domain" column in the Data tab Leave the "processed" column empty for new domains Run the workflow using the manual trigger How to customize the workflow Change target region**: Modify the AI prompt to research addresses in different countries Adjust batch size**: Change the batch size in the "Batch Process Domains" node (smaller batches = lower costs) Add custom fields**: Extend the AI prompt and Google Sheets mapping to include additional data points Automate execution**: Replace Manual Trigger with Schedule Trigger for regular processing Filter criteria**: Modify the Google Sheets filter to process specific subsets of domains Output data includes Complete company address (street, city, state, postal code, country) International phone number format Latest employee count and annual revenue (USD) Industry classification LinkedIn company URL Reliable source URL for verification Processing status tracking

⚡ Overview This workflow connects Telegram with an AI Agent (Gemini) and Notion to automate content requests. Team members can request content ideas directly in Telegram. The AI processes the request, then automatically creates a new entry in your Notion Content database. 🛠️ Features 🤖 AI-powered assistant: Gemini AI with memory to understand context and generate better responses. 📲 Telegram integration: Accepts requests directly from your Telegram bot. 🗂️ Notion automation: Auto-creates records in your Notion database (title, content draft, channel, assignee, date, references, type). 🛡️ Secure & flexible: No hardcoded API keys, placeholders used for easy setup. 📝 Setup Instructions Add your Telegram Bot Token, Google Gemini API Key, and Notion Integration Token in n8n credentials. Steps: Import this template JSON into your n8n instance. Configure credentials in n8n (Telegram, Notion, Gemini API). 🎯 Use Cases Content marketing teams managing requests via Telegram. Automating idea collection from distributed teams. Keeping Notion Content updated without manual entry.

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Workflow Description: Startup Idea Finder (n8n) What This Workflow Does: This n8n workflow helps entrepreneurs discover startup ideas by automatically scraping top posts from multiple subreddits that often discuss unmet needs or problems (e.g., posts containing phrases like “Why is there no tool that”, “I wish there was an app for”, “someone should make”, etc.). The workflow extracts key information from these posts and sends it to Google’s Gemini 1.5 Flash-8b AI model, which analyzes the problem and suggests possible solutions or startup ideas. All relevant data and AI-generated insights are then saved to a Google Sheet for easy review and tracking. How It Works (Step-by-Step) 1. Manual Trigger: The workflow starts with a manual trigger. 2. Reddit Scraping: It queries multiple subreddits for top posts matching specific keywords that indicate a problem or unmet need. 3. Merge & Edit Fields: The results are merged and filtered to keep only the necessary fields: title, selftext, ups, created, and url. 4. AI Analysis: The filtered post data is sent to the Gemini 1.5 Flash-8b model with a prompt asking for: An explanation of the core problem, Whether existing solutions exist, A new startup idea if not, The target user, An implementation overview. 5. Google Sheets Logging: Both the original post data and the AI’s output are appended as a new row in a Google Sheet for future reference. APIs & Credentials Needed To use this workflow, you must set up the following credentials in your n8n instance: Reddit API: For scraping subreddit posts. Google Gemini (PaLM) API: For AI-powered analysis and idea generation. Google Sheets API: For saving results to your spreadsheet. Google Sheets Setup Before running the workflow, create a Google Sheet with the following columns (in this order): title, selftext, ups, created, url, output* The workflow will automatically append new rows with the scraped post data and the AI-generated output. Summary This workflow is a powerful tool for anyone looking to systematically discover and analyze real-world problems discussed online, and to generate actionable startup ideas using AI. Just set up your credentials, prepare your Google Sheet, and you’re ready to start finding your next big idea!