Google Sheets Add-on
Check consent settings across your website list.
Run checks for website URLs or known GTM container IDs in Google Sheets and keep the results together for review.
How it works
From a list in your spreadsheet to results in new tabs.
Everything happens inside Google Sheets: the Add-on reads the rows you select and writes the results back into the same spreadsheet.
2
Consent Mode Monitor
Licence key
••••‑••••‑7F2A
Reports
Site scoringGTM scoring
Use current selection · 5 rows
5Run selected reports
- 1
Install the Add-on
Install Consent Mode Monitor from the Google Workspace Marketplace.
- 2
Open the sidebar
In Google Sheets, go to Extensions → Consent Mode Monitor → Open Sidebar.
- 3
Add your licence key
Paste the licence key you received by email. Each Google account that uses the Add-on needs one.
- 4
Choose your input
Select website URLs for Site scoring, or GTM container IDs for GTM scoring.
- 5
Run the reports
Click Run selected reports. The results are written into new tabs in your spreadsheet.
Website URLs
Check website URLs in bulk.
Select a list of websites and run Site scoring. The Add-on looks for the GTM container on each site and returns what it finds, row by row.
Use the list you have
Select the URLs already in your sheet and run the report on that selection.
GTM detection
See the GTM container detected on each website, where one can be found.
Consent signals
See each site's consent status and the Default and Update values of the main consent signals.
Page and platform details
Results also show details such as the consent platform detected and whether the scan was blocked.
GTM container IDs
Check known GTM container IDs.
If your list already has container IDs, score them directly with GTM scoring. Use this route when you already know which containers you need to review.
Known GTM IDs
Use IDs in the GTM-XXXXXXX format from your sheet, or reuse the GTM keys from your Site scoring results.
A score for each container
0 means no issues were detected by the checks; a more negative score means more issues.
Tag-level detail
See total tags, gatekeepers and the tags with ad, analytics or functional storage issues.
Results in Sheets
Keep your scan results together for review.
Each report adds its results to your spreadsheet, so you can compare rows, spot the ones that need attention and plan follow-up with your team.
Keep URL or GTM ID inputs next to the results they produced.
Add your own columns for notes, owners and next steps.
Share the spreadsheet with the people responsible for the changes.
Repeatable checks
Run the same list again whenever you need to.
Your list stays in the spreadsheet, so a follow-up check is a matter of selecting the rows and running the report again.
Re-runs you start yourself
Running a list again is a manual step. To run checks automatically, set up the Scheduler.
Ongoing monitoring
Schedule recurring checks from Google Sheets.
Use the Scheduler card in the sidebar to choose a daily, weekly or monthly frequency and save the schedule. The Add-on then runs the checks without you repeating the setup each time.
Daily
Run the scheduled checks every day.
Weekly
Run the scheduled checks every week.
Monthly
Run the scheduled checks every month.
Useful for teams that look after many sites and want an ongoing record of results in Google Sheets.
SchedulerCMM sidebar
Frequency
- RangeSites!A2:A6
- Result tabSiteScoringResults
Save schedule
Who it's for
Built for teams reviewing more than one website.
Use the Add-on when the work covers a portfolio or a client list. The results support technical review; they don't replace legal advice.
Agencies
Work through client website lists in one shared spreadsheet.
Brands with many domains
Check regional and brand sites from the same list.
Analytics and implementation teams
Find the containers and tags that need attention before changing GTM.
Privacy and compliance teams
Keep technical scan results together for internal reviews and follow-up checks.
Google Workspace Marketplace
Install the Add-on and start free.
Install it from the Google Workspace Marketplace. You can start on the free plan; paid plans add higher usage, and each Google account that uses the Add-on needs a licence key.
Google Sheets Add-on FAQs
Website URLs, with Site scoring, and GTM container IDs in the GTM-XXXXXXX format, with GTM scoring. You can also run GTM scoring on the GTM keys found by a Site scoring report.
Yes. Each Google account that uses the Add-on needs at least one licence key, and you paste it into the sidebar before running a report. The key is sent to you by email when you choose a plan; see Sheets plans and licence keys.
Yes. You can start free, with no credit card required. Paid plans add higher usage limits or usage-based billing. See Sheets plans for current limits and prices.
When you click Run selected reports, the Add-on writes the results into new tabs in your spreadsheet, such as SiteScoringResults for Site scoring and GtmScoringResults for GTM scoring.
Site scoring returns, for each website, the GTM key detected, its consent status, the Default and Update values of the main consent signals, consent-platform details and screenshot links. GTM scoring returns a score, total tags, gatekeepers and the tags with ad, analytics or functional storage issues.
Each result row includes State and Error Message columns, so you can see which rows didn't complete. If a website blocks the scan, try its GTM container ID with GTM scoring instead.
Yes. Use the Scheduler card in the sidebar to run checks daily, weekly or monthly. You can also re-run a list yourself at any time.
Select the rows again and click Run selected reports. Choose a new result tab name if you want to keep the earlier results alongside the new ones.
No. It doesn't request access to your GTM containers and doesn't make changes in GTM. See the Google Sheets Add-on Privacy Policy for the data it sends.
Start with CMM
Turn your site list into a consent review.
Start with website URLs or GTM IDs and keep the results with the rest of your review work in Sheets.