Skip to main content
6,173 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
2 votes
1 answer
198 views

I'm trying to fetch a spreadsheet with Google SDK. I'm logged into an account with a Service Account Token Creator role and the service account has access rights to the spreadsheet. This is my code: ...
Szymon Gołębiowski's user avatar
  • 23
Advice
0 votes
4 replies
58 views

I have an Add-On under review in the Google Marketplace. My Add-On runs in Google Slides and needs to access Google Sheets data to create various visuals in Slides. Specifically my Add-On pulls data ...
steeveesas's user avatar
  • 67
0 votes
0 answers
23 views

Everything is in the title. Google Sheet API v4 doesn't have a native method to add an image into a cell. Google App Scripts doesn't work with a service account which I'm using. IMAGE() function doesn'...
Lexe.Elf's user avatar
  • 71
0 votes
0 answers
54 views

I’m building a Flask web app for a Model UN conference with around 350-400 registered delegates. OCs (Organizing Committee members) log in. They scan delegate IDs (QR codes or manual input). The ...
Raghav Nirola's user avatar
  • 1
0 votes
0 answers
61 views

I Have a sheet that is bringing across all the article ID's listed there (and associated names) in line with the said name of that sheet. Also above this information I am looking to make a simple ...
Isaac Whiteside's user avatar
  • 1
0 votes
0 answers
143 views

I am building a script which is supposed to create and update documents in a certain folder of my Google Drive (personal account, not Google Workspace). If there is no document that particular name, ...
Ionică Bizău's user avatar
  • 114k
0 votes
2 answers
295 views

In Google Sheets, if you click Insert → Pre-built tables and then for example Blank table, the vertical padding of cells changes and userEnteredFormat.padding stops having an effect (you can try ...
root's user avatar
  • 2,946
0 votes
2 answers
131 views

I'm trying to create a Table in a Google Sheet using the API in Python. I've constructed an API request that mimics the example one here. My request looks like this: { "requests": [ { ...
kviLL's user avatar
  • 443
0 votes
0 answers
35 views

I need to have =QUERY(IMPORTRANGE) or simply =IMPORTRANGE() in sheets2 and sheets3 to automatically do its' thing as soon as the exporting sheet (source file) receives the data from its' source (drive ...
Rand Petersen's user avatar
  • 21
0 votes
0 answers
94 views

I am building a Node.js server-side application that needs to interact with the Google Sheets API on behalf of a user using the googleapis and google-auth-library packages. I have successfully ...
Nat's user avatar
  • 1,922
0 votes
1 answer
56 views

I'm looking to export a logbook of mine to paper. The logbook consists of entries of hours based on dates that continue row by row. I need to export these entries through printing with each page ...
Anthony Galushka's user avatar
  • 3
0 votes
0 answers
90 views

I have the code to create a new Spreadsheet using Service account, everything was working good, but after I change the sheet value manually with my own email, google has blocked the spreadsheetsand ...
Roberto Pegoraro's user avatar
  • 1,517
1 vote
2 answers
129 views

I have this worksheet that im working on: https://docs.google.com/spreadsheets/d/1u_CafEOKNLtthpWaXVo37BKiuRHQ2oGEC4liqkTmXuY/edit?usp=drivesdk and I have this script: function createWhatsAppHyperlink(...
ferdsyou's user avatar
  • 11
0 votes
1 answer
165 views

I have a script that imports sheets from one project to another by way of the script ID. It's a very large script so it would not be feasible for me to condense it down to a MRE because I do not know ...
J_code's user avatar
  • 347
0 votes
0 answers
61 views

I've programmed an App Script in Google Sheets. This App Script provides the name of the respective sheet (tab) as a formula. I've used this App Script in several Google Sheets, all of which are ...
Info DGB's user avatar
  • 9
0 votes
0 answers
69 views

I have a spreadsheet with two sheets, 'MySheet' and 'MySheetOptions'. I want column A of 'MySheet' to be dropdowns with options defined in the corresponding row of 'MySheetOptions'. That is, the ...
starchild's user avatar
  • 496
2 votes
1 answer
206 views

I'm trying to create a data validation rule that allows multiple selection from a dropdown list using the Google Sheets API. In the Google Sheets UI, there's an option "Allow multiple selections&...
Viacheslav Varov's user avatar
  • 163
0 votes
2 answers
110 views

I am trying to write a basic google sheet from the Azure Data Factory. Any ideas that work in 2025? I have tried a lot of approaches to no avail. Reading works fine with a basic API token, but ...
Julie's user avatar
  • 2,011
0 votes
1 answer
72 views

In Google Spreadsheet API to work on values (e.g. get, update), you can use open-ended row ranges in the form <column-start><row-start>:<column-end> (e.g. A2:A to get all cells from ...
LoganMzz's user avatar
  • 1,652
0 votes
0 answers
67 views

I'm working with the Google Sheets API to update a chart's data range and axis styling. The data range update works fine, but changes to the BOTTOM_AXIS text style (e.g., setting font size to 50 and ...
Mfoq's user avatar
  • 19
-1 votes
1 answer
89 views

I am trying to modify a Google Sheets file and a CSV file in Google Drive via the Apache Airflow Google Provider: df = pd.DataFrame(data) csv_data = df.to_csv(index=True) gcs_hook = GCSHook(...
Kotaka Danski's user avatar
  • 620
1 vote
0 answers
83 views

I have an Excel file stored in Google Drive that contains several columns with calculated fields (i.e., formulas like =C2*D2). My goal is to programmatically fetch the evaluated values (not the raw ...
Harikrishnan's user avatar
  • 11
-1 votes
1 answer
292 views

I am having an issue with a specific symbol of the HK stock market using the formula googlefinance(). =googlefinance("HKG:2800","price") returns no value where all other tickets ...
Ken Kam's user avatar
  • 1
-1 votes
1 answer
324 views

I have a python app that uses gspread, and I haven't run it in about a year, and I believe it is failing because of an authentication problem. My diagnostic output is as follows: DEBUG:urllib3.util....
Tom Stewart's user avatar
  • 9
0 votes
0 answers
44 views

So I have an application that uses service account is creating sheets that has protected fields. Becouse service account created those files I cannot edit protected fields with any other user even so ...
Wiktor Kęska's user avatar
  • 561
0 votes
0 answers
126 views

I have a Google Sheet with organizations and their addresses as Smart Chips from Google Maps in Column E. I want to copy each address into column L as text (Not a Smart Chip) so that my team can do a ...
Communications Staff's user avatar
  • 1
1 vote
0 answers
85 views

I have data transferred to a Google spreadsheet in a row and after reaching column Z, my data is transferred below and starts with column A and continues below, but I need it to be written to the ...
satixs's user avatar
  • 11
0 votes
2 answers
106 views

I have a Google Sheet that has long blocks of text in each cell of column H (it is input from a long-form response box in a Google Form). I want to take each response and move it onto a new page of a ...
user30073632's user avatar
  • 3
1 vote
2 answers
108 views

I need to read the Google sheet and getting the max value of a column and deleting the data to update them. I tried to get the max value and pass to delete_rows method, but don't work well. ...
Cesar Augusto's user avatar
  • 35
0 votes
1 answer
104 views

I'm building a Google Workspace Add-on for Google Sheets using CardService. I’ve configured the homepageTrigger properly in the manifest and the onHomepage() function returns a simple card with a ...
Easy Math's user avatar
  • 1
0 votes
1 answer
56 views

When I type "product" in a cell. The cell next to it would show a list of available variations via a drop-down menu? Something like this? This is the data sheet DATA SHEET: Column A Column B ...
Jenn Pomona's user avatar
  • 1
0 votes
3 answers
103 views

Do you know if there is some call in Google APIs which is roughly equal to MS Excel VBAs Worksheet.UsedRange? Attempted finding something, but have not had any positive results so far ... Short ...
Petr Pivonka's user avatar
  • 161
0 votes
0 answers
81 views

I want to updated a liked SheetsChart for Google Slides. It works instantly when the slide is in edit mode, doesn't refresh the chart with latest data from Google Sheets when it's in "Slideshow&...
Bao Le's user avatar
  • 17.7k
-3 votes
1 answer
744 views

so this is just a steps for this project. I will explain the full project first, and maybe you can suggest another solution. Basically, I have a template sheet for my job (Staffing Sheet). The sheet ...
I C's user avatar
  • 1
-6 votes
2 answers
197 views

i have datatables + highcharts (in Child rows ) and i want change code and i want data from google sheets and Is it possible to change? now data from json and i want data from google sheets and i want ...
IntProtest 's user avatar
  • 1
-1 votes
1 answer
102 views

i have datatables + highcharts and now don't working and i want replace sheets api v3 to v4 codepen.io/intprotest/pen/ewQJrK?editors=1010 https://sheets.googleapis.com/v4/spreadsheets/...
IntProtest 's user avatar
  • 1
0 votes
1 answer
380 views

I’m working on a feature where a client can link their Google Sheet to my system. Whenever a new row is added to the sheet, the system should send the new order data to a webhook. My initial approach ...
Abdelghani's user avatar
  • 93
1 vote
0 answers
89 views

As indicated by the docs, it sounds like I should: Get a list of the existing conditional formatting rules Use the index (aka, the key within sheets[0][conditionalFormats]) and send a batchRequest to ...
Charlie's user avatar
  • 333
1 vote
1 answer
107 views

I have a C# program that can fetch add and edit and remove values in my Google sheet. But I can't seem to sort the records in the table correctly. Here is my code: public bool SortGoogleSheet( int ...
MrSnrub's user avatar
  • 475
0 votes
1 answer
415 views

Edit: For clarity, I'm attempting to change the number of rows in the sheet. Google's LLM insisted this was the correct method to use, and the docs are...vague. I gave up on this approach as a red ...
Brad's user avatar
  • 369
1 vote
1 answer
89 views

I have an XLS file in Google Drive. Using Google Apps Script, trying to convert to Google Sheets. But it is being stored as Google Docs instead. function readBlob() { var file = DriveApp.getFileById(...
Active Hub's user avatar
  • 71
0 votes
0 answers
100 views

We have a plugin called FlexOrder, whose main functionality is to sync WooCommerce orders with Google Sheets and access them there. One of its key features is updating the order status by selecting ...
Rakibul Islam's user avatar
  • 1
-4 votes
1 answer
93 views

I’m having an issue in Google Sheets and could really use your help. Right now, my formula is returning all available results, but I only want it to return the specific result associated with the code ...
Walid Victor's user avatar
  • 1
1 vote
1 answer
113 views

Using the Python example taken directly from the "Google Sheets API documentation > Create a spreadsheet" and changing only the credentials, I am experiencing poor performance. It's ...
Stokedout's user avatar
  • 11.1k
0 votes
0 answers
47 views

I am using below code to call Google Sheet API $client = new \Google_Client(); $client->setApplicationName('Google Sheets API'); $client->setScopes([\Google_Service_Sheets::SPREADSHEETS]); $path ...
Ronak Solanki's user avatar
  • 39
0 votes
1 answer
63 views

On the OMS IV tab I need H22 to add the number of weeks in column D if j15:ab15 says non-clinical. Column D turns light yellow when the corresponding J15 etc shows non-clinical, but now I need to add ...
Briana Langston's user avatar
  • 3
1 vote
1 answer
122 views

I'm trying to clear all the values from a Google Sheets sheet, while keeping the formatting and data validation (e.g. dropdowns and checkboxes). The documentation for the spreadsheets.values.clear API ...
Sam's user avatar
  • 359
0 votes
0 answers
284 views

I am encountering the following error when attempting to access Google APIs in Java: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid ...
Cod's user avatar
  • 309
0 votes
0 answers
88 views

We are trying to migrate our DAGs from Airflow 2.9.3 on Composer 2 to Airflow 2.10.2 on Composer 3, but can't seem to get operators accessing Google Cloud Sheets to work. What works on Composer 2, is ...
Lars Haugseth's user avatar
  • 14.9k
0 votes
0 answers
108 views

I have a small .net Maui app which uses Google login to access files in Google Drive. The code I am using to get the UserCredential is as follows: Note that the sensitive values are fake and shown ...
dushyantp's user avatar
  • 4,776

1
2 3 4 5
…
124