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
0 answers

Salesforce connector in google sheets to get all events

I am using the extension Salesforce connect to connect google sheets to Salesforce. I have to write a SOQL query to get all events grouped by event owner and import it ti google sheet using Salesforce connect. Its hard to write a query on event,…
Ruby Khan
  • 19
  • 3
1
vote
1 answer

Updating a specific value in row with conditions nodejs google sheet

I've been trying to update an existing row with the same name, email, etc.. my problem is that I can't figure out how to add a number in the second trial WPM for the same user. to be more clear, the user submits a form and start the operation in the…
Bewenben
  • 13
  • 4
1
vote
1 answer

modify google spreadsheet using Ajax javascript only

i am using javascript only to read and write values in google spreadsheet (private sheet using oAuth). I can successfully read the values but i am getting issue on modifying the sheet. below is my code for updating the cell- $.ajax({ …
user3369120
  • 89
  • 1
  • 13
1
vote
2 answers

Erro to connect Google Sheets API

I'm trying to follow these Ruby quickstart code(https://developers.google.com/sheets/api/quickstart/ruby#step_2_set_up_the_sample), require "google/apis/sheets_v4" require "googleauth" require "googleauth/stores/file_token_store" require…
Felipe Cristiano
  • 183
  • 12
1
vote
1 answer

gspread find in_column list index out of range

I am trying to find an item inside a worksheet using gspread but only for a specific column. For some reason, when I do ws.find(item, in_column = 6) it givens an IndexError: list index out of range but when I do it with 2, it works fine. I tested…
Nebula
  • 23
  • 3
1
vote
1 answer

Upload worksheet instance with gspread

I have a template worksheet in a spreadsheet that I need to duplicate to another spreadsheet. How can I achieve this with gspread? gs = gspread.oauth() template_sh = gs.open_by_key(TEMPLATE_SHEET_ID) template_ws =…
DavideL
  • 294
  • 1
  • 3
  • 15
1
vote
1 answer

Google Apps Script - Sheets API AddNamedRange request for entire column

I am trying to create multiple named ranges from a list spreadsheet ID's and sheet ID's. I am using the Sheets API batchUpdate method to define the named range parameters. My requirement is to create named ranges for the entire columns (A:B) and not…
Pranjal Mishra
  • 19
  • 4
1
vote
1 answer

DetailedApiRequestError in Google Sheets API in Flutter

I trying to create a spread sheet in using Google Sheets API, I have Enabled Google Sheets API in console in google cloud but still getting error. Below Is Code I am Using. final authClient = await…
Roshan Shaikh
  • 11
  • 1
1
vote
1 answer

Make Specific Part Bold in Google Sheets via Python gspread Api

I have been trying to make a bold part of my cell using Gspread API. But I couldn't figure out how to do that. I found a way in that question but I couldn't integrate to Gspread API That shows how I something wanted
Okan
  • 11
  • 3
1
vote
1 answer

Add information to a spreadsheet from the Google API

I have a Typescript and Node project in which I am trying to insert the information I get from the database into the spreadsheet using the Google API V4 https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}:batchUpdate This is the JSON…
menphis
  • 85
  • 1
  • 8
1
vote
0 answers

Google Spreadsheet: Display text with game specific commands in separate window/cell

I have a google spreadsheet with different dialog texts which are going to be imported into a game. The game's dialogs use game specific simple emoji-commands that are applied in the game, like "" which gives red color to the next letters and ""…
Louis Miles
  • 11
  • 2
1
vote
1 answer

Python/Gspread How can I add column names while creating a worksheet?

#For creating a new-sheet sheets.add_worksheet(title=sheetName, rows=df.shape[0], cols=df.shape[1]) #For appending values = df.values.tolist() sheets.values_append(sheetName, {'valueInputOption': 'USER_ENTERED'}, {'values': values}) It creates a…
Subham
  • 160
  • 2
  • 10
1
vote
1 answer

How to edit manifest to create test deployment for Google Sheets add-on?

Years ago, I created an add-on for Google Sheets that I was able to deploy within my college domain. Specifically, I was able to access it on spreadsheets through the Extensions menu. It recently stopped working, with a message about the developer…
Ellen Spertus
  • 6,576
  • 9
  • 50
  • 101
1
vote
2 answers

how can I return Hyperlink from google apps script

//Link_generator function lk(num01) { try{ var sheets = SpreadsheetApp.getActiveSpreadsheet() var out_01 = new Array(); if(num01==1){var sheetnames =…
GM B
  • 25
  • 4
1
vote
1 answer

Why is my XPath returning only text without tags?

I am using Google Sheets to send an update to my Discord server every time there is an update from a forum site. However, when I scrape this link, https://forum.mir4global.com/board/patchnote using this…
Louie Senoc
  • 13
  • 3
1 2 3
…
99 100