Data & Analytics Workflows
Data processing and analytics
Automate Daily MLB Matchup Analysis with Google Sheets and Telegram
This workflow automates the analysis of daily MLB pitcher vs. batter matchups, integrating data from MLB's API into Google Sheets and sending top matchups to Telegram.
n8n$9.99Integrate AI-Generated Charts into Conversations Using OpenAI and Quickchart
This workflow enables an AI agent to generate and integrate charts into conversations using OpenAI's structured output and Quickchart.io. It enhances user interactions by visualizing data in real-time.
n8n$9.99Automate Company Data Enrichment from Google Sheets Using OpenAI and ScrapingBee
Enhance your company's data by automatically enriching it from Google Sheets using OpenAI's AI capabilities and ScrapingBee's web scraping technology.
n8n$9.99Automate Customer Feedback Analysis and Reporting with AI and Google Sheets
This workflow automates the analysis of customer feedback from Google Sheets using AI, generating insights, visualizations, and a comprehensive report ready for email delivery.
n8n$19.99Scrape Latest 20 TechCrunch Articles
# Retrieve 20 Latest TechCrunch Articles ## Who is this for? This workflow is designed for developers, content creators, and data analysts who need to scrape recent articles from TechCrunch. It's perfect for anyone looking to aggregate news articles or create custom feeds for analysis, reporting, or integration into other systems. ## What problem is this workflow solving? This workflow automates the process of scraping recent articles from TechCrunch. Manually collecting article data can be time-consuming and inefficient, but with this workflow, you can quickly gather up-to-date news articles with relevant metadata, saving time and effort. ## What this workflow does This workflow retrieves the latest 20 news articles from TechCrunch’s “Recent” page. It extracts the article URLs, metadata (such as titles and publication dates), and main content for each article, allowing you to access the information you need without any manual effort. ## Setup 1. Clone or download the workflow template. 2. Ensure you have a working n8n environment. 3. Configure the HTTP Request nodes with your desired parameters to connect to the TechCrunch API. 4. (Optional) Customize the workflow to target specific sections or topics of interest. 5. Run the workflow to retrieve the latest 20 articles. ## How to customize this workflow to your needs - Modify the HTTP request to pull articles from different pages or sections of TechCrunch. - Adjust the number of articles to retrieve by changing the selection criteria. - Add additional processing steps to further filter or analyze the article data. ## Workflow Steps 1. **Send an HTTP request** to the TechCrunch Recent page. 2. **Parse a posts box** that holds the list of articles. 3. **Parse all posts** to extract all articles. 4. **Split out posts** for each article. 5. **Extract the URL and metadata** from each article. 6. **Send an HTTP request** for each article using its URL. 7. **Locate and parse** the main content of each article. --- **Note:** Be sure to update the HTTP Request nodes with any necessary headers or authentication to work with TechCrunch's website.
n8n$9.99Extract, Summarize & Analyze Amazon Price Drops with Bright Data & Google Sheets
### Notice Community nodes can only be installed on self-hosted instances of n8n. ### Who this is for This n8n-powered automation uses Bright Data's MCP Client to extract real-time data from a price drop site listing Amazon products, including price changes and related product details. The extracted data is enriched with structured data transformation, content summarization, and sentiment analysis using Google Gemini LLM. The Amazon Price Drop Intelligence Engine is designed for: - **Ecommerce Analysts** who need timely updates on competitor pricing trends - **Brand Managers** seeking to understand consumer sentiment around pricing - **Data Scientists** building pricing models or enrichment pipelines - **Affiliate Marketers** looking to optimize campaigns based on dynamic pricing - **AI Developers** automating product intelligence pipelines ### What problem is this workflow solving? This workflow solves several key pain points: **Reliable Scraping**: Uses Bright Data MCP, a managed crawling platform that handles proxies, captchas, and site structure changes automatically. **Insight Generation**: Transforms unstructured HTML into structured data and then into human-readable summaries using Google Gemini LLM. **Sentiment Context**: Goes beyond raw pricing data to reveal how customers feel about the price change, helping businesses and researchers measure consumer reaction. **Automated Reporting**: Aggregates and stores data for easy access and downstream automation (e.g., dashboards, notifications, pricing models). ### What this workflow does **Scrape price drop site with Bright Data MCP** The workflow begins by scraping targeted price drop site for Amazon listings using Bright Data's Model Context Protocol (MCP). You can configure this to target: **Structured Data Extraction** Once the HTML content is retrieved, Google Gemini is employed to: - Parse and structure the product information (title, price, discount, brand, ratings) **Summarization & Sentiment Analysis** The extracted data is passed through an LLM chain to: - Generate a concise summary of the product and its recent price movement - Perform sentiment analysis on user reviews and public perception **Store the Results** - Save to disk for archiving or bulk processing - Updated in a Google Sheet, making it instantly shareable with your team or integrated into a BI dashboard ### Pre-conditions 1. Knowledge of Model Context Protocol (MCP) is highly essential. Please read this blog post - [model-context-protocol](https://www.anthropic.com/news/model-context-protocol) 2. You need to have the [Bright Data](https://brightdata.com/) account and do the necessary setup as mentioned in the **Setup** section below. 3. You need to have the Google Gemini API Key. Visit [Google AI Studio](https://aistudio.google.com/) 4. You need to install the Bright Data MCP Server [@brightdata/mcp](https://www.npmjs.com/package/@brightdata/mcp) 5. You need to install the [n8n-nodes-mcp](https://github.com/nerding-io/n8n-nodes-mcp) ### Setup 1. Please make sure to set up n8n locally with MCP Servers by navigating to [n8n-nodes-mcp](https://www.youtube.com/watch?v=NUb73ErUCsA) 2. Please make sure to install the Bright Data MCP Server [@brightdata/mcp](https://www.npmjs.com/package/@brightdata/mcp) on your local machine. 3. Sign up at [Bright Data](https://brightdata.com/). 4. Create a Web Unlocker proxy zone called mcp_unlocker on Bright Data control panel. 5. Navigate to Proxies & Scraping and create a new Web Unlocker zone by selecting Web Unlocker API under Scraping Solutions. 6. In n8n, configure the Google Gemini (PaLM) API account with the Google Gemini API key (or access through Vertex AI or proxy). 7. In n8n, configure the credentials to connect with MCP Client (SDIO) account with the Bright Data MCP Server as shown below.  Make sure to copy the Bright Data API_TOKEN within the Environments textbox above as API_TOKEN=<your-token> ### How to customize this workflow to your needs - **Target different platforms**: Switch Amazon for Walmart, eBay, or any e-commerce source using Bright Data's flexible scraping infrastructure. - **Enrich with more LLM tasks**: Add brand tone analysis, category classification, or competitive benchmarking using Gemini prompts. - **Visualize output**: Pipe the Google Sheet to Looker Studio, Tableau, or Power BI. - **Notification integrations**: Add Slack, Discord, or email notifications for price drop alerts.
n8n$14.99Automate Multi-Search Engine Queries and Extract Structured Data
Simulate human-like searches across Google, Bing, and Yandex using Bright Data MCP and extract structured insights with Google Gemini.
n8n$14.99Automate Google Reviews Analysis and Summarization with AI
This n8n workflow automates the process of analyzing Google Maps reviews for restaurants, using AI to summarize insights and identify optimization opportunities. It integrates with Google Sheets, SerpAPI, and OpenAI to streamline data collection, analysis, and reporting.
n8n$9.99Sequential Google Sheets Data Processing with Execution Control
Ensure reliable and sequential data processing from Google Sheets by preventing simultaneous workflow executions in n8n.
n8n$9.99Automate Business Data Enrichment for Company Domains with Perplexity AI and Google Sheets
This workflow automates the enrichment of company domain lists with detailed business information using Perplexity AI, storing results in Google Sheets for streamlined analysis.
n8n$9.99Automatically Process New Google Sheets Rows Every 5 Minutes
This workflow identifies and processes new rows in Google Sheets every five minutes, marking them as processed to prevent duplicate handling.
n8n$4.99Log Mailgun Email Opens to Google Sheets Automatically
Automatically track and log email opens from Mailgun into Google Sheets, capturing detailed recipient and client information for better insights.
MakeFreeMeta Ads Campaign Report by Period - Auto-Send via WhatsApp & Email
Automates pulling Meta Ads performance data, calculating key metrics like CPC/CTR, and sending formatted reports via WhatsApp or Email daily.
n8n$22.99AI Cost Estimation from Revit/IFC Models with GPT-4 & Claude
Automates material pricing and total cost estimation for BIM/CAD elements using LLMs, from XLSX or Revit/IFC files, generating multi-sheet Excel and HTML reports.
n8n$24.99Wix Chat Auto-Responder with OpenAI GPT and Email Fallback
Automates intelligent Wix Chat responses using OpenAI GPT-4, with human response throttling and email fallback alerts for support staff.
n8n$24.99Bare-Events Event-Driven Database Sync
Utilizes bare-events library for lightweight event emitters to enable efficient, real-time database synchronization in data analytics workflows.
n8n$7.99Automated AWS S3, Azure, Google Cloud to MinIO Backup Scheduler
Automates scheduled backups of objects from AWS S3, Azure Blob Storage, or Google Cloud Storage to a local/remote MinIO S3-compatible bucket for reliable data redundancy.
n8n$24.99Automate Employee Reimbursement with Gmail, Drive & AI Validation
Automates employee reimbursement claims by processing form submissions, validating with AI, storing in Google Drive/Sheets, and notifying finance via Gmail. Cuts processing time by 70% and eliminates errors.
n8n$22.99Automated Event Discovery with Bright Data & n8n
Automates discovery of upcoming events by scraping websites with Bright Data, compiling details like dates, locations, and descriptions into a structured format for easy storage and use.
n8n$14.99Website Lead Management: Forms to WhatsApp & Google Sheets
Automates website contact form submissions by sending instant WhatsApp notifications with lead details and logging data to Google Sheets for tracking.
n8n$14.99Capture Website Screenshots from Google Sheets to Google Drive
Automates capturing screenshots of websites listed in Google Sheets using CustomJS and uploads them to Google Drive with custom filenames.
n8n$12.99Automatically Transfer Gravity Forms Submissions to Microsoft Excel
Efficiently manage your data by automatically adding new Gravity Forms submissions as rows in Microsoft Excel. This workflow saves time and reduces errors by eliminating manual data entry.
Make$2.99Automatically Update Datastore Records via HTTP Requests
Seamlessly update your datastore with new records by leveraging HTTP requests, ensuring efficient data management and synchronization.
MakeFreeAutomate SQL Table Export to CSV
This workflow automates the process of exporting data from a specified SQL table into a CSV file. It begins with a manual trigger, allowing you to specify the table name. The workflow then executes a SQL query to retrieve the data, which is subseq...
n8n$4.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