Traffic Monitor – UTMC Camera

Configuration

Traffic API Key

Scan Interval (minutes)

Min Jam Factor (0–10)

Cluster Radius (metres)

Persist Radius (metres)

Monitoring Regions

Telegram Notifications

Enable Telegram notifications

Bot Token

Chat ID

Raw

🗺 Send map image 📋 Send text list

Filtered

🗺 Send map image 📋 Send text list

Persistent

🗺 Send map image 📋 Send text list

Header template ({time}, {minJam})

Point template ({n}, {jf}, {label}, {area})

Raw section header ({count})

Filtered section header

Persistent section header

Google Sheets Webhook

Enable Google Sheets logging

Script URL

How to set up Google Sheets

Open your Google Sheet → Extensions → Apps Script
Delete any existing code, then paste the script below
Click Save (💾), then Deploy → New deployment → Web app
Set Execute as: Me | Who has access: Anyone
Click Deploy, copy the Web App URL above

// Google Apps Script – Traffic Monitor webhook
// Paste into Extensions → Apps Script in your Google Sheet, then deploy as Web App.

function doPost(e) {
  try {
    var data = JSON.parse(e.postData.contents);
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var ts = new Date(data.scannedAt);

    // Sheet: Summary
    var summary = ss.getSheetByName('Summary') || ss.insertSheet('Summary');
    if (summary.getLastRow() === 0) {
      summary.appendRow(['Timestamp','Raw count','Filtered count','Persistent count']);
    }
    summary.appendRow([ts, data.raw.length, data.filtered.length, data.persistent.length]);

    // Sheet: Filtered
    var fSheet = ss.getSheetByName('Filtered') || ss.insertSheet('Filtered');
    if (fSheet.getLastRow() === 0) {
      fSheet.appendRow(['Timestamp','Lat','Lng','JamFactor','Label','Area','Region','Members']);
    }
    data.filtered.forEach(function(p) {
      fSheet.appendRow([ts, p.lat, p.lng, p.jamFactor, p.label, p.area, p.region, p.members]);
    });

    // Sheet: Persistent
    var pSheet = ss.getSheetByName('Persistent') || ss.insertSheet('Persistent');
    if (pSheet.getLastRow() === 0) {
      pSheet.appendRow(['Timestamp','Lat','Lng','JamFactor','Label','Area','Region']);
    }
    data.persistent.forEach(function(p) {
      pSheet.appendRow([ts, p.lat, p.lng, p.jamFactor, p.label, p.area, p.region]);
    });

    return ContentService
      .createTextOutput(JSON.stringify({ok: true, logged: data.filtered.length + data.persistent.length}))
      .setMimeType(ContentService.MimeType.JSON);
  } catch(err) {
    return ContentService
      .createTextOutput(JSON.stringify({ok: false, error: String(err)}))
      .setMimeType(ContentService.MimeType.JSON);
  }
}

function doGet() {
  return ContentService.createTextOutput('Traffic Monitor endpoint – use POST');
}

Local Data Storage

Save scan data on this server (traffic_data folder)

Retention (days, 0 = keep forever)

Scan History (saved on server)

No saved scans.

Recent Logs

No logs yet.

Configuration

Monitoring Regions

Telegram Notifications

Google Sheets Webhook

Local Data Storage

Scan History (saved on server) Refresh

Recent Logs Clear

Add Monitoring Region

Scan History (saved on server)

Recent Logs