Stack Overflow
Stack Overflow

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
1
vote
1 answer

How do I write values to a google spreadsheets row with the api?

I want, in node.js, for my command to, on the second row of my spreadsheet, set the values of A-D to 1-4. The code below seems to be how the documentation wants me to do it, but I keep getting the following error: "GaxiosError: Invalid JSON payload…
TGercken
  • 79
  • 9
1
vote
4 answers

Using Class CellImageBuilder to import Image into Google Sheets cell

On the 19th January 2022, the CellImageBuilder class was added to the Google Sheets Spreadsheet service. This class now allows you to import an image into a cell in Google Sheets, previously you could only add an image above the cell. Ive been…
A.Steer
  • 335
  • 3
  • 14
1
vote
0 answers

Stopped reading google tables (invalid stream header: EFBFBDEF)

My integration with Google tables worked successfully for half a year, but today it stopped because of an error java.io.StreamCorruptedException: invalid stream header: EFBFBDEF has anyone encountered such an error? private static Credential…
mr x
  • 11
  • 1
1
vote
2 answers

Download a tab of a google sheet as a CSV file

This used to work: curl 'https://docs.google.com/spreadsheets/d/1xaGu5Cd0kRPKy0v-EaVxgfnUxaxWlgDhfhfgRQy6hrc/gviz/tq?tqx=out:csv&sheet=Inv_Summary&range=A:G' The segment tqx=out:csv specified the format, sheet specfied the tab name, and range the…
Sherwood Botsford
  • 1,889
  • 5
  • 20
  • 35
1
vote
1 answer

Convert Index to Column A1 Notation and vice-versa

How would you convert an index, i.e. 53, to a column reference, i.e. BA in GoLang? The table below shows a 2-way expected output for both column & index. i.e. if you put in 703, you will get AAA. If you put in YOU, you will get 17311.
James
  • 699
  • 2
  • 6
  • 23
1
vote
1 answer

Google Sheet Api get function returns undefined value in NestJs

I have async function getTables() which using Google Sheet API to get google spreadsheet data. But on response it returns undefined value. this.getClient() returns OAuth2Client data. Could you check my async function, maybe it is written not…
Merei Temirkas
  • 63
  • 6
1
vote
0 answers

gspread returning error requests.exceptions.ConnectionError: ('Connection aborted.', TimeoutError('The write operation timed out'))

I found out about gspread and it is just what I need for my code. I tried testing it on 100+ rows and it was inserting fine, but after I testing it on 100K+ rows, it returning the following error. Traceback (most recent call last): File…
Ditto Rahmat
  • 56
  • 4
1
vote
2 answers

Froze a column inside a pivot table with api sheet

Do you know how to freeze a column using FrozenColumnCount property (or another), inside a pivot table ? request_body ={ "requests" : { "updateCells" : { "rows" : { "values" : [ …
Larow
  • 49
  • 6
1
vote
1 answer

Google sheet API, executing AddProtectedRangeRequest

based on: https://developers.google.com/sheets/api/samples/ranges How to execute Google sheet API, executing AddProtectedRangeRequest ? void addRangeRestriction(final String sheetId, final Sheets sheetService) throws IOException { …
ses
  • 13,174
  • 31
  • 123
  • 226
1
vote
1 answer

Problem using google spreadsheet as source for a Next.JS website: changes won't update pages

I made this restaurant's website and uses Google Spreadsheet to feed content into the menu pages. The choice of such method was based on simplicity and client expertise. I'm using google-spreadsheet package to fetch all the information I need from…
Eduardo Oliveira
  • 395
  • 2
  • 18
1
vote
1 answer

How to handle asynchronous queries in Google Sheets API for Android?

I am trying to create a Warehouse management app for Android using Java and the Google Sheets API. I create a query to get the data stored in a sheet. I have a class which handles all the requests to the API. I create an instance of this object from…
Geo7212
  • 81
  • 7
1
vote
0 answers

How do I open a Google Sheets Service using StoredCredentials?

I am working on an application (in Java) which will pull data from GoogleSheets. I am looking to retain the credentials in using Google's StoredCredentials object, however while I have figured out how to create a StoredCredentials object, I can't…
cgivre
  • 513
  • 4
  • 21
1
vote
2 answers

Value error when reading data from Google Sheets with comma as decimal

When reading from Google Sheet with Python and the Google API I have a hard time getting numeric values from the numeric values. Where i live we use comma as decimal separator, which seems to be the problem. The Google sheet input is: with…
NRVA
  • 507
  • 3
  • 20
1
vote
1 answer

How do we write data from a dictionary to a new row in google sheets?

I wrote some code to gather the local business names, postcodes, addresses, and phone numbers. Now I want to write them to the next row in my google spreadsheet in the order I want them to. I'm new to this use of the gsheets API. Can anyone explain…
Amen
  • 69
  • 8
1
vote
1 answer

Invisible chart area during print and in exported PDF file in spreadsheet created by service account with Google Sheets API (Node.js) in shared folder

I'm creating a spreadsheet in Node.js environment in shared folder using service account with Google Sheets API v.4 in few steps: Create spreadsheet itself in shared folder with "Can Edit" permission for service account. Inserting some data and…
regman
  • 113
  • 10
1 2 3
…
99 100