We are using Azure Data Factory to load GA4 data and Ads API data to data warehouse. To make the connection we have a Google Cloud project and use its credentials to authenticate.
I have setup ADF so that it will use a refresh token to get a new access token. The problem that im having is that refresh token expires in 7 days.
My understanding is that to expand the refresh token I need to publish the cloud project. I have done this in https://console.cloud.google.com/apis/credentials/consent . Under "Publishing status", I have clicked the "Publish app" button. Its currently showing "In production" and has a button labelled "Back to testing".
Sadly the refresh token still expires in 7 days. What am i missing or doing wrong? Is there some other place to publish the app?
At the moment i'm using developer playground to generate the refresh token. https://developers.google.com/oauthplayground/
Access token is generated trough https://www.googleapis.com/oauth2/v4/token API call.