Enriching Brazilian Company Data with CNPJ API and Google Sheets

Description

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 Brazilian business databases who needs to enrich company information at scale.

What it does

Reads CNPJ numbers** from your Google Sheets spreadsheet
Fetches complete company data** from Brazil's Federal Revenue database via MinhaReceita.org API
Updates your spreadsheet** with comprehensive business information including address, tax status, partners, and more
Sends Telegram notifications** when the process is complete
Processes data in batches** to handle large datasets efficiently

Key Features

✅ Free API - No authentication required, completely free to use
✅ Comprehensive Data - 47+ fields of official Brazilian company information
✅ Batch Processing - Handles up to 100 CNPJs per batch automatically
✅ Smart Filtering - Only processes CNPJs that don't already have data
✅ Real-time Updates - Updates your spreadsheet as data is retrieved
✅ Progress Notifications - Get notified via Telegram when complete

Setup Requirements

Google Sheets Structure
Your spreadsheet must contain at minimum:
cnpj** column with Brazilian CNPJ numbers (numbers only, no formatting)
razao_social** column (used to identify records without data)

Credentials Needed
Google Sheets OAuth2** credentials configured in n8n
Telegram Bot** credentials for notifications (optional but recommended)

Available Data Fields

The workflow can populate your spreadsheet with any or all of these official fields from Brazil's Federal Revenue:

🏢 Company Information
cnpj, razao_social, nome_fantasia, capital_social
porte, codigo_porte, natureza_juridica, codigo_natureza_juridica

📍 Address & Location
uf, municipio, codigo_municipio, codigo_municipio_ibge
bairro, logradouro, descricao_tipo_de_logradouro
numero, complemento, cep
pais, codigo_pais, nome_cidade_no_exterior

📞 Contact Information
email, ddd_telefone_1, ddd_telefone_2, ddd_fax

💼 Business Classification
cnae_fiscal, cnae_fiscal_descricao, cnaes_secundarios
regime_tributario, qualificacao_do_responsavel

📋 Registration Status
situacao_cadastral, descricao_situacao_cadastral
motivo_situacao_cadastral, descricao_motivo_situacao_cadastral
situacao_especial, identificador_matriz_filial, descricao_identificador_matriz_filial
ente_federativo_responsavel

📅 Important Dates
data_inicio_atividade, data_situacao_cadastral, data_situacao_especial

🏛️ Tax Regime Information
opcao_pelo_mei, data_opcao_pelo_mei, data_exclusao_do_mei
opcao_pelo_simples, data_opcao_pelo_simples, data_exclusao_do_simples

👥 Partners & Shareholders
qsa (Complete structured data of company partners and shareholders)

How to Use

Prepare your spreadsheet with CNPJ numbers in the cnpj column
Configure your Telegram ID in the Settings node for notifications
Set up Google Sheets credentials in n8n
Add the desired data columns to your spreadsheet (any combination from the list above)
Run the workflow - it will automatically process all CNPJs without existing data

Performance & Limitations

API Limits**: None - completely free API from MinhaReceita.org
Data Accuracy**: Official data from Brazil's Federal Revenue Service
Batch Size**: Configurable (default: 100 records per batch)

Use Cases

Lead Enrichment**: Enhance prospect databases with complete company information
Market Research**: Gather comprehensive data about Brazilian companies
Compliance & Due Diligence**: Verify company registration status and details
Sales Intelligence**: Access contact information and company classification data
Data Cleaning**: Standardize and complete existing company databases

Prerequisites

N8N instance with Google Sheets integration
Google Sheets document with CNPJ data
Basic understanding of Brazilian CNPJ format (14-digit company registration number)
Telegram bot token (optional, for notifications)

Important Notes

CNPJs must be active and registered with Brazil's Federal Revenue Service
The workflow only processes CNPJs where razao_social is empty (avoiding duplicates)
All data comes from official government sources via MinhaReceita.org
No rate limiting needed - the API is designed for bulk requests
Supports both matriz (headquarters) and filial (branch) identification