I'm trying to create GA4 properties from a Google Sheet using the Creating a GA4 property with GA4 Admin API instructions below:
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).