Category "google-sheets"

Call a Google Sheets add-on within a Google Apps Script?

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

Google Spreadsheet with data from WebSocket

I want to write a custom script using Google Apps Script for Spreadsheet that gets data from WebSocket. Is there a way doing so?

how to combine many google sheets in one sheet by using query

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

Get date value from header

I'm trying to use Google Sheets as a JSON backend. The JSON output is here: "gsx$company": { //all is ok "$t": "Company name"

How to sort sheets within a spreadsheet in chronological order by date in google apps script

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

How to prevent rows combining in pd.read_csv() google sheets

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

How to automatically add data to another sheet when a specific cell's values changes?

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

How to use REGEXEXTRACT for day and time?

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

How to do I locate a Google SpreadSheet ID?

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