Dataset Join & Merge (VLOOKUP for Datasets)

io.github.Nero-Enginev0.1.0Updated Oct 1, 2026

Returns two Apify datasets, files or Google Sheets by URL, or JSON arrays joined on key fields...

VerifiedStreamable HTTPWeb executableData & Analytics

Overview

AI-generated overview

Joins two Apify datasets, files or Google Sheets on key fields, like a VLOOKUP for datasets.

What it does
Returns two Apify datasets, files or Google Sheets by URL, or JSON arrays joined on key fields. It performs a key-based merge of two tabular sources, similar to a spreadsheet VLOOKUP, so an assistant can combine records from separate inputs. The manifest does not list individual tool names.
When to use it
Use it when two tables or datasets need to be combined on a shared key field, for example matching records from an Apify dataset with rows from a Google Sheet or a JSON array. It suits quick data reconciliation tasks where a spreadsheet-style lookup would otherwise be done by hand. Not needed if the data already lives in one source or a database join is available.
Requirements
A remote MCP endpoint at over streamable HTTP. An Apify API token is required, sent as the Authorization header in the form 'Bearer '. No packages or environment variables are declared.
Before you install
Requires an Apify API token sent as the Authorization header, so the token is a credential to protect. Runs are billed per event to the Apify account, so usage costs money. The server reads datasets, files and Google Sheets supplied by URL, which may send that data to a third party.

Installation

In SourceWeft

  1. Open Dataset Join & Merge (VLOOKUP for Datasets) in the dashboard and add it to a workspace.
  2. Enable the server for the chats that should use its tools.

Web executable via Streamable HTTP. Remote servers run from the web runtime once configured in a workspace.

Other MCP clients

Add this to your client's mcpServers config.

{
  "mcpServers": {
    "dataset-join-merge-full": {
      "type": "http",
      "url": "https://mcp.apify.com/?tools=nerolabs/dataset-join-merge"
    }
  }
}

Tools

0
Tool metadata has not been indexed yet.

Version history

1
  1. v0.1.0LatestOct 1, 2026