Use this tag for questions about interacting with Google Sheets programmatically.
I'm trying this function on Google spreadsheet without success in order to gather in a sheet a value after a …
google-sheets google-sheets-formula google-sheets-query gs-vlookup importrangeHow do you get the literal value (the formula) from a cell instead of the result value? EXAMPLE DESIRED: A2: "…
google-sheets google-sheets-formulaI have created a server side application in PHP that's supposed to work with Google Spreadsheets. I'm able to authenticate …
php list google-sheets sharedI'm trying to get a sense of the viability of replacing some of my Microsoft Excel spreadsheets with Google Doc …
google-apps-script google-sheets keyboard-shortcutsIn OpenOffice Calc, one can change number format between standard United States, with decimal separator being a period ., and the …
google-sheets number-formatting openoffice-calcProblem: When I run the script, Google tells me, You do not have permission to call openById I had copied …
google-apps-script google-sheets google-apps-script-addon google-sheets-custom-functionI am trying to determine how to get a script to take data from a spreadsheet and fill out a …
google-apps-script google-sheets google-formsI basically have small images in a table that I'd like to enlarge on mouse click. I'd like the enlarged …
google-apps-script google-sheets google-spreadsheet-apiWhat is the way to get the first and last day of the previous month in Google Spreadsheet? I tried …
google-sheets formula worksheet-functionHow can I upload a local CSV file to Google Drive using the Drive API v2 so that the uploaded …
csv google-drive-api google-sheets