6,173 questions
1
vote
1
answer
1k
views
Google Sheets API giving 400 response INVALID_ARGUMENT when attempting to add rows, can't figure out why
I am trying to add rows to a Google Spreadsheet using the Python API and I am getting a 400 response code and the response body says that all the values I am trying to add are invalid.
I simplified my ...
- 760
0
votes
2
answers
115
views
Sheets.Spreadsheets.Values.update doesn't write data into the sheets when triggered by installable trigger
I have data to be read from another sheet (Master Sheet) within a range
Master!A1:EE2000
and to be written on a separate sheet (Sheet A) with the same values (no alterations performed) and location.
...
- 3
0
votes
1
answer
839
views
Minimum Required Google Oauth Scope(s) to Read and Write specific (not all) Google Sheets Files?
Goodness, the OAuth landscape is elaborate! I've seen a bunch of posts that answer parts but not all of this question, including some that are old enough that there might be better answers now.
I'd ...
- 6,307
0
votes
0
answers
42
views
My line schedule does not work although I get data from GoogleSheets developer console
I'm trying to create a project that takes data from GoogleSheet and outputs it to the website as a linear graph, but somehow it doesn't work on the website, even though the graph itself is, and the ...
- 11
0
votes
2
answers
90
views
Writing a script to set current time depending on which cell the image is in
I have a setup of buttons in my "A" Column on my sheet that when pressed, log a value into the "F" column of the current time. However, each of these buttons is an individual image ...
- 3
0
votes
2
answers
119
views
Issues finding a google sheet in my drive
I am trying to get the data from a google sheet that is placed in my drive.The name of the file is "AnexoSepe".My code is simple:
"
var sheet=SpreadsheetApp.getActiveSpreadsheet()....
0
votes
0
answers
145
views
Remove a drawing using Google Sheets API
I have a drawing on a sheet that I use to indicate its a draft copy. When appropriate, this drawing needs to be removed.
Is it possible to remove a drawing using Google Sheets API?
i.e. the equivalent ...
0
votes
0
answers
131
views
Sending message from iframe to parent window and then to a second iframe to reload using Appscript WebApp
I have a main html, with iframe1 and iframe2 inside. I want to send a message to iframe2 to reload itself after a button has been pressed in iframe1. Message arrives successfully as can be seen in the ...
- 53
1
vote
0
answers
68
views
Access denied from google api to my python application
I programmed a small app to send data to google spreadsheets. It worked perfectly fine. I changed nothing on the code and suddenly I got authorisation error from google. I check online and found out ...
- 69
-1
votes
1
answer
353
views
Using Python's gspread, can I read the modifiedTime without fetching the entire spreadsheet? I want to use a local cache if there was no change
I'm using gspread to load read from my spreadsheets and it's working great. However, I'm hitting Google data caps quite often, especially when I'm testing.
I created a caching method that uses a local ...
- 341
0
votes
1
answer
1k
views
Check if a cell from a google sheet has a hyperlink inserted
I want my code to check the cell values from a column and pick only the rows that contains hyperlinks. The function has_hyperlink works with a local stored excel file, but when I try to use it on the ...
0
votes
1
answer
93
views
Writing Values to Google Sheet - Coroutines and NetworkOnMainThreadException Issue
I'm attempting to write data from a list to a specific Google Sheet. I've set up the configuration, but I'm encountering an error that seems related to not using a coroutine.
Is my approach correct? ...
- 103
0
votes
1
answer
53
views
Make a copy of certain columns from a spreadsheet to another spreadsheet using appscript
I have a spreadsheet file (master data) that I need to have its copy for my department. I want every change on master data is reflected to the copy file, including when someone adds a new tabsheet. ...
0
votes
2
answers
495
views
How can I format a part of a Google sheets cell value using googleapis?
I'm using https://www.npmjs.com/package/googleapis to insert data. One of my cells should contain multiple links, let's say
https://foo
https://bar
This is easy to do manually and I can query ...
- 13.5k
0
votes
1
answer
142
views
Trying to generate Chart Line on google sheet but with info horizontaly
I have the following info in google sheet, but all documentation to create google chart is more about to read the info in a vertical way and i have code to read it vertical but as you see my info is ...
- 17
1
vote
1
answer
139
views
Copy data from multiple Excel files to one worksheet in Google Sheets - ExcejJS - how to avoid overwriting data?
First of all - I'm a rookie, not a developer.
I'm trying to copy data from multiple excel files, that are in one folder, to one worksheet in Google Sheets. I'm using excelJS and Google Sheets API. The ...
- 13
0
votes
1
answer
825
views
i want to auto fill google form by data in google spreadsheets
i have this form
https://docs.google.com/forms/d/e/1FAIpQLSc4OjEgxlYpcAO7zkd9-jLNvkB3nZRsrkMv-IqVII6EnL0DnQ/viewform
and i want to submit 100 response into it,
every response will be 4 answers only.
...
-2
votes
1
answer
102
views
how can i find the greatest unique values like that table?
COMPANY
ID
NUMBER
NAME
WORKING HOUR
WORKING PRICE
WORKING DAY
AUDIT PRICE
BONUS
ALASKA
1
1232
JOHN
14,5
1102
23
1520
767
NEWYORK
1
1232
JOHN
1,5
114
7
375
0
OHIO
2
1414
HARRY
13,5
1020
25
1250
750
...
- 43
1
vote
2
answers
140
views
Stop the loop after the "code" is posted at the last row - google script
I am bit stuck here and trying to figure out the following:
How increment the id (code) if it reaches Item-00010 or Item-00100..and so on? Is it better to start the value string to "Item-1000&...
- 235
0
votes
1
answer
248
views
Writing to Google sheet from CSV add single quote in beginning
I am using python to get some data from database to csv and from csv to google sheet (sheet1).
When I write data from CSV to google sheet, it add a single quote in beginning of all values which ...
- 51
0
votes
1
answer
39
views
Google Authentication API not refreshing after a couple d
I followed the google API authentication steps, it worked initially but after a couple days following the same steps and redownloading "secrets" give me the above error, I thought this flow ...
0
votes
1
answer
432
views
google sheet api v4 non async function service build with Node js
I'm moving some python code to Node JS.
In python, I have connection to Google Sheet API v4 with a self.service = BuildService().build('sheets') function which I can initiate whenever I need ...
- 4,589
0
votes
0
answers
107
views
Write to google sheet through javascript API not working with Google Identity Services
I'm using a Google sheet API and I can read just fine from the Google sheet, but I can't write to it. From what I read, I needed to use Google Identity Services to login so I tried integrating it, but ...
0
votes
1
answer
88
views
Adding values to a row on google sheets appends to the bottom of list instead of the top
I'm writing an appscript on google sheets to implement reorder levels. I currently have a sheet called Reorder Levels Master. Through API's, it takes in live inventory from our Retail software and ...
- 1
0
votes
1
answer
74
views
how we can find the connexion of importrange function sources in ActiveSpreadsheets? [closed]
there are some sheets in my spreadsheet and I want find how many times I use importrange function to know every connection in my active spreadsheet.
Is there a formula to find this values?
-1
votes
1
answer
43
views
The code below creates spreadsheet (GSheets) and returns a link, but when i tried to open it and edit it i had no permission to do so. Any solutions?
There is my code:
from gspread_asyncio import AsyncioGspreadClientManager
import io
import csv
from google.oauth2 import service_account
from gspread.exceptions import SpreadsheetNotFound
async def ...
0
votes
1
answer
194
views
Google sheet automatically generate a pdf and send an email to notify
I need to write a script that allows me to automatically save a pdf after the data has been refreshed and send people an email.
The current problem is that there are too many columns in the google ...
- 65
1
vote
1
answer
133
views
Why after connect to Google OAuth2 the result.Credential is null?
I use the code below to authorize and refresh tokens to update some data in the Google sheet in my ASP.net MVC project,
I knew that after 1 hour, the token would expire, So I checked the expiration ...
- 892
-1
votes
1
answer
528
views
How to properly use the value_input_option for Google Sheets API
How do I use the batch_update correctly?
Here is the relevant code:
client = gspread.authorize(creds)
val = ['99', '0', '0', '0', '0', '98', '98', '0', '0', '105', '0', '0', '105', '106', '99', '102',...
-1
votes
1
answer
39
views
Show some of the rows in a Google Sheet
I have a Google Sheet stores all training records of all students. I want to set up something to let the clients only see their own records. If it is something Google Sheet could help me?
Please see ...
- 1
2
votes
1
answer
615
views
Google sheets python API - module 'google.auth.credentials' has no attribute 'CredentialsWithTokenUri'
I'm trying to set up the Google Sheets API for python. When I run the quickstart.py file (exactly as specified in the google documentation), I receive the following error:
AttributeError: module '...
- 41
0
votes
1
answer
105
views
Python sort google sheets API by column
I researched the topic and found this: Google Sheets API Sort column by date
The problem is that it sorts by column A.
So I changed it to the following:
request = {
"requests"...
- 5
0
votes
1
answer
527
views
How can I find my pay period number using a date in Google Sheets?
I'm keeping track of my time card and pay periods in google sheets, and I'd like to automatically fill the 'Pay Period' column based on the date of the shift I'm recording.
Date
Pay Period
10/30/23
13
...
- 16
0
votes
1
answer
213
views
Get number format from source data for individual values in Google Sheets charts
In Google Sheets it is possible for data labels in a chart to reflect the number formats for individual scale points? Even if its only possible via the Google Sheets REST API that would be fine.
...
- 8,195
1
vote
0
answers
97
views
Google Authentication Error for Google Sheet C#
In my asp.net application, I connected Google Sheets to read some data and show it in my view.
So I logged on to the Google account that Google Sheets has and went to the Google Cloud Console.
There I ...
- 621
0
votes
0
answers
76
views
Create a sheet that unify other sheets
I have a file with several sheets, they're all the same but contain data from different sources.
I would like to create a new sheet that updates automatically and give me the total of all the other ...
- 13
0
votes
0
answers
114
views
How to use Google API Sheets without OOB URI?
My app is a ruby on rails one.
I developed in 2018 one which used OAuth 2.0 authentication with an OOB_URI. But this technique doesn't work anymore and the Google sheets API documentation had changed.
...
- 75
3
votes
0
answers
131
views
google.accounts.oauth2.initCodeClient callback is not triggered for google sheets api
Goog morning from Sri Lanka!!! here goes my first question in StackOverflow. I am a novice, and bear with me its total stupid question.
I am trying to get google sheets data for wordpress site using ...
- 31
2
votes
2
answers
640
views
How can I set up a Google OAuth2 client using https scheme in Java using?
I am writing an application that uses the Spreadsheets API. Because I am using the write scope, which is sensitive, the OAuth2 redirect URI must use https instead of http (except when using localhost)....
- 328
0
votes
1
answer
276
views
How can i get a cell with multiple HYPERLINK tags from Google Sheets with GSpread
I need to get links from HYPERLINK'd cell, but i really dont know how i can do it.
I need to get links from HYPERLINK'd cells [Pic. 1] and i cant find any documentation on this problem in GSpread's ...
- 11
1
vote
0
answers
138
views
Google Sheets Service Account "keyfilePath error" NodeJs
I'm attempting to create a script to access data from a Google Sheet using a service account for authentication. However, when I run the script, I encounter an error that I'm having trouble ...
0
votes
1
answer
191
views
Highlighting rows and columns in google sheet using gspread
I am working on google sheets and using gspread to dump some data from different sources in it. Then I have some rows and columns which I want to highlight by a color but for some reason it is only ...
- 15
1
vote
1
answer
526
views
Resolve script error in google app script for sheets "The parameters (number[],String,String) don't match the method signature for Utilities.newBlob."
I'm trying to convert a column containing several rows of HTML code into rich text in another column. When I do it on a single cell, I succeed. But when I try to convert all the rows in the column ...
- 13
0
votes
1
answer
2k
views
Google Sheets API: socket.timeout: The read operation timed out
I am trying to upload about 40k rows (39345 rows x 60 columns) with Google Sheets API and I am getting the following error:
Error, sleep for 101 seconds
Traceback (most recent call last):
File "...
- 2,427
0
votes
2
answers
546
views
Copy multiple cells across multiple rows and columns, and paste to single row, with cells pasted sequentially
I have a data-set in Google Sheets that needs to be rearranged. I have data across multiple rows and columns that I would like to be pasted onto a single row, sequentially, following a logic of left ...
0
votes
1
answer
232
views
Custom Number Format not Showing in Arrayformula (Maybe Due to Script?)
EDIT: Added example sheet for clarity. Sorry for the delay, the real sheet is complicated and I had to track down which bits were most relevant to use in said example, while also being confident that ...
1
vote
1
answer
204
views
Script to hide and unhide non consecutive columns in google sheets
I'm working on a financial forecast vs Actuals. I created a button to separate forecast months vs. actual months and need a script to make them work. I want too be able to click forecast button, and ...
- 13
0
votes
0
answers
234
views
How to avoid the TEXTJOIN character limit with large Google sheets for matching values?
I've got four different sheets on one Google Sheet file. What they are is meter usage and costs from two different companies. The meters are the same, but when switching to the other company, they ...
0
votes
0
answers
77
views
How can I have human-less authorization and automation with Google Workspace APIs that have access to Google Drive/Sheets APIs in GCP?
Our organization is on Google Workspace enterprise.
We create projects in GCP so we can get tokens to make Google Workspace API calls (Google Drive and Google Sheets).
I want to write a program that ...
- 5,933
0
votes
1
answer
994
views
How to add multiple hyperlinks in a single-cell in Google Sheets using Python?
I'm working on a Python script to update a Google Sheets document using the Google Sheets API, and I need to add multiple hyperlinks in a single cell along with some messages. However, I'm having ...
- 212