Data & Analytics Workflows
Data processing and analytics
Automated Data Flow Distribution Using Incremental Logic
This workflow automates the distribution of data flows by using incremental logic to route data through different paths based on conditions.
MakeFreeAutomate 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 News Scraping and Summarization with AI and Store in NocoDB
This workflow scrapes the latest news posts from a site without an RSS feed, summarizes them using AI, extracts keywords, and stores the results in a NocoDB database. It runs weekly to ensure you have the most current information.
n8n$24.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 Construction Blueprint Processing to Google Sheets
Streamline the conversion of construction blueprints from Google Drive into structured Google Sheets entries using VLM Run for efficient data management.
n8n$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.99Analyze Hacker News for Business Insights Using AI and Google Sheets
This n8n workflow monitors top Hacker News posts to identify business-related pain points using AI, and logs results into Google Sheets for further analysis.
n8n$14.99Automate Yelp Business Data Extraction and Storage in Google Sheets
This n8n workflow automates the extraction of detailed business information from Yelp using Bright Data API and stores it in Google Sheets for easy access and analysis.
n8n$9.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.99Automate CSV Import to PostgreSQL from Local Filesystem
This workflow automates the process of importing CSV files from your local filesystem into a PostgreSQL database, streamlining data management for self-hosted users.
n8n$4.99Automate Company Data Enrichment in Google Sheets Using Explorium MCP
This n8n workflow automatically enriches company data in Google Sheets by integrating with Explorium MCP. It updates your spreadsheet with firmographic details like business ID, NAICS code, employee range, and revenue range.
n8n$9.99Monitor Customer Churn Indicators with Bright Data MCP and OpenAI
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automatically monitors customer churn indicators and early warning signals to help reduce customer attrition and improve retention rates. It saves you time by eliminating the need to manually track customer behavior and provides proactive insights for preventing customer churn. ## Overview This workflow automatically scrapes customer data sources, support tickets, usage analytics, and engagement metrics to identify patterns that indicate potential customer churn. It uses Bright Data to access customer data and AI to intelligently analyze behavior patterns and predict churn risk. ## Tools Used - **n8n**: The automation platform that orchestrates the workflow - **Bright Data**: For scraping customer data and analytics platforms without being blocked - **OpenAI**: AI agent for intelligent churn prediction and pattern analysis - **Google Sheets**: For storing churn indicators and customer retention data ## How to Install 1. **Import the Workflow**: Download the .json file and import it into your n8n instance. 2. **Configure Bright Data**: Add your Bright Data credentials to the MCP Client node. 3. **Set Up OpenAI**: Configure your OpenAI API credentials. 4. **Configure Google Sheets**: Connect your Google Sheets account and set up your churn monitoring spreadsheet. 5. **Customize**: Define customer data sources and churn indicator parameters. ## Use Cases - **Customer Success**: Proactively identify at-risk customers for retention efforts. - **Account Management**: Prioritize customer outreach based on churn probability. - **Product Teams**: Identify product issues that contribute to customer churn. - **Revenue Operations**: Reduce churn rates and improve customer lifetime value. ## 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 #churnprediction #customerretention #brightdata #webscraping #customeranalytics #n8nworkflow #workflow #nocode #churnindicators #customersuccess #retentionanalysis #customerchurn #customerinsights #churnprevention #retentionmarketing #customerdata #churnmonitoring #customerlifecycle #retentionmetrics #churnanalysis #customerbehavior #retentionoptimization #churnreduction #customerengagement #retentionstrategy #churnmanagement #customerhealth #retentiontracking
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.99Store Gmail Email Details in MySQL Database
## This workflow processes emails received in Gmail and saves detailed information about each email to a MySQL database. ### Before using, you need to have: - Gmail credentials - MySQL database credentials - A table in your database with the following columns: - messageId (Gmail message ID) - threadId - snippet - sender_name (nullable) - sender_email - recipient_name (nullable) - recipient_email - subject (nullable) ### How it works: - The Gmail Trigger listens for new emails (checked every minute). - A Code Node extracts the following fields from each email: - Sender's name and email - Recipient's name and email - The MySQL Node inserts the extracted data into your database. - If an entry with the same sender email already exists, it updates the record with the new details. ### How to use: - Make sure your database table has all required columns listed above. - Select the appropriate table and configure the matching column (e.g., id) to avoid duplicates. ### Customizing this Workflow: - You can further modify the workflow to store attachments, timestamps, labels, or any other Gmail metadata as needed.
n8n$4.99Automate LinkedIn Profile Collection with AI and Store in NocoDB
Efficiently gather LinkedIn profiles based on specific keywords and locations using SerpAPI, enhance data with OpenAI, and store results in NocoDB for easy access.
n8n$14.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.99Bypass Cloudflare Turnstile for Web Scraping with 2captcha
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. ## Bypass Cloudflare Turnstile for Web Scraping with n8n ### How It Works This workflow automatically solves Cloudflare Turnstile CAPTCHAs for legitimate web scraping and automation tasks. It extracts the Turnstile sitekey from target webpages, submits solving requests to [2captcha](https://2captcha.com/?from=26496602), and returns bypass tokens that can be used in automated form submissions or data collection workflows. ### Set Up Steps 1. [Create a 2captcha Account](https://2captcha.com/?from=26496602): Sign up and get your API clientKey for CAPTCHA solving. 2. Import the Workflow into n8n: Add the workflow to your n8n instance. 3. Configure Authentication: Set up custom HTTP authentication with your clientKey in the credential settings. 4. Test the Workflow: Run with the demo URL to verify Turnstile detection and solving works correctly. 5. Replace the sample destination_url with your target website and start automating! Setup should take just a few minutes with your API credentials ready. ### Getting Started Once configured, the workflow can extract sitekeys from any Turnstile-protected webpage and return solved tokens for seamless automation. The [API documentation](https://2captcha.com/api-docs/cloudflare-turnstile?from=26496602) provides additional technical details for advanced use cases. ### Customizing the Workflow The workflow targets a demo page for testing. To adapt it, simply update the destination_url variable with your target website. You can also modify the sitekey extraction logic for sites that implement Turnstile differently, or integrate this as a subworkflow into larger scraping operations. ### API Reference Uses the TurnstileTaskProxyless task type with REST-based HTTPS communication. Each solve costs approximately $0.002 USD and typically completes within 30-90 seconds depending on queue load.
n8n$14.99Automate LinkedIn Post Engagement Analysis with Airtop
Effortlessly extract and analyze engagement metrics from LinkedIn posts using Airtop for enhanced marketing and research insights.
n8n$4.99Automate Address Geocoding with Google Sheets and Google Maps API
Effortlessly convert addresses into latitude and longitude coordinates using Google Sheets and the Google Maps API, ideal for applications like delivery routing and market analysis.
n8n$4.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.99Scrape Every URL on the Web Without Getting Blocked by Anti-Bot Technologies with Scrapey
## Purpose of the Workflow Most scraping workflows get blocked by anti-bot technologies. To avoid this, you can use Scrappey to scrape every website you want. ## How It Works: We use test data and make an API call to the Scrappey service. We get the scraped website data back as a result. ## Setup Steps: - Replace YOUR_API_KEY in the Scrappey API Call node with your Scrappey API Key ([Register For Free](https://scrappey.com/?ref=n8n)). - Replace the test data with your production data. You can plug in any type of data connector at this point of your workflow.
n8n$4.99Build Academic Citation Networks with PDF Vector API for Gephi Visualization
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. ## Build Citation Networks from Research Papers Automatically build and visualize citation networks by fetching papers and their references. Discover influential works and research trends in any field. ### Workflow Features: - Start with seed papers (DOIs, PubMed IDs, etc.) - Fetch cited and citing papers recursively - Build network graph data - Export to visualization tools (Gephi, Cytoscape) - Identify key papers and research clusters ### Process Flow: 1. **Input**: Seed paper identifiers 2. **Fetch Papers**: Get paper details and references 3. **Expand Network**: Fetch cited papers (configurable depth) 4. **Build Graph**: Create nodes and edges 5. **Analyze**: Calculate metrics (centrality, clusters) 6. **Export**: Generate visualization-ready data ### Applications: - Research trend analysis - Finding seminal papers in a field - Grant proposal background research
n8n$9.99Automate Web Data Search, Summarization, and Delivery via Webhooks
This workflow automates the process of searching web data using Perplexity, cleaning and summarizing the results with Gemini AI, and delivering structured insights to a webhook.
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