The Scenario
You are an analytics engineer. The tagging review is next Tuesday. Your stakeholders — a mix of marketing managers and a CMO who does not use GA4 — need to sign off on which of the 40 key events on your property are actually driving business decisions and which are legacy leftovers from three implementations ago.
The GA4 Admin panel shows you the list of key events. It does not show you how many times each one fired last month. To get event counts, you need to go to the Reports section, run a separate query, and cross-reference the two lists manually. You also need to export both sets of data, align them by event name, and put the result in a format non-GA4 users can read.
The bad version of this week:
- Open GA4 Admin → Conversions → screenshot the list of 40 key events
- Open GA4 Reports → Events → filter to last month, export CSV of event counts
- Open both in Google Sheets, VLOOKUP the count against the event name for each row
- Realize 8 event names in the Admin list are capitalized differently from the Reports export
- Manually align the cases, redo the VLOOKUP for those 8
- Format the table for stakeholder readability
- Walk into Tuesday's review with a table you are not fully sure is right because of the capitalization issue.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that can list your GA4 key events and pull last month's event counts in a single operation.
Open the SheetXAI sidebar and type:
List all key events configured on my GA4 property. For each one, also pull its total event count from last month. Write event name and count as two columns into my Google Sheet starting at A1. Add a header row.
SheetXAI calls the GA4 Admin API to list key events and the Data API to pull event counts, aligns the two datasets by event name, and writes the joined result into your sheet. The capitalization alignment happens at the API level — you do not need a VLOOKUP.
What You Get
A clean two-column reference table:
- Column A — Key Event Name (as configured in GA4 Admin)
- Column B — Total Events Last Month
- 40 rows — one per configured key event
- Sorted by event count descending — highest-volume events at the top
Events that fired zero times last month show zero, not blank. Zero is informative — it tells you the event is configured but inactive, which is the most useful signal for the tagging review.
From this table, your stakeholders can immediately see which events are active versus dormant, and you can ask SheetXAI to flag any event with zero count in a third column for the review discussion.
What If the Data Is Not Quite Ready
Tagging audits surface messy histories. SheetXAI handles them inline.
When you want to see three months of counts, not just one
One month of zero does not mean the event is dead — it might be seasonal. You want October, November, and December counts side by side.
List all key events on my GA4 property. For each one, pull event counts for October 2025, November 2025, and December 2025 as separate columns. Write the result into my Google Sheet at A1 with headers: Event Name, Oct Count, Nov Count, Dec Count.
When you want a "Status" column for the review deck
Your stakeholders want to see Active, Low Volume, or Inactive at a glance without reading the numbers.
List all GA4 key events with last-month counts. Add a Status column: "Active" if count is above 100, "Low Volume" if count is 1 to 100, "Inactive" if count is 0. Write the table at A1.
When some event names look like duplicates
You suspect some events are tracking the same thing under different names from two historical implementations.
List all GA4 key events with last-month counts. After writing the table at A1, look for event names that appear to be near-duplicates (same base action, different prefixes or suffixes like purchase vs. ecommerce_purchase). Flag those pairs in a Notes column so I can investigate during the review.
When you want the full audit package in one shot
You need the event list, the three-month counts, the status flags, and a count of how many events are inactive — all formatted for a stakeholder who has never opened GA4.
List all key events on my GA4 property. Pull event counts for October, November, and December 2025. Add a Status column (Active / Low Volume / Inactive by the thresholds above). Sort by December count descending. Then write a one-sentence summary in cell E1: "X of 40 key events fired zero times in December." Format the whole table with bold headers.
The pattern: instead of a two-source manual join with a VLOOKUP, you describe the audit table you need and SheetXAI produces it — join, counts, and status flags included.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull your GA4 key events with last-month counts into any sheet you have open. The Google Analytics integration is included in every SheetXAI plan. See also how to export GA4 custom dimensions and metrics for documentation or the Google Analytics in Google Sheets overview.