I can not take data using JSON or XML Driver. I have made this link from Google Sheet. It always show 302 for JSON Driver and 1 for XML Driver

JSON Driver Link:
https://script.google.com/macros/s/AKfycbyphn30XSQYPcDdRzKcZ1_W7XnQwVYq95fQJraa9bzkkuB8_ErQFnLlFYYkyGU52j86AA/exec

XML Driver Link:
https://docs.google.com/spreadsheets/d/1zU-v9ubtb8QH7dm1CV4e8sNwpddIsjfTh4w5VUQtJsc/gviz/tq?tqx=outml">https://docs.google.com/spreadsheets/d/1zU-v9ubtb8QH7dm1CV4e8sNwpddIsjfTh4w5VUQtJsc/gviz/tq?tqx=outml

I feel like you will want to use the Google Sheets API for this which will require an API key but should work well with the VTScada driver to get a JSON response to your API request.

The URL would look something like:

https://sheets.googleapis.com/v4/spreadsheets/{SPREADSHEET_ID}/values/{RANGE}?key={YOUR_API_KEY}