ChatGPT runs 20 small office jobs every night: invoices, checks and filing

🧰 Before you start

• A paid ChatGPT plan with scheduled tasks and agent/app connections
• Logins for your CRM, accounting software and Google Sheets
• A clear written rule for each job

🪜 Steps (tick as you go)

1. ☐
   1. List your nightly chores

   Write down the small jobs you or staff do every day: checking orders, drafting invoices, updating the sales sheet, filing documents.

2. ☐
   2. Pick one job

   Start with the safest, e.g. 'compare today's orders with the CRM and list mistakes'. No money moves.

3. ☐
   3. Connect the apps

   In ChatGPT settings, connect the apps the job needs (e.g. Google Sheets, Gmail). For websites without a connection, ChatGPT's agent can use a browser while you're logged in.

4. ☐
   4. Write the job

   Paste the 'Nightly order check' prompt below and run it once while you watch.

5. ☐
   5. Schedule it

   Ask ChatGPT to run it every night at [11 p.m.] as a scheduled task. Check the results each morning for two weeks.

6. ☐
   6. Add the next jobOptional extra

   When the first is reliable, add the next, e.g. draft invoices. Keep a list of all jobs and what each may touch.

💬 Prompts to copy

Every night at [11 p.m.]:
1. Open [orders sheet/system] and list orders marked completed today.
2. Check each against the CRM [name]: client name, amount (MYR), items, delivery address. List any mismatch.
3. For orders with no mismatch, create a DRAFT invoice in [accounting software]. Do not send or finalise.
4. Add each order to Google Sheet [name]: date, client, amount, invoice draft number.
5. Send me a summary: orders checked, mismatches, drafts created.
Never send invoices, make payments or delete records.

🔗 Links

• X post (source): https://x.com/SunnyvaleSBay/status/2108047957874573477

From https://usecasy.com/use-case/chatgpt-nightly-back-office/ · Guide checked 15 October 2026 · Prices are rough and shown in USD unless stated (MYR where relevant).