Use this tag for questions about interacting with Google Sheets programmatically.
It is possible to set number format to a cell with google apps script like cell.setNumberFormat("0.000"); I need to …
google-apps-script google-sheetsI am trying to set some value to a cell in a Google Spreadsheet: function exampleFunction() { var ss = SpreadsheetApp.getActiveSpreadsheet(); …
google-apps-script google-sheets permissions authorization google-sheets-custom-functionDoes anyone know if it's possible to use Google Apps Scripts to run without needed a manual event? Meaning - …
google-sheets google-apps-scriptI'm using FILTER to extract rows from a range, and want to take only certain columns. For example, I filter …
google-sheetsI am trying to setup a Google Form that will create a 'choose from list' question, with each option being …
google-apps-script google-sheets google-formsI have the requirement to embed a Google Docs spreadsheet on a webpage, but it needs to be just the …
embed google-docs google-sheetsHow to design a sheet script that would result in an active row being highlighted? I would like to have …
google-apps-script google-sheets formattingI am attempting to post form data to a google spreadsheet. Currently, if the form is validated, then the following …
jquery ajax google-apps-script google-sheetsI have one array 1 2 3 another array 4 5 6 How do I use one function to join the 2 arrays? 1 2 3 4 5 6
arrays google-sheets google-sheets-formulaI'm looking for a way to programmatically populate a spreadsheet that filters data from another spreadsheet based on the logged …
google-apps-script google-sheets google-query-language