The Scenario
Your IT security team received a request from legal: produce a complete list of everyone with access to your company's Yandex Metrica counters, their permission level, and when access was granted. The request came in Monday morning. They need it by Thursday for an external compliance review.
You manage one of the counters. Two others are managed by a vendor. The fourth was set up by a contractor who left eight months ago and nobody is sure who inherited the admin credentials.
The Metrica UI shows you the grants for the counter you manage. For the others, you are relying on whoever you can track down.
The bad version:
- Log into Metrica, open your counter, click Access, type each user and permission into a spreadsheet row by row — eight users, eight rows, eight fields each
- Email the vendor asking for the same data from their two counters, wait two days, receive a PDF screenshot that you have to retype
- Give up on the fourth counter for now and note "access unknown" in the spreadsheet, which will generate a follow-up question from legal that costs another hour
This is the scenario where manual data collection adds three days to a one-hour task.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. Through the Yandex integration, it can retrieve the full grants list for any counter you have credentials for and write every field — login, permission type, grant date — directly into your sheet.
List all grants for Yandex Metrica counter 11223344 and write user login, permission level, and grant type into columns A, B, and C of this sheet. One row per grant. Add a header row.
What You Get
- Row 1: headers — User Login, Permission Level, Grant Type
- One row per access grant on the counter
- Permission level reflects the Yandex grant model: view, edit, or own
- If the counter has no grants listed (shared via a different mechanism), SheetXAI notes that in A2 rather than leaving the sheet blank
What If the Data Is Not Quite Ready
Multiple counters, one unified access roster
Legal needs one table covering all four counters, not four separate sheets.
For each counter ID in column A of the Counters tab, fetch all Yandex Metrica grants. Write counter ID into column A, counter name into column B, user login into column C, permission level into column D, and grant type into column E of the Access Roster sheet. One row per grant.
Flag accounts that have not logged in recently
Stale access is the most common compliance finding. You want to know which logins on the grants list have not been active in the last 90 days.
Fetch all grants for counter 11223344 and write user login, permission level, and grant type into columns A through C. In column D, flag any login that has not been active in the last 90 days as "Stale — review for removal" and mark the rest as "Active".
Highlight owner-level grants for immediate review
Owner access on an analytics counter is the highest privilege level. The compliance reviewer wants those flagged separately.
Fetch all grants for counter 11223344. Write user login, permission level, and grant date into columns A through C. In column D, write "High privilege — verify" for any row where permission level is "own", and "Standard" for all others.
Pull grants from all counters, deduplicate users who appear multiple times, and produce a summary count per user in one pass
Legal ultimately wants to know how many counters each user has access to — not just a flat row-per-grant list.
Fetch grants from all counters listed in the Counters tab. For each unique user login found across all counters, write the login into column A, the number of counters they have access to into column B, their highest permission level into column C, and a comma-separated list of counter IDs they appear on into column D of the Summary sheet.
That summary is the format legal actually wants. Building it from a flat export manually would take another hour.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where you are building the access roster, then ask it to pull grants from all your counters and flag the owner-level and stale accounts. See also: exporting goals and exporting traffic filters.