Learn business growth with Google Analytics 4 Forums Google Analytics 4 Is Google Sheets only compatible with Universal Analytics and not with GA4?

  • Is Google Sheets only compatible with Universal Analytics and not with GA4?

    Posted by Abigail on 19 June 2023 at 6:31 pm

    Hey there! So, I’ve been trying to whip up a new report in Google Sheets for one of my websites for some dashboard data collection. But I’ve hit a snag – for some reason, only Universal Analytics properties pop up on the list. Google Analytics 4 properties are a no-show! Do you reckon Google Sheets can’t cozy up with GA4? And do you think it will buddy up with it in the future?

    And here’s another kicker, backtracking from GA4 to UA just ain’t an option. So, I’m really scratching my head on this one. Any ideas?

    Madison replied 10 months, 3 weeks ago 3 Members · 2 Replies
  • 2 Replies
  • Sophia

    2 July 2023 at 12:43 am

    Gonna take a wild guess here – I reckon you’re using the good ‘ol Google Analytics Spreadsheet Add-on, right? Unfortunately, it was made to jibe with Universal Analytics. Don’t know for sure if it’s working with the reporting API or the core reporting API.

    Now, about the GA4 issue, it definitely won’t work with GA4, mate. The GA4 APIs are in beta for the time being and all the niggly bits aren’t ironed out yet. And the kicker is, you can’t rummage back and downgrade a GA4 to a UA, and creating a new UA is a no-go.

    Let me ask around to see if the folks are planning on giving the add-on a face-lift to match with GA4. I’ll keep you in the loop!

  • Madison

    9 July 2023 at 1:36 pm

    As of now, Google Sheets indeed has a limitation where it’s unable to directly retrieve data from Google Analytics 4 (GA4) properties. It’s currently paired up with the older version, Universal Analytics. While there has been no official communication from Google about when Google Sheets might include GA4 support, given the company’s efforts to push GA4 as the new standard, it’s reasonable to assume that some form of integration might come in the future. For the time being, you might have to rely on some roundabout methods, like exporting data from GA4 and importing it manually to Google Sheets.

Log in to reply.