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

Formatting cells (to type Duration) with the Google Sheets API (v4)

I'm using the Google Sheets API (v4) to create/update spreadsheets programmatically and have run into the following issue: I have seen via the JavaDoc that to set the cell to a NumberFormat of say, CURRENCY, I can set the NumberFormat type and…
prelesnik
  • 13
  • 2
1
vote
1 answer

How to use range in google sheet api?

I want to add a new value from B3. B1:E1 is from the first line of B to the first line of E. B:E is from the beginning of B to the end of E. I wonder what the difference is when the range is B:E, B1:E1. When there is a value in column A, the new…
gotqks
  • 31
  • 6
1
vote
1 answer

How to get SheetID in SheetsService c#

Thank you for reading it :) Im using Blazor server and Google.Apis.Sheets.v4. I am trying to delete columns in a sheet with this code: serviceSheet = new SheetsService(new Google.Apis.Services.BaseClientService.Initializer() { …
Kirill Lachaev
  • 13
  • 3
1
vote
1 answer

Google Sheets API with Python

I am attempting to connect to this Google Sheet: https://docs.google.com/spreadsheets/d/1u3Ql_Rs19PEe0mwqpsiw2wf2cUEbnSG4vZL63rh_OaE/edit?usp=sharing Both the .json file and the .py file are saved to my desktop. The email in the .json has been…
ah2Bwise
  • 82
  • 2
  • 17
1
vote
1 answer

Reading and updating multiple tabs in the same spreadsheet

I have a Google Spreadsheet where I retrieve data using the Google Analytics addon. In a tab I combine all the data and use this specific tab for my Google Datastudio report. In here I analyze my Google Ads campaign data - the costs and the…
Emdelin
  • 23
  • 3
1
vote
1 answer

Using Google Sheets API v4 above the quota

I'm trying to find the pricing for Google Sheets API. The limit is 300 requests/min per project and there's also a per-user limit. I read you can request a quota increase but I'm willing to pay with some pricing model so there's no cap on the number…
ScriptKiddieOnAComputer
  • 925
  • 12
  • 19
1
vote
1 answer

Create a separate sheet for every name in a range and move values under each name to each sheet

I have a master list with dozens of names in row 2 spread across a bunch of columns (A2:Z2). Under each name is a list of values and data. row 2 John Sally James row 3 Value Value Value row 4 Value Value Value row 5 Value Value row…
usernametaken
  • 69
  • 6
1
vote
1 answer

When accessing a google spreadsheets i get "You need permission"

I have an application and when I try to connect on Google Spreadsheets, during connection, I got the message "You need permission"! I use this code below to getSpredsheets: try{ $spreadsheetFeed = null; $auth_url…
mirec
  • 147
  • 1
  • 1
  • 7
1
vote
0 answers

Is there a way to add an unprotected range with the google sheets api?

I see in the documentation that you can add protected ranges and remove those that you add. But is there a way to add an unprotected range? I need to unprotect 3 cells in a protected sheet and not seeing any ways to do so. If I use the get api, I…
user17312265
  • 11
  • 1
1
vote
1 answer

Google Api create accessible by link SpeadSheet

I use script from here to create spread sheet, but it always creates as closed one. I need to create spread sheet that accessible by link, but I cannot find a way to do it. Here what I mean: $spreadsheet = new Google_Service_Sheets_Spreadsheet([ …
Kemsikov
  • 452
  • 3
  • 13
1
vote
1 answer

How to create a NamgedRange using google sheets API when doing a batch update with Go

I recently started writing a program to export CSV and SQL to google sheets. And in some scenarios I need to create a NamedRange while creating the sheet and/or updating it. The google official documentation is kinda confusion and not very helpful…
VandrerenErik
  • 13
  • 3
1
vote
1 answer

Request failed for https://api.coingecko.com returned code 429. Truncated server response: error code: 1015

I'm working with getting crypto pricing on my google sheet but I keep getting an error message. I've looked around and haven't really come across anything for CoinGecko. Below is the error message. "Exception: Request failed for…
Mitchell Bivens
  • 97
  • 2
  • 12
1
vote
1 answer

Google Sheet API error The caller does not have permission

I am trying to access google sheet using a Service account in a .net core console application. I can read the google sheet from my personal account. It has no issues. But trying to access google sheet in an organizational domain, it says Don't have…
Tech sghave
  • 13
  • 1
  • 4
1
vote
1 answer

Google App Script Exceeded Maximum Execution Limit

I've been attempting to export the entire contents of my spreadsheet. The code works fine, but it displays an error message that says Maximum execution limit exceeded. According to my research, the maximum execution time is only 6 minutes. I'm new…
cjwrk
  • 255
  • 1
  • 13
1
vote
1 answer

Preventing GoogleJsonResponseException: API call to sheets.spreadsheets.batchUpdate failed with error: Must specify at least one request

I have the following Google Spreadsheet function: function deleteRows() { const sheetName = "Sheet"; // Please set the sheet name. const ss = SpreadsheetApp.getActiveSpreadsheet(); const sheet = ss.getSheetByName(sheetName); const sheetId…
mishelles
  • 27
  • 6
1 2 3
…
99
100