Workflow Templates

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automatically performs weekly keyword research and competitor analysis to discover trending keywords in your industry. It saves you time by eliminating the need to manually research keywords and provides a constantly updated database of trending search terms and opportunities. Overview This workflow automatically researches trending keywords for any specified topic or industry using AI-powered search capabilities. It runs weekly to gather fresh keyword data, analyzes search trends, and saves the results to Google Sheets for easy access and analysis. Tools Used n8n**: The automation platform that orchestrates the workflow Bright Data**: For accessing search engines and keyword data sources OpenAI**: AI agent for intelligent keyword research and analysis Google Sheets**: For storing and organizing keyword research data How to Install Import the Workflow: Download the .json file and import it into your n8n instance Configure Bright Data: Add your Bright Data credentials to the MCP Client node Set Up OpenAI: Configure your OpenAI API credentials Configure Google Sheets: Connect your Google Sheets account and set up your keyword tracking spreadsheet Customize: Define your target topics or competitors for keyword research Use Cases SEO Teams**: Discover new keyword opportunities and track trending search terms Content Marketing**: Find trending topics for content creation and strategy PPC Teams**: Identify new keywords for paid advertising campaigns Competitive Analysis**: Monitor competitor keyword strategies and market trends Connect with Me Website**: https://www.nofluff.online YouTube**: https://www.youtube.com/@YaronBeen/videos LinkedIn**: https://www.linkedin.com/in/yaronbeen/ Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission) #n8n #automation #keywordresearch #seo #brightdata #webscraping #competitoranalysis #contentmarketing #n8nworkflow #workflow #nocode #seoresearch #keywordmonitoring #searchtrends #digitalmarketing #keywordtracking #contentautomation #marketresearch #trendingkeywords #keywordanalysis #seoautomation #keyworddiscovery #searchmarketing #keyworddata #contentplanning #seotools #keywordscraping #searchinsights #markettrends #keywordstrategy

Who is it for? This workflow is perfect for marketers, sales teams, agencies, and local businesses who want to save time by automating lead generation from Google Maps. It’s ideal for real estate agencies, restaurants, service providers, and any local niche that needs a clean database of fresh contacts, including emails, websites, and phone numbers. ✅ Prerequisites Before starting, make sure you have: Apify account** → to scrape Google Maps data OpenAI API key** → for GPT-4 email extraction Airtable account & base** → for structured lead storage Gmail account with OAuth** → to send personalized outreach emails Your Airtable base should have these columns: | Title | Street | Website | Phone Number | Email | URL | |-------------------------|-------------------------|--------------------|-----------------|------------------------|----------------------| | Paris Real Estate Agency| 10 Rue de Rivoli, Paris | https://agency.fr | +33 1 23 45 67 | contact@agency.fr | maps.google.com/... | 🏡 Example Use Case To keep things clear, we’ll use real estate agencies in Paris as an example. But you can replace this with restaurants, plumbers, lawyers, or even hamster trainers (you never know). 🔄 How the workflow works Scrape Google Maps leads with Apify Clean & structure the data (name, phone, website) Visit each website & extract emails with GPT-4 Save all leads into Airtable Automatically send a personalized email via Gmail This works for any industry, keyword, or location. Step 1 – Scraping Google Maps with Apify Start simply: Open your n8n workflow and choose the trigger: “Execute Workflow” (manual trigger). Add an HTTP Request node (POST method). Now, head over to Apify Google Maps Extractor. Fill in the fields according to your needs: Keyword: e.g., "real estate agency" (or restaurant, plumber...) Location: "Paris, France" Number of results: 50 (or more) Optional: filters (with/without a website, by categories…) Click Run to test the scraper. Then click API → select API endpoints tab. Choose “Run Actor synchronously and get dataset items”. Copy the URL, go back to n8n, and paste it into your HTTP Request node (URL field). Then enable: Body Content Type → JSON Specify Body Using JSON Go back to Apify, click the JSON tab, copy everything, and paste it into the JSON field of your HTTP Request. If you now run your workflow, you'll get a nice structured table filled with Google Maps data. Pretty magical already—but we're just getting started! Step 2 – Cleaning Things Up (Edit Fields) Raw data is cool, but messy. Add an Edit Fields node next, using Manual Mapping mode. Here’s what you keep (copy-paste friendly): Title → {{ $json.title }} Address → {{ $json.address }} Website → {{ $json.website }} Phone → {{ $json.phone }} URL → {{ $json.url }} Now, you have a clean, readable table ready to use. Step 3 – Handling Each Contact Individually (Loop Over Items) Next, we process each contact one by one. Add the Loop Over Items node: Set Batch Size to 20 or more, depending on your needs. This node is simple but crucial to avoid traffic jams in the automation. Step 4 – Isolating Websites (Edit Fields again) Add another Edit Fields node (Manual Mapping). This time, keep just: Website → {{ $json.website }} We've isolated the websites for the next step: scraping them one by one. Step 5 – Scraping Each Website (HTTP Request) Now, we send our little robot to visit each website automatically. Add another HTTP Request node: Method: GET URL: {{ $json.website }} (from the previous node) This returns the raw HTML content of each site. Yes, it's ugly, but we won't handle it manually. We'll leave the next step to AI! Step 6 – Extracting Emails with ChatGPT We now use OpenAI (Message a Model) to politely ask GPT to extract only relevant emails. Configure as follows: Model: GPT-4-1-mini or higher Operation: Message a Model Simplify Output: ON Prompt to copy-paste: Look at this website content and extract only the email I can contact this business. In your output, provide only the email and nothing else. Ideally, this email should be of the business owner, so if you have 2 or more options, try for the most authoritative one. If you don't find any email, output 'Null'. Exemplary output of yours: name@examplewebsite.com {{ $json.data }} ChatGPT will kindly return the perfect email address (or 'Null' if none is found). Step 7 – Neatly Store Everything in Airtable Almost done! Add an Airtable → Create Record node. Fill your Airtable fields like this: | Airtable Field | Content | n8n Variable | | ------------------ | ------------------------------- | ------------------------------------------ | | Title | Business name | {{ $('Edit Fields').item.json.Title }} | | Street | Full address | {{ $('Edit Fields').item.json.Address }} | | Website | Website URL | {{ $('Edit Fields').item.json.Website }} | | Phone Number | Phone number | {{ $('Edit Fields').item.json.Phone }} | | Email | Email retrieved by the AI agent | {{ $json.message.content }} | | URL | Google Maps link | {{ $('Edit Fields').item.json.URL }} | Now, you have a tidy Airtable database filled with fresh leads, ready for action. Step 8 – Automated Email via Gmail (The Final Touch) To finalize the workflow, add a Gmail → Send Email node after your Airtable node. Here’s how to configure this node using the data pulled directly from your Airtable base (from the previous step): Recipient (To): Retrieve the email stored in Airtable ({{ $json.fields.Email }}). Subject: Use the company name stored in Airtable ({{ $json.fields.Title }}) to personalize the subject line. Body: You can include several fields directly from Airtable, such as: Company name: {{ $json.fields.Title }} Website URL: {{ $json.fields.Website }} Phone number: {{ $json.fields["Phone Number"] }} Link to the Google Maps listing: {{ $json.fields.URL }} All of this data is available in Airtable because it was automatically inserted in the previous step (Step 7). This ensures that each email sent is fully personalized and based on clear, reliable, and structured information.

Overview A comprehensive educational workflow that demonstrates practical JavaScript usage in n8n's Code node through real-world business scenarios. Perfect for learning data manipulation, transformation, and automation patterns that you can immediately apply to client projects. What This Template Teaches: Data Filtering & Transformation - Filter employees by age, calculate bonuses, format contact information Statistical Analysis - Generate team statistics, averages, role distributions, and KPIs Multi-Format Export - Create CSV files, email lists, and API-ready payloads from raw data n8n Best Practices - Proper JSON handling, return formats, and data flow patterns How It Works: Manual Trigger starts the workflow with sample employee data Set Sample Data provides realistic business data (employees with roles, salaries, ages) Three Code Node Examples process the same data differently: Filter & Transform: Creates adult employee list with calculated bonuses Calculate Stats: Generates comprehensive team analytics and reports Format for Export: Prepares data for external systems (APIs, emails, CSV) Key Learning Points: Access input data using items[0].json.propertyName Return proper n8n format with [{ json: data }] structure Use JSON.parse() for string-to-object conversion Apply JavaScript array methods (filter, map, reduce) for data processing Handle multiple output scenarios and data aggregation Perfect For: n8n beginners learning Code node fundamentals Developers transitioning to n8n automation Client demos showing data processing capabilities Team training and onboarding sessions Foundation for building custom business automation workflows Business Use Cases: Transform this template for lead qualification, customer segmentation, report generation, data enrichment, and API integrations. Each Code node pattern can be adapted for different industries and automation needs.

This workflow will take a timer entry from Clockify and submit it to a matching ticket in Syncro. It saves the time entry ID from Clockify and the time entry ID from Syncro into a Google Sheets. Then, it will check if a match already exists from a previous update and will update the same time entry if the description or time is changed in Clockify. There is a Set node with the name and Syncro IDs of technicians. If you have multiple technicians with the same name, this won't work for you. Likewise, if the name in Clockify doesn't exactly match what you put in the Set, it won't work. You also need to setup a webhook in Clockify set to trigger on "Time entry updated (anyone)" and pointed at your workflow. Configured this way, you can start and stop time entries at will and it won't do anything until you change the description. > This workflow is part of an MSP collection, The original can be found here: https://github.com/bionemesis/n8nsyncro

Workflow Overview: This n8n workflow template takes a US phone number as input, validates it, and returns it in multiple standard formats, including handling extensions. It's designed to streamline the process of standardizing phone number data within your automations. How it Works: Input: Accepts a phone number string as input. This number can be in various common formats (e.g., (555) 123-4567, 555.123.4567, +15551234567, 5551234567x890). Formatting Removal: Strips all non-numeric characters to isolate the core number and any potential extension. Validation: Country Code Check:** Verifies if the number starts with the US country code (+1 or 1) or assumes US if no country code is present and the length is correct. Length Check:** Ensures the main number component consists of exactly 10 digits after stripping formatting and the country code. Output Generation (if valid): If the number passes validation, the workflow outputs the phone number in several standardized formats: Number Only:** 5551234567 E.164 Standard:** +15551234567 National Standard:** (555) 123-4567 Full National Standard:** 1 (555) 123-4567 International Standard:** 00-1-555-123-4567 Extension Handling: If an extension is detected in the input, it is separated and provided as: Extension (Number):** 890 Extension (String):** "890" Use Cases: Cleaning and standardizing phone number data in CRM systems. Formatting numbers before sending SMS messages via APIs. Validating user input from forms. Ensuring consistent phone number representation across different applications.

Description This workflow automates a video content pipeline that generates creative, Instagram Reel videos using AI. It combines OpenAI's GPT-4o-mini for idea generation with Sisif.ai's text-to-video AI technology to produce engaging short-form content automatically. Perfect for: Content creators, social media managers, marketing teams, and anyone who wants to maintain a consistent flow of AI-generated video content without manual intervention. Prerequisites Sisif.ai Account**: Sign up at sisif.ai and get your API token from https://sisif.ai/users/api-keys/ OpenAI Account**: Get your API key from OpenAI platform n8n Instance**: Self-hosted or cloud instance Step-by-step setup Import the workflow in n8n. Create OpenAI API credentials here. Create Sisif.ai API credentials here. Add OpenAI API & Sisif.ai API creds in n8n. Open the blue sticky → edit topic, style, duration, resolution. Enable the Cron trigger (defaults to every 6 h). Run once to test. Activate when ready. How it Works The workflow operates on a scheduled cycle, generating fresh video content every 6 hours: 🤖 AI Idea Generation: OpenAI's GPT-4o-mini acts as a creative video strategist, generating unique, trend-aware video concepts optimized for Instagram and social media 🎬 Video Creation: Sisif.ai transforms each creative prompt into a high-quality 5-second video in 360x640 resolution ⏱️ Smart Monitoring: The workflow intelligently monitors video generation progress, waiting for completion before proceeding 📊 Data Processing: Final video data is structured and prepared for further use or storage Key Features ⚡ Fully Automated Runs every 6 hours without manual intervention Generates 4 unique videos daily (28 videos per week) Self-monitoring with automatic retry logic 🎯 Optimized for Social Media Instagram 360x640 resolution 5-second duration for maximum engagement Trend-aware content generation Action-packed, visual storytelling 🔧 Smart Architecture Simple HTTP requests for reliable operation Bearer token authentication for secure API access Automatic status checking and waiting logic Error handling and retry mechanisms

Who this template is for This template is for everyone who needs to work with XML data a lot and wants to convert it to JSON instead. Use case Many products still work with XML files as their main language. Unfortunately, not every software still supports XML, as many switched to more modern storing languages such as JSON. This workflow is designed to handle the conversion of XML data to JSON format via a webhook call, with error handling and Slack notifications integrated into the process. How this workflow works Triggering the workflow: This workflow initiates upon receiving an HTTP POST request at the webhook endpoint specified in the "POST" node. The endpoint, designated as , can be accessed externally by sending a POST request to that URL. Data routing and processing: Upon receiving the POST request, the Switch node routes the workflow's path based on conditions determined by the content type of the incoming data or any encountered errors. The Extract From File and Edit Fields (Set) nodes manage XML input processing, adapting their actions according to the data's content type. XML to JSON conversion: The XML data extracted from the input is passed through the "XML" node, which performs the conversion process, transforming it into JSON format. Response handling: If the XML-to-JSON conversion is successful, a success response is sent back with a status of "OK" and the converted JSON data. If there are any errors during the XML-to-JSON conversion process, an error response is sent back with a status of "error" and an error message. Error handling: in case of an error during processing, the workflow sends a notification to a Slack channel designated for error reporting. Set up steps Set up your own in the Webhook node. While building or testing a workflow, use a test webhook URL. When your workflow is ready, switch to using the production webhook URL. Set credentials for Slack.

This is the workflow powering the n8n demo shown at StrapiConf 2022. The workflow searches matching Tweets every 30 minutes using the Interval node and listens to Form submissions using the Webhook node. Sentiment analysis is handled by Google using the Google Cloud Natural Language node before the result is stored in Strapi using the Strapi node. (These were originally two separate workflows that have been combined into one to simplify sharing.)

🧲 AI-Powered Lead Magnet Idea Generation from Topic List This n8n workflow automatically generates lead magnet ideas based on topics and website URLs stored in a Google Sheet. It uses the Lead Magnet Idea Generator AI API to produce relevant, value-driven ideas that marketers can turn into checklists, guides, templates, and more. 🔧 What This Workflow Does Monitors a Google Sheet for new or updated rows using a Drive trigger. Reads all rows and identifies entries where: The Topic column is not empty The Content (idea) column is empty Sends a request to the Lead Magnet Idea Generator AI API: Input: Topic + Website URL Output: AI-generated lead magnet idea Writes the idea back to the same Google Sheet with a timestamp. Repeats the process automatically every minute. 🌐 API Used Name:** Lead Magnet Idea Generator AI API Endpoint:** https://lead-magnet-idea-generator-ai.p.rapidapi.com/index.php Method:** POST Headers:** x-rapidapi-host: lead-magnet-idea-generator-ai.p.rapidapi.com x-rapidapi-key: YOUR_RAPIDAPI_KEY Body Params:** topic website ✅ Benefits | Feature | Value | |----------------------------------|------------------------------------------------------------------| | 🔄 Automated Flow | No manual entry needed — runs every minute | | 🧠 AI-Based Content Ideation | Smart suggestions tailored to your topic and brand | | 📝 Google Sheets Integration | Easy to manage, edit, and view input/output in one place | | 🕒 Timestamp Tracking | Know exactly when each idea was generated | | 🚫 No Duplicate Processing | Only rows missing ideas are sent to the API | | 💼 Scalable for Teams | Plug-and-play for any team managing multiple content ideas | ❌ Challenges This Solves | Old Challenge | New Workflow Solution | |--------------------------------------------|------------------------------------------------------------------| | Manual brainstorming of lead magnet ideas | Fully automated idea generation via API | | Missing or inconsistent content in sheets | Only incomplete rows are updated with valid ideas | | Lack of traceability | Timestamp logs show when each idea was generated | | Wasting time on repetitive tasks | Workflow handles idea generation while you focus on execution | 📌 Requirements ✅ A valid RapidAPI key ✅ Google Sheets & Google Drive credentials set up in n8n ✅ Google Sheet structured with the following columns: | Column Name | Purpose | Required | |------------------|----------------------------------------------------------|----------| | Topic | Main subject for which the idea is generated | ✅ Yes | | Website Url | Optional URL to provide brand context for the API | ❌ No | | Content | Will be filled with the AI-generated lead magnet idea | ✅ Yes | | Generated Date | Timestamp when the idea was created | ✅ Yes | 🧩 Technologies Used n8n** – Automation platform Google Sheets** – For storing topics and generated ideas Google Drive Trigger** – To initiate the workflow Lead Magnet Idea Generator AI API** – For content generation HTTP Request node** – To communicate with the API If / Wait / Split In Batches nodes** – For conditional logic and throttling 🧠 Example Use Cases Content marketing teams planning lead magnets for blog posts Agencies creating assets for multiple clients Email list-building strategists generating downloadable content ideas Business owners who want quick suggestions without manual brainstorming Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!

Drowning in security alerts? Spending hours translating technical logs from Wazuh, your SIEM, or other tools into business-friendly reports for leadership? This n8n workflow is your automated Security Analyst, designed to save you time and bridge the communication gap between technical teams and non-technical executives. Using a powerful two-stage AI process via the NixGuard Security RAG connector, this workflow transforms raw security event data into a concise, actionable daily briefing. How It Works: Stage 1: Intelligent Filtering & Data Structuring: On a daily schedule, the workflow first calls the AI to sift through all recent security events. It intelligently identifies significant alerts and structures them into a clean, machine-readable JSON array, cutting through the noise. Stage 2: Executive Summarization: If critical alerts are found, the workflow feeds this structured JSON into a second AI prompt. It tasks the AI to act as a Senior Security Analyst, generating a high-level summary that focuses on business impact, key threat patterns, and a clear, single recommendation—all in plain English. Automated Delivery: The final Markdown report is automatically converted to HTML and emailed as a professional daily security briefing to your stakeholders. Key Features & Benefits: Slash Reporting Time:** Automate the manual, time-consuming process of daily security analysis and reporting. Bridge the Technical Gap:** Deliver clear, non-technical summaries that executives can understand and act upon instantly. Reduce Alert Fatigue:** Let AI filter out the low-level noise and only escalate what truly matters. Two-Stage AI Processing:** Leverage a sophisticated AI chain for more accurate and relevant results than a single prompt. Highly Customizable:** Easily adapt the prompts, schedule, and data sources (any system compatible with the NixGuard RAG connector) to fit your exact needs. Who is this for? Security Analysts, Engineers, and Managers** who need to automate daily reporting. SecOps and DevOps Teams** looking to integrate security intelligence into their automated workflows. IT Directors and VPs** who need to provide consistent security posture updates to leadership. Anyone responsible for communicating cybersecurity risk to non-technical stakeholders. Stop copying and pasting logs. Download this workflow to automate your security reporting and deliver real business value today! Don't have the main workflow yet? Get it HERE! 🔗 Learn more about NixGuard: thenex.world 🔗 Get started with a free security subscription: thenex.world/security/subscribe Tags / Keywords: AI, Security, Automation, Cybersecurity, Wazuh, SIEM, Reporting, Executive Summary, Daily Briefing, Alert Fatigue, SecOps, Generative AI, LLM, NixGuard, Email, JSON

This workflow is your ultimate solution for reliable image retrieval from any web source, including those heavily protected. It operates with a smart, cost-effective strategy: it first attempts to fetch the image using a Classic Image Getter node (a standard, free HTTP request). In approximately 80% of cases, this method will be sufficient. However, for the remaining instances where you encounter IP blocking, CAPTCHAs, rate limiting, or other advanced anti-bot measures, the workflow seamlessly switches to a robust BrightData Web Unblocker service as a fallback. It leverages BrightData’s Image Unblocker to retrieve these blocked images. This template is indispensable for anyone needing consistent and complete access to web images, ensuring you get the data you need without unnecessary overhead. Why Use This Image Scrapper Workflow? Maximum Success Rate**: Retrieves images even from the most challenging or protected websites. Cost-Optimized Strategy**: Prioritizes free, standard HTTP requests, only incurring costs when advanced unblocking is truly necessary. Automated Resilience**: Intelligently handles failed direct attempts by automatically engaging the BrightData failover via the "Unlock Image" node. Versatile Image Scraping**: Perfect for market research, content aggregation, or data enrichment that demands reliable image access. How It Works When clicking ‘Execute workflow’: The workflow is initiated manually, allowing for easy testing and integration into larger processes. image: A Set node defines the target image URL. This can be easily configured to accept dynamic URLs from preceding nodes. Classic Image Getter: This HTTP Request node performs a direct image download. It's the primary, free, and efficient method for readily accessible images. Unlock Image (BrightData Web Unblocker): Configured as an error handler and failover, this HTTP Request node activates only if the "Classic Image Getter" encounters an error. It then routes the image URL through BrightData's Web Unblocker, designed to bypass advanced protective measures and successfully retrieve the image data. 🔑 Prerequisites To enable the advanced capabilities of this workflow, specifically the BrightData Web Unblocker functionality, you will need a BrightData account and a correctly configured Web Unblocker zone. Setting Up Your BrightData Web Unblocker: BrightData Account: Ensure you have an active account with BrightData. If you don't, you can sign up on their website. Create a Web Unblocker Zone: Log in to your BrightData dashboard. Navigate to the "Proxy & Scraping Infrastructure" section, then "Zones." Click "Add new zone." Select "Web Unblocker" as the product type. Give your zone a clear name (e.g., n8n-image-unlocker). Confirm the creation of the zone. Retrieve API Key: Once your Web Unblocker zone is active, go to its settings. Locate your API Key (often referred to as "password" for proxy access) within the "Access Parameters" or "Credentials" section. Configure in n8n: In the Unlock Image HTTP Request node within this workflow, update the Authorization header. Replace "Bearer yourkey" with "Bearer YOUR_BRIGHTDATA_API_KEY". Important: For production workflows, it's highly recommended to use n8n credentials to store your BrightData API key securely, rather than hardcoding it directly in the node. This template uses a placeholder for demonstration purposes. Crucially, ensure that the zone parameter in the Unlock Image node matches the exact Zone ID you created in your BrightData account. You will need to replace the placeholder web_unlocker with your actual BrightData zone ID. Phil | Inforeole

Setlist Manager This workflow takes a Google spreadsheet called 'Setlist_Manager' with 'Artist' and 'SongTitle' entries and get's Lyrics for each song and creates a playlist for that set of songs. Create Spotify Playlist (naming it 'Setlist - [date of today]') Create the Google doc that will store the lyrics found. (naming it 'Setlist - [date of today]') Get the rows of songs from 'Setlist_Manager'. Use AI to verify the Artist name and song title. Get the lyrics to the song. Append the Google Doc with the lyrics. Search for the song in Spotify. Add that song to the Spotify Playlist. Go to band practice and be prepared! =)