Encountered a problem where data changes in Google Sheets do not reflect in UTC time. Pressing the 'Reload' button also has no effect.Initially, the field 'Loaded rows' shows 0. Only after changing the row and column does it display results.
And another question. Is it possible to connect without using an API? It is feasible through VMIX itself if you import via a link from Google Sheets as Excel/CSV. In this case, only one sheet is connected (the number is contained in the link), but it's possible to connect several different sheets with necessary data this way. This method allows bypassing potential issues with API limits.
Encountered a problem where data changes in Google Sheets do not reflect in UTC time. Pressing the 'Reload' button also has no effect.Initially, the field 'Loaded rows' shows 0. Only after changing the row and column does it display results.
And another question. Is it possible to connect without using an API? It is feasible through VMIX itself if you import via a link from Google Sheets as Excel/CSV. In this case, only one sheet is connected (the number is contained in the link), but it's possible to connect several different sheets with necessary data this way. This method allows bypassing potential issues with API limits.