Use this tag for questions about interacting with Google Sheets programmatically.
I'm stuck on a something basic. How do I pass arguments to a Google Sheets custom function. I have a …
google-apps-script google-sheets arguments custom-functionI have written some code for my Google spreadsheet with the script editor. I want to share this spreadsheet with …
google-apps-script google-sheetsI need a color scale on a row or column in Google Spreadsheet, like the one provided by Microsoft Office …
google-apps-script google-sheets google-docs gs-conditional-formattingI have a Google Spreadsheet with two separate sheets. The first one is just a big list of names and …
sorting filter google-sheets array-filterSPECIFIC FOR: "NEW" google sheets only. This is a known issue as highlighted by google in the new sheets. Issues: …
google-apps-script google-sheets google-sheets-custom-functionI'm using Google Spreadsheet. To illustrate my problem, I use the range A2:A8 for the data validation of D2 …
google-sheets formula spreadsheetUsually don't need help with sheets but I think my brain is imploding from thinking on this too much. Trying …
google-sheets sumifs array-formulasAnother problem with Google Spreadsheet API. I'm trying to use QUERY() function in order to get all customers from our …
google-sheets google-sheets-formula google-sheets-queryI'm new to Google Apps Script. I want to get the value of a specific cell by it's column name, …
google-apps-script google-sheetsDoes anyone know if there is any official documentation for google spreadsheet embed URL paramaters? That is, given an embed …
google-sheets embed query-string