SheetConverter | Google Apps Script library - interprets Google Sheets | Document Editor library

I've been trying to create a script sending a cell array as a table (keeping formatting) however after hours and circa 30 variations of the code tested I keep on running into a wall...

So far I either: 1. Get an empty email 2. Get an email with all my data but no formatting (all numbers one after the other instead of a table) 3. The table written as HTML code in the email instead of the table itself. 4. An email with [Object] written as the message

I get result 2 by using this code:

To facilitate the annotation of audio files in a Google Spreadsheet, I'd like to implement an audio player in the sidebar which automatically plays the audio file mentioned as URL in the row of a table. After listening and entering some date in this row, I'd like to move to the next row and do the same. Thus, the URL to the audio file should be updated whenever I select a new row and the whole process should be fast, too, in order to listen quickly to one sound file after the other.

I've experimented with the solution mentioned in this SO post, but this solution is relying on a poll function with a time interval, which is impractical for me as it periodically is updating the sidebar. Crucial for me would be to update the content of the sidebar only once.

Code.gs

I want a Line chart from my spreadsheet to appear in the email.

I have applied this solution to e-mail the rows of a google sheet as part of the HTML body.

Unfortunately, it errors out because there is a limit set on the HTML body. The number of rows in my data is dynamic.

Limit Exceeded: Email Body Size. (line 209, file "SideBar")

Is there a way of getting around this? I would be OK with providing a preview of the rows, let's say 10 rows with all columns, on the HTML body and then providing a link to view the rest. Because the content on the sheet changes, the link should not be to that sheet. Instead I was thinking of saving a copy of the sheet as a new file on their own drive and linking to that. Another option is attaching an HTML file that has all the rows.

Here is what I currently have:

Is there a way to only display rows that are blank in column F and email them. Trying to get all rows that don't have equipment ordered and send them in a email daily.

I'm using this script that uses SheetConverter. Here is what my sheet looks like. Here is what my email looks like.

I am trying to write a code in google app script that can mail me the spreadsheet and everything works well. Below is the code I am using.