6,173 questions
0
votes
1
answer
55
views
JavaScript Query Google Sheets API To Retrieve All Sheets
I have the following code to query a single sheet (Sheet1) from a google sheet document. Haven't been able to find any documentation on how to query all sheets from the file
const GoogleSpreadsheet = ...
1
vote
2
answers
98
views
=IFERROR(Rounddown(datedif(B2,C2,"D")/7)) Make this show the weeks up to the date even if I don't have an end date yet
In google sheets I am using this formula to currently calculate the amount of time that has taken place between two dates. =IFERROR(Rounddown(datedif(B2,C2,"D")/7))
Is there something I can ...
0
votes
0
answers
23
views
Getting error "Exception: The script does not have permission to perform that action." with Apps Script [duplicate]
I've been trying to get a script from Apps Script to work with a specific Google Sheets whenever a certain column cell is changed, but for some reason, the script just returns "Exception: The ...
0
votes
2
answers
48
views
Question on google sheets URL from another language, like VB
In this line, https://docs.google.com/spreadsheets/d/[myworksheet]/edit?gid=0#gid=0, what does /d/ do and what other values could be there? Same questions for /edit, ?gid and #gid. (note- I could ...
- 3
-1
votes
1
answer
123
views
How can i read and write to cells in the same function?
I would like to read the spreadsheet cell H2 in the same function blackList
With this script, i am currently writing to cell H1. I would like to read cell H2 as well.
This is my updated script:
const {...
- 13
-1
votes
1
answer
95
views
How can i write to a specific cell in a Google sheets range?
I am creating a discord bot and would like to write to a specific cell in Google sheets. With this code i am able to post the userInput into the embed when the command is executed on discord.
However ...
- 13
1
vote
1
answer
83
views
How can I use specific cells in a Google sheets range?
I'm creating a Discord bot. Whenever I use the command that this is linked to it works. However it displays all the data in all cells in the set range. How do I get a specific cell out of the range ...
- 13
1
vote
1
answer
191
views
Send event from Google Spreadsheet to a Chrome extension
I previously had a Google Spreadsheet where I was able to send an event with parameters to my Google Chrome extension. It was a bit of a hack but the cell in my spreadsheet had something like this -
=...
- 2,166
0
votes
1
answer
95
views
Google Sheets API - Bolding and Highlighting text
I am using the Google Sheet API. My code is working as expected. Now though, I want to add some bolding, highlighting, etc. I have reviewed other pieces of code but I am not fully understanding how to ...
- 409
0
votes
1
answer
62
views
Google API: Loop through mySQL results to add multiple rows to Google Sheet
I dreaded posting this because I should have been able to figure this out. All I am trying to do is loop through the results in a mySQL query and add those rows into Google Sheets. I do not want to ...
- 409
1
vote
1
answer
437
views
Using Sheets.Spreadsheets.Values.update() Correctly
I've created an array that I'd like to have pasted on a sheet in cell A1. I'm aware of how to do that using setValues() but I was under the impression that using Sheets.Spreadsheets.Values.update() ...
- 766
0
votes
1
answer
259
views
Error when trying to import a CSV file to a live GoogleSheets: "DeprecationWarning: The order of arguments in worksheet.update() has changed"
This is my query:
import gspread
from google.oauth2.service_account import Credentials
import csv
# Path to your service account key file
SERVICE_ACCOUNT_FILE = '/Users/xxx/Desktop/projects/importcsv....
- 21
0
votes
1
answer
65
views
Google OAuth2.0 Callback on Java Spring returning different redirect_uri
I'm currently developing a program that using google sheet API to get some data. I tried deploying it onto Amazon EC2 (Amazon Linux) and configured SSL using Let's Encrpyt. Everything is working fine ...
- 1
0
votes
1
answer
351
views
Sending data from react app to google sheets w axios
I'm super new with React and Typescript, just started this week. I'm trying to make a form and upon form submission the data is sent to Google Sheets. I came across a few articles, and went with the ...
1
vote
1
answer
267
views
How get raw cell data from google sheets?
I receive data using Google Sheets API and want to get a link to a file that is located on Google Drive, the link is displayed as an icon and label as in the screenshot.
I am using the method https://...
- 314
1
vote
1
answer
81
views
javascript read google sheet value.getBatch issue
I could use javascript fetch() to read a google sheet single value without an issue. However, when tried reading multiple ranges, get error 403.
This code works fine:
const apiKey = 'key-here';
const ...
- 65
1
vote
1
answer
571
views
How to append a row to Google Sheets API? It's not working with Jquery: code 403 Unregistered callers
Here's the request URL format I am using currently:
postResURL = https://sheets.googleapis.com/v4/spreadsheets/${SHEET_ID}/values/Reserved!B2:D7:append?valueInputOption=RAW&key=${API_KEY}
Here is ...
- 480
-1
votes
1
answer
1k
views
Google Sheets API 404 error: "Requested Entity Was Not Found" Uncaught Google\Service\Exception
first let me say i apologize if this is an easy solution, i've never used google api or anything similar, as well as i'm new to php
i'm currently trying to read a spreadsheet using google sheets api ...
- 1
0
votes
1
answer
426
views
Google sheets API v4 - Getting 429 [ Resource has been exhausted (e.g. check quota) ] during spreadsheet creation
I am trying to create a google sheet using java springboot. Even though my request quota hasn't exceeded, i'm getting the 429 Too many requests exception.
Error image : (https://i.sstatic.net/m1axt0Ds....
0
votes
1
answer
133
views
Send mail function is not working, it gives no authorization to send mail. But the authorization is there and it sends email on test email function
function onEdit(e) {
try {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
if (sheet.getName() === "To Do List" && e.range....
0
votes
1
answer
60
views
google sheet url is not following the expected strcture
Yesterday I noticed that google api is formatting the sheet url different than before.
According to the Google Sheets API docs, the format of a google sheet url should be:
https://docs.google.com/...
1
vote
0
answers
300
views
Read operation timing out error with google drive api
When I am attempting to upload images to a google drive folder through my Python Flask web server using Google API, setting their permissions, and creating a spreadsheet with simple attributes that I ...
- 11
1
vote
1
answer
72
views
GSPREAD bulk export of dataframes on separate sheets without triggering API write request limits
I am running up against the gsheet api quota for write requests when writing some relatively small dataframes to a single spreadsheet.
The dataframes are held in a dictionary. The KEY is used for the ...
- 146
0
votes
1
answer
110
views
How to retrieve all sheets data from google sheets api using apache camel
I want to be able to retrieve all the sheets' (sheet1,sheet2,...etc) data from Google Sheets, not just one sheet (sheet1, in this example):
from("timer:run?repeatCount=1")
.to("...
- 11
0
votes
1
answer
75
views
Google Sheet Python API Cell formatting issue with 'repeatCell' request, resulting in no replies
I am trying to format multiple cells with spreadsheets().batchUpdate(spreadsheetId=ssid, body=body).execute()
firstly, I get formatting request using the following functions:
#this function gets ...
1
vote
1
answer
63
views
laravel google sheets adds apostrophe in some cases
I was able to successfully append data to my Sheet using laravel google sheets. The issue is with all dates and some integers. When uploaded, an apostrophe is added in front of the values.
I ensured ...
- 115
0
votes
1
answer
55
views
Kivy/Buildozer app using google sheets API crashes upon start
I am trying to run a Kivy app on my android phone (Xiaomi Redmi Note 12 Pro) which uses the google sheets API to write data to a google sheet upon pressing a button. For this I am using buildozer.
I ...
0
votes
0
answers
370
views
C# GoogleSheetsApi Error: The service sheets has thrown an exception. HttpStatusCode is NotFound. Requested entity was not found
I have a problem, GoogleSheetsApi does not see the table, despite the fact that it is configured and should work. I tried everything and couldn't solve the problem. Tell me, maybe someone knows a ...
0
votes
0
answers
75
views
Is there a way to convert all the worksheets within a google sheets spreadsheet to individual PDFs
Currently I have a google sheets spreadsheet for a project that I am working on that has a many worksheets. I am looking for a way to convert each worksheet into a PDF where the name of the PDF is the ...
- 11
1
vote
1
answer
70
views
Google Sheets - Image from URL is not received on email using Apps Script
I will explain what I'm trying to do.
I need to send a unique QR code per each row to the respective email IDs.
Below is the screenshot of the Google Sheet format:
Below is the App Script code (This ...
- 379
-1
votes
1
answer
107
views
How do I make separate api calls for different sheets (that are from one spreadsheet)?
I am trying to integrate google sheets api with nodejs. I am wondering what the correct syntax is for calling two different sheets, separately (note that they are inside one spreadsheet). I tried ...
- 47
0
votes
1
answer
141
views
Give access to a Big Query view to Google Sheets add-on users
I'd like to give my Google Sheets add-on users the ability to view Big Query data in a connnected sheet.
The perfect flow would be:
1- They push the button to display their data (from the sidebar)
2- ...
- 825
0
votes
1
answer
167
views
Duplicate sheet along with its scripts
I have a template google sheet that I use as a registration form. It has a attached google apps script that, when the submit button is clicked, scrapes the data from the sheet and sends it to my BE. ...
- 79
1
vote
0
answers
18
views
Get javax.net.ssl.SSLHandshakeException when trying to connect to google sheets api [duplicate]
I have the following problem - when I try to use google sheets api to fulfill my google document from a Spring application, i get the following error:
javax.net.ssl.SSLHandshakeException: PKIX path ...
0
votes
1
answer
55
views
How can I detect if a column is hidden?
I have a sheet where certain data is hidden and I need to ensure that I don't show that data if it's hidden (which columns are hidden will change frequently).
How can I detect which columns are hidden?...
- 409
-1
votes
1
answer
75
views
google sheets v4 API. how to add error bars to column chart?
I'm creating google spreadsheet and a chart inside following the sample code at https://developers.google.com/sheets/api/samples/charts
I did not find the properties inside BasicChartSpec https://...
- 159
0
votes
0
answers
33
views
Google App Script Export PDF isn't syncing [duplicate]
I have the following data in my Spreadsheet
Since the latest doc_no is TRY/2024/05/06/0707857126, I want to generate a PDF according to that number. Here's the PDF Spreadsheet:
I'm able to generate ...
- 1,099
1
vote
1
answer
84
views
Google Sheets to PDF - How to programmatically trim blank lines at the bottom of the printout?
I am using the following script, which works great to save a PDF copy of a particular Google Sheet to my Google Drive. It specifically saves overtop of an existing file on a schedule, but does not ...
- 33
0
votes
1
answer
41
views
Append Inserting in Random Rows
I'm inserting data into sheets using append, but the new data ends up being inserted in random positions. Sometimes at the bottom, sometimes at the top. Apparently sometimes in the middle also, ...
- 175
0
votes
1
answer
75
views
Copy and paste format in a spreadsheet using gspread
Want to copy format in particular cells in google sheet and paste it in a different cell. Using batch_update to do this but getting the following error:
ERROR -
values["range"] = ...
0
votes
1
answer
89
views
Problem selecting rows meeting specific conditions in Goolge-Sheets and NodeJS
My webapp backend is in Node.js, used for reading/writing to/from a Google Sheets spreadsheet.
I want to use a query that will retrieve only rows which meet specific conditions, but haven't been able ...
- 6,187
1
vote
1
answer
87
views
Sumproduct through Google Script PT2
This is a follow-up to a question I had asked some time ago. The person who answered it requested I set up a new question rather than modify the existing so here it goes.
Here is the sample document. ...
- 766
2
votes
0
answers
88
views
Google Sheets API Reading the table
I don't know how to write code in order to read the information from the Sheet and send it to Winforms (VisualStudio) to get the values and output them to the user. also connected the Google.Apis....
0
votes
1
answer
600
views
How to use batchUpdate in Node.js
I am using the following method to access a Google Spreadsheet using Javascript to, for example, insert a row of data:
const Sheets = require("@googleapis/sheets");
const jwt = new Sheets....
- 16.5k
0
votes
1
answer
42
views
Google Sheet script to copy hyperlinked text into a new tab
The script that I’m using on GoogleSheet Appscript when moving one row to a new tab any hyperlinked text will not paste over to the new tab. How can I solve for this?
Google Sheet Link: https://docs....
- 3
0
votes
2
answers
285
views
My Python script can't access my Google Sheet
My Python script can't access my Google Sheet as I'm getting this error:
Exception has occurred: RefreshError
('invalid_grant: Invalid JWT Signature.', {'error': 'invalid_grant', 'error_description': '...
0
votes
1
answer
126
views
How to read hyperlinks from range_read_cells() in googlesheets4
I need to read the urls from hyperlinks in Google sheets (where applicable) to be used in other parts of my analysis. I was reading my data with read_sheet() or range_read(), but that only gives me ...
- 26
1
vote
0
answers
79
views
Find the type of Google Sheet Chart tab using Google Sheets API/Apps Script
I have many sheets in a Google Sheet, I want to check the type of sheet via Google Apps Script
I know a chart sheet as well as a timeline sheet is a "OBJECT"
How to differentiate between the ...
- 3,198
0
votes
1
answer
400
views
API call to sheets.spreadsheets.values.append failed with error: Empty response
I am using Google Sheet API Request and I am not getting even an error message to know what I am lacking or what I am doing wrong. I am getting API call to sheets.spreadsheets.values.append failed ...
-1
votes
1
answer
102
views
Error when entering data via Telegram bot for the second time
Error when creating a telegram bot, when entering the Name/Email/Phone, I ask him to do this again, then he gives me the following error message:
<HttpError 400 when requesting https://sheets....
