Workflow Templates

This workflow synchronizes data one-way from Pipedrive to HubSpot. Cron node** schedules the workflow to run every minute. Pipedrive* and *Hubspot1 nodes pull in both lists of persons from Pipedrive and contacts from HubSpot. Merge node* with the option *Remove Key Matches identifies the items that uniquely exist in Pipedrive. Hubspot2 node** takes those unique items and adds them to HubSpot.

My Telegram bot provides specialized support through dedicated slash commands for different departments. Users can directly access the right support team using: /billing - For payment and invoice questions /tech-support - For technical assistance /return-policy - For returns and refunds Key Features: Command-based routing Direct department access via slash commands State management Tracks active conversations in PostgreSQL Knowledge base integration Pinecone vector stores for each department Auto-updating New Google Drive documents automatically populate the knowledge base Context-aware Maintains department choice

This powerful n8n workflow helps you automatically re-engage cold leads by summarizing their past emails and generating personalized outreach with OpenAI. It pulls in contacts from Google Sheets, fetches their prior communication from Outlook, and then uses an AI agent to analyze, strategize, and write a draft re-engagement message — all automatically. ⚙️ What the Workflow Does 📄 Get Contacts from Google Sheets Pulls a list of contacts and their email addresses from a Google Sheet. 📥 Search Emails from Outlook For each contact, fetches all emails received from that address since January 1, 2025. 📊 Aggregate Emails Merges relevant email fields (subject, body, createdDateTime) into a single string for analysis. 🧠 Use OpenAI to Analyze and Draft Response AI Agent summarizes the lead’s communication history. Suggests how to re-engage them in bullet points. Writes a personalized draft email to re-initiate the conversation. 📝 Save to Google Sheets Appends or updates the original row with: Summary of communication Re-engagement ideas Suggested subject line Suggested email body 📤 Create Draft Email in Outlook Creates a draft email in your Microsoft Outlook account using the subject and body provided by OpenAI. The email is not sent automatically — giving you a chance to review and personalize further. 🧰 What You'll Need 🔐 Google Sheets API connection** OAuth2 credential setup in n8n Make a copy of this sample sheet 🔐 Microsoft Outlook OAuth2 connection** Connected inbox with access to historical messages 🔐 OpenAI API Key** Add your OpenAI key in the OpenAI Chat Model node Recommended model: gpt-4o-mini or higher 👨‍💼 Built By Robert Breen Automation Consultant | n8n Expert | Data Strategist 🔗 Website: https://ynteractive.com 📧 Email: robert@ynteractive.com 💼 LinkedIn: https://www.linkedin.com/in/robert-breen-29429625/ 🏷 Tags openai outlook email reengagement lead nurturing automation google sheets ai email gpt-4o crm sales automation

🔧 AI-Powered B2B Prospecting Automation This automation is a complete end-to-end system designed to find, qualify, and contact B2B leads — fully automated and powered by AI. 1. Lead Discovery & Scoring Searches for target companies on LinkedIn via Ghost Genius API, using filters like location, and company size. Enriches each company with details like website, description, and follower count. Uses OpenAI to score each company (0 to 10) based on fit with your product. Filters out irrelevant companies and stores only qualified ones (score ≥ 7) into a Google Sheet CRM. 2. Decision-Maker Enrichment & Outreach Finds key decision-makers at each qualified company via LinkedIn Sales Navigator. Retrieves their job titles, descriptions, and LinkedIn summaries. Generates a fully personalized 3-email cold outreach sequence using OpenAI. Retrieves verified email addresses using a waterfall enrichment system. Stores all contact data and email content in your CRM and updates lead status. Key Features Fully automated**: runs daily with no manual input required. Smart targeting**: all filters and parameters managed in Google Sheets. AI-enhanced**: leverages OpenAI for scoring, personalization, and copywriting. Compliant & safe**: uses Ghost Genius API (cookieless scraping). Ideal for B2B startups, agencies, or growth teams looking to scale outbound without manual effort.

Job offers are a goldmine of information. Use them to boost your outreach results. They'll give you: more context to personalize your messaging a steady flow of new leads the right timing to contact your lead

This n8n workflow is designed to automate the aggregation, processing, and reporting of community statistics related to n8n creators and workflows. Its primary purpose is to generate insightful reports that highlight top contributors, popular workflows, and key trends within the n8n ecosystem. Here's how it works and why it's important: How It Works Data Retrieval: The workflow fetches JSON data files from a GitHub repository containing statistics about creators and workflows. It uses HTTP requests to access these files dynamically based on pre-defined global variables. Data Processing: The data is parsed into separate streams for creators and workflows. It processes the data to identify key metrics such as unique weekly and monthly inserters/visitors. Ranking and Filtering: The workflow sorts creators by their weekly inserts and workflows by their popularity. It selects the top 10 creators and top 50 workflows for detailed analysis. Report Generation: Using AI tools like GPT-4 or Google Gemini, the workflow generates a Markdown report summarizing trends, contributors, and workflow statistics. The report includes tables with detailed metrics (e.g., unique visitors, inserters) and insights into why certain workflows are popular. Distribution: The report is saved locally or uploaded to Google Drive. It can also be shared via email or Telegram for broader accessibility. Automation: A schedule trigger ensures the workflow runs daily or as needed, keeping the reports up-to-date. Why It's Important Community Insights**: This workflow provides actionable insights into the n8n community by identifying impactful contributors and popular workflows. This fosters collaboration and innovation within the ecosystem. Time Efficiency**: By automating data collection, processing, and reporting, it saves significant time and effort for community managers or administrators. Recognition of Contributors**: Highlighting top creators encourages engagement and recognizes individuals driving value in the community. Trend Analysis**: The workflow helps uncover patterns in usage, enabling better decision-making for platform improvements or feature prioritization. Scalability**: With its modular design, this workflow can be easily adapted to include additional metrics or integrate with other tools.

Beginner AI Agent Duo: Lead‑Qualifier Task Automator & Ecommerce Chatbot Status: Ready for Use ✅ Note: This template is built entirely with official n8n nodes—no community‑node installation required. 📝 Description This template demonstrates two beginner‑friendly AI‑agent patterns that cover the most common use cases: | Agent | Purpose | Flow Highlights | |-------|---------|-----------------| | Lead‑Qualifier Task Automator | Classifies phone‑call transcripts to decide if the caller is a good bulk‑order lead. | Manual Trigger → Code (sample data) → AI Agent (GPT‑4o‑mini) → Structured Output Parser → Set (clean fields) | | Ecommerce Chatbot | Answers customer questions about products, bulk pricing, shipping, and returns. | Chat Trigger (webhook) → AI Agent (GPT‑4o‑mini) with Memory → If node → Order‑placed reply or no‑op | Both agents run on GPT‑4o‑mini and use n8n’s LangChain‑powered nodes for quick, low‑code configuration. ⚙️ How to Install & Run Import the Workflow In n8n, go to Workflows → Import from File or Paste JSON, then save. Add Your OpenAI API Key Go to Credentials → New → OpenAI API. Paste your key from <https://platform.openai.com>. Select this credential in both OpenAI Chat Model nodes. (Optional) Select a Different Model Default model is gpt‑4o‑mini. Change to GPT‑4o, GPT‑3.5‑turbo, or any available model in each OpenAI node. Test the Lead‑Qualifier Agent Click Activate. Press Test workflow. The Code node feeds four sample transcripts; the AI Agent returns JSON like: { "Name": "Jordan Lee", "Is Good Lead": "Yes", "Reasoning": "Customer requests 300 custom mugs, indicating a bulk order." } Test the Ecommerce Chatbot Copy the Webhook URL from the When chat message received trigger. POST a payload like: { "message": "Hi, do you offer discounts if I buy 120 notebooks?" } The AI Agent replies with bulk‑pricing info. If the customer confirms an order, it appends *; the If node then sends “Your order has been placed”. 🧩 Customization Ideas Refine Qualification Logic** Edit the Task Agent’s system prompt to match your own lead criteria. Save Leads Automatically** Add Google Sheets, Airtable, or a database node after the Set node. Expand the Chatbot** Connect inventory APIs, payment gateways, or CRM integrations. Adjust Memory Length* Change the *Simple Memory node’s window to retain more conversation context. 🤝 Connect with Me Description I’m Robert Breen, founder of Ynteractive — a consulting firm that helps businesses automate operations using n8n, AI agents, and custom workflows. I’ve helped clients build everything from intelligent chatbots to complex sales automations, and I’m always excited to collaborate or support new projects. If you found this workflow helpful or want to talk through an idea, I’d love to hear from you. Links 🌐 Website: https://www.ynteractive.com 📺 YouTube: @ynteractivetraining 💼 LinkedIn: https://www.linkedin.com/in/robert-breen 📬 Email: rbreen@ynteractive.com

Quick Overview This workflow logs daily gold prices in INR from MetalpriceAPI into an n8n Data Table, calculates day-over-day changes, and uses Google Gemini to send Slack alerts for ±1% moves and a weekly trend report. How it works Runs every morning at 10:00 to fetch the latest XAU price in INR from MetalpriceAPI. Converts the returned rate into a per-10g gold price and stores it as a new row in an n8n Data Table. Retrieves all saved prices, takes the last two entries, calculates absolute and percentage change, and updates the latest row with these metrics. If the percentage change is ≥ 1% or ≤ -1%, Google Gemini drafts a short alert message and posts it to a Slack channel. Runs weekly at 10:00, fetches all Data Table records, and keeps the most recent seven entries. Aggregates the last seven days of prices and changes, Google Gemini generates a formatted summary report, posts it to Slack, and saves the report text back to the latest Data Table row. Setup Add your MetalpriceAPI credentials (HTTP header auth) and confirm the request parameters (base=INR, currencies=XAU) match your needs. Create or select an n8n Data Table with columns for gold_prices, price_change, percent_change, and alert_message, and update the workflow’s Data Table ID to point to it. Add Google Gemini (PaLM) API credentials for the alert and reporting prompts. Add Slack credentials and set the target channel for both Slack posting steps. Review the schedule triggers (daily and weekly at 10:00) and adjust the timezone/time as needed.

How it works This workflow automatically uploads YouTube Shorts from a Google Drive folder. It picks one video at each run, generates a YouTube-optimized title, description, and hashtags using an AI model, uploads the video through YouTube’s resumable upload API, and finally moves the processed video to a “Posted” folder. Key steps Run on a schedule (daily/hourly/custom CRON) Fetch one video from a selected Google Drive folder Generate title + description + hashtags using an LLM Prepare YouTube metadata Upload the video via resumable upload Move the file to a “posted” folder to avoid duplicates Setup instructions Connect your Google Drive credentials Connect your YouTube OAuth2 credentials Update the Drive folder IDs (input + posted folders) Edit the “Set variables” node to change store name, country, coupon code, and tone Review the prompt in the AI node if you want to customize content style All technical details are documented inside the sticky notes within the workflow.

Turn LinkedIn Noise Into Weekly Slack Insights 🚀 What if your team could skim the best of LinkedIn in 2 minutes instead of scrolling for hours? This workflow transforms raw LinkedIn posts into a bite-sized Slack digest — summarized, grouped, and delivered automatically every week. ⚡ What It Does Scrapes Posts Automatically**: Pulls fresh posts from LinkedIn profiles you specify (via Apify). Summarizes with AI: Condenses each post into **2–3 bullets (≤15 words). Keeps It Lean: Digest capped at **500 words total. Organized by Author**: See exactly who said what, without searching. Delivers to Slack**: Neatly formatted digest drops in your channel on schedule, with post links in thread replies. 🛠 How It Works Google Sheets → Profile URLs Add LinkedIn profile URLs into a Google Sheet tab — this is your watchlist. Apify Scraper → Posts Fetches up to 10 posts per profile within the past 7 days. Clean & Format Code nodes strip out clutter (hashtags, broken links, escapes). OpenAI Summarizer AI rewrites posts into concise bullets and trims the digest under 500 words. Slack Delivery Digest posts directly in Slack every Sunday morning, with original links attached as thread replies. ✅ Pre-conditions / Requirements Google Sheets API credentials** connected in n8n. Apify account + API Token** for the LinkedIn profile posts actor. OpenAI API Key** for summarization. Slack Bot Token** with permission to post messages in your chosen channel. Profiles you want to track must be publicly viewable or accessible to Apify. 🎛 Customization Options Schedule**: Change the Cron node if you prefer daily or monthly digests. Batch Size**: Default is 5 profiles per batch — increase or decrease for performance. Summaries**: Adjust OpenAI system prompt to allow longer or shorter bullet points. Filters**: Extend extendOutputFunction to exclude reposts, sponsored posts, or keep specific authors only. Slack Output**: Change formatting, channel, or send as direct message instead of posting in a channel. 💡 Why This Is Valuable Saves your team 3–5 hours/week of scrolling. Keeps everyone updated with actionable insights, not filler. Turns a chaotic LinkedIn feed into a signal-only digest. Positions you as the one who always brings the smartest highlights to the table. 🎯 Best For Founders who want LinkedIn insights without endless scrolling. Marketing and growth teams tracking thought leaders. Operators who want signal over noise, delivered straight to Slack. No more mindless scrolling. Just sharp insights, automatically packaged. ✅

AI-Powered PLG Revenue Engine: Segment, Attio & Outreach Sync This workflow bridges the gap between raw product data and revenue sales tools. It automates the entire Product Qualified Lead (PQL) lifecycle—from real-time intent routing to churn prevention—reducing SalesOps overhead by 80%. Who’s it for B2B SaaS Teams** looking to automate PQL outreach based on product usage. Revenue Ops** needing to sync Attio CRM, ActiveCampaign, and Lemlist. Growth Teams** requiring real-time AI classification of user intent. How it works Real-Time Intent Routing:** Segment webhooks trigger Claude AI to classify PQLs. High-intent users are instantly moved to Lemlist for outreach. Deal Progression Sync:** Changes in Attio deal stages automatically update ActiveCampaign nurture lists and Segment profiles. Intercom Revenue Signals:** AI scans Intercom conversations for buying signals or churn risks, creating Attio deals or churn prevention tasks. Daily PQL Scoring:** Every morning at 7 AM, the workflow scores trial users across 5 dimensions, enrolling "Hot" leads into conversion sequences. How to set up Node Configuration: Manually enter your specific Campaign IDs in the Lemlist nodes and List IDs in the ActiveCampaign nodes. Credentials: Set up official n8n credentials for Attio, Segment, Anthropic (Claude), Lemlist, Intercom, and ActiveCampaign. Webhook Mapping: Connect your Segment and Intercom webhook URLs to the respective Trigger nodes. Attio Schema: Ensure your Attio workspace includes custom attributes for pql_score, pql_tier, and churn_risk_score. Requirements n8n version:** 1.0+ AI Credits:** Anthropic (Claude) and OpenAI (for Intercom analysis). Tech Stack:** Segment, Attio CRM, ActiveCampaign, Lemlist, and Intercom. Results 65% Increase** in trial-to-PQL conversion rates. Outreach speed** improved from 3 days to under 10 minutes. 80% reduction** in manual SalesOps and Revenue Ops overhead.

Monitor CRM accounts for hiring spikes by enriching HubSpot companies with PredictLeads job data and alerting your team via Slack. This workflow pulls all companies from your HubSpot CRM, checks each one against the PredictLeads Job Openings API for target roles (sales, engineering, marketing, product, data), compares the current count to historical data stored in Google Sheets, and flags any company where hiring jumped more than 50%. Flagged companies get updated in HubSpot with a hiring signal and trigger a Slack alert so your sales team can act fast. How it works: Schedule trigger runs the workflow daily at 9 AM. Retrieves all companies from HubSpot CRM (domain, name, ID). Loops through each company and fetches job openings from PredictLeads. Filters jobs to target roles (sales, engineering, marketing, product, data). Reads the previous job count for that company from Google Sheets. Calculates percentage change between current and historical counts. If hiring increased more than 50%, flags it as a spike. Updates the HubSpot company record with a hiring signal property. Sends a Slack alert with the company name, role count, and percentage change. Updates Google Sheets with the latest count regardless of spike status. Setup: Connect your HubSpot CRM (OAuth2) with company read/write access. Create a Google Sheet with a "HistoricalCounts" tab containing columns: domain, company_name, job_count, previous_count, percent_change, check_date. Connect a Slack bot to the channel where you want hiring alerts. Add your PredictLeads API credentials (X-Api-Key and X-Api-Token headers). Requirements: HubSpot CRM account with OAuth2 credentials. Google Sheets OAuth2 credentials. Slack OAuth2 credentials (bot with chat:write permission). PredictLeads API account (https://docs.predictleads.com). Notes: The 50% spike threshold can be adjusted in the IF node. Target roles are configured in the Filter Target Roles code node -- add or remove roles as needed. The workflow updates historical data on every run, so spike detection improves over time. PredictLeads Job Openings API docs: https://docs.predictleads.com