Enrich Google Sheets with Dun & Bradstreet data blocks
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 7 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls plus.dnb.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Companies (Google Sheets): uses Google Sheets
- Only New Rows (Filter): keeps only the items that match a condition
- D&B Info (HTTP Request): calls an HTTP API
- Keep Score (Edit Fields (Set)): sets 1 field: Paydex
- Append to g-sheets (Google Sheets): append or update
- Get Token (HTTP Request): calls plus.dnb.com
Services it uses
HTTP calls to: plus.dnb.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (5)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set
From the author
Automate company enrichment directly in Google Sheets using Dun & Bradstreet (D&B) Data Blocks. This workflow reads DUNS numbers from a sheet, fetches a Bearer token (via Basic Auth → /v3/token), calls the Data Blocks API for each row (/v1/data/duns/...),…