I have done many searching about how to connect the google sheet as a database,
I know it can just simply use OPEN LINK function to add the URL link to read the file,
but is there any ways to extract specific data to global variables?
For example, I want the data from Google sheet cell A3 and store it to a global variable. Is there any possible ways (e.g. Javascript, Ajax, etc.) that can help?
Thanks