Look up CNPJ without coding (no-code)
You can look up a CNPJ (the Brazilian company tax ID) with the CNPJAPI API without writing code - straight in a spreadsheet or in an automation tool. This page gathers the no-code options and helps you pick the right one. They all use the same API and the same official data (the Brazilian Federal Revenue public base); only the tool changes.
First things first: an API key (free)
Every path below needs an API key - a token that identifies your account. Create your
free account at https://app.cnpjapi.com.br, generate the key in the portal (it starts
with cnpj_), and you are set. Each guide shows where to paste the key. Details in
Authentication.
In a spreadsheet
To enrich a list of CNPJs you already have in a spreadsheet:
- Look up CNPJ in Excel - with Power Query, applying a function to a whole column of CNPJs. Excel for Windows only.
- Look up CNPJ in Google Sheets - with a
=CNPJ()function via Apps Script. Works on any system (it is web based) and has a ready-to-copy template spreadsheet.
In automation tools
To look up automatically when something happens (new lead, new row, new CRM record) and store the result downstream:
- Look up CNPJ in Make (Integromat) - with the HTTP module in a no-code scenario.
- Look up CNPJ in Power Automate - with the HTTP action + Parse JSON, in the Microsoft ecosystem.
Which one to choose?
| Your case | Recommended path |
|---|---|
| I have a list of CNPJs in a spreadsheet and want to fill in the data | Excel (Windows) or Google Sheets |
| I am not on Windows / I want it in the cloud | Google Sheets |
| I want to enrich leads/rows automatically as they arrive | Make or Power Automate |
| I already live in the Microsoft ecosystem (Excel, SharePoint, Dataverse) | Power Automate |
| I want a visual, affordable automation builder | Make |
If you do write code, there are also the per-language guides (Python, Node.js, C#, PHP, Go, Java) and batch lookup.
Rate limit (applies to all)
On the free plan the API accepts a limited number of lookups per minute; when you
exceed it, it returns 429 (rate limited). No-code tools tend to fire calls in bursts, so
for large lists you either split into blocks or upgrade to a plan with a higher
limit and a comfortable monthly quota. See the plan limits.
Next steps
Create your free account at https://app.cnpjapi.com.br and run your first lookup without writing a single line of code.