I am trying to generate a JWT token for appstore connect APIs with ES256 algorithm. I have managed to call the APIs using python code JWT Token with below code. from datetime import datetime, timed...

In my script, I am reading data from a Spreadsheet and creating a time based trigger to make a POST request with some of that data at a specific time. The problem is, I can't find any way to pass ...

Is it possible to apply the 'Automatic' number format programmatically through GAS? My issue is that as I write columns of numbers, Sheets seems to attempt to apply appropriate formatting, but gets...

I've used the "Populate a team vacation calendar" sample at https://developers.google.com/apps-script/samples/automations/vacation-calendar to build an Apps Script to pull all Out Of Offi...

How do I filter out Gmail messages that DO NOT have attachments? Here is the documentation I'm trying to follow. I can see that in order to include messages with attachments, I use the following ...

I m in trouble using some filter in appscript. I can see that the spreasheet is filtering, but programaticaly i don't see any changes. Could you help ? Thanks var sheet = SpreadsheetApp.getActi...

I get this error "Service Spreadsheets timed out while accessing document with id ..." every time I run a very simple code, in which I am basically copying data from one google sheet to a...

We have some apps scripts system on goole sheets. Free g accounts, mostly scripts are bound. Several users. Currently want to read users data for some logs. I hope Session.getActiveUser() method ca...

Is it possible to include parameters in a URL referencing a shared Google Sheet? A typical URL will look like this: https://docs.google.com/spreadsheets/d/1c-sxi4cwZXUXTHJSU-Nzl1lAwPCs123l46UKQgAB...

So I have encountered a problem in the application I am writing using google spreadsheets and app-script. I have put together a step by step guid to reproduce it. Summary: any script that uses Spr...

G Suite users have recently gained access to an integrated Gmail interface. In this interface, Google Chat's rooms now have their own Tasks integration Has anyone found resources for accessing and ...

I've written a custom Google Apps Script that will receive an id and fetch information from a web service (a price). I use this script in a spreadsheet, and it works just fine. My problem is that ...

I created some Google Calendar events and now I would like to do some operations on them programmatically. Trouble is I don't have their IDs. When I go into the calendar and click on the event, ...

Is it possible to prevent a user from pasting in cells that have drop-down options based on data validation? While it could be a convenience, when one cell (with data validation) is copied and pas...

I am using the GOOGLEFINANCE() function in google sheets to get an exchange rate for expenses I am entering in for accounting. The issue is that sometimes I get an #N/A error with the message W...

I'm using google scripts to deploy a web app. I've done about 5-10 in the same account. When I try and run the web app/script, I'm now getting: a "Google Drive: Page not found" in the title and the...

I'm working on a Google Sheets script that I'm only intending to access data in the same spreadsheet that the .gs file is associated with. It seems like I should have permission to run a script in ...

If I have the event ID of a Google Calendar event, for example: [email protected] How can I construct a URL to view the event details in the Google Calendar interface? For example, if I ...

In excel you can create user defined functions with python using pyxll. I have been moving to Google spreadsheets and using their Google app script, but the libraries are so much bigger and better ...

I implement library with Google App Script and I have some difficulties to call a function from library using google.script.run. Here is the code of my Library : Code.gs function ShowSideBar() ...

Good Morning All. I have written a short script which batch-creates [single page] Google Slides based on rows from a spreadsheet. While in the loop for each creation, I would like to create a PNG o...

Would there be a way to export comments from Google Docs so that the comments show up in a Google Sheets doc in one column and the highlighted text from the Google Doc shows up in the column next t...

My company is switching from Microsoft Office to Google Docs, I have this (several) code I want to use in Google Spreadsheets but I have no idea on how to do that. Consider this sample of code: P...

So, I would like that when I send an email via a Google Form (now it is possible to embed the whole form automatically in the message - I usually do this) the email of the recipient would already b...

I have published an app script publicly (Anyone, even anonymous) with a doPost method as follow, function doPost(e){ var sheet = SpreadsheetApp.getActiveSheet(); var length = e.contentLength; v...