GA spreadsheet addon with GA4 metrics

[HB]

How do I use the GA Spreadsheet Addon with GA4 dimensions and metrics? In the report builder I only see my UA property but not GA4.

Also in the GA4 Dimensions & Metrics Explorer, I'm being asked to login to see the reference but when I try to login, I see the error, "This app is blocked.This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access."  I enabled the "let less secure apps access your Google account" but that did not work. 

How do I resolve this?

[Mark Sorkin]

The current plug-in for GA UA does not work with GA4

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/b538bba6-bbb9-488b-97ff-70ed74202b1en%40googlegroups.com.

--

Mark Sorkin

SabinoDb, LLC

Co-Founder and Vice President Data Sciences

Mobile  (847) 828-1522

Email    Mark....@Sabinodb.com

[HB]

Thanks. Is there a Spreadsheet Addon that also works with GA4?

[Mark Sorkin]

HB

The is one in the App Store that really

Sucks. They are working on a GA4

Version. Holding my breath or there

Are 10M of us that are screwed.

10M current downloads of the UA 

Plug-in

To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/7615f7ec-a7ea-482f-97a6-0b5faffb9f33n%40googlegroups.com.

[Michele Pisani]

Hi guys,

for GA4 solution, I create this add-on that helps you view and edit Google Analytics 4 data more easily in Google Sheets.

It works similar to the good old add-on for Universal Analytics, as it is *FREE*: https://workspace.google.com/marketplace/app/ga4_magic_reports/6532356327

[Bill Denneen]

This is exactly what I needed. Thank you!

[Andy Page (DarkUFO)]

It's an awesome Add-on, I've been using it a lot :)