All Questions
Tagged with google-workspace google-sheets-api
67
questions
0
votes
1
answer
58
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/...
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 ...
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
0
answers
35
views
Google Sheets not showing the last column in full
I have a couple of sheets that won't scroll all the way to the right to display the last column in full. I have tried adding in columns beside it & adjusting the width.
This sheet is using the ...
0
votes
0
answers
12
views
How to create pivottable filter
How can i create a pivot table filter using python, like filter by "namecolumn1"" == 1 | 2. I've tried searching in the API documentation but idk how to do it.
I've tried everthing
if ...
0
votes
0
answers
12
views
How to assign points automatically from one table to another?
I'm organising a challenge where participants get points on different categories. I'm going to assign numbers to the tables to make the understanding easier.
On table 1, I have a ranking system of ...
0
votes
0
answers
8
views
Spread sheet issue with sending from ipad to Gmail on computer
Ok, the last few days my coworker has been sending emails but the times aren't transfers to me but will transfer to my phone and outlook? What could be the cause? I am needing to get this resolved ...
0
votes
1
answer
19
views
Can I create a master spreadsheet of data and then only allow each individual to see their row?
I have compile data for our first aid squad for a program that we have.
Each person earns points for various activities.
I have a master spreadsheet which I share with the group. However, I want ...
0
votes
0
answers
41
views
Google sheets API in Python wrong SSL version error
I'm getting this strange intermittent wrong SSL version error that occurs in my python server, and I can't for the life of me figure out how to fix it. I asked ChatGPT and it told me to update python ...
-1
votes
1
answer
102
views
Date format in google shee
[google-sheets-api] I'm currently working on google sheet (excel) but having problems due to date formats. Our original excel sheet contains the format (dd/mm/yyyy which we cannot change) and when we ...
1
vote
0
answers
18
views
Making a cell change to the current date and time when anything is changed
So I have a Storage General Arrangement for the company I work with, and we have a google sheet to make it easier to know where certain claim addresses are. Within our sheets, I want to make a cell ...
0
votes
0
answers
25
views
How do I auto-fill multiple cells based on a value chosen in a drop down list in google sheets
I been trying and trying to create a drop down list to which when I click on a value in it, it will auto-fill the cells next to it.
The data that needs to be autofilled is pulled from another tab ...
1
vote
0
answers
117
views
google.apps.sheets.v4.SpreadsheetsService.GetValues 100% errors 503 "The service is currently unavailable.","status":"UNAVAILABLE"
I'm facing strange behaviours from google sheet api v4 since saturday as I get 503 error almost 1O out of 10 when trying to update or append values through api. Here are some values from google sheet ...
0
votes
0
answers
14
views
Timed Auto-Clear cells across multiple sheets in a Workbook
enter image description hereenter image description here
The title pretty much says it all. In the workbook I created there are about 6 corresponding sheets. My goal is to have the information in ...