Data & Analytics Workflows
Data processing and analytics
Bluesky New Follower Auto DM
Automatically sends welcome DMs to new Bluesky followers every 4 hours. Lightweight, stateless automation with no storage or dependencies needed.
n8n$9.99Summarize Glassdoor Reviews with Gemini & Bright Data Scraper
Automates Glassdoor company review scraping via Bright Data, summarizes insights with Google Gemini AI, and delivers actionable reports to webhooks for HR and market research teams.
n8n$19.99SharePoint List Fetch with OAuth Token
## Who is this template for? This template is designed for teams who need to automate data retrieval from SharePoint lists using n8n. It is ideal for users who want to authenticate via OAuth and then use the token to access SharePoint API endpoints, pulling in list data directly into n8n. ## How it works The template first generates an OAuth token using the Microsoft OAuth API. This token is then used to authenticate requests to the SharePoint List API, allowing the workflow to fetch data from a specified SharePoint list. By following the n8n workflow, the user can configure the necessary credentials and endpoints to automate SharePoint data access securely. ## Setup steps **Step 1:** Replace {tenant_id}, {client_id}, and {client_secret} with your Azure AD details for OAuth authentication. **Step 2:** Specify the SharePoint list API endpoint in the template (under SharePoint List Fetch node). **Step 3:** Configure the SharePoint list URL and make adjustments for specific data fields if necessary.
n8n$4.99Seamlessly Sync YouTube Channel Videos with Airtable for Analytics and Management
Effortlessly manage and analyze your YouTube channel content by syncing video data with Airtable, enabling comprehensive analytics and bulk updates.
n8n$14.99Send RSS Feed Data to Webhook
Filters articles based on keywords, checks against MongoDB for unique links, then sends results to different webhooks.
n8n$14.99Export SQL Data to XML with and without Attributes
This workflow exports data from a MySQL database into two XML files: one with simple XML elements and another with XML attributes. It demonstrates how to structure and convert data for different XML formats.
n8n$9.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.
MakeFreeReceive Google Sheet Data via REST API
Simple workflow which allows receiving data from a Google Sheet via REST endpoint. 1. Wait for Webhook Call 2. Get data from Google Sheet 3. Return data Example Sheet: [https://docs.google.com/spreadsheets/d/17fzSFl1BZ1njldfp5lvh8HtS0-pNXH66b7qGZIiGRU](https://docs.google.com/spreadsheets/d/17fzSFl1BZ1njldfp5lvh8HtS0-pNXH66b7qGZIiGRU)
n8n$2.99Compare Lists and Identify Common Items and Differences Using Custom Keys
This workflow compares two lists of objects (List A and List B) using a user-specified key (e.g., `email`, `id`, `domain`) and returns: - Items common to both lists (based on the key) - Items only in List A - Items only in List B ### How it works: 1. Accepts a JSON input containing: - `listA`: the first list of items - `listB`: the second list of items - `key`: the field name to use for comparison 2. Performs a field-based comparison using the specified key 3. Returns a structured output: - `common`: items with matching keys (only one version retained) - `onlyInA`: items found only in List A - `onlyInB`: items found only in List B ### Example Input: ```json { "key": "email", "listA": [ { "email": "alice@example.com", "name": "Alice" }, { "email": "bob@example.com", "name": "Bob" } ], "listB": [ { "email": "bob@example.com", "name": "Bobby" }, { "email": "carol@example.com", "name": "Carol" } ] } ``` ### Output: - `common`: `[ { "email": "bob@example.com", "name": "Bob" } ]` - `onlyInA`: `[ { "email": "alice@example.com", "name": "Alice" } ]` - `onlyInB`: `[ { "email": "carol@example.com", "name": "Carol" } ]` ### Use Cases: - Deduplicate data between two sources - Find overlapping records - Identify new or missing entries across systems This workflow is useful for internal data auditing, list reconciliation, transaction reconciliation, or pre-processing sync jobs.
n8n$4.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.99Split in Batches Node currentRunIndex Example
This workflow demonstrates how to use `currentRunIndex` to get the running index.  **Function node:** This node generates mock data for the workflow. Replace it with the node whose data you want to split into batches. **SplitInBatches node:** This node splits the data with the batch size equal to `1`. Based on your use-case, set the value of the Batch Size. **IF node:** This node checks the running index. If the running index equals `5`, the node returns `true` and breaks the loop. The node uses the expression `{{$node[SplitInBatches].context[currentRunIndex]}}`, which returns the running index. **Set node:** This node prints a message `Loop Ended`. Based on your use-case, connect the false output of the IF node to the input of the node you want to execute if the condition is `false`.
n8n$4.99Split In Batches Node: noItemsLeft Example
This workflow demonstrates how to use `noItemsLeft` to check if there are items left to be processed by the SplitInBatches node.  **Function node:** This node generates mock data for the workflow. Replace it with the node whose data you want to split into batches. **SplitInBatches node:** This node splits the data with the batch size equal to `1`. Based on your use-case, set the value of the **Batch Size**. **IF node:** This node checks if all the data by the SplitInBatches are not processed or not. It uses the expression `{{$node[SplitInBatches].context[noItemsLeft]}}` which returns a boolean value. If there is data yet to be processed, the expression will return `false`, otherwise `true`. **Set node:** This node prints a message `No Items Left`. Based on your use-case, connect the false output of the *IF* node to the input of the node you want to execute, after the data is processed by the *SplitInBatches* node.
n8n$4.99Sync Kanbanize Task Data to Airtable Automatically
Automatically import tasks from Kanbanize into Airtable, ensuring your project management data is always up-to-date and accessible.
MakeFreeStandardize 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.99Merge Data for Multiple Executions
This workflow demonstrates how to merge data from different executions.  The Merge Data Function node fetches the data from different executions of the RSS Feed Read node and merges them under a single object. **Note:** If you want to process the items that get merged, you will have to convert the single item into n8n understandable multiple items.
n8n$4.99Using the Merge Node - Merge by Key
This is an example of how you can make Merge by Key work. The "Data 1" and "Data 2" nodes simply provide mock data. You can replace them with your own data sources. Then the "Convert Data" nodes are important. They make sure that the different array items are actually different items in n8n. After that, you have the merge with the merged data.
n8n$4.99Generate, Retrieve, and Download a Report Using the SecurityScorecard
This workflow allows you to generate, retrieve, and download a report using the SecurityScorecard node.  **SecurityScorecard node:** This node generates a full scorecard report. Based on your use-case, you can generate another type of report. **SecurityScorecard1 node:** This node fetches the latest report from SecurityScorecard. Toggle **Return All** to `true` to return all the reports. **SecurityScorecard2 node:** This node downloads the report that got fetched from the previous node. Based on your use-case, you can either store this report in Dropbox, Google Drive, etc., or email it using the Gmail node, Send Email node, or the Microsoft Outlook node. You can replace the Start node with the Cron node to trigger the workflow on a regular interval.
n8n$4.99Sync Fomo Event Data to Airtable Records
Automatically transfer selected fields from Fomo events into Airtable records for streamlined data management.
MakeFreeUpdate Microsoft SQL Server database table rows from Google Sheets (in bulk)
Use this template to automatically update rows in a Microsoft SQL Server database table from a Google Sheets spreadsheet. Best for use cases when you need to update rows in bulk.
Make$2.99Create records in Airtable for new ideas in ProdPad
Every time an idea is added in your ProdPad a record will be created in your Airtable. In order for this scenario to work properly your Airtable table should look like (this)[https://airtable.com/shrHs4BrE5vEi2AHw].
Make$2.99Export API Data to Google Sheets and CSV
This workflow retrieves user data from an API and exports it to Google Sheets and a CSV file, enabling easy data management and analysis.
n8n$4.99Automate CV Screening & Analysis: Telegram, Gemini AI, Google Workspace
Automates CV collection from Telegram, validates PDFs, extracts data with Gemini AI, and stores in Google Drive/Sheets for HR teams. Saves hours on manual screening with duplicate prevention and structured logging.
n8n$24.99Manually Track Events in Segment
This workflow allows you to manually trigger and track events in Segment, providing flexibility in event management.
n8nFreeSurvey Insights with Qdrant, Python, and Information Extractor
This n8n template is one of a 3-part series exploring use-cases for clustering vector embeddings: - Survey Insights - Customer Insights - Community Insights This template demonstrates the Survey Insights scenario where survey participant responses can be quickly grouped by similarity and an AI agent can generate insights on those groupings. With this workflow, researchers can save days and even weeks of work breaking down cohorts of participants and identify frequently mentioned positives and negatives. Sample Output: [https://docs.google.com/spreadsheets/d/e/2PACX-1v6m8XH8JWJUAfwojc68NAUGC7q0lO7iV738J7aO5fuVjiVzdRRPkMm1C4N8wejai0XrmF1Q48/pubhtml](https://docs.google.com/spreadsheets/d/e/2PACX-1v6m8XH8JWJUAfwojc68NAUGC7q0lO7iV738J7aO5fuVjiVzdRRPkMm1C4N8wejai0XrmF1Q48/pubhtml) ### How it works - All survey questions and responses are imported from a Google Sheet. - Responses are then inserted into a Qdrant collection carefully tagged with the question and survey metadata. - For each question, all relevant responses are put through a clustering algorithm using the Python Code node. The Qdrant points are returned in clustered groups. - Each group is looped to fetch the payloads of the points and feed them to the AI agent to summarize and generate insights for. - The resulting insights and raw responses are then saved to the Google Spreadsheet for further analysis by the researcher. ### Requirements - Survey data and format as shown in the attached Google sheet. - Qdrant Vectorstore for storing embeddings. - OpenAI account for embeddings and LLM. ### Customizing the Template - Adjust clustering parameters which make sense for your data. Add more clusters for open-ended questions and less clusters when responses are multiple choice.
n8n$24.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