Enrich a Lead List With CRM Data (VLOOKUP Join)
Created by
Adam Pearce
Left-join scraped leads onto a CRM export by email, even when the key field is named differently on each side, and download the enriched list as Excel.
Dataset Join & Merge (VLOOKUP for Datasets)nerolabs/dataset-join-merge
Join status
Matches
Email
Name
+3 fieldsTextNumberBooleanListObject
Input
Left data (inline)
email:ana@example.com+3
name:Ana Silva+3
company:Silva Ltd+3
Right data (inline)
contact_email:ana@example.com+2
plan:Pro+2
owner:Sam+2
Key field(s) on the left:email
Key field(s) on the right:contact_email
Join type:left
Export result as file:xlsx
Output fields
Join status
Matches
Email
Name
Company
Plan
MRR
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.
