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

Google Sheet App Script: Match 1 values from one sheet to another sheet and then if condition met set background

I'm new to app script and still learning how to do thing. Here's what I want to do: I have 2 sheets, in the 1st are just the names ('List') in columns based on each person language, the 2nd one is schedule ('Roster'). I want to change cell…
Sergiu Tihon
  • 31
  • 5
1
vote
2 answers

how to automatically add a schedule from Google Sheets into Calendar?

I have tried to implement this code to integrate google calendar with my spreadsheet, but i am fail until now. Follow the code... function scheduleShifts() { var spreadsheet = SpreadsheetApp.getActiveSheet(); var calendarId =…
NEEMIAS
  • 21
  • 5
1
vote
0 answers

Google Sheets API: Error 400: redirect_uri_mismatch

I keep getting Authorization errors when sending a POST request from my React/Ruby app. I'm getting different errors depending on what OOB_URI I'm using. If I use OOB_URI = "urn:ietf:wg:oauth:2.0:oob".freeze then I get the following error: When I…
helloroos
  • 293
  • 1
  • 2
  • 11
1
vote
0 answers

Google Sheets API javascript quickstart uses obsolete Google Sign-in Platform Library, how can I use Google Identity Services library

Is there a modern version of the quickstart? Google sheets javascript quickstart Using google's code will display their own error in the browser console: Your client application uses libraries for user authentication or authorization that will soon…
Ted Scheckler
  • 1,389
  • 4
  • 16
  • 34
1
vote
1 answer

Python dataframe to Google Sheet: Freeze rows and sketch vertical lines around a sets of columns

I have a dataframe df_final (it is a time series data) as shown in attached photo. I am able to write this dataframe to the Google Sheet using the code below. Questions: In Google Sheet, I would like to draw vertical lines around the entire…
Sinha
  • 431
  • 1
  • 5
  • 12
1
vote
1 answer

Importing Importing API data via importJSON

This is my code: function pricesV2(){ var url='https://prices.runescape.wiki/api/v1/osrs/mapping' var data = JSON.parse(UrlFetchApp.fetch(url).getContentText()) let myItems = new Map() let myItem = new Map1() json=eval('data') …
Sander Vanhemel
  • 25
  • 5
1
vote
1 answer

Publish python dataframe to Gsheet: Sketch borders around a set of data based on dates

I have a dataframe df (it is a time series data) as shown in attached photo. I am able to write this dataframe to the Google Sheet using the code below. Questions: In Google Sheet, I would like to draw a horizontal line after each Week ends (shown…
Sinha
  • 431
  • 1
  • 5
  • 12
1
vote
3 answers

I need to link Google Sheet with my Laravel

i want to link my laravel app with Google sheet i use this package : Google Sheets API v4 for Laravel my function : public function doPostData(){ $append = [ 'name', 'email@email.com', 'joe', …
MADI
  • 19
  • 1
  • 10
1
vote
2 answers

Dynamic grouping in AppSript

I have a Spreadsheet with about 3000 rows which are grouped by order number. I'm trying to build an macro to: remove all groups multisort all rows recreate groups collapse all groups marked as finished orders (optional - have no idea how to…
Marcin Brach
  • 13
  • 5
1
vote
1 answer

To search the row in the google sheet if it is there update otherwise add, using google APIS in nodejs

I am using google sheets APIS, I have successfully created the APIS that will get the data and post the data in my google sheet. My google sheet looks like: Coin Price Volume Cap ETH $2,456.90 1459738 $8712BN BTH $2,900.89 1245983…
Utkarsh Goyal
  • 81
  • 8
1
vote
1 answer

Create a comment | Google-SpreadSheet | nodeJS

I am trying to put a comment using NODEJS and the "Google Spread-Sheet" module, I have managed to write in cells, read, delete, but I can not put a comment in a cell, and the tutorials I see only teach discontinued forms, someone could help me?…
user12742938
1
vote
0 answers

Error message : Google.Apis.Requests.RequestError Range (Sheet1!K1254) exceeds grid limits. Max rows: 804, max columns: 25 [400]

Started getting below error randomly. while same code works fine if I stop my service and sun again. but after 1 days or two its start giving this error. I have scheduled a job to run after every 15 minutes where based on some condition it update…
Vijai Maurya
  • 101
  • 1
  • 1
  • 8
1
vote
1 answer

Copy values from a range, clear existing values in a range and finally paste the copied values

As stated in the title, I'm trying to copy values from a range, clear the values that may exist in another range and finally paste the copied values into a range: def copy_clear_paste(sheet_id, get_page_copy_name, range_copy, get_page_clear_name,…
Digital Farmer
  • 1,705
  • 5
  • 17
  • 67
1
vote
1 answer

Retrieve specific value from api response in google sheets

Sorting out some of my trading cards into google sheets. I would like retrieve the average price of the card using yugiohprices api…
Pasta
  • 11
  • 2
1
vote
1 answer

Getting individual question scores(numbers) from Google forms to a google spreadsheet

I have a google form which is basically an assessment for students. Each question carries 1 point. When I connect my form to a specific spreadsheet, I get the total score of the student e.g 24/30 What I want to do: Along with the total score, we…
amna
  • 21
  • 3
1 2 3
…
99 100