Workflow Templates

What this template is made for: I have a personal Telegram channel and a bot inside it where I save interesting links that I want to save or read later. The idea is that n8n will take care of reading the new links added to this channel and send them, through the corresponding API, to the Hoarder and Readeck installations. How it works Since my server where n8n runs is not always on, a "Schedule Trigger" will be responsible for checking every so often if there is any new content in the Telegram channel where I store the links. This request is made through "http request" and the Telegram API. Next, a code block is responsible for filtering out everything that is not a hyperlink. At this point, the flow splits into two so that parallel and similar processes are performed for Hoarder and Readeck. The corresponding API is accessed to get a list of all the links saved in the corresponding service. A code block is responsible for filtering the list of hyperlinks previously obtained from Telegram so that only those that are not already saved in the service continue. Finally, another "Http Request" node is responsible for using the service API to save the link in the corresponding service. Configuration instructions The template makes use of the environment variables that I have declared in the n8n "docker-compose.yml" file through an external ".env" file. These are the variables I use: Telegram Bot Token Sherlink TG_SHERLINK_BOT_TOKEN=XXXXXXXX:XXXXXXXXXXXXXXXX Id Telegram Channel Sherlink TG_SHERLINK_ID=-XXXXXXXXXXXXX Readeck server READECK_SERVER=http://readeck.midomain.com READECK_API_KEY=xxxxxxxxxxxxx Hoarder server HOARDER_SERVER=http://hoarder.midomain.com HOARDER_API_KEY=xxxxxxxxxxxxxx Created in 1.85.4 n8n version

Who this is for? Extract & Summarize Yelp Business Review is an automated workflow that extracts the Yelp business reviews using Bright Data Web Unlocker, process and formats the raw data, summarizes using the Google Gemini's LLM, and forward the concise summary with the review respose to a specified webhook endpoint. This workflow is tailored for: Local SEO Specialists who need structured insights from Yelp reviews to optimize listings. Business Owners wanting quick summaries of what customers love or complain about. Reputation Managers who monitor brand sentiment and identify customer pain points. Data Analysts & Researchers extracting Yelp review patterns at scale. AI Product Builders needing clean Yelp review data as input for their LLMs or recommender systems. What problem is this workflow solving? Yelp reviews are rich in customer sentiment but messy to work with manually. This workflow solves: The pain of scraping Yelp review content manually. The challenge of building the structured data with the summary. The need for structured outputs suitable for analysis, reports, or AI input. What this workflow does This automated pipeline does the following: Bright Data Integration**: Queries Yelp and scrapes business listing data using Bright Data's Web Unlocker. Structured Data Formatting**: Formats the Yelp review data to a structured response in JSON format. Google Gemini Summarization**: Sends the cleaned reviews to Google Gemini to: Output Delivery**: Returns the structured response with the concise summary over the webhook endpoint. Setup Sign up at Bright Data. Navigate to Proxies & Scraping and create a new Web Unlocker zone by selecting Web Unlocker API under Scraping Solutions. In n8n, configure the Header Auth account under Credentials (Generic Auth Type: Header Authentication). The Value field should be set with the Bearer XXXXXXXXXXXXXX. The XXXXXXXXXXXXXX should be replaced by the Web Unlocker Token. In n8n, configure the Google Gemini(PaLM) Api account with the Google Gemini API key (or access through Vertex AI or proxy). Update the Yelp Business Review URL with the Bright Data zone by navigating to the Set Yelp URL with the Bright Data Zone node. Update the Webhook Notifier for the merged response node with the Webhook endpoint of your choice. How to customize this workflow to your needs This workflow is built to be flexible - whether you’re a market researcher, entrepreneur, or data analyst. Here's how you can adapt it to fit your specific use case: Target Specific Business Categories** Update the Yelp Business Review input to scrape different businesses like gyms, salons etc. Limit Reviews** Add filters by description, location, page range to get the top reviews. Tweak the Data Extraction Node** Update the Structured Data Extractor node Output Parser for building the JSON response with the appropriate fields or attributes. Tweak the Summarization Prompt** Modify the Gemini prompt to generate a comprehensive summary. Send Output to Other Destinations** Replace the Webhook URL to forward output to: Google Sheets Airtable Slack or Discord Custom API endpoints

This workflow automatically syncs your Zendesk tickets to your HubSpot contacts. Every 5 minutes, your Zendesk account collects all the new or updated tickets and syncs them accordingly, with your HubSpot contacts database. Prerequisites Zendesk account and Zendesk credentials HubSpot account and HubSpot credentials How it works Cron node triggers the workflow every 5 minutes. Function Item node checks all the tickets received after the last execution timestamp. Zendesk node collects all tickets updated after last execution. Zendesk node collects the user data of ticket requester. Set node collects the contact`s email, name and externalID. Merge by key node combines two inputs, ticket data and ticket requester data. If node splits the workflow conditionally, based on data received. If the data corresponds to a ticket that already exists, HubSpot node will update the ticket. If the data does not correspond to a ticket, HubSpot node creates/updates the contact. Zendesk node updates the external Id in Zendesk for the said contact. HubSpot node creates a new ticket. Zendesk node updates the ticket with the external Id. The Function Item node sets the new last execution timestamp.

Auto-Publish Social Videos to 9 Platforms via Google Sheets and Blotato Who is this workflow for? This workflow is ideal for marketers, content creators, virtual assistants, and automation specialists managing multi-platform video content. It’s especially useful for teams who want to centralize publishing via a spreadsheet and automate social distribution in one shot. What problem does this workflow solve? Manually posting videos to multiple social platforms is tedious and time-consuming. This workflow allows you to streamline video distribution using Blotato’s API — no more switching between platforms or re-uploading the same video multiple times. What this workflow does This automation reads video metadata (URL, caption, title) from a Google Sheet, uploads the video to Blotato, and automatically publishes it to Instagram, YouTube, TikTok, Facebook, LinkedIn, Threads, Twitter (X), Pinterest, and Bluesky. It also updates the sheet to reflect the publishing status (STATUS = DONE), ensuring that your data remains clean and trackable. Setup Set up your Google Sheet with the required columns: PROMPT, DESCRIPTION, URL VIDEO, Titre, row_number, and STATUS. Add your Blotato API key in the headers of the Upload Video and Post to X nodes. Replace the platform-specific IDs in the Assign Social Media IDs node (Instagram ID, Facebook Page ID, etc.). Set the schedule in the Schedule Trigger node to define when the publishing happens. > ⚠️ Disclaimer: This workflow uses Community Nodes. These are only available on self-hosted n8n instances. How to customize this workflow Add logic to skip rows already marked as DONE. Expand to more platforms supported by Blotato. Use a webhook or Telegram trigger instead of the scheduler for more interactivity. Modify content per platform if needed (caption formatting, hashtags, etc.). 📄 Documentation: Notion Guide Demo Video 🎥 Watch the full tutorial here: YouTube Demo

This n8n template demonstrates how easy it is to build an Outlook Calendar Assistant powered by an AI agent equipped with Tools. For teams using Outlook Calendar and Slack who need easier calendar management, this workflow can be a great first step to introducing powerful AI tools into your daily activities. How it works A Slack Trigger node is configured to catch "bot mentions" events in a designated channel. The message is parsed using the Edit fields node to extract only the required attributes of the event. An AI Agent equipped with Outlook Calendar Tools enables question and answer capability for the organisation's shared calendars and events. The AI agent's response is sent back to Slack as a reply to the user's query. How to use The workflow is triggered via @mention-ing the bot followed by the query. eg. "@bot how many meetings does Paul have to attend to this week?" To start listening to real mentions, you must activate the workflow and set it to production mode. You must use the production webhook URL for the event subscription. Some sample queries to try "What's included in the product team's sprint demo this week?" "Who's booked room 7 for this Thursday?" "When is Jim & Nik's sales meeting with Microsoft?" Requirements Slack for Chat and Trigger. To get connected to Slack, see the official n8n docs for Slack Credentials. Outlook for Agent Tools To get connected to Outlook, see the official n8n docs for Outlook Credentials. Customising this workflow Not using Slack? This template can be modified to work with Teams but requires a little more configuration. Agents can have any number of tools but an overloaded agent is prone to confusion! If this happens, try splitting into multiple agents serving separate needs.

This workflow gets leads' contacts from a CSV file and adds it to the Pipedrive CRM by creating an organization and a person. The CSV file in this workflow serves as a universal connector allowing you to export contacts from any platform like LinkedIn, Facebook, etc. Prerequisites Google account and Google credentials Pipedrive account and Pipedrive credentials How it works The Google Drive Trigger node starts the workflow when a new CSV file is uploaded to a specific folder in Google Drive. Google Drive node downloads the CSV file. Spreadsheet File node reads data from the CSV file and sends the output to the Merge node. This Spreadsheet File's output becomes the input 1 for the Merge node. Meanwhile, the Pipedrive node gets the same list of contacts from the CSV file. IF node checks if Pipedrive has these contacts already created previously and sends the checked results to the Merge node. These results arrive at the Merge node as input 2. Merge node compares two inputs via email and removes the matches. Pipedrive node creates new contacts based on the data provided by the Merge node with necessary details such as organization and notes.

This workflow creates a customizable form with a dynamic dropdown field that automatically updates its options from an external data source. How it works The workflow polls an external data source (Google Sheets in this example) at regular intervals New values are processed and formatted for the dropdown The form automatically updates with the new dropdown options Set up steps Configure your data source: Default setup uses Google Sheets replace with credentials for your sheet set up the update frequency Or modify to use any other data source (API, database, etc.) Adjust the form configuration: Customize the form title and description Add or modify form fields as needed The template includes the dropdown field by default Connect form submissions: Use the "Execute Workflow" node to process form submissions This template provides a foundation for creating dynamic forms that stay synchronized with your data sources, making it ideal for situations where dropdown options need to reflect current data.

🚀 Automated Founder Discovery: CrunchBase to Gmail Outreach Workflow! Workflow Overview This cutting-edge n8n automation is a sophisticated founder intelligence and outreach tool designed to transform startup research into actionable networking opportunities. By intelligently connecting CrunchBase, OpenAI, and Gmail, this workflow: Discovers Startup Founders: Automatically retrieves founder profiles Tracks latest company updates Eliminates manual research efforts Intelligent Profile Processing: Extracts key professional information Filters most relevant details Prepares comprehensive founder insights AI-Powered Summarization: Generates professional email-ready summaries Crafts personalized outreach content Ensures high-quality communication Seamless Email Distribution: Sends automated founder digests Integrates with Gmail Enables rapid professional networking Key Benefits 🤖 Full Automation: Zero-touch founder research 💡 Smart Profiling: Intelligent founder insights 📊 Comprehensive Intelligence: Detailed professional summaries 🌐 Multi-Platform Synchronization: Seamless data flow Workflow Architecture 🔹 Stage 1: Founder Discovery Manual Trigger**: Workflow initiation CrunchBase API Integration**: Profile retrieval Intelligent Filtering**: Identifies key startup founders Prepares for detailed analysis 🔹 Stage 2: Profile Extraction Detailed Information Capture** Key Field Mapping** Structured Data Preparation** 🔹 Stage 3: AI Summarization OpenAI GPT Processing** Professional Summary Generation** Contextual Insight Creation** 🔹 Stage 4: Email Distribution Gmail Integration** Automated Outreach** Personalized Communication** Potential Use Cases Venture Capitalists**: Startup scouting Sales Teams**: Lead generation Recruitment Specialists**: Talent discovery Networking Professionals**: Strategic connections Startup Ecosystem Researchers**: Market intelligence Setup Requirements CrunchBase API API credentials Configured access permissions Founder tracking setup OpenAI API GPT model access Summarization configuration API key management Gmail Account Connected email Outreach email configuration Appropriate sending permissions n8n Installation Cloud or self-hosted instance Workflow configuration API credential management Future Enhancement Suggestions 🤖 Advanced founder scoring 📊 Multi-source intelligence gathering 🔔 Customizable alert mechanisms 🌐 Expanded networking platform integration 🧠 Machine learning insights generation Technical Considerations Implement robust error handling Use secure API authentication Maintain flexible data processing Ensure compliance with API usage guidelines Ethical Guidelines Respect professional privacy Maintain transparent outreach practices Ensure appropriate communication Provide opt-out mechanisms Hashtag Performance Boost 🚀 #StartupNetworking #FounderDiscovery #AIOutreach #ProfessionalNetworking #TechInnovation #BusinessIntelligence #AutomatedResearch #StartupScouting #ProfessionalGrowth #NetworkingTech Workflow Visualization [Manual Trigger] ⬇️ [Updated Profiles List] ⬇️ [Founder Profiles] ⬇️ [Extract Key Fields] ⬇️ [AI Summarization] ⬇️ [Send Email] Connect With Me Ready to revolutionize your professional networking? 📧 Email: Yaron@nofluff.online 🎥 YouTube: @YaronBeen 💼 LinkedIn: Yaron Been Transform your founder research with intelligent, automated workflows!

Workflow Overview This sophisticated n8n automation is a powerful LinkedIn engagement and networking tool designed to revolutionize professional social media interaction. By intelligently combining web scraping, AI, and automation technologies, this workflow: Discovers Relevant Content: Automatically scrapes LinkedIn posts Identifies target profiles and recent content Ensures consistent networking opportunities Generates Intelligent Interactions: Uses AI to craft contextual, professional comments Ensures human-like, valuable engagement Maintains professional tone and relevance Automates Engagement Process: Likes and comments on selected posts Increases visibility and connection potential Builds professional network systematically Comprehensive Activity Tracking: Logs all interactions in Google Sheets Provides transparent engagement history Enables performance analysis and optimization Key Benefits 🤖 Full Automation: Consistent daily networking 💡 AI-Powered Interactions: Intelligent, context-aware engagement 📊 Detailed Tracking: Comprehensive interaction logging 🌐 Professional Visibility: Strategic online presence management Workflow Architecture 🔹 Stage 1: Content Discovery Scheduled Trigger**: Daily post scanning Phantombuster Integration**: LinkedIn post scraping Targeted Profile Research**: Identifies recent posts Extracts critical post metadata 🔹 Stage 2: AI-Powered Interaction OpenAI GPT Model**: Generates contextual comments Intelligent Analysis**: Understands post content Crafts personalized responses Professional Tone Maintenance** 🔹 Stage 3: Engagement Automation Automated Liking**: Increases post visibility Intelligent Commenting**: Posts AI-generated comments Ensures meaningful interaction 🔹 Stage 4: Performance Logging Google Sheets Integration** Comprehensive Activity Tracking** Interaction History Preservation** Potential Use Cases Sales Professionals**: Lead generation and networking Marketers**: Increased brand visibility Recruiters**: Talent discovery and engagement Entrepreneurs**: Professional network expansion Content Creators**: Audience interaction and growth Setup Requirements Phantombuster Account API key Configured LinkedIn scraping agents Profile URL list OpenAI API GPT model access API key for comment generation Preferred language model Google Sheets Connected Google account Prepared tracking spreadsheet Appropriate sharing settings n8n Installation Cloud or self-hosted instance Workflow configuration API credential management Future Enhancement Suggestions 🤖 Advanced sentiment analysis 📊 Engagement performance metrics 🎯 Intelligent post targeting 🔍 Machine learning optimization 🌐 Multi-platform support Technical Considerations Implement robust error handling Use exponential backoff for API calls Maintain flexible engagement strategies Ensure compliance with platform guidelines Ethical Guidelines Respect professional networking etiquette Maintain genuine, value-adding interactions Avoid spammy or repetitive engagement Prioritize quality over quantity Connect With Me Ready to revolutionize your professional networking? 📧 Email: Yaron@nofluff.online 🎥 YouTube: @YaronBeen 💼 LinkedIn: Yaron Been Transform your LinkedIn strategy with intelligent, automated workflows! #LinkedInAutomation #AINetworking #ProfessionalGrowth #CareerStrategy #NetworkingTech #AIMarketing #ProfessionalDevelopment #SocialMediaStrategy #ContentEngagement #BusinessIntelligence

Scrape Competitor Reviews & Generate Ad Creatives with Bright data and OpenAI How the Flow Runs Fill the Form Enter the Amazon product URL to analyze competitor reviews. Trigger Bright Data Scraper Bright Data scrapes Amazon reviews based on the provided URL. Wait for Snapshot Completion Periodically checks Bright Data until the scraping is complete. Retrieve JSON Data Collects the scraped review data in JSON format. Save Reviews to Google Sheets Automatically appends the scraped reviews to your Google Sheets. Aggregate Reviews Consolidates all reviews into a single summary for simpler analysis. Analyze Reviews with OpenAI LLM Sends the aggregated reviews to OpenAI (GPT-4o mini) to summarize competitors’ main weaknesses clearly. Generate Creative Ad Image OpenAI generates a visually appealing 1080x1080 ad image addressing these identified pain points. Send Ad Creative via Gmail Automatically emails the creative and review summary to your media buying team for immediate use in Meta ads. What You Need Google Sheets:** Template Bright Data:** Dataset and API key: www.brightdata.com OpenAI API Key:** For GPT-4o mini or your preferred LLM Automation Tool:** Ensure it supports HTTP Requests, Wait, Conditional (If), Google Sheets integration, Form Trigger, OpenAI integration, and Gmail integration. Form Fields to Fill Amazon Product URL:** Enter the competitor’s product URL from Amazon. Setup Steps Copy the provided Google Sheet template. Import the JSON workflow into your automation tool. Update credentials for Bright Data, Google Sheets, Gmail, and OpenAI. Test manually by submitting the form and verifying functionality. Optional: Set a schedule for regular workflow execution. Bright Data Trigger Example [ { "url": "https://www.amazon.com/example-product" } ] Tips Frequently update URLs to ensure fresh insights. Allow more wait time for extensive data scrapes. Focus on targeted products to optimize cost-efficiency. Need Help? Email: Yaron@nofluff.online Resources: YouTube: https://www.youtube.com/@YaronBeen/videos LinkedIn: https://www.linkedin.com/in/yaronbeen/ Bright Data Documentation: https://docs.brightdata.com/introduction

Automated outreach system that identifies and contacts potential leads from CrunchBase with personalized, timely messages. 🚀 What It Does Identifies target companies and contacts Personalizes email content Schedules follow-ups Tracks responses Integrates with email providers 🎯 Perfect For Sales development reps Business development teams Startup founders Investment professionals Partnership managers ⚙️ Key Benefits ✅ Automated lead generation ✅ Personalized outreach at scale ✅ Follow-up automation ✅ Response tracking ✅ Time-saving workflow 🔧 What You Need CrunchBase API access Email service (e.g., Gmail, SendGrid) n8n instance CRM (optional) 📊 Features Contact information extraction Email template personalization Send time optimization Open/click tracking Response handling 🛠️ Setup & Support Quick Setup Start sending in 30 minutes with our step-by-step guide 📺 Watch Tutorial 💼 Get Expert Support 📧 Direct Help Transform your outbound sales process with automated, personalized outreach to high-quality leads from CrunchBase.

🚀 AI-Powered YouTube Video Summary Distributor: From Channel to Community! Workflow Overview This sophisticated n8n automation transforms YouTube content discovery into a seamless, multi-platform intelligence sharing process. By intelligently connecting YouTube RSS, AI summarization, and content distribution platforms, the workflow: Discovers New Content: Monitors YouTube channels via RSS feed Captures latest video uploads Tracks content in real-time AI-Powered Summarization: Extracts video metadata Generates concise, meaningful summaries Leverages GPT-4o for intelligent content analysis Intelligent Distribution: Logs summaries in Google Sheets Sends summaries to Slack for review Publishes approved content to Reddit Detailed Setup Instructions 1. YouTube Data API Configuration Prerequisites Google Cloud Console account Enabled YouTube Data API v3 Setup Steps: Go to Google Cloud Console Create a new project Enable YouTube Data API v3 Create credentials (API Key) Store API key securely in n8n credentials Obtain channel RSS feed URL 2. OpenAI API Setup Prerequisites OpenAI account Active API subscription Configuration: Visit OpenAI Platform Generate API key Select GPT-4o model Configure API key in n8n credentials Set up billing and usage limits 3. Slack Integration Prerequisites Slack workspace Slack app permissions Setup Process: Create a Slack app in your workspace Configure OAuth scopes for sending messages Install app to workspace Obtain webhook or OAuth token Configure in n8n Slack node 4. Reddit API Configuration Prerequisites Reddit account Reddit application created Steps: Go to Reddit's app preferences Create a new application Obtain client ID and secret Configure OAuth2 credentials in n8n Select target subreddit Workflow Customization Channel Modification Replace YouTube RSS feed URL in trigger node Adjust channel_id parameter Modify extraction logic if needed Subreddit Customization Change subreddit parameter in Reddit node Adjust title and text formatting AI Summarization Tuning Modify system message in Summarizer Agent Adjust prompt for different content types Implement custom filtering Key Customization Points Modify RSS feed URL Change target subreddit Adjust AI summarization prompt Add custom filtering logic Implement multi-channel support Technical Requirements n8n v0.220.0 or higher YouTube Data API v3 OpenAI API access Slack workspace Reddit application Stable internet connection Potential Use Cases Content creator content tracking Research and trend analysis Social media content distribution Automated content curation Community engagement Security Considerations Use environment variables for API keys Implement proper OAuth2 authentication Respect platform usage guidelines Maintain user privacy Future Enhancement Roadmap Multi-language support Advanced content filtering Sentiment analysis integration Expanded platform distribution Customizable summarization parameters Workflow Visualization [YouTube RSS Trigger] ⬇️ [Extract Channel ID] ⬇️ [Fetch Video Details] ⬇️ [AI Summarization] ⬇️ [Google Sheets Logging] ⬇️ [Slack Approval] ⬇️ [Reddit Publishing] Hashtag Performance Boost 🚀 #YouTubeAutomation #AIContentDistribution #WorkflowInnovation #ContentCuration #AIMarketing #DigitalMediaTech #AutomatedSummaries #CrossPlatformContent Connect With Me Ready to revolutionize your content workflow? 📧 Email: Yaron@nofluff.online 🎥 YouTube: @YaronBeen 💼 LinkedIn: Yaron Been Transform your content strategy with intelligent, automated workflows! Note: Always test and customize the workflow to fit your specific use case and comply with platform guidelines.