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

Escaping text wih google spreadsheet api

I am using the google spreadsheet api to update data in several spreadsheets and I need to escape some texts to use them in the following formula: =IFNA(FILTER('Another_SheetName'!B:B, 'Another_SheetName'!A:A=92433), HYPERLINK(url,…
Diego Silvera
  • 201
  • 1
  • 2
  • 13
1
vote
1 answer

Why when I send data from firebase to google sheets it is only shown in the first row of the sheet?

I'm trying send some data from firebase to google sheets. I used the method push() to insert the data into a variable and call it in "resource {values: duplicitiesWithJudicialCharges}". I know that have more than one value, but in my google sheet…
Rodrigo Fiad Pasini
  • 57
  • 6
1
vote
1 answer

How can I delete or update Google spreadsheet using Python import csv?

I'm working on my Python script and right now my script can import csv to spreadsheet, but I have to modify it to replace or delete the old spreadsheet that already imported and update it to the latest csv, since currently my script only working in…
rodskies
  • 119
  • 1
  • 11
1
vote
1 answer

Unable to upload raspberry pi sensor data to a Google Spreadsheet

I am working on a raspberry pi project where I want to send sensor datas to google spreadsheet every 30 seconds. But I am getting output 'failed'. Seems like datas are not appending to spreadsheet. I could not find the exact problem. Also,I expect…
Lizzie
  • 13
  • 3
1
vote
0 answers

How to get specific data from Google Sheets API?

I'm trying to use Google Sheet as a database, using Next.js to build this app. Unfortunately, I've suffered some problems over a few days. The problems are I want to get data by searching for a specific id, but I can't figure out how to solve this…
hao
  • 197
  • 1
  • 3
  • 11
1
vote
2 answers

Using Google Sheets API from Java using GKE Workload Identity

We've been successfully using the Java client for Google Sheets for a while within our GKE cluster, using the ComputeCredential class to provide credentials. The following code is more or less what we're doing: import…
josno
  • 96
  • 5
1
vote
1 answer

Unable to sketch vertical and horizontal lines around selected dataframe columns published in Gsheet using Python

As per discussion on Python dataframe to Google Sheet: Freeze rows and sketch vertical lines around a sets of columns , I have been able to use the code below (thank you @Tanaike!) and sketch vertical and horizontal borders around dataframe df_final…
Sinha
  • 431
  • 1
  • 5
  • 12
1
vote
1 answer

Is there a way to eanble Sheet API via Apps Script?

I've exploring possibilities here to dimish the workload for users when first running the sets of script I'd have built into the spreadsheet. One of the functions requires Sheets API and having the user manually enable it would be a killer. I've…
onit
  • 2,275
  • 11
  • 25
1
vote
1 answer

Adding columns to Google Sheets

I am trying to add columns to a Google Sheets, but I get an error. I need to add a copy of the previous column. Code: def insert_column(): sa = gspread.service_account(filename="service_account.json") sh = sa.open("**NAME**") wks =…
pdvp
  • 11
  • 2
1
vote
2 answers

Google Sheets deleteRow not working in my Macro

I'm trying to build a Macro to erase all the rows that have empty values on column D. Originally, I was using this code that I found: function deleteRows() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var s = ss.getSheetByName('Datos…
jkenigs
  • 13
  • 2
1
vote
1 answer

Google Sheets, how to run function every x column?

I have a script in google sheets with the following function: // Function to get current active sheet-name. function getsheetName(dummy) { return SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getName(); } Currently this function runs…
Axxi
  • 193
  • 1
  • 10
1
vote
2 answers

How to copy the multiline value of a cell without quotation mark?

I have a cell with a multiline value. For example: Testing line 1 Testing line 2 When I copy it and paste it at any text editor, there are quotation mark at the front and at the end of the value. That is "Testing line 1 Testing line 2" How can I…
Myrick Chow
  • 332
  • 1
  • 6
  • 16
1
vote
1 answer

Convert this array formula for google spreadsheet

I found out that you can't use an array formula if you are using the "if" "and" "or" formula on google spreadsheet. Can someone please help me fix this formula I made, if possible I still want it to be an array…
eiriinjye
  • 25
  • 4
1
vote
1 answer

Service account initialization failing inside lambda function on AWS Python

I am trying to create a lambda function to read from a google sheet when triggered by an API call. I had it working on my local machine but when I packaged it an put it as a lambda function it would not initialize the API using the…
chipego kalinda
  • 49
  • 9
1
vote
1 answer

Google Web App Script Unknown Parameter Error on Load

On load my web app is producing this error: DataTables warning: table id=data-table - Requested unknown parameter '9' for row 21, column 9. For more information about this error, please see http://datatables.net/tn/4 Code.gs function doGet()…
Chrizh
  • 27
  • 4
1 2 3
…
99 100