Pa Review Queue Manager

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "name": "PA Review Queue Manager",
  "nodes": [
    {
      "parameters": {
        "triggerTimes": [
          "00:30",
          "06:30",
          "12:30",
          "18:30"
        ],
        "timezone": "UTC"
      },
      "id": "node_schedule_trigger",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1,
      "position": [
        100,
        100
      ]
    },
    {
      "parameters": {
        "method": "GET",
        "url": "https://maqqjchekovcgtbzrbrv.supabase.co/rest/v1/pa_review_queue?status=eq.PENDING_REVIEW&limit=100",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer {{ $env.SUPABASE_SERVICE_ROLE_KEY }}"
            },
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        }
      },
      "id": "node_read_pending",
      "name": "Read Pending PA Items",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4,
      "position": [
        300,
        100
      ]
    },
    {
      "parameters": {
        "functionCode": "// Apply PA-to-CEO 5-point review framework\nconst items = $input.first().body;\nif (!Array.isArray(items)) return [{status: 'NO_ITEMS'}];\n\nconst reviewed_items = items.map(item => {\n  return {\n    ...item,\n    review_points: {\n      data_authenticity: item.content_summary ? 'PASS' : 'FLAG',\n      legal_compliance: 'REVIEW', // Manual review required\n      liability_risk: 'REVIEW', // Manual review required\n      brand_compliance: item.brand_violations && item.brand_violations.length > 0 ? 'FLAG' : 'PASS',\n      inference_validity: 'REVIEW' // Manual review required\n    },\n    review_status: 'PENDING_FOUNDER',\n    flagged: false // Set by manual PA review\n  };\n});\n\nreturn reviewed_items;"
      },
      "id": "node_apply_review_framework",
      "name": "Apply 5-Point Review",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        500,
        100
      ]
    },
    {
      "parameters": {
        "method": "PATCH",
        "url": "https://maqqjchekovcgtbzrbrv.supabase.co/rest/v1/pa_review_queue?id=eq.{{ $input.first().id }}",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer {{ $env.SUPABASE_SERVICE_ROLE_KEY }}"
            },
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        },
        "requestFormat": "json",
        "jsonParameters": {
          "parameters": [
            {
              "name": "review_status",
              "value": "{{ $input.first().review_status }}"
            },
            {
              "name": "review_points",
              "value": "={{ JSON.stringify($input.first().review_points) }}"
            },
            {
              "name": "reviewed_at",
              "value": "={{ new Date().toISOString() }}"
            }
          ]
        }
      },
      "id": "node_update_review_queue",
      "name": "Update PA Review Queue",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4,
      "position": [
        700,
        100
      ]
    },
    {
      "parameters": {
        "method": "POST",
        "url": "https://maqqjchekovcgtbzrbrv.supabase.co/rest/v1/approval_requests",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer {{ $env.SUPABASE_SERVICE_ROLE_KEY }}"
            },
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        },
        "requestFormat": "json",
        "jsonParameters": {
          "parameters": [
            {
              "name": "item_reference",
              "value": "{{ $input.first().item_reference }}"
            },
            {
              "name": "item_type",
              "value": "{{ $input.first().item_type }}"
            },
            {
              "name": "pa_review_status",
              "value": "{{ $input.first().review_status }}"
            },
            {
              "name": "status",
              "value": "PENDING_FOUNDER"
            },
            {
              "name": "required_fields",
              "value": "data_authenticity,legal_compliance,liability_risk,brand_compliance,inference_validity"
            },
            {
              "name": "created_at",
              "value": "={{ new Date().toISOString() }}"
            }
          ]
        }
      },
      "id": "node_create_approval_request",
      "name": "Create Approval Request",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4,
      "position": [
        900,
        100
      ]
    },
    {
      "parameters": {
        "method": "POST",
        "url": "https://maqqjchekovcgtbzrbrv.supabase.co/rest/v1/execution_logs",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer {{ $env.SUPABASE_SERVICE_ROLE_KEY }}"
            },
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        },
        "requestFormat": "json",
        "jsonParameters": {
          "parameters": [
            {
              "name": "workflow_name",
              "value": "PA Review Queue Manager"
            },
            {
              "name": "workflow_run_id",
              "value": "={{ $execution.id }}"
            },
            {
              "name": "status",
              "value": "COMPLETED"
            },
            {
              "name": "action_log",
              "value": "PA review cycle executed. Items reviewed and forwarded to founder queue."
            },
            {
              "name": "execution_timestamp",
              "value": "={{ new Date().toISOString() }}"
            }
          ]
        }
      },
      "id": "node_audit_log",
      "name": "Write Audit Log",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4,
      "position": [
        1100,
        100
      ]
    },
    {
      "parameters": {
        "chatId": "{{ $env.TELEGRAM_CHAT_ID }}",
        "text": "PA Review Queue Manager: Review cycle completed. Items forwarded to founder queue. Telegram notifications disabled for Phase 3B."
      },
      "id": "node_telegram_disabled",
      "name": "Telegram Notification (DISABLED)",
      "type": "n8n-nodes-base.telegram",
      "typeVersion": 1,
      "position": [
        1300,
        200
      ],
      "disabled": true
    }
  ],
  "connections": {
    "node_schedule_trigger": {
      "main": [
        [
          {
            "node": "node_read_pending",
            "branch": 0
          }
        ]
      ]
    },
    "node_read_pending": {
      "main": [
        [
          {
            "node": "node_apply_review_framework",
            "branch": 0
          }
        ]
      ]
    },
    "node_apply_review_framework": {
      "main": [
        [
          {
            "node": "node_update_review_queue",
            "branch": 0
          }
        ]
      ]
    },
    "node_update_review_queue": {
      "main": [
        [
          {
            "node": "node_create_approval_request",
            "branch": 0
          }
        ]
      ]
    },
    "node_create_approval_request": {
      "main": [
        [
          {
            "node": "node_audit_log",
            "branch": 0
          }
        ]
      ]
    },
    "node_audit_log": {
      "main": [
        [
          {
            "node": "node_telegram_disabled",
            "branch": 0
          }
        ]
      ]
    }
  },
  "active": false,
  "settings": {
    "executionOrder": "v1"
  }
}

About this workflow

PA Review Queue Manager. Uses httpRequest, telegram. Scheduled trigger; 7 nodes.

Source: https://gist.github.com/prateekgehlot09/37341cecd133286bbbc84ec6be171b90 — original creator credit. Request a take-down →

More Slack & Telegram workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.