Data & Analytics Workflows
Data processing and analytics
Weekly Data Transfer from Google Sheets to MySQL
Automate the weekly import of data from Google Sheets into a MySQL database, ensuring your database is consistently updated.
n8n$3.99Send data to Google Sheets using a custom webhook and API key authentication
Automatically send data to Google Sheets using a custom webhook and API key authentication. Streamline data entry with Makes integration of Google Sheets.
Make$3.99Automate Daily Sales Reports with Google Sheets and Email Summaries
Streamline your daily sales reporting by automatically generating and sending formatted email summaries from Google Sheets data. Ideal for teams seeking efficient performance updates.
n8n$9.99Fetch and Store Company Branding Data in Airtable
Automatically retrieve a company's logo, icon, and other information using Brandfetch and store it in Airtable for easy access and management.
n8n$4.99Export PostgreSQL Data to Excel File
Automatically extract data from a PostgreSQL database, convert it to an Excel file, and save it locally.
n8n$3.99Comparing Data with the Compare Datasets Node
This workflow is designed to compare two datasets (Dataset 1 and Dataset 2) based on a common field, fruit, and provide insights into the differences. Here are the steps: 1. **Manual Trigger**: The workflow begins when a user clicks "Execute Workflow." 2. **Dataset 1**: This node generates the first dataset containing information about fruits, such as apple, orange, grape, strawberry, and banana, along with their colors. 3. **Dataset 2**: This node generates the second dataset, also containing information about fruits, but with some variations in color. For example, it includes a kiwi with the color mostly green. 4. **Compare Datasets**: The "Compare Datasets" node takes both datasets and compares them based on the fruit field. It identifies any differences or matches between the two datasets. In summary, this workflow is used to compare two datasets of fruits and their colors, identify differences, and provide guidance on how to explore the comparison results.
n8n$4.99Create an RSS Feed Based on a Website's Content
This workflow parses content from a website (for this example, [Baserow's release page](https://baserow.io/blog/category/release)) and creates an RSS feed based on the extracted data. ## Prerequisites - Some familiarity with HTML and CSS selectors ## Nodes - [Webhook node](https://docs.n8n.io/integrations/core-nodes/n8n-nodes-base.webhook/) triggers the workflow when new content (a new Baserow release) is published on a website. - [Set nodes](https://docs.n8n.io/integrations/core-nodes/n8n-nodes-base.set/) set the required URLs and links for the RSS feed. - [HTTP Request node](https://docs.n8n.io/integrations/core-nodes/n8n-nodes-base.httprequest) fetches data from a specified website page. - [HTML Extract nodes](https://docs.n8n.io/integrations/core-nodes/n8n-nodes-base.htmlextract/) extract the posts and their fields (such as date, title, description, and link) from the website. - [Item Lists node](https://docs.n8n.io/integrations/core-nodes/n8n-nodes-base.itemlists/) iterates over each post on the page. - [Date & Time node](https://docs.n8n.io/integrations/core-nodes/n8n-nodes-base.datetime/) converts the date of the post to a different format. - [Function Item node](https://docs.n8n.io/integrations/core-nodes/n8n-nodes-base.functionitem/) creates RSS items for each post. - [Function node](https://docs.n8n.io/integrations/core-nodes/n8n-nodes-base.function/) creates the response code for the RSS feed. - [Respond to Webhook node](https://docs.n8n.io/integrations/core-nodes/n8n-nodes-base.respondtowebhook/) returns the RSS feed in response to the Webhook node. The result of this workflow would look like this: 
n8n$9.99Import Workflows and Map Their Credentials Using a Multi-Form
## Purpose This workflow allows you to import any workflow from a file or another n8n instance and map the credentials easily.   ## How it works - A multi-form setup guides you through the entire process. - At the beginning, you have two options: - Upload a workflow file (JSON) - Copy workflow from a remote n8n instance - If you choose the second option, you get to choose one of your predefined (in the Settings node) remote instances first, then it retrieves a list of all the workflows using the n8n API which you then can choose a workflow from. - Now both initial options come together - the workflow file is being processed. - In parallel, all credentials of the current instance are being retrieved using the Execute Command node. - The next form page enables a mapping of all the credentials used in the workflow. The matching happens between the names (because one workflow can contain different credentials of the same type) of the original credentials and the ones available on the current instance. Every option then shows all available credentials of the same type. In addition, the user has always the choice to create a new credential on the fly. - For every option which was set to create a new credential, an empty credential is being created on the current instance using the n8n API. An emoji is being appended to the name, which indicates that it needs to be populated. - Finally, the workflow gets updated with the new credential IDs and created on the current instance using the n8n API. Then the user gets a message, if the process has succeeded or not. ## Setup - Select your credentials in the nodes which require those. - Configure your remote instance(s) in the Settings node. (You can skip this step, if you only want to use the File Upload feature) - Every instance is defined as an object with the keys name, apiKey, and baseUrl. These instances are then wrapped inside an array. You can find an example described within a note on the workflow canvas. ## How to use - Grab the (production) URL of the Form from the first node. - Open the URL and follow the instructions given in the multi-form. ## Disclaimer - Security: Beware, that all credentials are being decrypted and processed within the workflow. Also, the API keys to other n8n instances are stored within the workflow. - This solution is primarily meant for transferring data between testing environments. For production use, consider the n8n enterprise edition which provides a **reliable** way to deploy workflows between different environments without the need of manual credential mapping.
n8n$24.99Insert Custom Documents into MongoDB with Manual Trigger
This workflow allows you to manually insert a document into a MongoDB collection by setting custom key-value pairs.
n8n$3.99Calculate the Centroid of a Set of Vectors
# n8n Workflow: Calculate the Centroid of a Set of Vectors ## Overview This workflow receives an array of vectors in JSON format, validates that all vectors have the same dimensions, and computes the centroid. It is designed to be reusable across different projects. ## Workflow Structure ### Nodes and Their Functions: 1. **Receive Vectors (Webhook)**: Accepts a GET request containing an array of vectors in the `vectors` parameter. - **Expected Input:** `vectors` parameter in JSON format. - **Example Request:** `/webhook/centroid?vectors=[[2,3,4],[4,5,6],[6,7,8]]` - **Output:** Passes the received data to the next node. 2. **Extract & Parse Vectors (Set Node)**: Converts the input string into a proper JSON array for processing. - **Ensures `vectors` is a valid array.** - **If the parameter is missing, it may generate an error.** - **Expected Output Example:** ```json { "vectors": [[2,3,4],[4,5,6],[6,7,8]] } ``` 3. **Validate & Compute Centroid (Code Node)**: Validates vector dimensions and calculates the centroid. - **Validation:** Ensures all vectors have the same number of dimensions. - **Computation:** Averages each dimension to determine the centroid. - **If validation fails:** Returns an error message indicating inconsistent dimensions. - **Successful Output Example:** ```json { "centroid": [4,5,6] } ``` - **Error Output Example:** ```json { "error": "Vectors have inconsistent dimensions." } ``` 4. **Return Centroid Response (Respond to Webhook Node)**: Sends the final response back to the client. - **If the computation is successful**, it returns the centroid. - **If an error occurs**, it returns a descriptive error message. - **Example Response:** ```json { "centroid": [4, 5, 6] } ``` ## Inputs - JSON array of vectors, where each vector is an array of numerical values. ### Example Input ```json { "vectors": [ [1, 2, 3], [4, 5, 6], [7, 8, 9] ] } ``` ## Setup Guide 1. **Create a new workflow in n8n**. 2. **Add a Webhook node** (`Receive Vectors`) to receive JSON input. 3. **Add a Set node** (`Extract & Parse Vectors`) to extract and convert the data. 4. **Add a Code node** (`Validate & Compute Centroid`) to: - Validate dimensions. - Compute the centroid. 5. **Add a Respond to Webhook node** (`Return Centroid Response`) to return the result. ### Function Node Script Example ```javascript const input = items[0].json; const vectors = input.vectors; if (!Array.isArray(vectors) || vectors.length === 0) { return [{ json: { error: "Invalid input: Expected an array of vectors." } }]; } const dimension = vectors[0].length; if (!vectors.every(v => v.length === dimension)) { return [{ json: { error: "Vectors have inconsistent dimensions." } }]; } const centroid = new Array(dimension).fill(0); vectors.forEach(vector => { vector.forEach((val, index) => { centroid[index] += val; }); }); for (let i = 0; i < dimension; i++) { centroid[i] /= vectors.length; } return [{ json: { centroid } }]; ``` ## Testing - Use a tool like Postman or the n8n UI to send sample inputs and verify the responses. - Modify the input vectors to test different scenarios. This workflow provides a simple yet flexible solution for vector centroid computation, ensuring validation and reliability.
n8n$4.99Automate Personalized Upwork Proposals with GPT-4, Google Docs & Mermaid
AI agent automates Upwork proposals by generating personalized copy, professional Google Docs, and Mermaid diagrams using proven $500K strategies.
n8n$24.99GitLab MR Auto-Review & AI Risk Analysis with Claude/GPT
Automates GitLab Merge Request reviews using Claude or GPT-4o AI to analyze code diffs, detect risks/issues, generate reports, and notify teams via email and MR comments.
n8n$24.99Automatically Create YouTube Metadata with AI
Automates YouTube metadata generation using AI to create optimized titles, descriptions, tags, and more from video transcripts, with affiliate integration and direct YouTube updates.
n8n$24.99WhatsApp AI Recipe Suggestions from Pantry via Gemini & FatSecret
Transforms WhatsApp pantry item lists into personalized recipes using Gemini AI for intent analysis and FatSecret API for nutritional data. Enables conversational cooking assistance with context memory.
n8n$24.99Use REGEX to Select Dates
This workflow looks for a Close Date value using REGEX in the IF node. If it finds the correct value, it will pass that value on. If it does not find the correct value, it will generate a value based on the present time plus three weeks. The final result will show up in the NoOps node. You can test this execution by enabling and disabling the Set node when you run the execution.
n8n$4.99Automate Daily Image Jokes on Twitter
Schedules daily posts of random image jokes from BlaBlagues API to Twitter at 5 PM, boosting social media engagement effortlessly.
n8n$12.99Automate Real-Time Currency Conversion with Webhook and Google Search
This n8n workflow automates real-time currency conversion by capturing GET requests via a webhook, parsing exchange rate data from Google Search, and returning a formatted response. It ensures reliable conversions through query parameter validation and error handling.
n8n$9.99Automate GitHub Issue Tracking in Notion
Automatically sync GitHub issues with your Notion database. This workflow updates the Notion database whenever an issue is opened, edited, closed, or deleted in GitHub, ensuring your project management is always up-to-date.
n8n$9.99Automate Google Events Data Collection to Google Sheets via SerpApi
Effortlessly scrape and organize Google Events data using SerpApi and store it in Google Sheets for streamlined analysis and tracking.
n8n$9.99Automate Table Creation and Data Management in Snowflake
This workflow automates the creation of a table in Snowflake and manages data by inserting and updating records. It streamlines database operations for efficient data handling.
n8n$4.99Export Zammad Data to Excel for Users, Roles, Groups, and Organizations
This n8n workflow exports Zammad data, including Users, Roles, Groups, and Organizations, into separate Excel files. It streamlines data management and reporting by providing structured outputs for further processing or sharing.
n8n$14.99Automate Salesforce File Archiving to Amazon S3 with Slack Notifications
Efficiently archive outdated Salesforce files to Amazon S3, maintain traceability, and receive Slack notifications upon completion, all through a scheduled n8n workflow.
n8n$14.99Deduplicate Data Records Using JavaScript Array Methods
## How It Works - Data Deduplication in n8n This tutorial demonstrates how to remove duplicate records from a dataset using JavaScript logic inside n8n's Code nodes. It simulates real-world data cleaning by generating sample user data with intentional duplicates (based on email addresses) and walks you through the process of deduplication step-by-step. **The process includes**: - Creating Sample Data with duplicates. - Filtering Out Duplicates using filter() and findIndex() based on email. - Displaying Cleaned Results with simple statistics for before-and-after comparison. This is ideal for scenarios like CRM imports, ETL processes, and general data hygiene. ## š Set-Up Steps ā Step 1: Manual Trigger Node: When clicking "Test workflow" Purpose: Initiates the workflow manually for testing. ā Step 2: Generate Sample Data Node: Create Sample Data (Code node) What it does: - Creates 6 users, including 2 intentional duplicates (by email). - Outputs data as usersJson with metadata (totalCount, message). - Mimics real-world messy datasets. ā Step 3: Deduplicate the Data Node: Deduplicate Users (Code node) What it does: - Parses usersJson. - Uses .filter() + .findIndex() to keep only the first instance of each email. - Logs total, unique, and removed counts. - Outputs clean user list as separate items. ā Step 4: Display Results Node: Display Results (Code node) What it does: **Outputs structured summary**: - Unique users - Status - Timestamp Prepares results for review or downstream use. ### Sample Output - Original count: 6 users - Deduplicated count: 4 users - Duplicates removed: 2 users šÆ Learning Objectives **You'll learn how to**: - Use .filter() and .findIndex() in n8n Code nodes - Clean JSON data within workflows - Create simple, effective deduplication pipelines - Output structured summaries for reporting or integration **Best Practices** - Validate input format (e.g., JSON schema) - Handle null or missing fields gracefully - Use logging for visibility - Add error handling for production use - Use pagination/chunking for large datasets
n8n$9.99Get Workflows Affected by 0.214.3 Migration
If you previously upgraded to n8n version `0.214.3`, some of your workflows might have been accidentally rewired in the wrong way. This issue affected nodes with more than one output, such as `If`, `Switch`, and `Compare Datasets`. This workflow helps you identify potentially affected workflows and nodes that you should check. **Please ensure that you run this workflow as the instance owner.**
n8n$9.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