Invoice Processing

When an invoice PDF lands in Drive, extract its data, log it to a sheet, and send a drafted email response.

n8nGoogle DriveGeminiGmail
Invoice Processing workflow in the n8n editor

The problem

A new invoice PDF still has to be opened, keyed into a sheet, and answered by email before anyone else can act on it.

The solution

The workflow watches a Drive folder, downloads the file, extracts text from the PDF, uses Gemini to pull invoice fields, appends them to a sheet, then drafts and sends an email response.

How it works

  1. 1

    Catch the new file

    A Google Drive trigger fires when a file is created, then a download node fetches the binary.

  2. 2

    Read the PDF

    Extract from File pulls text from the PDF so the model is not guessing from a filename.

  3. 3

    Extract and log

    An Information Extractor backed by Google Gemini Chat Model pulls invoice fields, and Update DB appends them to a sheet.

  4. 4

    Draft and send

    Create Email Response Text prepares the message, and a Gmail node sends it.