Top "Google-spreadsheet-api" questions

The Google Sheets API lets developers write third-party applications that read and modify any aspect of spreadsheets.

Sheet.getRange(1,1,1,12) what does the numbers in bracket specify?

Sheet.getRange(1,1,1,12) I cannot understand the arguments 1,1,1,12 . What is this - the sheet id or row or what? method getRange(…

google-apps-script google-sheets google-spreadsheet-api
Selecting Multiple Values from a Dropdown List in Google Spreadsheet

The Google Spreadsheet looks like can only select one value in the dropdown list. Is there any way to select …

google-sheets google-spreadsheet-api
How to automatically import data from uploaded CSV or XLS file into Google Sheets

I have a legacy database system (not web accessible) on a server which generates CSV or XLS reports to a …

google-apps-script google-sheets google-drive-api google-spreadsheet-api
Google spreadsheet api Request had insufficient authentication scopes

I'm making an script to read data from google spreadsheet using the following script on nodejs: var url = oauth2Client.…

node.js google-api google-spreadsheet-api
Retrieve rows from spreadsheet data using google app script

I am using Google app script to write form data to spreadsheet. Now I would like to fetch the values …

google-apps-script spreadsheet google-spreadsheet-api
Pushing data to Google spreadsheet through JavaScript running in browser

I am working on an web application where I would like to allow the user to push data to her …

javascript jsonp google-sheets cors google-spreadsheet-api
Google Spreadsheet - Insert cut/copied cells/rows

Google Spreadsheet doesn't have the functionality to "insert cut cells" like in Excel. Let's say I selected A4 to B5, …

google-apps-script google-spreadsheet-api
email notification if cell is changed

need help with google script. I have multiple row spreadsheet. Need a script that does the following: If any cell …

google-apps-script google-sheets google-spreadsheet-api
Get list of sheets and latest sheet in google spreadsheet api v4 in Python

I am trying to read and write values of different sheets in python 3 following the google official documentation. Though I …

python google-spreadsheet-api google-sheets-api
Is there a way to enlarge an image on mouse click in Google Sheets?

I 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-api