The Scenario
You are an analytics engineer. The tagging review is next Tuesday. Your stakeholders need to sign off on which of the 40 key events on your GA4 property are actually business-relevant and which are legacy leftovers from two implementations ago.
The GA4 Admin panel shows the list of key events. It does not show how many times each one fired last month. To get counts, you go to the Reports section, run a separate query, and cross-reference the two lists — which means two separate data pulls and a manual VLOOKUP in Excel, with the added risk that event names are sometimes capitalized differently between the Admin list and the Reports export.
The bad version of this week:
- Screenshot the 40 key events from GA4 Admin
- Export event counts from GA4 Reports as a CSV, import into Excel
- VLOOKUP the count against the event name for each of the 40 events
- Find that 8 event names are capitalized differently in the two sources
- Manually fix the case, redo the VLOOKUP for those 8
- Walk into Tuesday's review with a table you are not fully confident in.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that can list GA4 key events and pull last-month counts in a single operation — no VLOOKUP, no case alignment.
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 into the Audit tab of my workbook starting at row 2 with headers in row 1.
SheetXAI calls the GA4 Admin API to list key events and the Data API to pull counts, aligns both datasets by event name, and writes the joined result into the Audit tab.
What You Get
A clean two-column reference table in the Audit tab:
- Row 1 — headers: Key Event Name, Last Month Count
- 40 rows — one per configured key event
- Sorted by count descending — highest-volume events at the top
- Zero for events that fired zero times — informative, not blank
Zeros are the most useful signal for the review. An event configured but inactive for a month is a deletion candidate. SheetXAI writes zero explicitly so you can filter for it.
What If the Data Is Not Quite Ready
Tagging audits surface messy histories. SheetXAI handles them inline.
When you want three months of counts side by side
One month of zero does not confirm the event is dead — it might be seasonal. You want October, November, and December counts in separate columns.
List all key events on my GA4 property. For each, pull event counts for October 2025, November 2025, and December 2025 as separate columns. Write the result into the Audit tab at row 2 with headers in row 1: Key Event Name, Oct Count, Nov Count, Dec Count.
When you want a Status column for the review
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 into the Audit tab at row 2 with headers in row 1.
When some event names look like duplicates from old implementations
You suspect some events track the same thing under different names.
List all GA4 key events with last-month counts and write the table into the Audit tab. After writing, 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.
When you want the full audit package in one shot
You need the event list, three-month counts, status flags, a count of inactive events, and a one-sentence summary — all formatted for a stakeholder who has never opened GA4.
List all key events on my GA4 property. Pull counts for October, November, and December 2025. Add a Status column (Active above 100, Low Volume 1-100, Inactive 0). Sort by December count descending. Write the table into the Audit tab at row 2 with headers in row 1. Then write a one-sentence summary in cell E1: "X of 40 key events fired zero times in December."
The pattern: instead of a two-source VLOOKUP with capitalization problems, you describe the audit table you need and SheetXAI produces it directly from the API.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull your GA4 key events with last-month counts into your workbook. The Google Analytics integration is included in every SheetXAI plan. See also how to export GA4 custom dimensions and metrics for documentation in Excel or the Google Analytics in Excel overview.