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

I want to replicate a sheet from Google Sheets to a Markdown type. I'm using the API to request it: from google.oauth2.service_account import Credentials from googleapiclient.discovery import build ...
David Amato Mantegari's user avatar
  • 52
Best practices
0 votes
1 replies
59 views

I’m running into some confusion with OAuth scopes around Google Sheets and wanted to sanity check that I’m not missing something obvious. My use case is pretty simple: I let users pick a Google Sheet ...
Filipe Pina's user avatar
  • 2,249
3 votes
1 answer
77 views

I have a problem. I need to get info from merged cell, but this information only on first cell of this merged cell. F.e. I get request for cells C2:C3. But C3 is a part of merged cell A3:C3. How I ...
ReZord's user avatar
  • 21
0 votes
1 answer
68 views

The problem appears when i have a big amount of values in my pandas df. When i take 27 or 54 values(1 or 2 columns) it works normaly, but when i take more columns it gives me this erorr (i import gs ...
Oleksii Korna's user avatar
  • 1
1 vote
1 answer
461 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
  • 13
Advice
0 votes
4 replies
74 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
29 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
71 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
64 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
164 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
  • 115k
-1 votes
2 answers
461 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
  • 3,095
0 votes
2 answers
147 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
  • 465
0 votes
0 answers
41 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
108 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,932
0 votes
1 answer
73 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
99 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
0 votes
2 answers
135 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
  • 9
0 votes
1 answer
225 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
  • 357
0 votes
0 answers
75 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
292 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
-1 votes
1 answer
159 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,009
0 votes
1 answer
75 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,656
0 votes
0 answers
74 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
107 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
428 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
683 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
1 vote
0 answers
88 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
120 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
114 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
145 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
60 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
110 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
92 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
1k 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
200 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
108 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
540 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
95 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
110 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
1 vote
1 answer
97 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
104 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
99 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
121 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
1 answer
66 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
135 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
1 answer
57 views

I am creating a Java application where I need to read google sheets, create objects from the row values and store them in the database. The problem is that I need to read not the whole sheet (tens of ...
Gary Greenberg's user avatar
  • 1,152
2 votes
2 answers
819 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
65 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
123 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

1
2 3 4 5
…
124