I'm trying to get data from Google Finance in Google Sheets with this formula: =GoogleFinance("CURRENCY:BTC") But I'm getting this error: GOOGLEFINANCE, the
I'm not sure where to post this question but I thought here would be a good spot. What would be a Google Sheets formula to see if I am on track to stay within m
I have a Google Apps Script custom function, very simple: function sharesBurned(sharesToSell) { return "tree" } Obviously, this works when I test it in
I am wondering if you can point me to an example of reading/writing to/from a google doc/spreadsheet using python. I did look at google docs API here https://
Is it possible to call a Google Sheets add-on as if it were a function in an Apps Script? I am trying to automate a few steps like this: Import/append data fr
I want to write a custom script using Google Apps Script for Spreadsheet that gets data from WebSocket. Is there a way doing so?
I created two online sheets and tried to collect them in another one sheet by query but there a missing data although it's exists in the original sheets (data s
I'm trying to use Google Sheets as a JSON backend. The JSON output is here: "gsx$company": { //all is ok "$t": "Company name"
I am attempting to sort the sheets within my spreadsheet in chronological order. They are all dates in the same format (MM-dd-yyyy), but I am unsure of how to t
I'm seeing an odd behaviour where the first 5 rows in my google sheet are combining to one row in my dataframe. This is the output from df.columns.values: ['bus
I have a sheet with the pricing of different products. These prices are updated very frequently, and I would love to find a solution whereby, whenever I change
I am using a third-party app that allows me to log in my day, time and location at the push of a button, on a google sheet. (source: imggmi.com) While the app c
https://developers.google.com/apps-script/guides/rest/api#parameter_and_return_types When using the Google Execution Api for Java, the ID of the spreadsheet is