Used by PO Intake and supplier invoice extraction. Get a key from console.anthropic.com. Cost ~$0.01 per PO parsed.

Polls office@expresspaint.com.au every 10 minutes. New PDFs from known builder senders auto-flow into the PO Intake queue. Setup guide: GMAIL_SETUP.md

Push the painter schedule into TSheets as all-day shifts. Worker hourly rates and the crew list also sync from TSheets (see People → Workers). This area is a work in progress.

A brief block of standard site rules automatically added to the bottom of every work order sent to TSheets (under a — SITE RULES — heading). Keep it short. A completion-photo upload link is also appended automatically.

Paste a Google Maps API key with the Places API (New) enabled to power the Location address search (Add shift → Location). The key is stored server-side and never shown in the page. Leave blank to use the free OpenStreetMap search instead.

Get a key: Google Cloud Console → enable Places API (New) → Credentials → Create API key → enable billing. Restrict the key to the Places API (New) for safety.

Email patterns for builder PO emails. *@domain.com matches any email from that domain. Subject filters cut false positives (e.g. repair schedules, statements).

Email patterns for supplier invoice emails (Dulux, Wattyl, Taubmans, Cairns Hardware etc). Subject filters cut promotional emails, newsletters, etc.

No polls yet.

Pulls timesheets from TSheets every 10 minutes. Auto-matches jobcodes to dashboard jobs by address. Calculates labour cost from worker hourly rates × hours.

TSheets jobcodes auto-match to dashboard jobs by address. For unmatched jobcodes (work that isn't in the dashboard), either link to an existing job OR click "Create Job" to make a new one - timesheets backfill automatically.

No polls yet.

Sends booking confirmations, supervisor checks, and client notifications via SMS. Get credentials from console.twilio.com.

Auto-SMS workflow

When ON: cron auto-sends booking confirmations, supervisor checks (2 days before start) and client notifications (1 day before) for every eligible job. Send window 7am-7pm. Stale schedules (>24h old) auto-skip to prevent backdated spam.

AI auto-reply (experimental)

When ON: inbound replies are analysed by Claude. If AI confidence ≥80% and intent is one of confirm / access info / reschedule / question, the top suggested reply is auto-sent. Decline / other intents always leave for human follow-up. 30-min loop guard prevents bot-talking-to-itself. Cost ~$0.005 (AI) + ~$0.08 (Twilio SMS) per auto-reply.

OneDrive (folder linking), MYOB (invoice push) added in next phases.

Your expected ex-GST rate per task. The PO rate-check applies these to a PO's quantities to work out what the job should be worth vs what the builder is paying. Rates are guidelines ("approx — depends on size & access"). Edit a cell and hit Save on that row.

Applies any pending database structure updates (new columns/tables for features like bonus plans, day sheets, user permissions, streak flat-rate, template timing). Safe to run anytime — it only adds what's missing and never touches your data.

Lets a sub / foreman submit a new day sheet from their phone with no login — behind a shared password. They can only create, never view existing sheets. Guest sheets land as Drafts in Day Sheets for you to review.

Walks every active worker and recomputes the stored hourly_rate + cost_total columns on every one of their timesheet rows to match the current rate in Settings → People. Useful when historical timesheets show $0/hr or stale rates in the labour-entries modal because they were imported before a worker's rate was set. Safe to re-run — idempotent.

Use this if SMS have gone out unexpectedly. Shows every recipient that received a real SMS recently, so you can see if any were real supervisors/clients (rather than test numbers). One-tap kill switch stops all further automation.

Revert schedule auto-applies

Roll back jobs whose start_date was changed by the schedule_intake auto-apply (e.g. when the Gmail backfill processed old emails). Restores from the audit log's old_start_date.

Send correction / apology SMS

Send a one-off correction to the recipients you tick above. Tagged as template_key='correction' for audit.

One-off operations - safe to re-run.

Walks every job in stage Approved with a start date, classifies it (Townsville → Kerrod Townsville, else Ambrose → Karl, else Kerrod Cleall) and creates a single schedule entry on each job's start date. Idempotent - re-running won't duplicate. Undo deletes only the entries the bulk import created (tagged with a specific note) and reverts those jobs back to Approved.

Walks you through the full SMS workflow on a test job so you can run as many full cycles as you want, end-to-end, without affecting real jobs. Each "Fire" button resets that stage and sends immediately (bypasses the 7am-7pm window + auto-send toggle). Reply YES to the Supervisor Check from your phone to unlock the Client Notification stage. NO blocks it.