Automate PO Processing with Gmail and Slack

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": "PO Pipeline",
  "nodes": [
    {
      "parameters": {
        "path": "={{ $env.HOME }}/incoming",
        "triggerOn": "fileCreated"
      },
      "id": "trigger-watch-folder",
      "name": "Watch Incoming Folder",
      "type": "n8n-nodes-base.localFileTrigger",
      "typeVersion": 1,
      "position": [
        200,
        300
      ]
    },
    {
      "parameters": {
        "method": "POST",
        "url": "http://localhost:8000/upload-po",
        "sendBody": true,
        "contentType": "multipart-form-data",
        "bodyParameters": {
          "parameters": [
            {
              "name": "file",
              "parameterType": "formBinaryData",
              "inputDataFieldName": "data"
            }
          ]
        },
        "options": {}
      },
      "id": "http-upload-po",
      "name": "Upload PO to API",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4,
      "position": [
        460,
        300
      ]
    },
    {
      "parameters": {
        "conditions": {
          "number": [
            {
              "value1": "={{ $json.validation_report.flagged }}",
              "operation": "larger",
              "value2": 0
            }
          ]
        }
      },
      "id": "if-has-exceptions",
      "name": "Has Exceptions?",
      "type": "n8n-nodes-base.if",
      "typeVersion": 1,
      "position": [
        720,
        300
      ]
    },
    {
      "parameters": {
        "sendTo": "buyer@retailer.com",
        "subject": "=PO {{ $json.po_number }} \u2014 Exceptions Require Attention",
        "emailType": "text",
        "message": "={{ $json.exception_summary.email_draft }}",
        "options": {}
      },
      "id": "gmail-send-exception",
      "name": "Email Buyer: Exceptions Found",
      "type": "n8n-nodes-base.gmail",
      "typeVersion": 2,
      "position": [
        980,
        200
      ],
      "credentials": {
        "gmailOAuth2": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "channel": "#ops",
        "text": "=PO {{ $json.po_number }} processed successfully \u2014 all {{ $json.validation_report.total_lines }} lines passed validation.",
        "otherOptions": {}
      },
      "id": "slack-success",
      "name": "Slack: PO Processed Clean",
      "type": "n8n-nodes-base.slack",
      "typeVersion": 2,
      "position": [
        980,
        420
      ],
      "credentials": {
        "slackApi": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "values": {
          "string": [
            {
              "name": "po_number",
              "value": "={{ $json.po_number }}"
            },
            {
              "name": "status",
              "value": "={{ $json.status }}"
            },
            {
              "name": "flagged",
              "value": "={{ $json.validation_report.flagged }}"
            },
            {
              "name": "logged_at",
              "value": "={{ $now.toISO() }}"
            }
          ]
        },
        "options": {}
      },
      "id": "set-log-result",
      "name": "Set Log Fields",
      "type": "n8n-nodes-base.set",
      "typeVersion": 3,
      "position": [
        1240,
        300
      ]
    }
  ],
  "connections": {
    "Watch Incoming Folder": {
      "main": [
        [
          {
            "node": "Upload PO to API",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload PO to API": {
      "main": [
        [
          {
            "node": "Has Exceptions?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Has Exceptions?": {
      "main": [
        [
          {
            "node": "Email Buyer: Exceptions Found",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Slack: PO Processed Clean",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Email Buyer: Exceptions Found": {
      "main": [
        [
          {
            "node": "Set Log Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Slack: PO Processed Clean": {
      "main": [
        [
          {
            "node": "Set Log Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  },
  "staticData": null,
  "tags": [],
  "triggerCount": 0,
  "updatedAt": "2026-05-03T00:00:00.000Z",
  "versionId": "1"
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• gmailOAuth2
• slackApi

About this workflow

PO Pipeline. Uses localFileTrigger, httpRequest, gmail, slack. Event-driven trigger; 6 nodes.

Source: https://github.com/Anirudh-Ka/wholesale-po-pipeline/blob/15e322634206469bac9f2eba64d7342e661e3817/workflows/po_pipeline.json — original creator credit. Request a take-down →

More Email & Gmail workflows → · Browse all categories →

Related workflows

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