There is a built-in GA4 connector inside Google Sheets that most guides completely miss. Here is what it can do, who can actually use it, and what to do if you are locked out.
Open any Google Sheet, click Data in the top menu, and look for "Data connectors." If you see "Connect to Google Analytics 4" listed there, you have access to something most tutorials never mention: a native, no-add-on GA4 connector built directly into Google Sheets.
Most people have never seen this option. There is a reason for that, and it has nothing to do with a hidden setting you need to enable.
What the Built-In GA4 Connector Actually Is
Google Sheets has a feature called Data connectors: a framework that lets you connect a sheet to an external data source and query it using a structured interface or SQL-like syntax. Google has built first-party connectors for BigQuery, Looker, and Google Analytics 4.
The GA4 connector within Data connectors is separate from the Google Analytics add-on that most guides recommend. It does not require installing anything from the Marketplace. It appears directly inside the Data menu, treats GA4 as a live data source, and lets you run queries that write into the sheet without any scripting.
This feature has been available since Google expanded Connected Sheets capabilities in 2022, but coverage of it in marketing blogs remains almost nonexistent. Searches for "google sheets ga4 connector" return hundreds of articles about the add-on and almost nothing about this built-in option.
The Catch: This Is a Google Workspace Feature
Here is why you may never have seen this option: it is only available to Google Workspace Business Standard and above.
The tier breakdown:
- Personal Gmail accounts, no Data connectors menu visible for GA4.
- Google Workspace Starter, no GA4 Data connector (BigQuery connector also unavailable).
- Google Workspace Business Standard. GA4 Data connector available.
- Google Workspace Business Plus and Enterprise, available.
- Google Workspace for Education Standard and Plus, available.
This paywall is significant. Business Standard starts at $14 per user per month as of mid-2025. For a five-person team, that is $70/month just for the Workspace tier that unlocks this feature: before you have spent anything on analytics tools.
If you opened Google Sheets right now and could not find "Connect to Google Analytics 4" under Data, you are almost certainly on a lower Workspace tier or a personal Gmail account. You have not misconfigured anything; the feature simply does not exist for your account type.
What It Can Do
For teams that do have Business Standard or above, the built-in connector has some genuine advantages.
Direct query without add-on dependencies
The connector runs inside the sheet itself. There is no third-party add-on token to refresh, no Marketplace listing to keep updated, and no separate authentication flow beyond your standard Google account permissions. If you have Viewer access to the GA4 property in Google Analytics, the connector inherits that access automatically.
Structured metric and dimension picker
The connection interface presents a searchable list of all GA4 dimensions and metrics. You do not need to know API field names. Select date range, dimensions, and metrics from a visual interface, and the connector writes the data into a sheet range.
Scheduled refresh
Like other Data connectors in Sheets, the GA4 connector supports scheduled refresh. You can configure it to update daily, which is sufficient for most reporting use cases.
Native integration with Sheets formulas
Because the data lands in regular sheet cells, you can reference it with standard formulas, build pivot tables on top of it, and use it as a source for charts: all without any intermediate step.
What It Cannot Do
The built-in connector has real limitations that matter for power users.
No sub-daily refresh
The scheduler supports once daily at most. If you need hourly data for active campaign monitoring, this connector will not help. See GA4 in Google Sheets: How to Get Hourly Refresh for options.
No item-level e-commerce data
Like the GA4 Data API generally, this connector does not expose the items array from e-commerce events. You cannot pull product-level revenue or transaction detail through this path. That requires BigQuery export. See GA4 E-Commerce Data in Google Sheets: Why You Need BigQuery for Product-Level Detail.
Limited custom calculations
The connector does not support calculated metrics or blended fields. You get raw GA4 dimensions and metrics. Any derived calculations need to be built in Sheets itself using formulas on top of the exported data.
No multi-source blending
The GA4 Data connector handles GA4 only. You cannot join GA4 data with Stripe revenue or HubSpot contacts inside the connector itself. For multi-source blending, you need a separate solution.
Workspace dependency creates a sharing problem
If you build a report in a Business Standard sheet using the GA4 Data connector and share it with someone on a Starter plan or a personal Gmail account, they will see the data that was last fetched, but they cannot refresh it or modify the connector configuration. The sheet becomes read-only for the analytics layer for those users.
How to Access It (Step by Step)
If you have a qualifying Workspace account:
- Open a new or existing Google Sheet.
- Click Data in the top menu bar.
- Look for Data connectors near the bottom of the menu. If you see it, click it.
- A panel appears on the right side of the screen. Click Connect to Google Analytics 4.
- Authenticate if prompted: use the Google account that has access to your GA4 property.
- Select your GA4 account, property, and reporting view.
- In the query builder, add dimensions (e.g.,
date,sessionMedium,sessionSource) and metrics (e.g.,sessions,conversions,totalRevenue). - Set a date range.
- Click Apply to write the data to the sheet.
- To schedule refresh: with the Data connector panel open, click the gear icon and set a refresh schedule.
If Data connectors does not appear in the Data menu, your account does not have access. The next section covers what to do.
Alternatives for Non-Workspace Users
If you are on a personal Gmail account, Google Workspace Starter, or simply do not want to pay for Business Standard to unlock this one feature, you have several practical alternatives.
Google Analytics add-on (free)
The official Google Analytics add-on from the Google Workspace Marketplace works with any Google account. It provides similar dimension/metric selection and writes data to sheets. The downside is that scheduling is limited to once daily, and the add-on requires periodic re-authentication.
Apps Script with GA4 Data API (free, code required)
You can query the GA4 Data API directly from Apps Script using UrlFetchApp. This approach requires a Google Cloud project, service account credentials, and JavaScript, but it is free and gives you full control over scheduling, including hourly triggers.
brooked.io (paid, no-code)
brooked.io connects to GA4 and writes data to Google Sheets on schedules as frequent as every 15 minutes. It works regardless of your Workspace tier, requires no Google Cloud project, and handles authentication automatically. This is the fastest path for teams that are not on Business Standard and do not want to write code.
Supermetrics (paid)
Supermetrics for Google Sheets supports GA4 as a source and works with personal Gmail accounts and all Workspace tiers. It offers daily scheduling on base plans and hourly on higher plans.
Coupler.io (paid, limited free tier)
Coupler connects GA4 to Sheets with hourly refresh. Like brooked.io and Supermetrics, it works independently of your Workspace plan.
Comparison Table
| Method | Works on Personal Gmail | Works on Workspace Starter | Minimum Refresh | No-Code | Cost |
|---|---|---|---|---|---|
| Built-in GA4 Data connector | No | No | Daily | Yes | Included with Business Standard ($14/user/mo) |
| Official GA4 Add-On | Yes | Yes | Daily | Yes | Free |
| Apps Script | Yes | Yes | Hourly (configurable) | No | Free (dev time) |
| brooked.io | Yes | Yes | 15 minutes | Yes | Paid |
| Supermetrics | Yes | Yes | Hourly (higher plans) | Yes | Paid |
| Coupler.io | Yes | Yes | Hourly | Yes | Paid (free tier) |
The Real Value Proposition: When to Pay for Business Standard vs. Use an Alternative
The question teams actually face is: "Should we upgrade to Google Workspace Business Standard to get this connector, or should we use a different tool?"
Here is a framework for thinking about that:
Upgrade makes sense if you were already considering Business Standard for its other features, 2 TB of Drive storage per user, video conferencing with 150 participants, enhanced Meet features, and better admin controls. In that case, the GA4 connector is a bonus, not the reason to upgrade.
Upgrade does not make sense if the sole reason is the GA4 Data connector. At $14/user/month, a five-person team pays $840/year to unlock a connector that does the same job as free alternatives. The math does not work unless you value the Workspace upgrades independently.
The alternative is always available: The official Google Analytics add-on is free and covers the same daily-refresh use case. Third-party connectors like brooked.io cost less than a Business Standard upgrade for small teams and provide sub-daily refresh the built-in connector cannot match.
There is also a governance consideration. Some teams prefer the built-in connector because it does not involve a third-party service with access to GA4 data. If your organization's security policy requires minimizing third-party data access, the native connector (assuming you are already on Business Standard) removes that concern entirely.
Troubleshooting
"Data connectors" does not appear in my Data menu. You are on a Google account tier that does not include this feature. Confirm your Workspace tier in Admin Console. Upgrading from Starter to Business Standard will enable it.
I see Data connectors but Google Analytics 4 is not listed. Check that your Google Cloud project has the Google Analytics Data API enabled and that your account has the Analytics Viewer role on the GA4 property. Occasionally, a browser cache issue hides the connector; try in an incognito window.
The connector is connected but returns no data. Confirm the GA4 property ID is correct and that there is data in the date range you selected. Properties with sampling applied to large date ranges may return empty results: reduce the date range and test.
Scheduled refresh stopped working. This typically happens when the connecting Google account's GA4 property permissions are revoked or changed. Open the Data connector panel, disconnect, and reconnect using the correct account.
A colleague cannot see the Data connector tab I set up. If they are on a lower Workspace tier, they can view the data already in the sheet but cannot interact with the connector. Share a static copy or use an alternative method (such as brooked.io) that works for all account types on your team.
Bottom Line
The built-in GA4 Data connector in Google Sheets is a genuinely useful feature for teams on Google Workspace Business Standard or above. It is zero-add-on, inherits your existing GA4 permissions, and integrates cleanly with the rest of Sheets.
The problem is that it is behind a $14/user/month Workspace paywall that many small teams and individual practitioners simply do not have. For everyone else, the Google Analytics add-on covers daily reporting for free, and tools like brooked.io handle sub-daily refresh without any Workspace tier requirement.
Do not spend hours trying to unlock a feature your account does not support. Know which tier you are on, and pick the tool that works for your situation.
Connect GA4 to Google Sheets, No Workspace Upgrade Required
brooked.io works with every Google account type, refreshes every 15 minutes, and takes under 10 minutes to set up. Start free at brooked.io, no Workspace Business Standard required.
Related guides on brooked.io:
- GA4 in Google Sheets: How to Get Hourly Refresh (Not Just Daily)
- GA4 E-Commerce Data in Google Sheets: Why You Need BigQuery for Product-Level Detail
- How to Combine Stripe, HubSpot, and Google Analytics Data in One Google Sheet
Troubleshooting quick reference
Frequently asked questions
Is the built-in GA4 connector the same as the Google Analytics add-on?
No. They are two separate products. The add-on is a Marketplace extension that installs into your sheet. The Data connector is a native Sheets feature that appears in the Data menu. Both ultimately use the GA4 Data API, but they have different interfaces, scheduling options, and Workspace tier requirements.
Can I use the built-in connector for GA4 Universal Analytics properties?
No. The Data connector is GA4-only. Universal Analytics (UA3) properties are also no longer active as of July 2023, so this distinction is mainly relevant for historical migration context.
Does the built-in connector count against GA4 API quota?
Yes. Each refresh consumes API quota against your GA4 property's daily limit of 10,000 requests. For typical use (one daily refresh of a few reports), this is not a concern.
Can multiple people in my organization use the same connector configuration?
The connector is tied to the Google account that authenticated it. Other users can view the data, but only the owner can modify the connection or trigger a manual refresh, and only if they are on Business Standard or above.
What happens to my sheet if I downgrade from Business Standard to Starter?
The data that was fetched remains in the sheet. The connector configuration is preserved but cannot be used or refreshed. You would need to switch to an alternative method to continue pulling new data.
Ready to connect your data to Google Sheets?
Brooked's free tier covers 100 imports per month with AI Analyst included, no credit card required.
Install Brooked free →
