If the spreadsheet cell content starts with an apostrophe/single quote ('), the Sheets API removes it

[willthomson]

We have some spreadsheet content that contains quoted text (used for a quote module). We used double quotes which are fine, but translators have used single quotes for other languages. In these cases, the sheets API removes the single quote from the beginning of the string, leaving just a single quote at the end.

There are others facing similar issues with no clear fix for our case:

• https://stackoverflow.com/questions/42235484/escape-single-quote-when-update-google-sheets-through-api-v4
• https://stackoverflow.com/questions/63256402/google-sheets-stripping-single-quotes-from-the-beginning-of-string-cells

[willthomson]

Please see the associated pull request. This fix may be too crude but I couldn't see a better option.