Automatic Gmail invoice PDF upload to Google Drive with spreadsheet logging

Sort invoice PDFs from Gmail to Google Drive and Google Sheets

Who’s it for

Freelancers, finance teams, and small businesses that receive invoice PDFs by email and want them automatically saved to Google Drive and logged in Google Sheets—without manual downloading or copy-pasting.

How it works / What it does

This workflow watches your Gmail inbox for unread messages that match an invoice pattern (e.g., subject:invoice filename:pdf). For each email, it checks for attachments, uploads each PDF to a chosen Google Drive folder, and appends a new row to a Google Sheet with useful metadata: received time, sender, subject, filename, Drive link, and IDs. Finally, it marks the original email as read to avoid duplicates.

How to set up

1. Open the Config (Set) node and fill in:

drivefolderid (or leave blank for root) spreadsheetid (from the Sheet URL) sheetname (e.g., Invoices) 2. Connect credentials for Gmail, Google Drive, and Google Sheets in each node. 3. Adjust the Gmail search query if needed (language/vendor terms). 4. Run once manually to verify data mapping, then activate.