Community Dropcontact Bulk Enrichment

Name: Community Dropcontact Bulk Enrichment
Rating: 2.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

36 views

0 downloads

Data Enrichmentapibulkdatadropcontactenrichmentpostgres

Bulk enrich leads using Dropcontact API.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow allows you to bulk enrich leads using the Dropcontact API. It queries your PostgreSQL database for leads that haven't been enriched yet, formats them for the Dropcontact API, sends them in batches, and then updates your database with the enriched data.

Key Features

Fetches leads from PostgreSQL.
Batches requests for the Dropcontact API.
Handles asynchronous Dropcontact requests.
Updates enriched data back into PostgreSQL.
Configurable wait times between requests.

How To Use

Ensure you have a PostgreSQL database with a profiles table containing first_name, last_name, domain, and full_name columns.
Configure your PostgreSQL credentials in n8n.
Configure your Dropcontact API credentials in n8n.
Set the API_BASE_URL and BASE_URL environment variables in your n8n setup.
Adjust the SQL query in the PROFILES QUERY node to match your specific needs for lead selection.
The BULK DROPCONTACT REQUESTS node is configured for POST requests and uses apiKey for authentication. Ensure this matches your Dropcontact API setup.
The Wait2 node is set to 600 seconds (10 minutes). Adjust this value as needed based on Dropcontact API rate limits and your workflow requirements.
The Postgres node for updating the database is configured to update specific fields. Ensure the column names and values match your schema.

Apps Used

api

bulk

data

dropcontact

enrichment

postgres

Workflow JSON

{
  "id": "90e80d3b-dec2-4b84-8cc5-e1fa817cac3b",
  "name": "Community Dropcontact Bulk Enrichment",
  "nodes": 0,
  "category": "Data Enrichment",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.