Track Policy Expiry Dates and Ownership with Google Sheets and Gmail…

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 →

{
  "id": "NBP9VDzT8zFtkYfy",
  "meta": {
    "info": "***SANITIZED***"
  },
  "name": "GRC Module 4 - Policy Lifecycle Tracker",
  "tags": [],
  "nodes": [
    {
      "id": "fe69debd-7076-4af7-82e3-510c6530035d",
      "name": "Fetch Policy Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -336,
        -128
      ],
      "parameters": {},
      "typeVersion": 4.6,
      "alwaysOutputData": false
    },
    {
      "id": "e76fee01-69af-4615-81c2-1ae2be3566c0",
      "name": "Is Policy Expiring Soon?",
      "type": "n8n-nodes-base.if",
      "position": [
        -128,
        -128
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "66b5f39c-da2d-45d8-8755-14b97a37cc80",
      "name": "When clicking \u2018Execute workflow\u2019",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -544,
        -144
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a9656a5c-7b92-456e-9590-5ea4e035c0aa",
      "name": "Is Owner Missing?",
      "type": "n8n-nodes-base.if",
      "position": [
        128,
        -208
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "fa85241a-c62e-4e46-9fc0-a245c047c368",
      "name": "Notify Missing Owner",
      "type": "n8n-nodes-base.gmail",
      "position": [
        368,
        -224
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "108a5b6e-e365-4b3f-8456-2cc652799e9c",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        544,
        -80
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "8f00cdcc-7e70-4e0d-ad6a-6c0c7072b3a7",
  "connections": {
    "Fetch Policy Data": {
      "main": [
        [
          {
            "node": "Is Policy Expiring Soon?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Is Owner Missing?": {
      "main": [
        [
          {
            "node": "Notify Missing Owner",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Is Policy Expiring Soon?": {
      "main": [
        [
          {
            "node": "Is Owner Missing?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking \u2018Execute workflow\u2019": {
      "main": [
        [
          {
            "node": "Fetch Policy Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

About this workflow

Purpose Automates the monitoring of policy documents for expiry and ownership gaps. Ensures accountability by sending proactive notifications when policies are nearing renewal deadlines or when no owner is assigned.

Source: https://n8n.io/workflows/7864/ — 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.