Skip to content
TriedPrompts

More in Bookkeeping, receipts & invoices.

File subcontractor invoices into 30 job folders automatically with ChatGPT

Copy the prompt below and paste it into the AI tool named on this page.

Prompt Recreated prompt

The source didn't share its exact prompt, so we wrote this from what it describes.

What the prompt labels mean

I'm a builder and I get several subcontractor invoices a day by email across about 30 jobs. Help me build a simple script that collects every invoice from my email, reads it, works out which job it belongs to and files it in the right Google Drive folder.

Try this in:

Sends the Recreated prompt shown above. ChatGPT and Grok open with it filled in, and ChatGPT may send it straight away. Gemini opens empty, so we copy the prompt for you to paste. Every button also copies it.

Opens in a new tab. We don't see what you send.

These links are only a shortcut. We're not affiliated with OpenAI, Google or xAI, and your results may not match the source.

Optional stronger version

Our rewrite with extra checks. The poster didn't test it.

Before you start, ask me 1–3 short questions about the details below and wait for my answers. Once I've answered, confirm the plan in one line and run the whole task start to finish.

Goal: Automatically collect the invoices I get by email and file each one under the right job or client.

Questions to ask me first:
- Which email account and accounting tool do you use?
- How are your job or client folders named and organized?
- How can an invoice be matched to a job (address, job number, client name)?

Inputs (fill in or confirm):
- Email account and how invoices arrive: [EMAIL SETUP]
- Folder system and naming: [FOLDERS]
- How to tell which job an invoice belongs to: [MATCHING RULES]
- Accounting tool: [ACCOUNTING TOOL]

Rules:
- Explain each step of the script in plain words, since I don't write code.
- Never delete emails or invoices; copy or move them only.
- Put any invoice you can't match confidently in a 'Needs review' folder instead of guessing.
- Keep a simple log of each invoice filed, with sender, amount and job.

Checkpoint: Run it on the last ten invoices first and show me where each one would go before filing anything.

If you get stuck: If a connection or permission fails, tell me exactly which setting to change and why.

Verify before you finish: Check the test results against my own filing for the same ten invoices and fix any mismatches.

Output: A working script, setup steps I can follow and a log of filed invoices.

Done when: New invoices land in the right job folder on their own, and I only review the uncertain ones.

AI tool

ChatGPT

Outcome

Morgan Sterling runs Beach Cities Builder, a construction company in Hermosa Beach, California, and gets several subcontractor invoices a day across roughly 30 active job folders. Each one used to mean opening the invoice, working out the project, typing the details into Zoho Books and filing it in the right Google Drive folder. After a friend suggested it could be automated, Sterling asked ChatGPT and ended up with a script hooked up to email that puts every invoice in one folder, reads it, identifies the job and moves it to the right place. The first version took about two hours to build; Sterling says it's now effectively 100% accurate and saves roughly 5–6 hours a week. Sterling also built a script that adds any forecast with more than a 40% chance of rain in the next seven days to the calendar.

Evidence: Article or interviewA newsletter, journalist or interview account of what happened.

Source

Posted
by OpenAI Academy (story about Morgan Sterling)
Last checked
Method:
How we verify

https://academy.openai.com/public/blogs/how-chatgpt-became-a-contractors-back-office-2026-05-07

Context: This story is published by OpenAI, which makes ChatGPT. The accuracy and time savings are Sterling's own estimates.

More in Bookkeeping, receipts & invoices