# Log, validate, and track Brazilian boletos with Gmail, forms, and Google Sheets

> Quick overview This workflow captures Brazilian boleto payment slips from Gmail PDF attachments or an n8n form, validates and decodes their barcode data, logs results to Google Sheets, and sends Gmail reminders for unpaid boletos that are overdue or due within 3 days. How it works 1. Triggers when a new Gmail email arrives with PDF attachments or when a user submits the n8n form with a digitable line/barcode. 2. Extracts text from each PDF attachment and pulls candidate digitable lines plus any printed due date and “Valor do documento” amount. 3. Decodes the digitable line/barcode, reconstructs the 44-digit barcode, and validates FEBRABAN check digits while deriving boleto type, bank/segment, amount, and due date. 4. Compares barcode-derived values to printed values (when provided) and routes invalid or mismatching boletos to a Review log in Google Sheets. 5. Reads the existing Boletos tab in Google Sheets to detect duplicates, appends new valid boletos to the Boletos tab, and logs pos

- **Domain**: `n8n-workflow-22368.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/22368
- Page (HTML): https://agenstry.com/agents/n8n-workflow-22368.n8n.io
- Documentation: https://n8n.io/workflows/22368
