sparklines | A sparkline htmlwidget for R using jQuery Sparklines

First, this error message is indeed expected on Jan. 11th, 2022.
See "Improving Git protocol security on GitHub".

January 11, 2022 Final brownout.

This is the full brownout period where we’ll temporarily stop accepting the deprecated key and signature types, ciphers, and MACs, and the unencrypted Git protocol.
This will help clients discover any lingering use of older keys or old URLs.

Second, check your package.json dependencies for any git:// URL, as in this example, fixed in this PR.

As noted by Jörg W Mittag:

There was a 4-month warning.
The entire Internet has been moving away from unauthenticated, unencrypted protocols for a decade, it's not like this is a huge surprise.

Personally, I consider it less an "issue" and more "detecting unmaintained dependencies".

Plus, this is still only the brownout period, so the protocol will only be disabled for a short period of time, allowing developers to discover the problem.

The permanent shutdown is not until March 15th.

As in actions/checkout issue 14, you can add as a first step:

One option would be to adjust your mutate/map using an if condition to return a scaler NA for cases where there are only missing values or only one non-missing value:

Do a join after the summarise

In as.datatable() you can add the option of how large you want your page length to be. In this case, I am setting the page length to 30.

I usually create a picture file then insert it on the mail. This works fine for me, try it.

From the question

However, the function is not returning anything when I try to getValues:

Google Finance is blocked in Google Apps Script. See Reading the values of cells that summarize Google Finance data results via Apps Script

P.S.

1. It doesn't make sense to include SpreadsheetApp.flush() as the last function statement. It should be used when you need to force that the changes made are applied before the function ends because you will be reading something that was changed by the script to be used in later part of it.

2. The Best Practices discourages the use of Google Apps Script classes (in this case var cell = sheet.getRange(row, col);) in loops because they are slow.

OkHttp client can make 64 requests in parallel by default. You can play with that value and increase maxRequests number. Create new OkHttp dispatcher:

All you need is group_by() and summarise():

You have the option to use the item.name slot. Create a separate column for chart, then use its slot to put the sparkline: