google-sheets-api Questions
7
I am trying to develop an application, where I where fetching data from multiple clients related to some transactions. Now I want to make some analysis using the Google Spreadsheet. Is there any wa...
Mcclintock asked 22/1, 2016 at 4:21
4
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...
Insensible asked 19/4, 2021 at 15:44
2
Here is the code I'm using to access a google sheet and change some of the characteristics of one of the cells in Javascript
The API seems to require you to specify a percentage of RGB colors rath...
Multivocal asked 18/8, 2019 at 18:55
4
I tried reading through the api docs but failed to find directions to perform queries regarding the existence of tabs and to create a tab if one does not exist.
Does anyone have a clue?
Beginner asked 3/1, 2017 at 14:26
2
Solved
I am using SpreadsheetApp.getActiveRange().getValues(); to get the value of a range of cells, but it doesn't return the hyperlink associated with that cell, only the text. Is there any way to get t...
Stoll asked 12/12, 2012 at 19:18
2
Solved
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 g...
Liponis asked 12/4, 2021 at 12:56
6
Solved
I can't find any reference to an API that enables Rest API clients to export an existing Google Sheet to a csv file.
https://developers.google.com/sheets/
I believe there should be a way to expor...
Sinner asked 8/6, 2016 at 14:35
4
Solved
Hi I am using Google Colaboratory (similar to Jupyter Notebook). Does anyone know how to access data from Google Sheets using Google Colaboratory notebook?
Ashmead asked 26/1, 2018 at 22:50
2
We've been tracking for a while an Out of Memory error that seemed to happen from time to time in the build step.
We finally pinpointed the commit. Said commit caused the tsc --alwaysStrict build t...
Longplaying asked 14/6, 2019 at 13:44
5
Solved
I have an app that opens the json version of a spreadsheet that I've published to the web. I used the instructions on this website: https://www.freecodecamp.org/news/cjn-google-sheets-as-json-endpo...
Confectionery asked 18/8, 2021 at 5:23
5
Solved
I have a legacy database system (not web accessible) on a server which generates CSV or XLS reports to a Google Drive folder. Currently, I am manually opening those files in Drive web interface and...
Risinger asked 10/11, 2014 at 22:55
6
The Google Spreadsheet looks like can only select one value in the dropdown list.
Is there any way to select multiple values from a dropdown list in google spreadsheet?
Tyndareus asked 29/4, 2014 at 15:43
7
Solved
I am trying to save form data to a spreadsheet in Next.js but I keep getting this error which appears as soon as I import google-spreadsheet
Error
./node_modules/google-spreadsheet/node_modules/g...
Matteo asked 20/3, 2021 at 10:12
3
Solved
We have a restricted app in which we control user accounts creation. We also use Google Sign-in. Currently the app is unverified and its fine since all users are in our GSuite domain. But we want t...
Philps asked 18/5, 2020 at 18:37
4
Solved
I am trying to access Google Sheet (read only mode) from Python (runs in GKE).
I am able to get application default creds, but getting scopes issue (as I am missing https://www.googleapis.com/auth...
Gwyngwyneth asked 24/4, 2020 at 15:58
3
Solved
I can add a new row to a Google spreadsheet with this code:
$valueRange = new Google_Service_Sheets_ValueRange();
$valueRange->setValues(["values" => ['data1', 'data2']]);
$range = 'Sheet1!A...
Deadandalive asked 12/3, 2017 at 19:0
2
Solved
I am building a simple script which polls some data and then updates a spreadsheet that I am giving to my client. (It is a small project and I don't need anything fancy.)
So I created a Google Clou...
Thine asked 15/2, 2023 at 0:14
7
Solved
I've seen numerous articles on this but they seem outdated, for instance none of the Google Docs Spreadsheet urls has key parameter. I read this as well:
JSON data from google spreadsheet
Then I r...
Omniscience asked 13/5, 2014 at 21:1
3
Solved
I wasted a whole day on this and still haven't solved it.
How the hell do I create a function that returns the background color of a specified cell?
How to get the range of the function's argument,...
Ladon asked 16/10, 2021 at 18:57
2
Solved
When trying the access a federated source (Google sheets) from BigQuery API, the following error is thrown:
[..]
"errorResult" : {
"location" : "/gdrive/id/<removed_file_id>",
"message" :...
Reeducate asked 22/11, 2016 at 0:19
5
I followed the instructions on Google API quickstart Python so that I can get started quickly. I downloaded the JSON file set with the default name and as a Desktop App. After making sure the each ...
Muller asked 22/10, 2020 at 4:47
2
Solved
I'm trying to populate a Google sheet from a Python program using its API, using the quickstart guide (https://developers.google.com/sheets/api/quickstart/python) as a starting point:
from __futur...
Dehiscence asked 30/7, 2018 at 23:42
8
I've generated a server key in the API Manager and attempted to execute the following on my Mac:
curl 'https://sheets.googleapis.com/v4/spreadsheets/MySheetID?ranges=A1:B5&key=TheServerKeyIGen...
Abbotson asked 15/8, 2016 at 4:27
7
Solved
I have a Sheets spreadsheet that has many cells that use a custom function which calls IMPORTHTML and parses the results. Other calculations in the sheet use the returned values from these custom f...
Tupiguarani asked 26/10, 2018 at 14:23
9
Solved
How to get the last row with value in the new Google Sheets API v4 ?
i use this to get a range from a sheet:
mService.spreadsheets().values().get("ID_SHEET", "Sheet1!A2:B50").execute();
how to ...
Cathrinecathryn asked 19/5, 2016 at 18:49
1 Next >
© 2022 - 2025 — McMap. All rights reserved.