Библиотека / Финансы, счета и бухгалтерия
Финансы, счета и бухгалтерия
Чтение PDF-чеков из Gmail с помощью Claude и сопоставление выписок по картам в Google Sheets
Когда в Gmail приходит письмо с меткой и PDF-файлом, Claude читает чек, код проверяет итоги и налог, результаты сохраняются в Google Sheets, а строки выписки по карте сопоставляются с ними.
Что делает
## Receipts in, card statement matched PDF receipts and invoices that arrive in Gmail are read by Claude. Code checks every number (the total is printed in the document, lines and tax add up, the tax rate fits), saves the result to Google Sheets, and then matches your card statement against the receipts — with no AI in the matching. ### How it works 1. Gmail Trigger picks up mails with the label receipts and a PDF. The PDF text is extracted, and Claude reads the PDF into JSON. 2. Code checks it: the amounts must be written in the PDF text, quantity × price must equal each line, lines + tax must equal the total. A failed check is saved as Needs review with the reason. A scan with no text is flagged, not trusted. 3. Paste your card statement into the Card tab, run Reconcile now. Code matches by amount and date window and writes the Matches tab: Matched, Ambiguous, No receipt, Possible double charge, Near match, Receipt only, Duplicate receipt. 4. A Slack message lists what needs a human. ### Setup 1. Blank Google Sheet: paste its ID in Spreadsheet ID, run Run once (adds the Receipts, Card and Matches tabs), then select the sheet in the Google Sheets nodes. 2. Credentials: Gmail, Google Sheets, Anthropic, Slack (pick a channel the app is in). Create the Gmail label receipts. 3. In Config, set the card column names and the date window. ### Customization Change the currency, the date window and the amount tolerance in Config.
Шаги
- Gmail Trigger
- Reconcile now
- Config
- Is it a new email?
- Split attachments
- Extract text from PDF
- AI: Read receipt
- Check receipt
- Add to Receipts tab
- Read Receipts tab
- Read Card tab
- Match statement
- Clear Matches tab
- Matches rows
Всего шагов: 21.
Похожие автоматизации
Финансы, счета и бухгалтерияОтправляйте еженедельные сводки по денежным средствам и runway в Slack с Aggregate и ClaudeШагов: 12Финансы, счета и бухгалтерияReconcile bank payments to invoices and ERP using Postgres and ClaudeШагов: 33Файлы и облачное хранилищеSend weekly sales PDF reports from Google Sheets to Slack with Claude and MintPDFШагов: 14Финансы, счета и бухгалтерияПоиск утечек выручки и отправка писем с восстановлением платежей через Gemini, Gmail и SlackШагов: 17