Workflow Templates

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

Transform your Telegram bot into a secure content analyzer: send any URL, and get safe, structured Q&A extractions with AI-powered safety checks and web search capabilities. 📋 What This Template Does This workflow activates when a user sends a valid URL to your Telegram bot. It extracts questions and answers from the webpage using Airtop, applies NSFW and PII guardrails to ensure safe content, then uses an OpenRouter AI agent (with optional Tavily search) to generate and send a concise response. If guardrails fail, it alerts the user instead. Filters for valid URLs only to prevent unnecessary processing Extracts structured Q&A from documents or forms Enforces safety checks for harmful or private content Supports web searches for enhanced responses when needed 🔧 Prerequisites A Telegram bot created via @BotFather Accounts with Airtop, OpenRouter, and Tavily 🔑 Required Credentials Telegram API Setup Open Telegram → Search @BotFather → Use /newbot command Follow prompts to create bot and obtain API token Add to n8n as Telegram API credential type Airtop API Setup Visit https://airtop.ai → Sign up or log in → Navigate to Dashboard → API Keys Generate a new API key with extraction permissions Add to n8n as Airtop API credential type OpenRouter API Setup Go to https://openrouter.ai → Sign up or log in → Navigate to API Keys section Generate and copy your API key (free tier sufficient for basic use) Add to n8n as OpenRouter API credential type Tavily API Setup Visit https://app.tavily.com → Sign up or log in → Go to API Keys Generate and copy your API key Add to n8n as Tavily API credential type ⚙️ Configuration Steps Import the workflow JSON into n8n Assign your Telegram, Airtop, OpenRouter, and Tavily credentials to the respective nodes Activate the workflow to register the Telegram trigger Test by sending a plain URL (no extra text) to your bot in Telegram Monitor the first execution and adjust guardrail thresholds if needed 🎯 Use Cases Researchers summarizing academic papers or reports while ensuring no sensitive data leaks Support teams extracting info from customer-submitted docs/forms with automatic safety filtering Content creators pulling Q&A from articles for bots, blocking inappropriate responses Educators analyzing educational resources safely for student-facing chat tools ⚠️ Troubleshooting No response from bot: Verify the message contains only a valid URL; adjust regex in Filter Only URLs node if needed Guardrail failures: Lower NSFW threshold (e.g., from 0.7 to 0.5) or disable PII checks in Apply Safety Guardrails node Extraction errors: Test with public, text-heavy URLs; some JS-heavy sites may require alternative extractors Rate limits hit: Check OpenRouter/Tavily dashboards for usage; upgrade to paid tiers for heavy traffic

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

Who it’s for This workflow is for content creators and marketers who write short scripts in Google Sheets and want to automatically turn each line into an AI-generated avatar video stored in Google Drive, with links written back to the sheet. How it works A Manual Trigger starts the workflow. It first uses Get Avatar Description (Google Sheets) to read avatar details from a dedicated “Gaia” sheet. The Global Variables node sets the working script page (for example, “Draft 5”) and exposes the avatar description. Next, Get Script reads all rows from the selected sheet. Loop Over Items iterates through each row, while Set Loop Inputs prepares the variables: avatar description, speech, and framing. For every row, Generate a video with Veo (Google Gemini video model) creates an 8-second 16:9 clip. Upload video file saves it to a chosen Google Drive folder, and Update row in sheet with link to video writes the Drive link back into the same row, then loops to the next snippet. Yellow sticky notes explain each phase, with the large one summarizing the end-to-end snippet generation loop. How to set up Connect your Google Sheets and Google Drive credentials. Update the spreadsheet IDs, sheet names, and Drive folder to match your own. Configure the Gemini/Veo model credentials. Adjust the default script page name in Global Variables. Requirements n8n instance Google Sheets and Google Drive accounts Google Gemini / Veo API access No API keys or personal identifiers are hardcoded; always store credentials securely in n8n and avoid real PII in test data. How to customize Change the page value in Global Variables to target different script tabs. Edit the Veo prompt to alter background, camera framing, or speaking style. Modify video duration, aspect ratio, or output folder in the Gemini and Drive nodes. Extend the loop to add more post-processing steps (e.g., thumbnail generation, analytics tracking).

📄 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

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.

Monitor competitor ad activity via Telegram using BrowserAct & Gemini Turn your Telegram bot into a covert marketing intelligence tool. This workflow allows you to send a company name to a bot, which then scrapes active ad campaigns, analyzes the strategy using AI, and delivers a strategic verdict directly to your chat. Target Audience Digital marketers, dropshippers, e-commerce business owners, and ad agencies looking to track competitor activity without manual searching. How it works Receive Command: The workflow starts when you send a message to your Telegram bot (e.g., "Check ads for Nike" or "Spy on Higgsfield"). Extract Brand: An AI Agent (using Google Gemini) processes the natural language text to extract the specific company or brand name. Scrape Ad Data: A BrowserAct node executes a background task (using the "Competitor Ad Activity Monitor" template) to search ad libraries (like Facebook or Google) for active campaigns. Analyze Strategy: A second AI Agent acts as a "Senior Marketing Analyst." It reviews the scraped data to count active ads, identify key hooks, and determine if the competitor is scaling or inactive. Deliver Report: The bot sends a formatted HTML scorecard to Telegram, including the ad count, best ad copy, and a strategic verdict (e.g., "ADVERTISE NOW" or "WAIT"). How to set up Configure Credentials: Connect your Telegram, BrowserAct, and Google Gemini accounts in n8n. Prepare BrowserAct: Ensure the Competitor Ad Activity Monitor template is saved in your BrowserAct account. Configure Telegram: Ensure your bot is created via BotFather and the API token is added to the Telegram credentials. Activate: Turn on the workflow. Test: Send a company name to your bot to generate a report. Requirements BrowserAct* account with the *Competitor Ad Activity Monitor** template. Telegram** account (Bot Token). Google Gemini** account. How to customize the workflow Adjust Analysis Logic: Modify the system prompt in the Generate response agent to change how the "Verdict" is calculated (e.g., prioritize video ads over image ads). Add More Sources: Update the BrowserAct template to scrape TikTok Creative Center or LinkedIn Ads. Change Output: Replace the Telegram output with a Slack or Discord node to send reports to a team channel. Need Help? How to Find Your BrowserAct API Key & Workflow ID How to Connect n8n to BrowserAct How to Use & Customize BrowserAct Templates Workflow Guidance and Showcase Video Automated Ad Intelligence: How to Outsmart Your Competitors (n8n + BrowserAct)

This workflow automates the extraction of SEO metadata (URL, page title, and meta description) from every page listed in your website's sitemap and exports it to Google Sheets. Ideal for SEO audits, content inventories, and tracking on-page elements. Prerequisites Before using this workflow: A publicly accessible sitemap.xml URL Google Sheets spreadsheet with columns: URL, Title, and meta description Google Sheets API access via OAuth2 Setup Instructions 1. Configure Sitemap Source In the "Get Sitemap XML" node, replace the default URL with your actual sitemap URL 2. Connect Google Sheets Open the "Append or update row in sheet" node Configure Google Sheets credentials Set Document ID and Sheet Name Verify column mappings match your spreadsheet 3. Adjust Rate Limiting (Optional) Modify Wait nodes if encountering 429 errors Increase delay between requests if needed How It Works Trigger: Manual workflow execution Sitemap Fetch: Retrieve sitemap.xml file URL Parsing: Extract all URLs from sitemap Batch Processing: Process URLs in manageable batches Data Extraction: Scrape title and meta description from each page Data Merge: Combine URL with extracted metadata Sheet Update: Append or update rows in Google Sheets using URL as a unique key Features Duplicate Prevention**: Uses appendOrUpdate with URL matching Rate Limiting**: Built-in delays between requests Flexible Processing**: Handles sitemaps of various sizes Easy Customization**: Modify code nodes for additional data extraction Use Cases SEO audits of title and description tags Content migration planning Website content inventory management Ongoing SEO monitoring and reporting

⚡ 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!