• A Google Sheets add-on that turns raw canvassing pings into a weekly audit, topline summary, and a simple heatmap—right inside your spreadsheet. No external database.

    1. Open Google Sheets

    2. Install from the Google Workspace Marketplace (search “Canvassing Auditor”)

    3. Open a sheet → Extensions → Canvassing Auditor → Open

    • Spreadsheets – read your raw tab and write results to summary tabs

    • Drive (file) – save output inside the current file

    • User info – show your account for licensing

    • External request – check Developer License CSV (read-only)

  • In your Google Drive (the spreadsheet you’re working in). The add-on does not copy your data to an external server.

    • Validation of raw pings (Speed check and Duplicate removal)

    • Roll-ups by user/date/status

    • A topline sheet with totals you can paste into reports

    • A basic heatmap to spot outliers

    • Put all raw pings in a tab named Raw Upload

    • Include at least: timestamp, user/email, and basic status fields

    • One row per ping

  • Usually yes. If a field name doesn’t match, set the mapping in Settings → Field mapping and re-run.

  • The audit uses your spreadsheet’s time zone (File → Settings). Change it there if your results look offset.

    • First-time trial: 14 days free

    • Plans: Starter / Essentials / Standard / Managed (see Pricing)

    • Licensing is checked against a read-only CSV which I control. If you need to add or move users, contact me.

  • The sidebar will show “License not found or expired.” Your sheets remain intact; you just won’t be able to run new audits until renewed.

  • Most weekly runs finish in seconds to a couple minutes depending on rows

  • Yes. You can:

    • Rename output tabs in Settings

    • Add your own charts or filters to summary tabs (we won’t overwrite custom tabs)

    • Export toplines to CSV for sharing

  • It’s directional—great for spotting outliers. Breaks each hour down into 10 minute segments to track inconsistent or unrealistic door counts.

    For compliance decisions, rely on the numeric audit tables.

  • Google Sheets → Extensions → Manage add-ons → Uninstall. This leaves your spreadsheet data untouched.

    • Runs inside your Google account; data remains in your spreadsheet

    • Read-only license check via HTTPS

    • No third-party reselling of your data, ever