Questions tagged [google-sheets-api]

The Google Sheets API lets developers write third-party applications that read and modify any aspect of spreadsheets. Not to be confused with [google-apps-script]

The Google Sheets REST API enables developers to create applications that read and modify the data in Google Sheets.

This API is useful for:

  • Managing the worksheets in a Google Sheets file
  • Consuming the rows of a worksheet
  • Managing cells in a worksheet by position
  • Performing complex formatting of cell text

Example quickstarts are available for most popular languages, along with Google-provided client libraries.

References

6071 questions
31
votes
2 answers

Chrome Extension Writing to Google Spreadsheet

I've been doing some research and for some reason can't find a good example showing this anywhere, and I am starting to wonder if it's even possible. What's I'm looking to do is to have my extension write data within a Google Spreadsheet, so that…
Albert
  • 605
  • 3
  • 7
  • 12
30
votes
3 answers

Reading whole Google Spreadsheet with Sheets API v4 Java

I would like to read a Google Spreadsheet like described in the Java Quickstart https://developers.google.com/sheets/quickstart/java The Quickstart explaines how to read data from a give range ..... String range = "Class Data!A2:E"; ValueRange…
Michael Meyer
  • 2,179
  • 3
  • 24
  • 33
30
votes
8 answers

How do I rename a (work)sheet in a Google Sheets spreadsheet using the API in Python?

I have been trying/looking to solve this problem for a long while. I have read the documentation for gspread and I cannot find that there is a way to rename a worksheet. Any of you know how to? I would massively appreciate it! There is indeed…
29
votes
3 answers

Is it possible to use json key instead of p12 key for service account credentials?

I am using "Google.Apis.Bigquery.v2 Client Library" with C#. I am authorizing to Google BigQuery using "Service Account" (see http://www.afterlogic.com/mailbee-net/docs/OAuth2GoogleServiceAccounts.html). To create the X509 certificate I use the p12…
29
votes
2 answers

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 from Excel which matches conditions (eg., filtered by date, username) and display them with app script. My spreadsheet has…
palaniraja
  • 10,432
  • 5
  • 43
  • 76
28
votes
5 answers

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. I would like to update this sheet with Google Spreadsheet API. But I am getting error. My requirement is update the sheet thru API even…
27
votes
2 answers

How to increase Google Sheets v4 API quota limitations

The new Google Sheets API v4 currently has an unlimited read/write quota per day (which is fantastic), but restricted to 500 reads/writes per account per 100 seconds, and 100 read/writes per key per 100 seconds (or, I have found, multiple keys…
Peter Jansen
  • 271
  • 1
  • 3
  • 3
27
votes
12 answers

Googlesheet APIv4 getting empty cells

I have a googlesheet where a column may contain no information in it. While iterating through the rows and looking at that column, if the column is blank, it's not returning anything. Even worse, if I do a get of a full row and include that…
GregMa
  • 740
  • 2
  • 10
  • 25
26
votes
5 answers

How to export a csv from Google Sheet API?

I can't find any reference to an API that enables Rest API clients to export an existing Google Sheet to a csv file. https://developers.google.com/sheets/ I believe there should be a way to export them.
user1447414
  • 1,306
  • 2
  • 12
  • 25
25
votes
6 answers

Download/Export Public Google Spreadsheet as TSV from Command Line?

I have a public (published) Google spreadsheet that I’m trying to download programmatically in TSV form. In my browser, with a Google login active, for some actual key $key,…
Aaron Davies
  • 1,190
  • 1
  • 11
  • 17
25
votes
2 answers

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 own Google spreadsheet. Firstly I tried to use Google APIs Client Library for JavaScript but it doesn't seem to cover the Spreadsheet API…
Martin Dimitrov
  • 4,796
  • 5
  • 46
  • 62
24
votes
4 answers

Google Sheets API: Create or move Spreadsheet into Folder

Is it possible to create a Spreadsheet in a specified Folder or do I have to use the Drive API to move it afterwards?
Hans Bickhofe
  • 343
  • 1
  • 2
  • 5
24
votes
9 answers

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 a range from a sheet: mService.spreadsheets().values().get("ID_SHEET", "Sheet1!A2:B50").execute(); how to detect the last row with value in the sheet ?
seba123neo
  • 4,688
  • 10
  • 35
  • 53
24
votes
2 answers

How do I export the revision history of a gdoc to git?

I have a spreadsheet in google docs that I'd want to integrate in a git workflow (and push to github). Are there any tools (or even libraries that are gdoc version aware) that do, or help me do, that? I have some old ruby hacks lying around based on…
ecmanaut
  • 5,030
  • 2
  • 44
  • 66
23
votes
10 answers

How to connect Google Sheets to Database

I'm trying to auto-populate some raw data on a sheet in my google sheets file with a query. It doesn't look like sheets has any built in functionality to do so like Microsoft Excel does. Am I missing something? I found one add-on that has since…
obizues
  • 1,473
  • 5
  • 16
  • 30