Data & Analytics Workflows
Data processing and analytics
Automate Facebook Ads Insights to Google Sheets Updates
Effortlessly extract insights from Facebook Ads and update Google Sheets rows for streamlined data analysis and reporting.
Make$3.99Filter and update Google Sheets cells with messages from Anthropic Claude
Use this template to filter Google Sheets rows and update a specific cell with messages from Anthropic Claude. Streamline data management and communication in your spreadsheets.
Make$3.99Automate Data Insertion and Update in Airtable
This workflow automates the process of inserting and updating records in Airtable, streamlining data management tasks.
n8n$4.99Parse JSON and Add New Record to Datastore
Efficiently parse JSON data and automatically add a new record to your datastore for seamless data management.
Make$3.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 Disqus Forum Details Instantly
Simple n8n workflow to fetch detailed information about a Disqus forum (e.g., hackernoon) via manual trigger. Ideal for quick data retrieval in marketing and analytics.
n8n$4.99Automate Webhook Data Transfer to Notion
Streamline your workflow by automatically transferring data from webhooks to Notion, ensuring real-time updates and enhanced collaboration.
MakeFreeAutomate Data Transfer from Airtable to Google Sheets
Streamline your workflow by automatically transferring and synchronizing data from Airtable to Google Sheets, ensuring up-to-date information for enhanced collaboration and decision-making.
Make$2.99Daily Transfer of BigML Anomaly Scores to Google Sheets
Automatically updates a Google Sheets document with the previous day's anomaly scores from BigML every day.
MakeFreeTrack and Log Android Geofence Events in SeaTable
Automatically log your Android device's geofence events in SeaTable for easy visualization and tracking. This workflow captures entry and exit data from specified geofences and records them in a structured table.
Make$2.99Automate LinkedIn Profile Discovery for Key Roles Using Google Search
This workflow automates the discovery of LinkedIn profiles for roles like CISO and CEO using Google Programmable Search. It extracts profile links, names, and timestamps, logging them into a structured Google Sheet for analysis.
n8n$4.99Automatically Log iOS Geofence Events to SeaTable
Track and log your iOS geofence events in SeaTable for easy visualization and analysis. This workflow captures entry and exit events from specified geofences and records them in a SeaTable database.
Make$2.99Automate Issue Creation in MantisBT from New Google Sheets Rows
Automatically create a new issue in MantisBT whenever a new row is added to a specified Google Sheets spreadsheet. This workflow streamlines issue tracking by integrating data entry directly with your bug tracking system.
Make$2.99Automate Webhook Responses and File Retrieval from Google Drive
Efficiently handle incoming webhooks by retrieving specific files from Google Drive and sending customized responses back.
Make$3.99Automatically Log New Memberstack Members in Google Sheets
Effortlessly track new Memberstack members by automatically adding their details to a Google Sheets spreadsheet.
MakeFreeAutomate Data Transfer from Datastore to HTTP Endpoint
Automatically send data from your datastore search results to a specified HTTP endpoint. This workflow streamlines data management by ensuring seamless data transfer without manual intervention.
Make$2.99Automate Data Insertion and Retrieval in Stackby
This workflow automates the process of inserting new data into a Stackby table and retrieving all existing data from it, streamlining your data management tasks.
n8n$4.99Automated n8n Workflow Backups to Google Drive with Version History
Automatically backs up self-hosted n8n workflows to Google Drive on a schedule, detects changes to avoid duplicates, and organizes versioned JSON files for easy restores.
n8n$14.99Daily Jira Ticket Summarizer with GPT-5 & Email Reports
Automates fetching daily Jira tickets, AI-powered summarization using GPT-5, and email reports for team insights. Saves hours on manual reviews and boosts visibility into support progress.
n8n$22.99Log Answered RingCentral Calls to Google Sheets
Automatically record details of every answered call in RingCentral to a Google Sheets spreadsheet, ensuring you have a comprehensive call log.
MakeFreeAutomate JSON Data Parsing and Entry into Google Sheets
Efficiently parse JSON data from incoming webhooks and seamlessly add it to Google Sheets for streamlined data management.
Make$3.99Automate Email Validation and Status Update in Google Sheets with DeBounce
Automatically validate email addresses from a Google Sheet using DeBounce and update the sheet with the validation status. This workflow ensures your email list is accurate and up-to-date.
Make$3.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.99Automatically Enrich and Log Meeting Attendees' Data in Google Sheets
Enhance your meeting scheduling process by automatically retrieving and logging attendee and company information from Clearbit into Google Sheets whenever a meeting is booked via ScheduleOnce.
Make$2.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