Questions tagged [google-sheets-api]
The Google Sheets API lets developers write third-party applications that read and modify any aspect of spreadsheets. Not to be confused with [google-apps-script]
google-sheets-api
6,178
questions
0
votes
0
answers
19
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://...
1
vote
1
answer
35
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 ...
0
votes
0
answers
31
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 ...
0
votes
1
answer
25
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 ...
0
votes
0
answers
33
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
57
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
45
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
43
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 ...
1
vote
2
answers
32
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 ...
0
votes
1
answer
36
views
How to retrive 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("...
0
votes
1
answer
20
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
30
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 ...
0
votes
0
answers
15
views
TransportError: HTTPSConnectionPool
import gspread
from google.oauth2.service_account import Credentials
import pandas as pd
scope = ["https://spreadsheets.google.com/feeds", "https://www.googleapis.com/auth/spreadsheets&...
0
votes
0
answers
32
views
Get access to hyperlinks which was added in UI
I'm trying to get access to all hyperlinks in my sheet using python and gsheet api v4. But fields='sheets/data/rowData/values/hyperlink' is not working, valueRenderOption=FORMULA not working because ...
0
votes
1
answer
26
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 ...