Google Spread Sheet Api Not work

[adeloche2]

I created an API key in Google Cloud Console and enabled the Google Sheets API.
Then, I copied both the API key and the sheet key into the UTC interface, but no data was retrieved.

The same API key and sheet key work perfectly when used in the vMix Data Sources settings — data loads without any issues there.

Steps to Reproduce

1. Create an API key in Google Cloud Console.
2. Enable Google Sheets API.
3. Paste the API key and sheet key into the UTC interface.
4. Try to fetch the spreadsheet data.

Expected Behavior

UTC should retrieve and display the spreadsheet data using the provided API key and sheet key.

Actual Behavior

No data is retrieved in UTC, even though the same credentials work in vMix Data Sources.

[elgarf]

Do you paste full URL in UTC or just sheet key? 🤔

[adeloche2]

I tried the sheet key, and just to make sure I also tried the full URL.

[elgarf]

Can I test your sheet/api keys? You can send me them to elgarf@outlook.com