Publishing data from Aggregate to Google Sheets

Continuing the discussion from Issue with publishing data in ODK Aggregate into Google Spreadsheet:

I am having the same problem although I have publish some form data to Google sheets which are working fine and if now try to publish the same data to a new Google sheet they aren't working and being struck at active state

Please note that Central is now the ODK server and that Aggregate has not been supported since May 2021. Please see this post for more details: