This project extends the functionality of google-spreadsheet and adds the ability to control TextFormatRun

// Libraries
npm i lodash @types/lodash googleapis cheerio google-spreadsheet

// usage:
// getting cell from GoogleSpreadsheetWorksheet
cell.clearAllFormatting();
const text = `<b>lorem ipsum</b>`;
Object.assign(cell, htmlToTextFormatRuns(text));
// ...saveUpdatedCells();

Available HTML tags:
u, s, b, i, a, span

available "style" attribite with css params:
color <HEX string>
font-weight <bold>
font-style <italic>
font-size <String | Number>
text-decoration <underline|line-through>

Examples:
'<span style="font-size:8; color: #df9ee8">Ꮢ</span>'
`<a style="text-decoration: none; color: #ff0000" href="https://example.com">link text<a>`

Made in Ukraine 🇺🇦 with ❤️
https://github.com/lortonx