Codex
62220186af
- New ExternalImportSource and ExternalWorkHistoryEntry models, controller and migrations - Screening fields on external profile imports - Admin and provider profile views, routes and workflow tests updated - Phase 1 validation, route inventory, gap report template and roadmap docs - Add the Google Sheets work-order parser tool (tools/google-sheets-wo-parser)
2.0 KiB
2.0 KiB
Setup and giveaway guide
User setup
- Make a copy of the published Google Sheet template into your own Google Drive.
- Open the copy on a desktop browser.
- Select WO Parser > Set up / repair workbook.
- Review and approve the Google authorization screen.
- The parser automatically finds recent Inbox messages from Field Nation and WorkMarket. No Gmail label or filter is needed.
- Return to the Sheet and select WO Parser > Check Gmail now to verify it works immediately.
- Open New WOs on the Google Sheets mobile app when you want the optional spreadsheet view.
The installer creates the labels WO Parser/Processed and WO Parser/Needs Review, plus a five-minute trigger. It scans only recent Inbox messages from Field Nation and WorkMarket senders; it does not delete or mark source mail read.
Template owner setup
- Create a clean Google Sheet under the project account.
- Open Extensions > Apps Script and replace the default file with
src/Config.gs,src/Parsers.gs, andsrc/Code.gsfrom this repository. Set the manifest fromappsscript.json. - Reload the Sheet, run WO Parser > Set up / repair workbook, and use fabricated/redacted test messages from Field Nation or WorkMarket sender patterns in a test Inbox.
- Share the finished sheet as Anyone with the link > Viewer. Do not give strangers edit access to the template itself.
- Share a make-a-copy URL by replacing the final
/editportion of the sheet URL with/copy. - Publish this repository beside the template link so recipients can inspect the code.
Each recipient must run Setup in their own copy. Triggers belong to the Google account that creates them and do not make the template owner a reader of anyone else's Gmail.
Updating a released template
Do not silently download or execute remote code in a user's Sheet. Publish a version number and release notes. For a breaking update, publish a new template and provide an import/export migration path for the old archive.