Go to example tasks

Enrich Rows From a Lookup CSV or Google Sheet by URL

Created by

Adam Pearce

Actor

Dataset Join & Merge (VLOOKUP for Datasets)

Join a small lead list to a lookup table at a public link: the open ISO country-codes CSV on GitHub here, but any CSV, Excel, JSON file or Google Sheet works the same way. Matches a two-letter country code to the sheet's differently named key column, pulls in the country name, continent, capital, dial code and currency, and downloads CSV and Excel. Swap in your own dataset or sheet link.

Dataset Join & Merge (VLOOKUP for Datasets)nerolabs/dataset-join-merge

Join status

Matches

Email

Name

+3 fields

Input

Left data (inline)

lead:Silva Ltd+5

iso2:BR+5

email:ana@example.com+5

Right file URL (CSV, Excel, JSON or Google Sheet):https://raw.githubusercontent.com/datasets/country-codes/main/data/country-codes.csv

Key field(s) on the left:iso2

Key field(s) on the right:ISO3166-1-Alpha-2

Join type:left

Right fields to bring in:official_name_en+4

If a key matches several right rows:first

Export result as file:csv+1

Output fields

Join status

Matches

Email

Name

Company

Plan

MRR

How it works

Sign up on Apify01

Create your Apify account to access the Dataset Join & Merge (VLOOKUP for Datasets).

Start the run02

The Actor will start running based on the input automatically.

Receive the output03

Monitor the progress in real-time. You will be notified as soon as your dataset is complete and ready for review.

Integrate into your workflow04

The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow.

Integrate Actor directly into your workflow

Choose from one of 100+ integration options we provide or integrate via API

Webhook

n8n

Make

Zapier

Airbyte

Keboola

IFTTT

Hubspot

GDrive

Gmail

Apify MCP

GitHub

Slack

LangChain

LlamaIndex

Flowise

Pinecone

OpenAI

Mastra

Clay