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
13
votes
3 answers

Linking to another tab in Google Sheets

I have a Google Sheets workbook with more than 70 tabs, or sheets, in it. In one of them, I have a master list of all of them. For better reference, in the tab "PropertyID", and the column F, from 2 and downwards, I have the name of each other sheet…
Andre Arancibia
  • 137
  • 1
  • 1
  • 4
13
votes
3 answers

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 on retrieving data (and it is working fine), I am unable to figure out how to write into the spreadsheet. Could anyone, please…
Zsolt Balla
  • 533
  • 2
  • 7
  • 16
13
votes
1 answer

How to pass parameter(s) to timed trigger function in library script

I have created a function which trigger every after 30 mins, and I want to pass some parameter. I have one library which returns carHistory, and my spreadsheet from where I call library function. Library1.gs function carHistory(number,maker) { //…
Satinder singh
  • 10,100
  • 16
  • 60
  • 102
13
votes
3 answers

Import google spreadsheet data into google forms with app script

I searched the internet and I can't find a response to this nor the documentation for it. I need to dynamically generate Google forms questions with data from a Google spreadsheet using app script, but I don't know how to reference and read a…
Vector
  • 747
  • 2
  • 11
  • 22
13
votes
1 answer

how to work with spreadsheets using Google Drive API on iOS

I'm trying to write an iPhone app that stores its database in a Google spreadsheet. I followed the DrEdit example here which uses the Drive API to read/write plain text files to Google Drive. I'm trying to modify the example app to work with…
mlpg
  • 133
  • 1
  • 1
  • 5
12
votes
4 answers

Did Google Sheets stop allowing json access?

I have an app that opens the json version of a spreadsheet that I've published to the web. I used the instructions on this website: https://www.freecodecamp.org/news/cjn-google-sheets-as-json-endpoint/ It's been working fine for a couple months, but…
Dima
  • 459
  • 1
  • 3
  • 13
12
votes
4 answers

Accessing Google Sheets Api with Python

I'm currently trying to make updates to google sheets via python and I'm running into some issues with permissions. I've been following the instructions from this Twilio…
KirklandShawty
  • 263
  • 2
  • 11
12
votes
3 answers

Google sheets API with chrome extension, how to use?

I am making my first chrome extension. My idea is to call Google Sheets API to append a row in a google spreadsheet from my extension. I am referring this link for the same and successfully tried the API to append row in my desired sheet. Now I am…
Shyam Kansagra
  • 892
  • 12
  • 24
12
votes
1 answer

Google Sheets java sdk oAuth unauthorized after some hours (spring boot)

I successfully created a spring boot Serviceclass in order to write on google sheets, following the Java Quistart Tutorial for Sheets API My problem is that the authorization is not renewing, so after the first successful authentication via browser,…
user4330585
  • 185
  • 1
  • 9
12
votes
3 answers

Google Sheets API addProtectedRange Error: No grid with id: 0

I am not sure if I am making a mistake or if possibly this is related to the same issue reported here: Google Sheets API V4 - Autofill Error - No grid with id: 0 I am getting: HttpError 400 "Invalid requests[0].addProtectedRange: No grid with id:…
Patrick Rainsberry
  • 121
  • 1
  • 6
12
votes
4 answers

How can my Google Apps Script be run by others the Sheet is shared with?

I've got a Google Apps Script that works fine for me. Others who the sheet is shared with that try to use it get the message: You do not have access to perform that action. Please ask the owner of this item to grant access to you. The script is…
Baddie
  • 305
  • 1
  • 3
  • 11
12
votes
2 answers

Find a Google Drive Sheet By Name Using API 4 In Android

I followed the "Android Quickstart" below. https://developers.google.com/sheets/api/quickstart/android Works great. But the sample hard-codes a spreadsheetId to an existing spreadsheet. String spreadsheetId =…
LimaNightHawk
  • 6,613
  • 3
  • 41
  • 60
12
votes
2 answers

Google Sheets API: How to "publish to web" for embeddable sheet?

If I wanted to publish a Google Sheets spreadsheet so I could embed it on a page within an iframe, I would manually do the following: Navigate to Google Drive Open a spreadsheet File > Publish To Web > Embed > Copy the generated iframe link into an…
The Qodesmith
  • 3,205
  • 4
  • 32
  • 45
12
votes
1 answer

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 listing of all my Google Drive docs. What I can't seem to do is get into a specific spreadsheet. Code is as follows with…
Josh
  • 3,385
  • 5
  • 23
  • 45
12
votes
6 answers

Hyperlink to a specific sheet

I would like to open a specific sheet of a Google Sheets from a hyperlink in another spreadsheet. I have different links in my master spreadsheet and each should have a hyperlink to the same slave spreadsheet but to a different sheet. I know…
Ulk
  • 187
  • 1
  • 3
  • 12
1 2 3
…
99 100