Data & Analytics Workflows
Data processing and analytics
Crypto RSI Alert System with EODHD, Telegram & TradingView
Automates RSI(14) monitoring on crypto watchlists using EODHD 1h data, detects 30/70 crossings, and sends Telegram alerts with TradingView chart links.
n8n$16.99Standardize US Phone Numbers with Multiple Format Options and Validation
## 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.
n8n$4.99Automatically Save Koncile Processed Data to Google Drive
Streamline your document processing by using Koncile to extract structured data and automatically save it as a CSV in Google Drive. This workflow eliminates manual exports, making it ideal for archiving and reporting.
Make$2.99Automate Airtable Record Cleanup with ZeroBounce via Webhook
Trigger a custom webhook to validate and clean up Airtable records by checking email validity with ZeroBounce. Automatically delete records with invalid emails.
Make$4.99Retrieve Entries from Cockpit Collection on Demand
This workflow allows you to manually trigger the retrieval of entries from a specified Cockpit collection, providing flexibility in data management.
n8nFreeTrack Website Visibility in Google AI Overviews with SerpAPI & Sheets
Automates monitoring of your site's presence in Google's AI Overviews for target keywords using SerpAPI to fetch results and Google Sheets for logging structured data.
n8n$14.99Automated Sitemap Link Extraction and Google Sheets Integration
This workflow extracts sitemap links using the ScrapingBee API and appends them to a Google Sheet. It recursively processes new XML links found during sitemap scraping.
n8n$14.99Validate Typeform Emails and Organize Responses in Google Sheets
Automatically validate emails from Typeform responses using MailboxValidator and organize the data into Google Sheets based on verification status.
Make$3.99Automate Email Validation and Status Updates in Google Sheets with ZeroBounce
Automatically validate email addresses from a Google Sheet using ZeroBounce and update the sheet with the validation status. This workflow ensures your email list is clean and up-to-date.
Make$3.99Automatically Enrich Pipedrive Organizations with BizMachine Data
This workflow enriches newly added organizations in Pipedrive with detailed business data from BizMachine, enhancing your CRM data quality.
Make$3.99Preconfigured Nodes for Systeme.io API Requests
Using the Systeme API can be challenging due to its pagination settings and low rate limit. This requires a bit more knowledge about API requests than a beginner might have. This template provides preconfigured HTTP Request nodes to help you work more efficiently. Pagination settings, item limits, and rate limits are all configured for you, making it easier to get started. ### How to configure Systeme.io credentials The Systeme API uses the Header Auth method. So, create a Header Auth credential in your n8n with the name X-API-Key.  ### Check out my other templates āļøš [**https://n8n.io/creators/solomon/**](https://n8n.io/creators/solomon/)
n8n$9.99Automate Data Transfer from MySQL to Google Sheets
Effortlessly transfer selected data from MySQL to Google Sheets, enhancing data accessibility and streamlining management across platforms.
MakeFreeSync RSS Feed Articles to Airtable Records Automatically
Effortlessly keep your Airtable database up-to-date by syncing new articles from RSS feeds. This workflow automates the process of reading RSS feeds and creating corresponding records in Airtable.
Make$2.99Automate Shopify Abandoned Cart Data to Google Sheets
Automatically transfer abandoned cart data from Shopify to Google Sheets for streamlined analysis and follow-up.
Make$4.99Automate Jotform Submissions to HTTP Endpoint
Effortlessly transfer data from Jotform submissions to your desired HTTP endpoint, ensuring seamless data integration.
Make$3.99Automate Product Data Extraction from Webpage Screenshots
This workflow automates the extraction of product information from webpage screenshots using Dumpling AI and GPT-4o, perfect for eCommerce teams and market researchers dealing with sites that block traditional scraping.
n8n$9.99Automatically Parse and Store Phone Numbers in Google Sheets via Webhook
Effortlessly parse phone numbers from incoming data using a custom webhook and store them in Google Sheets for streamlined contact management.
Make$3.99Automate Barcode Reading from Google Drive PDFs to Google Sheets
Streamline your workflow by automatically reading barcodes from PDFs stored in Google Drive and logging the results in Google Sheets using PDF.co's powerful API.
Make$4.99EPA Clean Water Act Data Access & Compliance Monitoring API Integration
## ADVANCED USE ONLY - U.S. EPA Enforcement and Compliance History Online (ECHO) - Clean Water Act (CWA) Rest Services MCP Server (36 operations) ### This workflow is for advanced users only! Need help? Want access to this workflow + many more paid workflows + live Q&A sessions with a top verified n8n creator? [Join the community](https://www.skool.com/beyond-nodes-automation-lab-2006/about) This MCP server contains **36 operations** which is significantly more than the recommended maximum of tools for most AI clients. ### Recommended Alternative for basic use cases **Seek a simplified MCP server** that utilizes the official n8n tool implementation for U.S. EPA Enforcement and Compliance History Online (ECHO) - Clean Water Act (CWA) Rest Services if available, or an MCP server with only common operations as it will be more efficient and easier to manage. ### Advanced Usage Requirements **BEFORE adding this MCP server to your client:** ### Disable or delete unused nodes - Review sections and disable/delete those you don't need **AFTER adding the MCP server to your client:** 1. **Selective tool enabling** - Instead of enabling all tools (default), manually select only the specific tools you need for that Workflows MCP client. 2. **Monitor performance** - Too many tools can slow down AI responses ### Pro tips **Keep maximum 40 enabled tools** - Most AI clients perform better with fewer tools - Group related operations and only enable one group at a time - Use the overview note to understand what each operation group does - Ping me on [discord](https://discord.me/cfomodz) if your business needs this implemented professionally ## Quick Setup 1. **Import** this workflow into your n8n instance 2. **Credentials** Add U.S. EPA Enforcement and Compliance History Online (ECHO) - Clean Water Act (CWA) Rest Services credentials 3. **Activate** the workflow to start your MCP server 4. **Copy** the webhook URL from the MCP trigger node 5. **Connect** AI agents using the MCP URL ## How it Works This workflow converts the U.S. EPA Enforcement and Compliance History Online (ECHO) - Clean Water Act (CWA) Rest Services API into an MCP-compatible interface for AI agents. **MCP Trigger**: Serves as your server endpoint for AI agent requests **HTTP Request Nodes**: Handle API calls to https://echodata.epa.gov/echo **AI Expressions**: Automatically populate parameters via `$fromAI()` placeholders **Native Integration**: Returns responses directly to the AI agent ## Available Operations (36 total) ### Cwa_Rest_Services.Get_Download (2 endpoints) **GET /cwa_rest_services.get_download**: Submit CWA Download Data **POST /cwa_rest_services.get_download**: Clean Water Act (CWA) Download Data Service ### Cwa_Rest_Services.Get_Facilities (2 endpoints) **GET /cwa_rest_services.get_facilities**: Submit CWA Facility Search **POST /cwa_rest_services.get_facilities**: Clean Water Act (CWA) Facility Search Service ### Cwa_Rest_Services.Get_Facility_Info (2 endpoints) **GET /cwa_rest_services.get_facility_info**: Submit CWA Facility Details **POST /cwa_rest_services.get_facility_info**: Clean Water Act (CWA) Facility Enhanced Search Service ### Cwa_Rest_Services.Get_Geojson (2 endpoints) **GET /cwa_rest_services.get_geojson**: Submit CWA GeoJSON Data **POST /cwa_rest_services.get_geojson**: Clean Water Act (CWA) GeoJSON Service ### Cwa_Rest_Services.Get_Info_Clusters (2 endpoints) **GET /cwa_rest_services.get_info_clusters**: Submit CWA Info Clusters **POST /cwa_rest_services.get_info_clusters**: Clean Water Act (CWA) Info Clusters Service ### Cwa_Rest_Services.Get_Map (2 endpoints) **GET /cwa_rest_services.get_map**: Submit CWA Map Data **POST /cwa_rest_services.get_map**: Clean Water Act (CWA) Map Service ### Cwa_Rest_Services.Get_Qid (2 endpoints) **GET /cwa_rest_services.get_qid**: Submit CWA Paginated Results **POST /cwa_rest_services.get_qid**: Clean Water Act (CWA) Paginated Results Service ### Cwa_Rest_Services.Metadata (2 endpoints) **GET /cwa_rest_services.metadata**: Submit CWA Metadata **POST /cwa_rest_services.metadata**: Clean Water Act (CWA) Metadata Service ### Rest_Lookups.Bp_Tribes (2 endpoints) **GET /rest_lookups.bp_tribes**: Submit BP Tribes Data **POST /rest_lookups.bp_tribes**: ECHO BP Tribes Lookup Service ### Rest_Lookups.Cwa_Parameters (2 endpoints) **GET /rest_lookups.cwa_parameters**: Submit CWA Parameters **POST /rest_lookups.cwa_parameters**: ECHO CWA Parameter Lookup Service ### Rest_Lookups.Cwa_Pollutants (2 endpoints) **GET /rest_lookups.cwa_pollutants**: Submit CWA Pollutants **POST /rest_lookups.cwa_pollutants**: ECHO CWA Pollutants Lookup Service ### Rest_Lookups.Federal_Agencies (2 endpoints) **GET /rest_lookups.federal_agencies**: Submit Federal Agencies **POST /rest_lookups.federal_agencies**: ECHO Federal Agency Lookup Service
n8n$24.99Compare and Analyze SQL Datasets Across Different Time Periods
This workflow compares two SQL datasets from different time periods, generating a detailed report on similarities and differences.
n8n$4.99Parse phone numbers from WatchForms and create items in Monday.com
Automatically parse phone numbers from WatchForms submissions and create corresponding items in Monday.com, streamlining your data management and organization process.
Make$3.99Format and Sync Data to Google Sheets
This workflow ensures that data is properly formatted before being inserted into Google Sheets. It involves renaming fields, selecting necessary fields, and adding timestamps to ensure compatibility with the destination spreadsheet. This is partic...
n8n$4.99Automate Airtable Record Retrieval and HTTP Data Transmission with Delay
Efficiently search Airtable records, introduce a delay, and transmit the data via HTTP request for seamless integration and processing.
Make$3.99Extract, Transform LinkedIn Data with Bright Data MCP Server & Google Gemini
### Disclaimer This template is only available on n8n self-hosted as it's making use of the community node for MCP Client.  ### Who this is for? The Extract, Transform LinkedIn Data with Bright Data MCP Server & Google Gemini workflow is an automated solution that scrapes LinkedIn content via Bright Data MCP Server then transforms the response using a Gemini LLM. The final output is sent via webhook notification and also persisted on disk. This workflow is tailored for: 1. **Data Analysts**: Who require structured LinkedIn datasets for analytics and reporting. 2. **Marketing and Sales Teams**: Looking to enrich lead databases, track company updates, and identify market trends. 3. **Recruiters and Talent Acquisition Specialists**: Who want to automate candidate sourcing and company research. 4. **AI Developers**: Integrating real-time professional data into intelligent applications. 5. **Business Intelligence Teams**: Needing current and comprehensive LinkedIn data to drive strategic decisions. ### What problem is this workflow solving? Gathering structured and meaningful information from the web is traditionally slow, manual, and error-prone. This workflow solves: 1. Reliable web scraping using Bright Data MCP Server LinkedIn tools. 2. LinkedIn person and company web scraping with AI Agents setup with the Bright Data MCP Server tools. 3. Data extraction and transformation with Google Gemini LLM. 4. Persists the LinkedIn person and company info to disk. 5. Performs a Webhook notification with the LinkedIn person and company info. ### What this workflow does? This n8n workflow performs the following steps: 1. **Trigger**: Start manually. 2. **Input URL(s)**: Specify the LinkedIn person and company URL. 3. **Web Scraping (Bright Data)**: Use Bright Data's MCP Server, LinkedIn tools for the person and company data extract. 4. **Data Transformation & Aggregation**: Uses the Google LLM for handling the data transformation. 5. **Store / Output**: Save results into disk and also performs a Webhook notification. ### 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://github.com/nerding-io/n8n-nodes-mcp) 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. Navigate to Proxies & Scraping and create a new Web Unlocker zone by selecting Web Unlocker API under Scraping Solutions. 5. Create a Web Unlocker proxy zone called mcp_unlocker on Bright Data control panel. 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>. 8. Update the LinkedIn URL person and company workflow. 9. Update the Webhook HTTP Request node with the Webhook endpoint of your choice. 10. Update the file name and path to persist on disk. ### How to customize this workflow to your needs 1. **Different Inputs**: Instead of static URLs, accept URLs dynamically via webhook or form submissions. 2. **Data Extraction**: Modify the **LinkedIn Data Extractor** node with the suitable prompt to format the data as you wish. 3. **Outputs**: Update the Webhook endpoints to send the response to Slack channels, Airtable, Notion, CRM systems, etc.
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