AI Powered Invoice Inbox System

Overview

An AI powered workflow that reads incoming invoice emails, extracts key fields, and automatically records them into a centralised spreadsheet for finance tracking.

Problem

Invoices were manually reviewed and entered into a Google Sheet, leading to slow processing and human errors across dozens of weekly vendor emails.

Solution

Created a Make.com scenario that watches Gmail, uses PDF.co to extract text, prompts OpenAI to structure data, and logs entries with metadata while handling duplicates.

1. 1.Watch Gmail for invoice related messages.
2. 2.Use PDF.co to extract text from attachments or email body.
3. 3.Prompt OpenAI to structure extracted data into key fields.
4. 4.Log each entry in Google Sheets with sender and timestamp metadata.