{
  "name": "Summarize Google Play Store reviews with GPT-4-mini, Pinecone & Slack alerts",
  "nodes": [
    {
      "id": "976a0252-5685-4678-83d8-925d06853179",
      "name": "Split Out4",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        288,
        -384
      ]
    },
    {
      "id": "9ad91b18-e9c3-4e43-b301-cc833747fbe2",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -112,
        -384
      ]
    },
    {
      "id": "fd00f503-709f-472d-b0c3-8e8d617f8506",
      "name": "Loop Over Items1",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -192,
        96
      ]
    },
    {
      "id": "c67fa141-8df9-4010-8d46-b038bc540381",
      "name": "AI Agent - Summary creator",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        32,
        96
      ]
    },
    {
      "id": "83cf0fc5-66cc-4598-b354-6dd0f4f9ef1c",
      "name": "Set the bundle ids",
      "type": "n8n-nodes-base.set",
      "position": [
        -512,
        -384
      ]
    },
    {
      "id": "93bea9f6-775f-4232-be24-b33bba745393",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -592,
        -576
      ],
      "parameters": {
        "width": 272,
        "height": 336,
        "content": "Define the list of bundle ids of the Google Play Store apps you want to summarise reviews for. Bundle ids can be found in the Google Play Store url of the app. For example, bundle id of the app with u"
      }
    },
    {
      "id": "0bcfc993-e58e-49d6-aeba-ad7accb2087b",
      "name": "Daily Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -720,
        -384
      ]
    },
    {
      "id": "53df7cef-c399-48a5-bd10-82ec4547999a",
      "name": "Split Out",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -288,
        -384
      ]
    },
    {
      "id": "e1b05a7a-a9ce-4eed-89f9-c4162d76f1f0",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -304,
        -464
      ],
      "parameters": {
        "width": 320,
        "height": 224,
        "content": "Loop over bundle ids (apps) in the list"
      }
    },
    {
      "id": "68a7de8f-ad17-4b8b-8a5e-fba73b66794f",
      "name": "HTTP Request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        112,
        -384
      ]
    },
    {
      "id": "9a2f22a9-294e-472f-862f-cad8f9209d60",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        -464
      ],
      "parameters": {
        "width": 336,
        "height": 224,
        "content": "Fetch reviews from Google with a service account"
      }
    },
    {
      "id": "beb2b08e-f53d-4b36-82a8-ae282ae477ba",
      "name": "Filter",
      "type": "n8n-nodes-base.filter",
      "position": [
        496,
        -384
      ]
    },
    {
      "id": "63dfdf05-c792-49a9-830a-ec21edf907e1",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        464,
        -464
      ],
      "parameters": {
        "width": 464,
        "height": 224,
        "content": "Store the previous day's reviews in the vector store. Create a different namespace for each app (bundle id). Clear the name space once a week to remove old reviews."
      }
    },
    {
      "id": "3107ffd9-94ea-43ef-9fad-d0c8c75c32b4",
      "name": "Pinecone Vector Store",
      "type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
      "position": [
        688,
        -384
      ]
    },
    {
      "id": "a7611074-702b-496a-bef4-be4eeffda2b9",
      "name": "Embeddings OpenAI",
      "type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
      "position": [
        672,
        -160
      ]
    },
    {
      "id": "d6f865d0-fba7-456e-9bed-b531b11250c5",
      "name": "Default Data Loader",
      "type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
      "position": [
        864,
        -160
      ]
    },
    {
      "id": "fd7a2f0c-69f4-446e-978c-1b67d0041f87",
      "name": "Set app details",
      "type": "n8n-nodes-base.set",
      "position": [
        -544,
        96
      ]
    },
    {
      "id": "d2a57fa1-b396-4132-9ab6-7316a20a11cd",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -384,
        16
      ],
      "parameters": {
        "width": 320,
        "height": 224,
        "content": "Loop over bundle ids (apps) in the list"
      }
    },
    {
      "id": "e9baa7a4-d0bc-4dd1-90da-4677d75d6c75",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -576,
        16
      ],
      "parameters": {
        "width": 176,
        "height": 224,
        "content": "Define app bundle ids and names"
      }
    },
    {
      "id": "3e88c0ea-e6d5-412c-9aae-a702220d626d",
      "name": "Split Out1",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -368,
        96
      ]
    },
    {
      "id": "4eac3a49-5126-47b6-b748-fb97770dbab8",
      "name": "OpenAI Chat Model1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -32,
        320
      ]
    },
    {
      "id": "044cd2a3-c3d4-41a2-8c46-4291b3ba0ac8",
      "name": "Embeddings OpenAI1",
      "type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
      "position": [
        96,
        448
      ]
    },
    {
      "id": "ec306b60-8dbb-4ea9-a4c3-fa5ce4807f1d",
      "name": "Pinecone Vector Store1",
      "type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
      "position": [
        96,
        304
      ]
    },
    {
      "id": "053e5a35-875e-4e16-a788-ec2c7eea8425",
      "name": "Send to Slack channel",
      "type": "n8n-nodes-base.slack",
      "position": [
        400,
        80
      ]
    },
    {
      "id": "18bd7d4e-7893-4c36-85fa-300cfe55f941",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        16
      ],
      "parameters": {
        "width": 272,
        "height": 224,
        "content": "Generate Google Play Store review summary for the app"
      }
    },
    {
      "id": "cc8b8188-9d76-4dc1-babc-37cfc0c6cd84",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        352,
        16
      ],
      "parameters": {
        "width": 192,
        "height": 224,
        "content": "Post the summary to a Slack channel"
      }
    },
    {
      "id": "071bb344-81f1-45f6-bd41-b3df56e7ef4f",
      "name": "Weekly trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -736,
        96
      ]
    },
    {
      "id": "89236196-49fa-4fc9-a9c1-b8388b0f83d7",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -768,
        16
      ],
      "parameters": {
        "width": 176,
        "height": 224,
        "content": "Prepare and send the summary once a week"
      }
    },
    {
      "id": "109b52b1-1223-49f2-88d5-60dc2d2d2b80",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1360,
        -608
      ],
      "parameters": {
        "width": 448,
        "height": 928,
        "content": "## Google Play Store Reviews Summary with Pinecone, OpenAI & Slack Notification\n\nThis workflow automatically fetches reviews for one or more Google Play Store apps, summarizes the feedback using OpenA"
      }
    },
    {
      "id": "f215d048-e697-4925-a471-260062de023c",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -784,
        -464
      ],
      "parameters": {
        "width": 176,
        "height": 224,
        "content": "Fetch reviews once a day"
      }
    }
  ],
  "connections": {
    "Filter": {
      "main": [
        [
          {
            "node": "Pinecone Vector Store",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out1": {
      "main": [
        [
          {
            "node": "Loop Over Items1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out4": {
      "main": [
        [
          {
            "node": "Filter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "main": [
        [
          {
            "node": "Split Out4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Trigger": {
      "main": [
        [
          {
            "node": "Set the bundle ids",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Weekly trigger": {
      "main": [
        [
          {
            "node": "Set app details",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set app details": {
      "main": [
        [
          {
            "node": "Split Out1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items1": {
      "main": [
        [],
        [
          {
            "node": "AI Agent - Summary creator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Embeddings OpenAI": {
      "ai_embedding": [
        [
          {
            "node": "Pinecone Vector Store",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "Embeddings OpenAI1": {
      "ai_embedding": [
        [
          {
            "node": "Pinecone Vector Store1",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent - Summary creator",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Set the bundle ids": {
      "main": [
        [
          {
            "node": "Split Out",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Default Data Loader": {
      "ai_document": [
        [
          {
            "node": "Pinecone Vector Store",
            "type": "ai_document",
            "index": 0
          }
        ]
      ]
    },
    "Pinecone Vector Store": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send to Slack channel": {
      "main": [
        [
          {
            "node": "Loop Over Items1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Pinecone Vector Store1": {
      "ai_tool": [
        [
          {
            "node": "AI Agent - Summary creator",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent - Summary creator": {
      "main": [
        [
          {
            "node": "Send to Slack channel",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}