google-apps-scripts | Libraries for Google Apps Scripts

I am using this code to upload the heic file and finding a way to convert heic as jpg or png via apps script (not right click save as)

I have my code

Inspired by such a convenience of Cheerio from this answer, I'm trying to use it in the following codes. The codes was able to pull any table data by calling class="snapshot-td2", but I'm interested in getting only those in the first table. How can I do that? The URL has two tables having class="snapshot-td2". And it retrieved them in string. How can I get them in array? Thank you for any help!

No matter what I try, I cannot get an app script to return an existing date that's retrieved from another cell.

In the script below, both mDate (the actual value of L2), and dateString result in a return value of 'Sat Dec 30 1899', which I understand as GS's start date.

I have tried creating a new date object, retrieving the cell's display value, formatting the existing date object with a utility E.g.:

I recently learned about clasp, and became excited about the possibility of using TDD to edit my Google Apps Scripts (GAS) locally.

     NOTE: there might be a way to write tests using the existing GAS editor, but I'd prefer to use a modern editor if at all possible :)

clasp works great, but I cannot figure out how to mock dependencies for unit tests (primarily via jest, though I'm happy to use any tool that works)

• I got farthest by using the gas-local package, and was able to mock a single dependency within a test
  • However I could not find a way to mock multiple dependencies in a single test/call, and so I created this issue

• I am a javascript novice, and probably missed something important while researching this problem :)
• Despite installing @types/google-apps-script, I am unclear on how to "require" or "import" Google Apps Script modules whether using ES5 or ES2015 syntax, respectively--see below for an illustration of this.

Although there is a similar SO question on unit testing here, most of the content/comments appear to be from the pre-clasp era, and I was unable to arrive at a solution while following up the remaining leads. (Granted, it's very possible my untrained eye missed something!).

As I mentioned above, I created an issue (see link above) after trying to mock multiple dependencies while using gas-local. My configuration was similar to the jest.mock test I describe below, though it's worth noting the following differences:

• I used ES5 syntax for the gas-local tests
• My package configuration was probably slightly different

I am trying to publish a web app through the script code. I read this post but I can't make it work, maybe it's a slightly different situation. I have got a script that copies a spreadsheet: in the script, I want to publish the new copy of the spreadsheet as a web app and, if it's possibile, retrieve its public url (anyone should be able to access to it).

Here it is my code: