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

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 without authentication. The Google Spreadsheet is published with public. I would like to use the following…
Junya Sato
  • 175
  • 2
  • 9
10
votes
1 answer

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 hyperlink associated with that cell, only the text. Is there any way to get the hyperlink or do I have to add another field with…
Scottux
  • 1,577
  • 1
  • 11
  • 22
9
votes
3 answers

Using Google Docs and Google Spreadsheet APIs for Android

I am planning on using the Google Documents List, and Google Documents Spreadsheet API's for uploading a database from my app to a spreadsheet online and then editing it. I just wanted to know if these API's would be the right approach for using…
gtdevel
  • 1,513
  • 6
  • 21
  • 38
9
votes
1 answer

Typescript & Googleapis Surge in Memory Used

We've been tracking for a while an Out of Memory error that seemed to happen from time to time in the build step. We finally pinpointed the commit. Said commit caused the tsc --alwaysStrict build to go from 175MB (RAM) to complete the build to…
eversor
  • 3,031
  • 2
  • 26
  • 46
9
votes
1 answer

OAuth flow for third party API access

There is a lot of information on the web about OAuth 2, its different types of flows and where/how to use them. I find that most of these resources discuss authenticating a user for an application, but I am struggling to understand what the…
Matt Wilson
  • 8,159
  • 8
  • 33
  • 55
9
votes
2 answers

Google Sheets, "The request is missing a valid API key"

I am trying to use the Google Sheets API. The problem is, once I call my script function on the google spreadsheet, I get the following error: API call to sheets.spreadsheets.values.get failed with error: The request is missing a valid API key.…
Giacomo
  • 551
  • 2
  • 4
  • 16
9
votes
4 answers

How to add a new Sheet into existing SpreadSheet? Google Sheets API with Node.js

Using Google-Sheets-API for Node.js, how would I programmatically add/create a new Sheet into an existing Spreadsheet?
UFC Insider
  • 838
  • 1
  • 7
  • 19
9
votes
2 answers

How to write to Google Sheets in Swift

I'm trying to write to a Google Sheets document by following this google api, but I'm not having much success. I'm not even sure I'm following the right api, because it says "Appscript" and looks like Swift. I've been able to read in data from the…
Jeffrey Chen
  • 225
  • 3
  • 16
9
votes
1 answer

Google sheets query - Cartesian join between two ranges

How can we achieve the following join between two ranges on Google Spreadsheet using the query function? Range 1 Model Style Nissan Coupe Nissan Truck Honda Sedan Honda Hatchback Toyata Truck Honda Coupe Range 2 Style Engine Coupe …
Ashish Dhandharia
  • 351
  • 2
  • 9
9
votes
1 answer

Google Sheets "You do not have permission to call appendRow"

function myFunction() { var url = 'https://api.github.com/users/chaimf90/repos' var response = UrlFetchApp.fetch(url); var json = response.getContentText(); var data = JSON.parse(json) var sheet =…
Chaim Friedman
  • 6,124
  • 4
  • 33
  • 61
9
votes
3 answers

How to create a spreadsheet with google api and set a proper permissions with PHP?

I have this define('CLIENT_SECRET_PATH', __DIR__ . '/config_api.json'); define('ACCESS_TOKEN', '0b502651********c52b3'); I can create a spreadsheet with this and get the id and url. $requestBody = new Google_Service_Sheets_Spreadsheet(); $response…
SERG
  • 3,907
  • 8
  • 44
  • 89
9
votes
1 answer

How to read value of fetched cell data as date google sheets API

I have a spreadsheet that have dates formatted as "Jan 30" etc, but have actual date values. I fetch the data using python google Sheets API like so: def get_spreadsheet_sheets(service, spreadsheetId): spreadsheet =…
abbood
  • 23,101
  • 16
  • 132
  • 246
9
votes
3 answers

Google Sheets API Python - Clear sheet

I'd like to constantly update/re-write to a Google sheet. I cannot just update it, though, without clearing out the old sheet because sometime the update has less rows then the previous and the old rows are left in the sheet. The protocol listed on…
Count_Zer0
  • 420
  • 1
  • 4
  • 9
9
votes
1 answer

How to get access to a private spreadsheet from the API?

Hello I need to get access to a spreadsheet from google spreadsheet API. I have enabled Google Sheets API and added API key, but this doesn't work!!! https://sheets.googleapis.com/v4/spreadsheets/[my_spreadsheet_id]/values/A1?key=[my_api_key] The…
Gms Brothers
  • 115
  • 1
  • 5
9
votes
1 answer

Google Spreadsheet API v4, is it possible to get revision content?

I'm reading through the v4 API and can't satisfy my own question. I want to build an app that gathers a single spreadsheet's previous revision(s). (Specifically, I want to be able to get the entire content of a previous revision.) Is this…
yamori
  • 1,213
  • 4
  • 14
  • 27
1 2 3
…
99 100