Google sheets can be an attractive light weight CMS option, but the first place it seems to breakdown is in supporting rich text. Google sheets does allow for some rich text editing within a cell (bold, italic, multiple links), but we currently don't have a way to get a useful representation of that out.
It seems like we should be able to write a custom function using Google's script editor to make this representation. I don't really know if that's possible.
Proposal
Try to write a reusable google sheet function for translating native google sheet rich text into a more useful representation like html or markdown. If can't then document why this is not technically possible.
Background
Google sheets can be an attractive light weight CMS option, but the first place it seems to breakdown is in supporting rich text. Google sheets does allow for some rich text editing within a cell (bold, italic, multiple links), but we currently don't have a way to get a useful representation of that out.
It seems like we should be able to write a custom function using Google's script editor to make this representation. I don't really know if that's possible.
Proposal
Try to write a reusable google sheet function for translating native google sheet rich text into a more useful representation like html or markdown. If can't then document why this is not technically possible.
Deliverables
A custom function.
Timeline
One day.