Templates / Review agency asset readiness and approvals with Google Sheets and Gmail

Review agency asset readiness and approvals with Google Sheets and Gmail

Ready for 3.0

by Fahmi Fahreza ✓ · 0 views · created 2026-10-15 · Project Management

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 21 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Gmail.

How it runs

Trigger: Manually, when you click “Execute workflow”.

  1. Pilot configuration (Code): runs custom JavaScript code
  2. Validate pilot setup (Code): runs custom JavaScript code
  3. Read projects (Google Sheets): read (sheet)
  4. Read items (Google Sheets): read (sheet)
  5. Read decisions (Google Sheets): read (sheet)
  6. Read ledger (Google Sheets): read (sheet)
  7. Gate reviewed preview (Code): runs custom JavaScript code
  8. Route approved send only (If): checks a condition and branches into true / false
  9. Reserve before sending (Google Sheets): append (sheet)
  10. Return preview only (Code): runs custom JavaScript code

…plus 10 more steps. See the full node list below.

Services it uses

Google SheetsGmail

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (5)

From the author

Quick overview This manual workflow reads a Google Sheets tracker of projects, items, and version-specific review decisions to calculate readiness and generate a preview digest of missing assets, pending reviews, requested changes, and approvals, with an…

Excerpt from Fahmi Fahreza's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.