Top "Google-spreadsheet-api" questions

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

Google Spreadsheets API with OAuth2.0 using Javascript

I'm trying to access a private Google Spreadsheet using Javascript. I have sucessfully authorized with OAuth2.0 and can see a …

javascript oauth-2.0 google-spreadsheet-api
Authorizing requests with OAuth 2.0 in Google Spreadsheet API

I am trying to create a PHP web page that requires reading some data from a google spreadsheet in my …

oauth google-sheets google-data-api google-spreadsheet-api
Browser Pop up in Google Apps Script

Background: I have prepared a form in HTML Service in Google apps script which I call with DoGet function from …

javascript html google-apps-script google-spreadsheet-api google-caja
RegEx to match 2 or more digits in a string

Suppose I have strings like: ABC-L-W7P-1423 ABC-L-W7E-87 CH-L-W7-756 I need to grab the number at the end. …

regex google-sheets google-spreadsheet-api re2
How can I retrieve the hyperlink from a data cell in google apps script?

I am using SpreadsheetApp.getActiveRange().getValues(); to get the value of a range of cells, but it doesn't return the …

google-apps-script google-sheets google-spreadsheet-api
How to get public Google Spreadsheet data using Google Spreadsheet API Java library without authentication

-what I want to do I would like to get data from Google Spreadsheet using Google Spreadsheet API Java library …

java google-sheets google-spreadsheet-api google-authentication
Set cell format in Google Sheets spreadsheet using its API & Python

I am using gd_client.UpdateCell to update values in a google spreadsheet and am looking for a way to …

python formatting google-spreadsheet-api google-api-python-client google-sheets-api
gspread authentication throwing insufficient permission

Using developers.google.com we created api user and downloaded credentials as json file. Now On my macbook gspread authentication …

python google-drive-api google-spreadsheet-api gspread
How to get a note or comment

I have an Excel containing cell comments/notes, I've uploaded it to Google Drive, and converted it into a Google …

google-sheets google-spreadsheet-api google-docs-api
Google Sheets API "update" method Http Error 400

I am trying to make a python script that reads and writes to a google spreadsheet. I've basically copied the …

python google-spreadsheet-api google-api-python-client