10 items on the hub serve machine shops. Ready-to-run automations first, then the tools they build on.
Ready to run (10)
Install and go. Each one is a complete automation with its own schedule or trigger.
workflowCertificate of Conformity Generator (Docs → PDF → Customer) — For shop floors marking shipments \"ready-for-coc\" in a Google Sheet, automatically copies a Doc template, find-replaces merge fields with row data, exports PDF, files to Drive, emails the PDF to the customer's buyer, and marks the row \"coc-sent\". One CoC per scheduled run. Zero AI cost \u2014 fully deterministic.
workflowDrawing Revision Watcher — Watches Gmail for drawing-revision emails. For each PDF attachment, AI reads the title block to extract part_number and rev. Looks the part up in a DrawingsTracker Sheet; if the rev is new, archives the old drawing to a Superseded folder, uploads the new drawing to the workflow's Drive folder, updates the tracker, and emails the estimator + production. Catches mid-production rev changes.
workflowOutside Processing Tracker — Daily tracker for parts sent to outside vendors (heat treat, plating, anodize, NDT, paint). Reads an OutsideOps Sheet, sends throttled follow-up emails to vendors past their promised return date, flags upcoming returns for the receiving dock, and emails a digest to the owner. Pairs with the rfq-triage / coc-generator small-shop quartet.
workflowQuote Follow-up (Daily Check-in) — Finds QuoteLog rows where status is \"quoted\" and the RFQ came in more than N days ago without customer reply, sends a polite check-in email, and stamps the row \"followed-up\" so it doesn't repeat. Runs once daily. Zero AI cost.
workflowRFQ Triage (Gmail → Sheets → Drive) — Triage incoming RFQ emails. AI-extracts customer/area/qty/material/processes/due, files attachments to a per-RFQ Drive folder, appends to a Sheets quote log, auto-replies to the customer in thread with a reference number, and notifies the estimator. Processes one RFQ per scheduled run.
workflowShop Status Digest (Daily) — Once-daily plain-text digest of the shop's open quotes, rush queue, stale RFQs to chase, shipments ready for CoC, and CoCs sent today. Reads the QuoteLog and ShipLog Sheets maintained by rfq-triage and coc-generator. No AI \u2014 pure deterministic counting.
skillGD&T Explainer (ASME Y14.5) — Explain a feature control frame in plain English — what it controls, the datum reference frame, the tolerance zone, how to measure it, and common gotchas. ASME Y14.5-2018 vocabulary; works from text input or a drawing image.
skillMaterial Substitution Advisor — Suggest material substitutions when the specified material is unavailable or unsuitable. Returns 2-4 candidates with property comparisons, machining notes, cost ratios, lead times, and customer-approval implications (ECN/MRB/FAI requirements for aerospace/medical work).
skillQuote Estimator (Machine Shop) — Produce a rough first-pass quote estimate (setup, cycle, material, OSP, suggested price, lead time, confidence) for a machined or fabricated part. Starting point for a senior estimator's review — not a final quote.
skillSpecification Summary (AMS / ASTM / MIL-STD / etc.) — 60-second orientation on an industry spec — title, scope, key requirements, who invokes it, common pitfalls, verification trail, and related specs. For triage and starting research; not a substitute for the actual standard.