6,173 questions
2
votes
1
answer
263
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
60
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
24
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
58
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
61
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
144
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, ...
- 114k
0
votes
2
answers
300
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 ...
- 2,956
0
votes
2
answers
132
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": [
{
...
- 443
0
votes
0
answers
35
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
95
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,922
0
votes
1
answer
56
views
Page Totals and Running Totals on Export in Google Sheets
I'm looking to export a logbook of mine to paper. The logbook consists of entries of hours based on dates that continue row by row.
I need to export these entries through printing with each page ...
0
votes
0
answers
91
views
The caller does not have permission
I have the code to create a new Spreadsheet using Service account, everything was working good, but after I change the sheet value manually with my own email, google has blocked the spreadsheetsand ...
- 1,517
1
vote
2
answers
129
views
Google sheets setting columns range in app script
I have this worksheet that im working on:
https://docs.google.com/spreadsheets/d/1u_CafEOKNLtthpWaXVo37BKiuRHQ2oGEC4liqkTmXuY/edit?usp=drivesdk
and I have this script:
function createWhatsAppHyperlink(...
- 11
0
votes
1
answer
170
views
How to debug Sheets.Spreadsheets.batchUpdate
I have a script that imports sheets from one project to another by way of the script ID. It's a very large script so it would not be feasible for me to condense it down to a MRE because I do not know ...
- 347
0
votes
0
answers
61
views
AppScript creates #ERROR! depending on folder of saved file
I've programmed an App Script in Google Sheets. This App Script provides the name of the respective sheet (tab) as a formula. I've used this App Script in several Google Sheets, all of which are ...
- 9
