Enrich Google Sheets with Dun & Bradstreet data blocks

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/...), extracts Paydex, and appends or updates the sheet. A Filter node skips rows already marked Complete for efficient, idempotent runs.

---

✅ What this template does - Pulls DUNS values from a Google Sheet - (Option A) Uses an HTTP Header Auth credential for D&B, or (Option B) Dynamically fetches a Bearer token from /v3/token (Basic Auth) - Calls D&B Data Blocks per row to retrieve payment insights - Extracts Paydex and upserts results back to the sheet - Skips rows already Complete

---

👤 Who's it for - RevOps/Data teams enriching company lists at scale - SDR/Marketing teams validating firmographic/credit signals - BI/Automation builders who want a no-code/low-code enrichment loop

---

🧩 How it works (node-by-node) 1. Get Companies (Google Sheets) – Reads rows with at least duns, paydex, Complete. 2. Only New Rows (Filter) – Passes only rows where Complete is empty. 3. D&B Info (HTTP Request) – Calls Data Blocks for each DUNS using a header credential (Authorization: Bearer <token>). 4. Keep Score (Set) – Maps nested JSON to a single Paydex field: {{$json.organization.businessTrading[0].summary[0].paydexScoreHistory[0].paydexScore}} 5. Append to g-sheets (Google Sheets) – Append or Update by duns, writing paydex and setting Complete = Yes.

> The workflow also includes Sticky Notes with in-canvas setup help.