{
  "name": "Generate daily Jira summaries & weekly reports with Azure OpenAI and Gmail",
  "nodes": [
    {
      "id": "cf39d6c2-8075-48bd-90e2-f5aabe04235e",
      "name": "Azure OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        672,
        640
      ]
    },
    {
      "id": "bb0d663a-30fd-40dc-affd-b7bedb5d08bf",
      "name": "Azure OpenAI Chat Model1",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        608,
        1600
      ]
    },
    {
      "id": "654069da-1c35-4475-8a67-1771a9301892",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        736,
        1600
      ]
    },
    {
      "id": "88de2233-3d12-4183-a700-4c40f9c91935",
      "name": "Structured Output Parser1",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        800,
        640
      ]
    },
    {
      "id": "4014c2f1-5ff9-4617-b780-f345669b3a1a",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -336,
        496
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": "## Daily Evening Trigger  \nSchedules and initiates the EOD workflow each workday evening automatically."
      }
    },
    {
      "id": "3d75eeb6-2cac-44a0-8b7a-2462f6fdfe61",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        112,
        304
      ],
      "parameters": {
        "width": null,
        "height": 176,
        "content": "## Get ALL issues (Jira)  \nRetrieves all Jira issues for the day, including statuses, priorities, and assignees, to power the EOD summary."
      }
    },
    {
      "id": "2644c493-fb58-474a-bc2e-89fcf93f8299",
      "name": "Get ALL issues",
      "type": "n8n-nodes-base.jira",
      "position": [
        208,
        528
      ]
    },
    {
      "id": "f4cee73e-d692-4835-b5a7-c0c94808cb13",
      "name": "Flatten Input",
      "type": "n8n-nodes-base.code",
      "position": [
        432,
        528
      ]
    },
    {
      "id": "7692b76d-68c2-46f0-8d6c-eff609de74b7",
      "name": "Create Summary",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        656,
        416
      ]
    },
    {
      "id": "514fc953-ea89-46e4-b1c0-c05367d978df",
      "name": "Append Summary",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1008,
        528
      ]
    },
    {
      "id": "30e6b160-c87c-40ca-b2cd-75f5ae93d9ff",
      "name": "Daily Evening Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -16,
        528
      ]
    },
    {
      "id": "1e5d7fbe-718a-472f-8d44-efc621042073",
      "name": "Friday Evening Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -80,
        1376
      ]
    },
    {
      "id": "f4c8a646-d963-4b84-b442-91ecad3b31d8",
      "name": "Get all stored data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        144,
        1376
      ]
    },
    {
      "id": "d26c622b-92f7-4826-adeb-ddf57df9daf2",
      "name": "Flatten the input",
      "type": "n8n-nodes-base.code",
      "position": [
        368,
        1376
      ]
    },
    {
      "id": "a626ce54-881d-4dbc-88ae-19adad2f6389",
      "name": "Create Weekly Summary",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        592,
        1376
      ]
    },
    {
      "id": "82ae1eaa-b298-4a81-a839-248558ce2fd9",
      "name": "Create Email",
      "type": "n8n-nodes-base.code",
      "position": [
        944,
        1376
      ]
    },
    {
      "id": "9d53e156-2c55-412f-a342-ac7b15be99f9",
      "name": "Email to Stakeholders",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1168,
        1376
      ]
    },
    {
      "id": "551aec75-3b84-4fe9-a859-c224e194463f",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        352,
        688
      ],
      "parameters": {
        "width": null,
        "height": 176,
        "content": "## Flatten Input  \nNormalizes and flattens the Jira JSON into a lighter structure so downstream nodes can parse consistently."
      }
    },
    {
      "id": "74294bfe-8fcb-4b01-b3de-015ba940405e",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        640,
        176
      ],
      "parameters": {
        "width": null,
        "height": 192,
        "content": "## Chat Model (EOD)  \nGenerates a structured End‑of‑Day summary from the flattened issue data using the configured Azure OpenAI model."
      }
    },
    {
      "id": "c02f0d08-1761-4f59-bdde-1c430082776f",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        944,
        704
      ],
      "parameters": {
        "width": null,
        "height": 192,
        "content": "## Append Summary (Sheet)  \nWrites the EOD summary and the day’s metadata into the Excel/Sheet store for later weekly aggregation."
      }
    },
    {
      "id": "8539c40a-70dc-4e66-a2a4-02fe9deca977",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        1360
      ],
      "parameters": {
        "width": null,
        "height": 176,
        "content": "## Friday Evening Trigger  \nStarts the weekly compilation workflow every Friday evening to build and send the weekly report."
      }
    },
    {
      "id": "affe1837-b2b5-4337-80a0-59adca265027",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        64,
        1168
      ],
      "parameters": {
        "width": null,
        "height": 176,
        "content": "## Get all stored data (Sheet)  \nReads the week’s EOD entries from the sheet, providing the full set of daily summaries for the weekly report."
      }
    },
    {
      "id": "2e86ba0f-1810-478b-b68b-f5e949b442e8",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        304,
        1536
      ],
      "parameters": {
        "width": null,
        "height": 176,
        "content": "## Flatten the input (Weekly)  \nConverts the read rows into a unified format for the weekly AI summarization step."
      }
    },
    {
      "id": "5b3bc309-60b3-467c-bc62-3a04b7b52e32",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        576,
        1168
      ],
      "parameters": {
        "width": null,
        "height": 176,
        "content": "## Chat Model (Weekly)  \nProduces a consistent Weekly Summary by analyzing the five daily EOD entries (Monday–Friday)."
      }
    },
    {
      "id": "6ab5b8a2-7aa4-4795-aa2b-2514b5045776",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        880,
        1536
      ],
      "parameters": {
        "width": null,
        "height": 176,
        "content": "## Create Email  \nTransforms the weekly summary into styled, mobile‑friendly HTML with a clear subject and preview."
      }
    },
    {
      "id": "91a7270d-1ad6-4d10-9182-29068b710763",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1104,
        1168
      ],
      "parameters": {
        "width": null,
        "height": 176,
        "content": "## Email to Stakeholders  \nSends the final weekly report email to the stakeholder list using the configured email provider."
      }
    }
  ],
  "connections": {
    "Create Email": {
      "main": [
        [
          {
            "node": "Email to Stakeholders",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Flatten Input": {
      "main": [
        [
          {
            "node": "Create Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Summary": {
      "main": [
        [
          {
            "node": "Append Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get ALL issues": {
      "main": [
        [
          {
            "node": "Flatten Input",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Flatten the input": {
      "main": [
        [
          {
            "node": "Create Weekly Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get all stored data": {
      "main": [
        [
          {
            "node": "Flatten the input",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Weekly Summary": {
      "main": [
        [
          {
            "node": "Create Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Evening Trigger": {
      "main": [
        [
          {
            "node": "Get ALL issues",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Friday Evening Trigger": {
      "main": [
        [
          {
            "node": "Get all stored data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Azure OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Create Summary",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Azure OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Create Weekly Summary",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Create Weekly Summary",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser1": {
      "ai_outputParser": [
        [
          {
            "node": "Create Summary",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    }
  }
}