Top "Google-spreadsheet-api" questions

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

How to import a CSV file using Google Sheets API V4

Background I'm developing a Python 2.7 script that analyzes data from an SQL table and at the end, generates a CSV …

python-2.7 google-spreadsheet-api google-sheets-api
Write data into Google Spreadsheet w/ Java

I'm lost on this one. I'm trying to connect Java with Google spreadsheet, and although the API's documentation is complete …

java google-sheets google-drive-api google-spreadsheet-api
Google Docs Spreadsheet to JSON

I've seen numerous articles on this but they seem outdated, for instance none of the Google Docs Spreadsheet urls has …

javascript json google-sheets google-spreadsheet-api
How to convert Google spreadsheet's worksheet string id to integer index (GID)?

To export google spreadsheet's single worksheet to CSV, integer worksheet index(GID) is required to be passed. https://spreadsheets.google.…

google-sheets gdata-api google-spreadsheet-api gdata-python-client
Access Google spreadsheet API without auth token

I have created Google Spreadsheet, and given edit access to all (can edit even without login). Here is the link. …

google-sheets google-spreadsheet-api google-authentication google-developers-console
List names of sheets in Google Sheets and skip the first two

I found code to list the names of all the sheets in Google Sheets (from here): function SheetNames() { // Usage as …

google-apps-script google-sheets google-spreadsheet-api
External API call in Google Spreedsheet is possible?

I have created a Google Spreadsheet with five columns; Once the user filled the values in the first three columns, …

google-sheets spreadsheet google-spreadsheet-api
Google Sheets API v4 - How to get the last row with value?

How to get the last row with value in the new Google Sheets API v4 ? i use this to get …

android google-sheets google-drive-api google-spreadsheet-api
How can I get the number of rows in a Google Spreadsheet using api?

Is it possible to fetch the number of filled rows without fetching the whole spreadsheet, or find the first empty …

google-docs-api google-spreadsheet-api
Appending multiple rows to Spreadsheet - Google Apps Script

I wish to append multiple rows to a google sheet via GAS whilst being considerate of performance and undesired possiblities. …

google-apps-script google-spreadsheet-api