Enriching Brazilian company data with CNPJ API and Google Sheets

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) - razaosocial column (used to identify records without data)