Consent Mode Monitor for Google Sheets™ helps you validate Google Consent Mode setups at scale for websites using Google Tag Manager.
Built for regulators, brands, and agencies that need a fast way to spot consent issues across many properties, without jumping between tools.
◼️ How it works
• Install the add-on from Google Workspace Marketplace.
• Open your spreadsheet and go to Extensions → Consent Mode Monitor → Open Sidebar.
• Paste your Consent Mode Monitor licence key. Get the license key from here: https://consentmodemonitor.com/google-sheets-extension/
• Choose how you want to run checks:
▪️ Start from a list of website URLs (Site scoring)
▪️ Or score a list of GTM container IDs you already have (GTM scoring)
• Click Run selected reports to write results into new tabs in your sheet.

◼️ What you can do
• Bulk-check website URLs and detect connected GTM containers
• Score GTM containers and surface the main consent problem areas
• Generate spreadsheet-ready output for audits, client reporting, and internal reviews
• Schedule recurring checks to keep an ongoing monitoring trail in Google Sheets™

◼️ Who it’s for
• Compliance and privacy teams reviewing Consent Mode across multiple sites
• Agencies running regular audits for clients
• Brands managing many domains, regions, or teams
• Legal and assurance workflows that need repeatable checks and consistent output

◼️ Requirements
• A valid Consent Mode Monitor licence key
• Either website URLs or GTM container IDs (format: GTM-XXXXXXX)

◼️ Notes on data and permissions
The add-on runs from Google’s infrastructure and writes results to your spreadsheet. It requests access needed to read selected ranges, create result tabs, and call the Consent Mode Monitor service to return scores and reports.

◼️ Feedback and Support
Need a hand getting started, or want to share feedback? 
✉️ Email hello@consentmodemonitor.com or,
🔗 Use our contact form: consentmodemonitor.com/contact-us