GoogleAppsScript | Google Apps Script

I want to unit test this code, which is Typescript transpiled using Clasp into Google App Script:

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 have a Google Docs document with a PARAGRAPH followed by a TABLE followed by a TABLE. Visually there is a PARAGRAPH between the two TABLEs. Programatically, however, using the following code, the run log demonstrates that there is no PARAGRAPH, viz

I have documents coming in through E-mail from a scanner.

The scanner CANNOT change the subject. All email subjects from scanner are same "Scan to E-mail Server Job"

However, each file name is unique.

Google threads the messages, and I generally want to keep threading on.

I run a script to extract the PDF and put on drive, and then send the message to the trash.

The problem is.. future scans run the same script on the entire thread, so I end up with numerous copies of the same exact document every time the script is run.

I looked here and elsewhere this: permanently delete only one gmail message from a thread using a google script

Overview: When I call ContactsApp.getContact() in a GoogleAppsScript function, the function works fine when run from the Script Editor. However, when I try to use my function from a Google Spreadsheet, I get a permission error. How can I resolve this permission error and use ContactsApp from a custom function in a spreadsheet?

Details: I create a new spreadsheet and open the Script Editor and define the following simple function:

I'm developing a Google Apps Script (GAS) using Typescript (via the clasp tool).

I imported type definitions by running npm i -S @types/google-apps-script.

Some types are quite lengthy, for example:

I am trying to use data from a column in a Pandas DataFrame as a variable in an API call. I can't figure out how to convert the data into the correct formatting to pass it to the API.

For context, I am grabbing ProductIDs (i.e. the APIs unique DB reference for a product) from one call to grab meta data about said products in another call. Just calling the whole DB is not an option as I generally have 100s of ProductIDs whereas the DB is 140'000 deep so this would be very inefficient! I've managed to achieve what I want to do via GoogleAppsScript / JavaScript but looking to migrate to Python to make the whole job more efficient.

I call: