Enriching Brazilian company data with CNPJ API and Google Sheets
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 8 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Telegram.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Settings (Edit Fields (Set)): sets 2 fields: telegram_id, api_base_url
- Get All CNPJs in Sheet (Google Sheets): uses Google Sheets
- Loop CNPJs (Loop Over Items (Split in Batches)): loops over the items in batches
- Limit: keeps the first few items
- Send API Request (HTTP Request): calls an HTTP API
- Notify When Finish (Telegram): uses Telegram
- Update CNPJ Info in Sheet (Google Sheets): update
Services it uses
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 (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Telegram
n8n-nodes-base.telegram - Limit
n8n-nodes-base.limit
From the author
Overview This workflow automatically enriches Brazilian company data by fetching comprehensive CNPJ information from the MinhaReceita.org API and updating your Google Sheets spreadsheet. Perfect for data analysts, sales teams, and anyone working with…