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.

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

3524 questions
0
votes
0 answers

How to retrieve google sheet api v4 data into JSON format

I am able to parse data from google sheet api v4. Here is retrieve sheet data. Sample: https://sheets.googleapis.com/v4/spreadsheets/1vW-N2WRchAmxd8-isEx4oPpJourPsIIavqfvT_Nbtzw/values/Master?key=AIzaSyAwaXGDfOOdUX-YaGIn0S8Q7ae-ONC_cLs But i want…
Shihab365
  • 129
  • 10
0
votes
0 answers

Google Sheets API Oauth issue

I am trying the sample listed here. I have not added any Redirect URI to my credential as it is not suggested anywhere. When I run the sample, I get the following error, and every time the port is different. Authorization Error Error 400:…
ss87
  • 1
0
votes
2 answers

How to get all google sheet tab name from a public sheet without app script

I am able to parse JSON data from https://spreadsheets.google.com/feeds/list/1AtYF5g2_A3AiAhejVj595bDLxO1zoGq7PNGjbdV9U8Q/od6/public/values?alt=json this way. Is there any similar way to get all the sheet tab name?
Shihab365
  • 129
  • 10
0
votes
0 answers

Add multiple filterviews using values from a column of the sheet

I have this Apps Script function that Adds a filterview to a sheet. I would like to use a function that creates multiple filterviews to the same sheet, using the values from columnIndex 3 to define the title, filterViewId, and filter criteria. This…
Albert Iturbe Recasens
  • 1
0
votes
1 answer

Date format messed up while copying data from one spreadsheet to another using Google Sheets API batchUpdate

I am copying a dataset from one spreadsheet to another and all is fine except the dates. In the source file the dates are like "2020-07-27", but after I run the script, the dates in the destination file are in completely different format like "Sun…
Tonny
  • 3
  • 1
0
votes
0 answers

Google Sheets API - Timeout

I regularly use gspread and lately I've been getting these read timeout errors but only on certain sheets. Sometimes I'll be able to read & write to a sheet for a bit and then it'll hang until I get this read timeout error and then all subsequent…
Matt Perry
  • 1
0
votes
1 answer

Time trigger end of months

as the end of months varies from 30 to 31 and I have to set up a time trigger to trigger another function. if I input the 31 of all months, will it work on the 30? here is my code function timerTrigger()…
Jean Yves Le Magnifik
  • 31
  • 4
0
votes
2 answers

Stop Google Sheets from creating link automatically

I am trying to write some text in Google Sheets, specifically some URLs. I need that because I am trying to explain to an agency the new tracking we are implementing. I have the URL in a cell, and I went to have some caracters in red to highlight…
Kahil Mamodaly
  • 1
0
votes
0 answers

Problems with a variable in Google Apps Script

I'm beginner in apps script. I was trying to follow a tutorial (which you can find here: https://www.youtube.com/watch?v=1CSPpsBGlQ0). I'm facing problems trying to pass a variable between functions inside my front-end HTML. The goal of this project…
Deusiel de Souza
  • 1
  • 1
0
votes
1 answer

Google SpreadSheets Api blocks table after some requests

My application sends requests to Google Spreadsheets Api to write values to table. I can successfully send only 3-4 requests after this table blocks for 6-12 hours and servers sends 503 error (unavailable). I thought that this occurs with basic…
Pavel Narizhny
  • 11
  • 2
0
votes
0 answers

insert images in google docs (or pdf) coming from google spreadsheets?

I have Google spreadsheets with several raws and lines. I take each lines of each raw of my google spreadsheet and i generate a pdf with it based on a Google Docs template. In one raw, I have url's from pictures stored into Google Drive, and I want…
collaboratif MSP
  • 1
  • 1
0
votes
0 answers

Multiple sheets writting to a single master sheet

I have two user input sheets, in which users can enter data in row 2. This data is then copied over to the master once the save button is pressed. The script I've written to do all this works fine, my concern comes down to the moment both of these…
Sebastián H
  • 15
  • 5
0
votes
1 answer

Vlookup to Make a list?

This site has been super helpful, thank you to everyone who has answered my questions. Here is the next one I am working on. Not sure if I should use vlookup, hlookup, a combination of both or something else. So I have a list of teams with…
Josh McElheny
  • 7
  • 1
0
votes
1 answer

Google Sheets api append method is not adding a line after the last row

It is supposed that values.append method should add a line when it meets an empty row starting from the first row of the defined range. If there is no gaps between existing rows, then it should add a line in the end of the defined range table. In my…
Serob_b
  • 709
  • 8
  • 23
0
votes
2 answers

How to add API key to the google spreadsheet?

I have created a google sheet and have converted it into JSON using the URL. example: https://spreadsheets.google.com/feeds/list/SHEETID/od6/public/values?alt=json I want to add a api key to this google sheet. I have generated a API key though…
sfmc_newbie
  • 7
  • 1
1 2 3
…
99
100