Skip to content

v0.18.0 — Google Workspace admin project workflow (n8n port)

Choose a tag to compare

View all tags
@MorrisLu-Taipei MorrisLu-Taipei released this 20 May 16:24
· 27 commits to main since this release
v0.18.0
e98f34a

What's new

A full 1:1 n8n port of mihozip/google-workspace-admin-project-workflow, originally written in Google Apps Script. Lives at examples/google-workspace-admin-workflow/.

Workflows (7)

  • core/core-setup.workflow.json — one-time bootstrap (root subfolders + master control sheet)
  • core/core-project-starter.workflow.json — shared logic for new project creation: 11 subfolders + 9-section Doc + 待辦追蹤表 + 成果檢核表 + Calendar reminders + control row + email
  • core/core-milestone.workflow.json — shared logic for adding milestone dates to existing projects
  • entry-n8n-form/* — n8n Form Trigger adapters (2 files)
  • entry-google-forms/* — Webhook adapters + Apps Script bridge .gs (3 files)

Node strategy

Native Google nodes (Drive / Sheets / Docs / Calendar / Gmail) wherever possible. Only 3 HTTP Request nodes survive — each annotated with a yellow Sticky Note explaining why:

  • Docs heading / TITLE paragraph style (no native operation)
  • Sheets dropdown validation setDataValidation (no native operation)
  • Sheets header bold + bg colour + frozen row repeatCell/updateSheetProperties (no native operation)

Verbatim fidelity from upstream

11 subfolders / 20-column control sheet / 17-column milestone log / 12-column task tracker / 6-column checklist / 10 default tasks / 10 checklist items / 14 milestone date types / 5 reminder offsets / 9 Doc heading sections — all line-for-line.

Docs

  • README.md / README.en.md — overview
  • SCENARIO.md — persona-driven walkthrough mapping n8n workflow names to real use cases
  • SDD.md — planning / development / migration / test / validation (5 sections)
  • docs/install.md / docs/google-credentials.md / docs/field-mapping.md
  • CREDITS.md — upstream attribution

Validation

  • _audit.mjs — static lint encoding n8n-validation-expert + n8n-expression-syntax rules. 0 errors / 0 warnings
  • _n8n_import_test.mjs — round-trip POST against local n8n /api/v1/workflows. 7/7 accepted, then cleaned up
  • Layer 3 (live execution against real Google APIs) still pending — requires user-authorized OAuth credentials.

What this release does not change

skills/, reference-workflows/, cookbook/ remain at 0.17.0 behaviour. Pure additive release.

Diff: cfb655d...v0.18.0

Assets 2
Loading