Use this tag for questions about interacting with Google Sheets programmatically.
I want to calculate the number of days passed between past date and a current date. My past date is …
date google-sheets datediffI see most examples from Google is they use only functions in a single giant script. e.g. https://developers.…
google-apps-script google-sheets global-variables google-docsSo I'm stuck with something. I have two spreadsheets, column A on each are similar but not identical, some values …
google-sheets google-sheets-formula gs-vlookupUsing Google Apps Script, is there a way to write the values in a Google Spreadsheet array to a range …
arrays google-apps-script google-sheetsI have data in one google docs. Call it docA. I would like to reference this data in docB. Something …
google-sheets formulasI've generated chart form google spreadsheets. In my report for horizontal axis I have values: 1 ,2 ,3 ,4 ,5 ,10 ,20 ,30 ,40 ,50 ,100 ,200 ,300 ,400 ,500 ,600 ,700 ,800 ,900 ,1000. Chart interprets them as a …
google-docs google-sheets google-visualizationI'd like to be able to delete an entire row in a Google Spreadsheets if the value entered for say …
google-apps-script google-sheetsI want to union ranges from any Google spreadsheets. The example Sheet1!A:A {12, 131, 45} Sheet2!A:A {12, 131, 46} The unknown function =…
arrays google-apps-script google-sheets google-sheets-formulaI've made a script that every few hours adds a new row to a Google Apps spreadsheet. This is the …
performance google-apps-script google-sheetsI've written a custom Google Apps Script that will receive an id and fetch information from a web service (a …
google-apps-script google-sheets custom-function