External collection Google Sheet not load datas

I’m a beginner with Adalo and I’ll explain my problem: I configured the link with the external collection (Google Sheets) by the endpoint provided by Google and everything works in fact doing the link test via the Adalo screen returns me the json with the correct data.
On Google Drive I shared the file with the service account.
In the “Image list” menu I selected the right collection, but I can’t get the data from Google Sheets.

Can anyone help me?
If you need more information please let me know.

Many many thanks

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.