Kütüphane / Görevler ve Proje Yönetimi
Görevler ve Proje Yönetimi
Google Sheets ve Gmail üzerinden ajans varlık hazırlığını ve onayları inceleyin
Bir reklam ajansı için Google Sheets takipçisini okuyan, varlık hazırlığını hesaplayan, sürüm onaylarını yöneten ve sahip takip kuyruğu oluşturan manuel çalışan bir araç.
Ne yapar
## Review agency input readiness and version approvals with Google Sheets ### Purpose and audience Help a small creative, web or marketing agency coordinator review missing assets, received work awaiting review, requested changes and approved current versions. This manual workflow reads a human-maintained Google Sheets tracker, calculates readiness from included required items, and produces an owner follow-up queue. Receipt, silence and approval of an older version never approve the current version. ### Connected apps and how it works Uses built-in n8n nodes and Google Sheets. A Manual Trigger loads private configuration and reads projects, items, decisions and send_ledger. JavaScript validates IDs, types, dates, receipts and version-specific decisions. A strict branch returns a readable preview with project readiness, item status and suggested owner actions. Invalid or conflicting input fails closed. Gmail is included only as an optional, disabled, separately approved synthetic test-send path. It reserves and rechecks an append-only ledger, current source data and explicit operator approval before sending. Its original email formatter differs from the readable preview proposal. ### Setup The workflow's yellow notes contain the complete sheet headers, data types, copyable fictional sample rows, configuration fields and operating steps. Create a synthetic workbook with the four exact tab names, enter the provided headers and your fictional records, select an authorized Google Sheets credential on every Sheets node, and set spreadsheet_id in Pilot configuration. Keep mode=preview, allow_test_send=false, all recipient/approval fields blank, single_operator_confirmed=false and Gmail disabled. No external sample file or private repository document is needed. ### Usage Run manually, one execution at a time, without activation or publication. Inspect Return preview only for evaluation, readable_items, proposed_subject and proposed_body. The preview writes no ledger rows and sends no email. A person maintains all receipts, versions, explicit decisions, owners and dates. Use the embedded example and fixed-clock instructions for a reproducible no-send check; restore the current clock afterward. ### Limitations and costs This is a synthetic single-operator pilot. It does not watch uploads, review file contents, authenticate reviewers, infer approval or contact clients.
Adımlar
- Run one approved test
- Pilot configuration
- Validate pilot setup
- Read projects
- Read items
- Read decisions
- Read ledger
- Gate reviewed preview
- Reserve before sending
- Recheck ledger
- Recheck projects
- Recheck items
- Recheck decisions
- Verify fresh data and reservation
Toplam 21 adım.
Benzer otomasyonlar
Görevler ve Proje YönetimiGmail'deki Fatura E-postalarını Google Tasks'e Dönüştür10 adımGörevler ve Proje YönetimiOllama ile Gmail'den Jira Kayıtları Oluştur10 adımGörevler ve Proje YönetimiGPT ile Gmail'den Görevleri Çıkarıp Supabase'e Aktar8 adımGörevler ve Proje YönetimiEtiketli Gmail e-postalarını Notion veritabanı sayfalarına dönüştürme23 adım