Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

GA4 Admin API from a Google Sheet

I'm trying to create GA4 properties from a Google Sheet using the Creating a GA4 property with GA4 Admin API instructions below:

brandoncaballer_0-1708146942801.png

And I've gotten it to work in the Extensions > Apps Script when I run it, however, using the function option in the Google Sheet keeps giving me the following error.

ErrorGoogleJsonResponseException: API call to analyticsadmin.properties.create failed with error: Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project. (line 2).

1 0 397
0 REPLIES 0