Problem
The operational challenge
Reviews handled across email and chat can create unclear ownership, missed deadlines, fragmented feedback, and limited visibility into the latest draft or decision.
Coordinates marketing requests through Airtable using validation rules, reviewer assignment, priority-based deadlines, and decision routing. Approval, revision, rejection, and resubmission paths update records and trigger Gmail notifications—improving ownership, review visibility, and feedback tracking.
Marketing Content Review and Approval Management
Scroll to zoom · Click and drag to move
Project Overview
This project manages the marketing content review lifecycle in one centralized workspace. Airtable stores requests and decisions, while n8n validates submissions, assigns reviewers, applies priority-based deadlines, routes approval outcomes, tracks revisions, and sends Gmail notifications.
Problem
Reviews handled across email and chat can create unclear ownership, missed deadlines, fragmented feedback, and limited visibility into the latest draft or decision.
Solution
The workflow connects Airtable, n8n, and Gmail to validate requests, assign reviewers, calculate deadlines, record decisions and feedback, process revised submissions, and prevent duplicate handling.
Outcome
One approval workspace
Centralized Review
Requests, reviewer assignments, deadlines, decisions, feedback, and revision history remain visible in Airtable.
Reviewer and deadline rules
Clear Ownership
Each valid request is assigned to the appropriate reviewer with a priority-based deadline.
Recorded approval history
Traceable Decisions
Approvals, revisions, rejections, feedback, and resubmissions remain linked to the original request.
Documentation
Selected implementation screenshots created with test data. No real client or sensitive information is included.
Airtable Approved Content
Airtable New Content Request
Gmail Content Approved Notification
Gmail Reviewer Notification
Next Project