Skip to main content
6,173 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
41 views

Context We have a master template and many users using copies of it in their accounts. I'm using apps script to update users sheets to new version, once we make changes to master template spreadsheet. ...
roma's user avatar
  • 1,590
2 votes
2 answers
622 views

As the title suggests, I would like to create a Table from a specific range in a worksheet using code from Apps Script. I searched around but I didn't find an answer. Thanks Google Sheets Table I did ...
Sebastián Sombra's user avatar
  • 23
0 votes
0 answers
62 views

I'm using time-driven triggers in my apps script to get it to run my code every 2 hours. The problem is that there are reasonably specific times I would like this to happen - it doesn't have to be ...
Katie Hannah's user avatar
  • 1
0 votes
0 answers
117 views

The program works as it should, that is, it fills in the Google Sheets table, but for some reason, when executing this code, the error This range already has a worksheet with different title set is ...
Ali's user avatar
  • 1
0 votes
2 answers
334 views

I've written an Apps Script function that sets values to non-contiguous cells in multiple sheets. This particular function is tied to a custom sheet operation that the user can call from a custom menu ...
J_code's user avatar
  • 347
1 vote
1 answer
100 views

I'm trying to build an Android app using Android Studio, and I'm having issues resolving the Google Sheets API dependency during Gradle sync. What I've tried: Added the required dependencies to build....
אורי עזריה's user avatar
  • 11
0 votes
0 answers
125 views

We are using the Google API to read sheet data from Google Sheets (in Node.js): const res = await sheets.spreadsheets.values.get( { spreadsheetId: spreadsheetId, range: sheetName, ...
Andre M's user avatar
  • 7,718
0 votes
0 answers
42 views

I just need some help. I have been using this script, however today I got this error. I have not change anything and it works perfectly fine until today. function createPMA() { var ui = ...
Hannabi's user avatar
  • 1
0 votes
0 answers
20 views

I am experiencing the same problem as i am trying to create a chart using PHP Google Sheets API error 400 Invalid requests[0].addChart: error pops up but I was advised, not to reply unless it was ...
Tom Cornelis's user avatar
  • 1
0 votes
0 answers
31 views

I have a cell that will not show anything else but the number "0". I have erased it, added a formula, changed font, size, color and nothing will show up but a "0". DOes anyone know ...
Carlos Casas-Hawkins's user avatar
  • 1
1 vote
0 answers
30 views

I have a table with one of the columns containing a list of comma delimited values in google sheets. How do I transform each element of a list-like to a row, replicating index values. Python ...
Sagar agarwal's user avatar
  • 11
0 votes
2 answers
71 views

I'm trying to organize my partner management using Google Sheets. I have a main spreadsheet where columns F-I are dynamic, meaning I want data from these columns to be transferred to columns A-D in ...
Kristina's user avatar
  • 1
0 votes
0 answers
45 views

After adding and updating some data in a Google Sheet, I want to sort the whole sheet by column D. Yet my code has no effect (nor error message). Sorting via web interface works fine. Setting a ...
Cerber's user avatar
  • 2,959
1 vote
1 answer
129 views

The problem: I am developing a Google Sheets add-on using Google Apps Script. The goal is to create a custom menu in Google Sheets that allows users to apply specific formatting options. The add-on ...
Marketing Rigotti Consultoria's user avatar
  • 11
0 votes
0 answers
28 views

I have a sales tracking sheet. I have different employees on a dropdown list. I would like to create a summary sheet that will pull data in the row of the employee in the dropdown shift to one page ...
Eric Abney's user avatar
  • 1
0 votes
2 answers
173 views

I'm using the Google Sheets API to fetch data from a sheet where numbers use a European locale. The input Google Sheet looks like this: product_price impressions clicks ctr avg_click_price ...
Anton Mislawsky's user avatar
  • 31
0 votes
1 answer
64 views

I want to have a vaule in my google sheet increase when above a number e.g. when above 20 it will increase by 1,000 for every 1 it goes up but is there anyway to have it work that way and when it is ...
Lil Wally's user avatar
  • 3
0 votes
1 answer
135 views

I've used a script from a kind and helpful commentor and it worked if my format in the sheets are the same. However, when i type in the details and the row size changed, the page is shifted to the ...
russetsyren's user avatar
  • 33
0 votes
0 answers
75 views

I use the following code to read google sheet ,Recently at certain times of the day, and this operation always timeout and it used to work normally public List<List<Object>> ...
lvsiqi's user avatar
  • 24
0 votes
0 answers
104 views

community members. I sincerely hope that one of you has tried solving this challenge, which is driving me up the wall. My Objective I need to update some cells in a Google Sheet associated with a Jira ...
Ben's user avatar
  • 15
1 vote
1 answer
153 views

I am using the Python Client to amend a Google Sheet shared to a Google Service Account. Everything works as expected when using a Sheet that is created by the Service Account, but returns a Requested ...
Jason Dilworth's user avatar
  • 45
0 votes
1 answer
138 views

I have been trying to convert a Google sheet to a PDF file. (This is the input Google Sheet.) I have browsed the internet and gotten to converting the Google Sheets to HTML using the gspread library, ...
Anish's user avatar
  • 13
1 vote
1 answer
78 views

I'm writing a Python script that uploads a Polars DataFrame to Google Sheets and formats it accordingly. One of my goals is to create a summary row at the bottom of the table that sums the numerical ...
Austin Mangelson's user avatar
  • 53
0 votes
0 answers
122 views

We have a simple table based grid on an html page that contains a few icons which are about 1KB in size. Our end users have copied and pasted info out of this table into google sheets for about 10 ...
Matt's user avatar
  • 1,610
0 votes
1 answer
61 views

I have a sheet in the following format: What I need to do is, sorting the skills by skill number, not alphabetically. I'm having trouble because the original sheet has thousands of names. Here's what ...
Altinos's user avatar
  • 3
0 votes
3 answers
103 views

I have a table managed list of items (Green row), and its quantity by using a table (like a matrix). But in the end I want to combine it into one single string by each row, representing the quantity ...
Nguyễn Nguyễn's user avatar
  • 1
2 votes
0 answers
100 views

When using the Google Sheets API - spreadsheets/get (docs) I don't see any ETag value, but it seems that it CAN be in the APIs: var sheet = test.Spreadsheets.Get("1WC7CGN**************************...
Mark Bøg Lønquist's user avatar
  • 21
2 votes
1 answer
85 views

I'm trying to use Google Apps Script to populate column D of my Google Sheet with the corresponding CVE description based on the CVE ID from column A. I'm getting the CVE descriptions/summary from the ...
Praveen K S's user avatar
  • 21
0 votes
2 answers
65 views

This needs to be using Google Sheets API and PHP I have a singleton wrapper class (lets face it, most Google PHP apis need them) of which an instance in my client class is $gsheets I have had this ...
Datadimension's user avatar
  • 1,104
0 votes
0 answers
82 views

I'm able to read rows from my google sheet, but unable to write to it (append rows).. That probably means that I'm clear on the whole authentication business right? Below is my code for trying to ...
qandaqanda's user avatar
  • 1
0 votes
1 answer
76 views

This is an example from their docs: import gspread credentials = { "type": "service_account", "project_id": "api-project-XXX", "private_key_id&...
x89's user avatar
  • 3,522
1 vote
0 answers
74 views

I’m having trouble with GitHub Actions while trying to integrate with the Google Sheets API. I’m attempting to save my Google Sheets credentials as a credentials.json file from repository secrets, but ...
3l3ctric_philip's user avatar
  • 11
1 vote
1 answer
102 views

All commands of gspread send requests? Here error 429 doesnt raise gc = gs.service_account(filename="service_files/creds.json") wks = gc.open_by_key("url have 35 list") article = []...
Teramisu's user avatar
  • 13
0 votes
1 answer
90 views

Using Google Sheets, I have this formula that takes text data from multiple cells from another sheets: ='24 KPI Weekly'!Z5&" / "&'24 KPI Weekly'!Z6&" / "&'24 KPI ...
Fan H's user avatar
  • 3
0 votes
1 answer
60 views

We have encountered a regression in the functionality involving the Google Sheets API. Our system is frequently receiving a 502 error with the following message: That’s an error. The server ...
user14557232's user avatar
  • 1
0 votes
0 answers
79 views

I'm quite new to programming in general and was hoping someone could help me with this issue: I have a Python script that was working fine until today. The script reads a Google Sheets spreadsheet ...
João Victor Matriz's user avatar
  • 1
0 votes
1 answer
128 views

The image saved in google drive is not viewing in the google sheet, instead it appears as folder name along with image name. The image is saved through the APPSHEET and I need that image to be view in ...
Manojkumar Dhandapani's user avatar
  • 1
0 votes
0 answers
70 views

I have a google form that automatically sends data to a google sheet when filled out. I need this data to be connected to certain formulas and right now have it set up to be connected to another sheet ...
Jacob Finch's user avatar
  • 1
0 votes
0 answers
179 views

I am trying to write a script to import data from Google Sheets into my python script as a dataframe to then analyse. I have watched several videos but I can't seem to make it work more than once (I ...
KrisK's user avatar
  • 31
0 votes
1 answer
101 views

I'm trying to figure out why I'm getting the following error: TypeError: Cannot read properties of undefined (reading 'includes') The error occurs at the line var nameIndex = dataFlatArr.findIndex(s =&...
DanCue's user avatar
  • 766
-3 votes
1 answer
71 views

I'm trying to insert data into a google sheet, but I always get this error. Fatal error: Uncaught TypeError: implode(): Argument #2 ($array) must be of type ?array, string given in C:\xampp\htdocs\...
Joseph Olivas's user avatar
  • 1
0 votes
2 answers
147 views

I would really appreciate it if someone could help me get this tricky function right on google sheets. Everytime stock is scanned I would like to see the timestamp next to that stock ID on google ...
Dean Lowry's user avatar
  • 3
2 votes
1 answer
96 views

In a spreadsheet I want to distribute to my colleagues, I want to automatically unhide the next row (for the following record), as soon as a row (or a cell) is entered data into. Alternatively unhide ...
Hawq's user avatar
  • 45
0 votes
1 answer
177 views

I'm trying as a practical exercise connect Zoho apps with Google API, in this case I'm trying to connect with Google Sheets API. I'm connecting with OAuth2.0 Auth but when I connect the applications ...
Alonso's user avatar
  • 1
0 votes
0 answers
124 views

Having discovered Apps script for Google sheet, I successfully automated the creation of multiple copies of a source sheet within a single spreadsheet. Perfect. However, the source sheet in question ...
NotSoOldNick's user avatar
  • 625
-1 votes
1 answer
145 views

Have One Google Sheet where staff can only View Have One google Sheet where Admin can type and edit while it transfers the data to that view only google sheet. I am trying to have the data transfer ...
Jonathan Almendarez's user avatar
  • 1
1 vote
0 answers
205 views

I am using google drive with google colab. Here is the code (basically, login to google drive, read a spreadsheet with some data, process that data, and write it to another spread sheet) from google....
qwerty_99's user avatar
  • 798
1 vote
1 answer
120 views

I have in mind to develop an Android app using Google Sheet API to store some data. Each user of the app will have his own Google Sheet document and the content will remain private (so, me, as the app ...
OlivierGrenoble's user avatar
  • 4,173
-2 votes
2 answers
201 views

Every end of the month I duplicate a tab with multiple hidden rows, then delete all those hidden rows from the duplicate tab. For that purpose I modified the following code of Tanaike, the code ...
raf's user avatar
  • 22
-1 votes
1 answer
108 views

I'm using a function made in JavaScript in a platform called voiceflow. It has an input variable known as range which only fetches a specified sheet name data. I want to modify the function to fetch ...
WM7's user avatar
  • 1

1
2
3 4 5
…
124