{
  "name": "Automated GA4 analytics data backfill to BigQuery with Telegram alerts",
  "nodes": [
    {
      "id": "de9827c8-f389-4ddd-82fc-af6df83c11be",
      "name": "GA4 - Session Channel Group",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        208,
        -32
      ]
    },
    {
      "id": "9cac6be1-4782-4bf7-b35c-65a265a43270",
      "name": "BQ - ga4_data_session_channel_group",
      "type": "n8n-nodes-base.googleBigQuery",
      "position": [
        432,
        -32
      ]
    },
    {
      "id": "0521bcf3-a478-476e-b600-c78e9e51be41",
      "name": "GA4 - Session Source/Campaign/Medium",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        208,
        160
      ]
    },
    {
      "id": "efb72346-baff-42d4-82ae-31167c3f9773",
      "name": "BQ - ga4_data_session_source_campaign_medium",
      "type": "n8n-nodes-base.googleBigQuery",
      "position": [
        432,
        160
      ]
    },
    {
      "id": "04c362d9-7678-4110-a65a-5b6b5af27200",
      "name": "GA4 - Country/Language/City",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        208,
        352
      ]
    },
    {
      "id": "f67555ea-ccd9-41fe-a118-f47954d60e42",
      "name": "BQ - ga4_data_country_language_city",
      "type": "n8n-nodes-base.googleBigQuery",
      "position": [
        432,
        352
      ]
    },
    {
      "id": "9061c72d-e67d-4761-a730-f024294d8645",
      "name": "GA4 - Item Name",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        208,
        544
      ]
    },
    {
      "id": "f3d2ecf5-fcce-421e-bd5f-1d5380969661",
      "name": "BQ - ga4_data_item_name",
      "type": "n8n-nodes-base.googleBigQuery",
      "position": [
        432,
        544
      ]
    },
    {
      "id": "0c380ced-0dd0-4c17-ada9-3a31cc83d817",
      "name": "GA4 - Browser/OS/Device",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        208,
        736
      ]
    },
    {
      "id": "7d699fd6-5ba7-4675-b4ba-abb4eb76df57",
      "name": "BQ - ga4_data_browser_os_device",
      "type": "n8n-nodes-base.googleBigQuery",
      "position": [
        432,
        736
      ]
    },
    {
      "id": "839aab16-0b61-438d-a8be-daa1dcf0de38",
      "name": "GA4 - First User Source/Medium",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        208,
        928
      ]
    },
    {
      "id": "58ac9920-db2c-4bb0-9ac5-a0c3395fa435",
      "name": "BQ - ga4_data_first_user_source_medium",
      "type": "n8n-nodes-base.googleBigQuery",
      "position": [
        432,
        928
      ]
    },
    {
      "id": "9dabc1ce-2e6e-4f1d-b849-45d69d9e36a2",
      "name": "GA4 - First User Channel Group",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        208,
        1120
      ]
    },
    {
      "id": "5f351870-d30e-4bbd-a424-4d2909c69e83",
      "name": "BQ - ga4_data_first_user_channel_group",
      "type": "n8n-nodes-base.googleBigQuery",
      "position": [
        432,
        1120
      ]
    },
    {
      "id": "c36e4a29-f8a0-4ba5-9bd2-f42621935ca5",
      "name": "GA4 - Ads Data",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        208,
        1312
      ]
    },
    {
      "id": "032022fe-a6c8-4b9f-81ec-8c4bc3732a4b",
      "name": "BQ - ga4_ads_data",
      "type": "n8n-nodes-base.googleBigQuery",
      "position": [
        432,
        1312
      ]
    },
    {
      "id": "b7acb21d-1d3a-44aa-a6a6-d61e877f6d0c",
      "name": "GA4 - All Metrics",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        208,
        1504
      ]
    },
    {
      "id": "3c5039ee-07b4-4dab-af2a-4cedaa5e773d",
      "name": "BQ - ga4_all_metrics_data",
      "type": "n8n-nodes-base.googleBigQuery",
      "position": [
        432,
        1504
      ]
    },
    {
      "id": "3f5878e3-0809-4744-9c8a-d616c63dff45",
      "name": "GA4 - Event Metrics",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        208,
        1696
      ]
    },
    {
      "id": "fc58d30d-3350-4466-8fe2-330510ebb890",
      "name": "BQ - ga4_event_metrics_data",
      "type": "n8n-nodes-base.googleBigQuery",
      "position": [
        432,
        1696
      ]
    },
    {
      "id": "48bfa988-0088-4ce2-a7da-14496dda8738",
      "name": "GA4 - Page Location",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        208,
        1888
      ]
    },
    {
      "id": "2533064a-f1c2-4bab-9f72-8368fe5de632",
      "name": "BQ - ga4_page_location_data",
      "type": "n8n-nodes-base.googleBigQuery",
      "position": [
        432,
        1888
      ]
    },
    {
      "id": "280f8dbe-dea6-41b5-a96c-9b49ee2c3248",
      "name": "GA4 - Landing Page",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        208,
        2080
      ]
    },
    {
      "id": "89e42bf3-90fe-40e4-a3aa-a588a7a6eb2f",
      "name": "GA4 - Transaction Items",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        208,
        -224
      ]
    },
    {
      "id": "6f95331c-4b34-4427-ab2d-38da7716a453",
      "name": "BQ - ga4_transaction_items",
      "type": "n8n-nodes-base.googleBigQuery",
      "position": [
        432,
        -224
      ]
    },
    {
      "id": "5dc8ff31-180d-4762-a420-39bb91b0a286",
      "name": "Backfill Config",
      "type": "n8n-nodes-base.set",
      "position": [
        -16,
        928
      ]
    },
    {
      "id": "6f6e0a0a-f81a-4573-b0ce-bf96db048777",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -240,
        928
      ]
    },
    {
      "id": "b18f7c11-b540-46cd-83f4-f962f47cf345",
      "name": "BQ - ga4_landing_page_data",
      "type": "n8n-nodes-base.googleBigQuery",
      "position": [
        432,
        2080
      ]
    },
    {
      "id": "121381a5-247a-47d9-a65f-3fc526c2011b",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        1664,
        640
      ]
    },
    {
      "id": "67d2d83b-47cd-4adb-9794-56792090e1f7",
      "name": "Merge1",
      "type": "n8n-nodes-base.merge",
      "position": [
        2144,
        976
      ]
    },
    {
      "id": "1d9603e7-41af-4dc5-814b-bd361409d4b9",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "position": [
        2352,
        976
      ]
    },
    {
      "id": "960ed711-34ff-4edd-ba94-146ba81ab8cd",
      "name": "Send a text message",
      "type": "n8n-nodes-base.telegram",
      "position": [
        2560,
        976
      ]
    },
    {
      "id": "53436acd-dc75-460a-a7ca-dd09ab527891",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1040,
        -304
      ],
      "parameters": {
        "width": 992,
        "height": 1056,
        "content": "# 🚀 N8N GA4 Backfill Workflow\n\n## Automate your GA4 Backfilling!\n\nThis workflow fetches key reports from Google Analytics 4 and loads them into Google BigQuery, complete with status alerts.\n\n### 📋 How"
      }
    },
    {
      "id": "33fc9b3a-298b-4471-9859-5cf9a592c3d7",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1040,
        -304
      ],
      "parameters": {
        "width": 3888,
        "height": 2624,
        "content": ""
      }
    }
  ],
  "connections": {
    "Code": {
      "main": [
        [
          {
            "node": "Send a text message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge1": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "GA4 - Ads Data": {
      "main": [
        [
          {
            "node": "BQ - ga4_ads_data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Backfill Config": {
      "main": [
        [
          {
            "node": "GA4 - Transaction Items",
            "type": "main",
            "index": 0
          },
          {
            "node": "GA4 - Session Channel Group",
            "type": "main",
            "index": 0
          },
          {
            "node": "GA4 - Session Source/Campaign/Medium",
            "type": "main",
            "index": 0
          },
          {
            "node": "GA4 - Country/Language/City",
            "type": "main",
            "index": 0
          },
          {
            "node": "GA4 - Item Name",
            "type": "main",
            "index": 0
          },
          {
            "node": "GA4 - Browser/OS/Device",
            "type": "main",
            "index": 0
          },
          {
            "node": "GA4 - First User Source/Medium",
            "type": "main",
            "index": 0
          },
          {
            "node": "GA4 - First User Channel Group",
            "type": "main",
            "index": 0
          },
          {
            "node": "GA4 - Ads Data",
            "type": "main",
            "index": 0
          },
          {
            "node": "GA4 - All Metrics",
            "type": "main",
            "index": 0
          },
          {
            "node": "GA4 - Event Metrics",
            "type": "main",
            "index": 0
          },
          {
            "node": "GA4 - Page Location",
            "type": "main",
            "index": 0
          },
          {
            "node": "GA4 - Landing Page",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "GA4 - Item Name": {
      "main": [
        [
          {
            "node": "BQ - ga4_data_item_name",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Backfill Config",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "BQ - ga4_ads_data": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 8
          }
        ]
      ]
    },
    "GA4 - All Metrics": {
      "main": [
        [
          {
            "node": "BQ - ga4_all_metrics_data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "GA4 - Landing Page": {
      "main": [
        [
          {
            "node": "BQ - ga4_landing_page_data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "GA4 - Event Metrics": {
      "main": [
        [
          {
            "node": "BQ - ga4_event_metrics_data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "GA4 - Page Location": {
      "main": [
        [
          {
            "node": "BQ - ga4_page_location_data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "BQ - ga4_data_item_name": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 4
          }
        ]
      ]
    },
    "GA4 - Browser/OS/Device": {
      "main": [
        [
          {
            "node": "BQ - ga4_data_browser_os_device",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "GA4 - Transaction Items": {
      "main": [
        [
          {
            "node": "BQ - ga4_transaction_items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "BQ - ga4_all_metrics_data": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 9
          }
        ]
      ]
    },
    "BQ - ga4_landing_page_data": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 3
          }
        ]
      ]
    },
    "BQ - ga4_transaction_items": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "BQ - ga4_event_metrics_data": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "BQ - ga4_page_location_data": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "GA4 - Country/Language/City": {
      "main": [
        [
          {
            "node": "BQ - ga4_data_country_language_city",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "GA4 - Session Channel Group": {
      "main": [
        [
          {
            "node": "BQ - ga4_data_session_channel_group",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "GA4 - First User Channel Group": {
      "main": [
        [
          {
            "node": "BQ - ga4_data_first_user_channel_group",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "GA4 - First User Source/Medium": {
      "main": [
        [
          {
            "node": "BQ - ga4_data_first_user_source_medium",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "BQ - ga4_data_browser_os_device": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 5
          }
        ]
      ]
    },
    "BQ - ga4_data_country_language_city": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 3
          }
        ]
      ]
    },
    "BQ - ga4_data_session_channel_group": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "GA4 - Session Source/Campaign/Medium": {
      "main": [
        [
          {
            "node": "BQ - ga4_data_session_source_campaign_medium",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "BQ - ga4_data_first_user_channel_group": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 7
          }
        ]
      ]
    },
    "BQ - ga4_data_first_user_source_medium": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 6
          }
        ]
      ]
    },
    "BQ - ga4_data_session_source_campaign_medium": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 2
          }
        ]
      ]
    }
  }
}