All Questions

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: ...

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 ...

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'...

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 ...

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 ...

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, ...

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 ...

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": [ { ...

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 ...

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 ...

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 ...

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 ...

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(...

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 ...

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 ...