6,157 questions
0
votes
1
answer
114
views
Exception: API call to sheets.spreadsheets.batchUpdate failed with error: Empty response
I would like to know if there is someone intimately familiar with the Google sheets API who knows precisely what this error means:
Exception: API call to sheets.spreadsheets.batchUpdate failed with ...
- 359
2
votes
0
answers
84
views
Request text rotation in Google Sheets API [duplicate]
I want to replicate a sheet from Google Sheets to a Markdown type. I'm using the API to request it:
from google.oauth2.service_account import Credentials
from googleapiclient.discovery import build
...
Best practices
0
votes
2
replies
94
views
Why is there no spreadsheets.file scope similar to drive.file for user-selected Sheets only?
I’m running into some confusion with OAuth scopes around Google Sheets and wanted to sanity check that I’m not missing something obvious.
My use case is pretty simple:
I let users pick a Google Sheet ...
- 2,249
3
votes
1
answer
78
views
How to get information from merged cell in Google Sheets API
I have a problem. I need to get info from merged cell, but this information only on first cell of this merged cell.
F.e. I get request for cells C2:C3. But C3 is a part of merged cell A3:C3. How I ...
- 21
0
votes
1
answer
69
views
When big data : requests.exceptions.ConnectionError: ('Connection aborted.', RemoteDisconnected('Remote end closed connection without response'))
The problem appears when i have a big amount of values in my pandas df. When i take 27 or 54 values(1 or 2 columns) it works normaly, but when i take more columns it gives me this erorr (i import gs ...
1
vote
1
answer
476
views
'str' object is not callable in Google SDK when trying to fetch a spreadsheet
I'm trying to fetch a spreadsheet with Google SDK. I'm logged into an account with a Service Account Token Creator role and the service account has access rights to the spreadsheet. This is my code:
...
Advice
0
votes
4
replies
79
views
Slides Add-On accessing Sheets Data and Narrowing Scopes
I have an Add-On under review in the Google Marketplace.
My Add-On runs in Google Slides and needs to access Google Sheets data to create various visuals in Slides. Specifically my Add-On pulls data ...
- 67
0
votes
0
answers
30
views
How to insert an image from Google Drive inside a Google Sheet Cell programmatically (via API)?
Everything is in the title.
Google Sheet API v4 doesn't have a native method to add an image into a cell.
Google App Scripts doesn't work with a service account which I'm using.
IMAGE() function doesn'...
- 71
0
votes
0
answers
76
views
Flask + gspread: multiple Google Sheets API calls (20+) per scan instead of 1
I’m building a Flask web app for a Model UN conference with around 350-400 registered delegates.
OCs (Organizing Committee members) log in.
They scan delegate IDs (QR codes or manual input).
The ...
0
votes
0
answers
67
views
What function should I use to search a 2d Array for a value and return all values from left most column
I Have a sheet that is bringing across all the article ID's listed there (and associated names) in line with the said name of that sheet.
Also above this information I am looking to make a simple ...
0
votes
0
answers
168
views
How to create a Google Spreadsheet document using a service account?
I am building a script which is supposed to create and update documents in a certain folder of my Google Drive (personal account, not Google Workspace).
If there is no document that particular name, ...
- 115k
-1
votes
2
answers
505
views
Change the vertical padding in Google Sheets tables
In Google Sheets, if you click Insert → Pre-built tables and then for example Blank table, the vertical padding of cells changes and userEnteredFormat.padding stops having an effect (you can try ...
- 3,173
0
votes
2
answers
149
views
How to fix offset column names in `addTable` request?
I'm trying to create a Table in a Google Sheet using the API in Python.
I've constructed an API request that mimics the example one here. My request looks like this:
{
"requests": [
{
...
- 465
0
votes
0
answers
41
views
automate =QUERY(IMPORTRANGE) or =IMPORTRANGE()
I need to have =QUERY(IMPORTRANGE) or simply =IMPORTRANGE() in sheets2 and sheets3 to automatically do its' thing as soon as the exporting sheet (source file) receives the data from its' source (drive ...
0
votes
0
answers
114
views
Node.js Google Sheets API returns 401 'Login Required' on first call despite valid refresh token
I am building a Node.js server-side application that needs to interact with the Google Sheets API on behalf of a user using the googleapis and google-auth-library packages.
I have successfully ...
- 1,982