Data & Analytics Workflows
Data processing and analytics
Real-Time Email Validation with APILayer in n8n
This n8n workflow validates email addresses in real-time using the APILayer Email Verification API, enhancing data quality and reducing bounce rates for lead generation, user registration, and newsletter sign-ups.
n8n$4.99Automate Notifications for New Google Sheets Entries Every 45 Minutes
This workflow checks Google Sheets for new data every 45 minutes and sends a notification to Mattermost if new entries are found.
n8n$4.99Bright Data-Powered Competitive Price Lookup and Report Generator
This n8n workflow automates the collection, enrichment, and analysis of e-commerce product listings using Bright Data and AI, then delivers an HTML email report with the most competitive offers. **What It Does** - Pulls product titles from a Google Sheet. - For each product, searches a Bright Data marketplace dataset (Google Shopping) for available listings. - Extracts relevant fields: price, title, seller name, and listing URL. - Sends this data to Google Gemini for AI-powered Markdown report generation. - Converts Markdown to HTML and styles the output for better email rendering. - Sends an email report for each product with the top 20 most affordable offers. **Step-by-Step Setup** - Load product list from Google Sheets. - For each product title, run a Bright Data filter request (case-sensitive match). - Poll the snapshot status until it is ready. - Retrieve snapshot content and clean the results with a Code node. - Pass the results to Gemini (PaLM/Gemini Flash) for analysis and report generation in Markdown. - Convert Markdown into styled HTML using Markdown + Code nodes. - Send formatted email to a predefined recipient. - Return to the loop and repeat for the next product. **How It Works** - Loop Control: SplitInBatches handles product-by-product processing. - Snapshot Handling: Snapshot status is polled every 30s until success/failure. - AI Formatting: Gemini summarizes listings and formats content. - Error Handling: Failed snapshots produce a warning message and resume the loop. **Final Output** - Each email contains: - The product name - A clean HTML of up to 20 sellers with lowest prices - Links to listings - AI-generated pricing summary **Credentials Used** - Bright Data account - Google Gemini (PaLM/Gemini Flash) - Google Sheets (OAuth2) - SMTP Email (emailSend node) **Important Notes** - Item title search is case-sensitive. Typos or casing mismatches may result in no results. - Requires **n8n-nodes-brightdata community node** to be installed.
n8n$14.99Automate YouTube Video Comment Analysis for Insightful Reports
This n8n workflow automates the analysis of YouTube video comments and details to generate comprehensive reports. It provides insights into video performance, audience engagement, and viewer feedback, helping creators identify trends and opportunities for content improvement.
n8n$14.99Extract Email Addresses from Websites with EmailListVerify API and Google Sheets
## How to Scrape Emails from Websites This workflow will: - Try to find emails by scraping the website via HTTP request. - If no result is found, it will use the [EmailListVerify email finder API](https://emaillistverify.com/email-finder-api) to guess an email address. Scraping email via HTTP request is a cost-effective way to find email addresses, so it can save you a few bucks to use it before calling any email finder API. ## Who is it for This workflow will help you transform a list of websites into a list of leads with email addresses. This is a handy workflow for any lead generation specialist. Pay attention that this workflow will usually return only generic emails like contact@. Those generic emails are useful when you target small businesses; the owner usually monitors those emails. However, I don't advise this workflow to target enterprise customers. ## Requirements In order to use this workflow, you will need: - To copy [this Google sheet template](https://docs.google.com/spreadsheets/d/1VOFM8UeWHhJbtBM7SRca6vsVJlRUXzX71kjJ8n2jUY/edit?gid=1538095319#gid=1538095319). - Get an API key for [EmailListVerify](https://emaillistverify.com/). You then need to edit the setup of the 3 stages highlighted with a yellow sticky note, and you will be good to go.
n8n$14.99Automate LinkedIn Company Profile Scraping to Google Sheets
This workflow automates the process of scraping LinkedIn company profiles and storing the data in Google Sheets. It captures comprehensive company information, employee details, and related profiles.
Make$2.99Optimize Website Content with Google Analytics, Firecrawl, and InfraNodus
Extract top-performing pages from Google Analytics, scrape content with Firecrawl, and visualize insights using InfraNodus to identify content gaps and opportunities.
n8n$14.99Automate Resume Data Extraction from Gmail and Notifications via Slack
Streamline your recruitment process by automatically extracting data from resumes received in Gmail and sending notifications to Slack.
Make$4.99Automate AI Chat Logs Transfer from Postgres to Google Sheets
This n8n workflow automates the retrieval of AI agent chat logs from a Postgres database and exports them to Google Sheets, creating a new sheet for each session. Ideal for teams needing to review and analyze chat logs collaboratively.
n8n$14.99Automate Trustpilot Review Scraping to Google Sheets and CSV for HelpfulCrowd
This workflow automates the process of scraping Trustpilot reviews for a specified business and saving them into Google Sheets. It also formats the data for compatibility with HelpfulCrowd.
n8n$9.99Automate Security Reconnaissance with Google Dorks and Email Reports
This workflow automates the process of generating Google dorks for a given domain, scraping search results, and emailing a formatted report. Ideal for security professionals seeking efficient reconnaissance.
n8n$9.99Upload Google Drive Files to an InfraNodus Graph
This template can be used to **upload the files in your Google Drive** to an **[InfraNodus knowledge graph](https://infranodus.com)**. The InfraNodus graph will then reveal the **main topics** and **ideas** in your collection of documents and show the **content gaps** in them. You can also use the **built-in AI** to converse with the documents.  You can also access the InfraNodus Graphs via its **GraphRAG API** to reuse them in your other n8n workflows for high-quality content retrieval and knowledge base optimization. The template showcases the use of multiple n8n nodes and processes: - Extracting documents from a Google Drive folder - Text extraction - Optional: high-quality PDF conversion using [ConvertAPI](https://convertapi.com?ref=4l54n) - [InfraNodus knowledge graph](https://infranodus.com) generation **Note**: If you want to **Sync your Google Drive** to an InfraNodus graph, check out our other workflow. ## How it works Here's a description of this workflow step by step: - Find all the files in a specific Google Drive folder - For each file found: reiterate the workflow and - Identify the type of the file (X, PDF, Markdown) - For X and Markdown files, extract the text data - For PDF files, use a special PDF to text converter to extract the text data. (Optional: using [ConvertAPI](https://convertapi.com?ref=4l54n) for better quality PDF conversion) - Forward everything to the InfraNodus `graphAndStatements` [API endpoint](https://support.noduslabs.com/hc/en-us/articles/13605983537692-InfraNodus-API-Access-Points) with the `name` of the new graph, the `text` field with the text data, the text settings, and `doNotSave=false` to create a new graph - Reiterate through another file. ## How to use You need an [InfraNodus GraphRAG API account and key](https://infranodus.com/use-case/ai-knowledge-graphs) to use this workflow. - Create an InfraNodus account - Get the API key at [https://infranodus.com/api-access](https://infranodus.com/api-access) and create a Bearer authorization key for the InfraNodus API nodes. - Use that API key to set up authorization for the InfraNodus tool in the workflow. - If you want to upload the files to an existing graph, you should copy its name from InfraNodus. Otherwise, you can specify any name you want. ## Requirements - An [InfraNodus](https://infranodus.com/use-case/ai-knowledge-graphs) account and API key - A Google Drive account and authorization (you will need to set it up via Google Cloud using the n8n instructions provided in the Google Drive node). ## Customizing this workflow You can use Dropbox instead of Google Drive. You can also modify this workflow slightly to make it sync with a Google Drive when new files appear in it. Check out the **complete guide** at [https://support.noduslabs.com/hc/en-us/articles/20267019838108-Upload-Sync-Your-Google-Drive-Folder-with-InfraNodus-using-n8n](https://support.noduslabs.com/hc/en-us/articles/20267019838108-Upload-Sync-Your-Google-Drive-Folder-with-InfraNodus-using-n8n).
n8n$14.99Automate Startup Funding Data Extraction to Excel
This workflow automates the discovery and extraction of seed-funded startup data from RSS feeds, processes it with AI, and exports it to an Excel sheet on OneDrive, streamlining lead generation for sales teams.
n8n$9.99AI Marketing Team: Multi-Agent Content Automation with OpenAI
Simulates a full marketing team using OpenAI O3 CMO agent that delegates chat inputs to specialist GPT-4.1-mini agents for copywriting, SEO, ads, and more.
n8n$24.99Automatically Store Retell Call Transcripts in Google Sheets, Airtable, or Notion
This workflow captures and stores Retell call transcripts and analyses in Google Sheets, Airtable, or Notion upon receiving a 'call_analyzed' webhook event. It is ideal for users who need to maintain a structured record of call data.
n8n$9.99Automate Sports Betting Data with The Odds API
# **Automate Sports Betting Data with TheOddsAPI** This workflow enables you to create and update a table using TheOddsAPI for sports betting data. It automatically pulls upcoming Ice Hockey games at the start of the day and updates the table with results at the end of the day. You can modify it to retrieve odds and game data for any sport. This setup is particularly useful for sports betting applications, such as tracking the results of a predictive model. It leverages scheduled triggers to activate HTTP requests, which then create or update fields in Airtable by matching on the game ID. --- ## **Prerequisites** Before implementing this workflow, ensure you have the following: 1. **TheOddsAPI Account & API Key** - Sign up at [TheOddsAPI](https://theoddsapi.com/) and obtain an API key. - Ensure you have the correct API permissions to access sports odds and results. 2. **Airtable Account & API Key** - Create an account at [Airtable](https://airtable.com/) and set up a database. - Obtain an API key from the **Account Settings** page. 3. **API Access & Rate Limits** - Review **TheOddsAPI's rate limits** and ensure your account tier allows for scheduled API calls. - Confirm that **Airtable API limits** align with your expected data retrieval frequency. --- ## **Step-by-Step Guide to Integrating TheOddsAPI** ### **1. Schedule API Requests** Set up a trigger to automatically pull upcoming Ice Hockey games at the start of each day. ### **2. Fetch Data from TheOddsAPI** Retrieve the latest sports betting data, including game details and odds, using TheOddsAPI. ### **3. Store Data in Airtable** Insert or update records in Airtable by matching game IDs, ensuring data accuracy. #### **Sample Airtable Template Column Setup for Ice Hockey** *(Table can adjust depending on sport and data needs. Reference [TheOddsAPI](https://theoddsapi.com/) for more documentation.)* - **Game ID** - **Sport** - **League** - **Game Date (UTC)** - **Home Team** - **Away Team** - **Completed** (Boolean: `TRUE`/`FALSE` for game completion status) - **Scores** (JSON or String for final scores) - **Last Update** (Timestamp of the latest update) ### **4. Schedule an End-of-Day Update** Configure another trigger to fetch final game results at the end of the day. ### **5. Update Records in Airtable** Modify existing Airtable records with final scores and game outcomes for complete tracking. ### **6. Customize for Other Sports** Adjust API parameters to retrieve data for different sports and betting odds, making the system flexible for multiple use cases. --- This structured workflow automates sports betting data collection and updates, ensuring accurate and real-time tracking of odds and game results. By integrating TheOddsAPI with Airtable, you can build scalable applications for predictive sports analytics and betting insights.
n8n$9.99Demo Workflow - How to Use workflowStaticData()
This workflow demonstrates how to use the `workflowStaticData()` function to set any type of variable that will persist within workflow executions. [https://docs.n8n.io/code/cookbook/builtin/get-workflow-static-data/](https://docs.n8n.io/code/cookbook/builtin/get-workflow-static-data/) This can be useful, for example, when working with access tokens that expire after a certain time period. Using `staticData`, we can keep a record of that access token and the expiry time and build our workflow logic around it. ## Important Static Data only persists across **production** executions, i.e., triggered by Webhooks or Schedule triggers (not manual executions!). For this, the workflow will have to be activated. ## Setup - Configure HTTP Request node to fetch access token from your API (optional) - Activate workflow - Test the workflow with the webhook production link - You can check the population of the static data in the single executions ### Feedback If you found this useful or want to report some missing information - I'd be happy to hear from you at [ria@n8n.io](mailto:ria@n8n.io)
n8n$9.99Automate Data Transfer from Webhook to ChatGPT and Google Sheets
Streamline your workflow by automatically sending data from a Webhook to ChatGPT for processing, and then storing the results in a Google Sheet for easy access and analysis.
Make$3.99XML to SQL Database Import
This is an example workflow that imports an XML file into an SQL database. - The ReadBinaryFiles node loads the XML file from the server. - Then the Code node extracts the file content from the binary buffer. - Afterwards, an XML node converts the XML string into a JSON structure. - Finally, the MySQL node inserts the data records into the SQL table. In the upper part of the workflow, there is another MySQL node that is disabled. This node creates a new table with all the required variables based on the sample SQL database: https://www.mysqltutorial.org/mysql-sample-database.aspx
n8n$9.99Split Out Binary Data
This workflow helps with processing binary data. You'll often have binary objects with keys such as `attachment_0`, `attachment_1`, `attachment_2`, etc., attached to your items, for example, when reading an incoming email. This binary data is hard to process because it's not an array you can simply loop through. This workflow solves this problem by providing a Function node that takes all incoming items and all their binary data and then returns a single item for each file with a `data` key containing your binary file. Incoming binary data:  Processed binary data: 
n8n$4.99Synchronize Typebot Flows with GitHub for Backup and Deletion
Automate the backup of Typebot flows to GitHub and ensure synchronization by deleting files in GitHub if flows are removed from Typebot.
n8n$19.99Efficiently Scrape Google Maps Data Using SerpAPI and n8n
Automate the extraction of detailed Google Maps data using SerpAPI and store it in Google Sheets for easy access and analysis.
n8n$14.99Automate Pinterest Content Scraping with AI and BrightData
This n8n workflow automates the process of scraping Pinterest content based on user-defined keywords using BrightData's API and the Claude Sonnet 4 AI model. It efficiently manages the scraping process, monitors progress, and organizes the extracted data into Google Sheets.
n8n$14.99Daily Insight Email from Structured Web Data with Firecrawl
**Daily Web Scraper & AI Summary with Firecrawl + Email Automation** Need to extract and summarize web content from a site that doesn't have an API? This workflow runs daily to scrape a web page using Firecrawl, summarize the content with OpenAI, and send it directly to your email - fully automated. **Watch Full Video Step-by-step Tutorial Here:** [https://www.youtube.com/@Automatewithmarc](https://www.youtube.com/@Automatewithmarc) **How It Works** - **Daily Trigger** - Starts the workflow every 24 hours. - **Firecrawl Node** - Crawls and extracts structured data from any web page you specify. - **OpenAI Node (Optional)** - Processes and summarizes the raw content using a prompt you control. - **Gmail Node** - Sends the final summary or content snapshot to your email inbox. **Perfect For** - Business analysts tracking daily market or industry news - Researchers and founders automating competitive intelligence - Anyone who wants web data delivered without coding or scraping scripts **Setup Instructions** - **Firecrawl API Key** - Sign up and insert your key in the credentials. - **Update Target URL** - Edit the URL in the Firecrawl node to your desired site. - **Customize the Prompt** - Tailor the OpenAI prompt to extract the insights you want. - **Connect Gmail** - Add your Gmail credentials and set your recipient email. **Built With** - Firecrawl (Web scraping without code) - OpenAI (For summarizing and insight extraction) - Gmail (Automated notifications) - n8n (Workflow automation engine)
n8n$14.99
Related categories
Custom AI Systems & Services
Our team of experienced AI builders will help build custom AI systems, workflows, and solutions.
Request Custom Work