Consent Mode Monitor Google Sheets™ Extension
Using Consent Mode Monitor’s Google Sheets™ extension is the easiest way to check the compliance of countless websites.
How to use the Consent Mode Monitor Google Sheets™ add-on
Turn a sheet into a fast consent audit dashboard. Score GTM containers in bulk and pull a line-by-line report you can share with legal, analytics, or clients.
Step 1: Get a licence key (free to start)
Grab a free trial key to evaluate the add-on. You can upgrade later for higher limits and automation.
You’ll need: at least one licence key per Google account using the add-on. Find the link to get the licenses below.
Step 2: Install the add-on
Install Consent Mode Monitor from the Google Workspace™ Marketplace (link coming soon). It adds the CMM_* formulas to your Sheets environment.
Step 3: Set up your sheet & use the add-on
After installing the add‑on, place your licence key in a dedicated cell so all formulas can reference it. In our example, we put the key in E2. You can then reuse $E$2 as an absolute reference across every formula.
Get a GTM container ID (from a URL)
If you only have URLs, first extract the GTM container ID with the formula below, then reference that GTM container ID value in later steps. In our example image, the website URL is in A2, and we place this formula in B2:
// Use:
=CMM_GTM(CMM_KEY_Cell, Website_URL_Cell)
// Example (key in E2, URL in A2, result in B2):
=CMM_GTM($E$2, A2)
The above example formula returns a GTM‑XXXXXXX container ID for the site in A2.
Get the Consent Mode Monitor score
Next, calculate the Consent Mode Monitor health score for each GTM container you extracted.
// Use:
=CMM_SCORE(CMM_KEY_Cell, GTM_Container_ID_Cell)
// Example (key in E2, GTM ID in B2, score in C2):
=CMM_SCORE($E$2, B2)
Fill down to score for every site in your list.
Get the detailed Consent Mode Monitor report (with headers)
To pull a column‑friendly Consent Mode Monitor detailed report, use SPLIT with the || delimiter.
// Headers Use:
=SPLIT(CMM_REPORT_HEADERS(), "||")
// Example (place above your data block):
=SPLIT(CMM_REPORT_HEADERS(), "||")
// Row data Use:
=SPLIT(CMM_REPORT(CMM_KEY_Cell, GTM_Container_ID_Cell), "||")
// Example (key in E2, GTM ID in B2):
=SPLIT(CMM_REPORT($E$2, B2), "||")
Note: CMM formulas take a GTM Container ID as input, not a website URL. Always pair your URL list with the GTM extraction step above to generate the IDs before calling CMM_SCORE or CMM_REPORT.
Pricing for the Google Sheets™ add-on
Turn any sheet into a consent audit dashboard. Extract GTM IDs, score containers, and export line-by-line reports for evidence. Start free to try the workflow, then upgrade for higher limits or usage-based billing.