PLANET-6163 Support clickable links in Spreadsheet block

[planet-4]

Currently if the source sheet contains links around the cell value, then these links are not included in the block output, only their link text.

This is because the block uses the CSV publication of the sheet to get the data.

Perhaps using another format (or maybe API) we can get it to include the links.

If you use the HTML publication of the sheet, Google does include the links, but turns them into a redirect that goes through google.com first. So maybe it's for security they strip links in other output, in which case solving this issue might not be possible.

Tasks

• Add a help text as a warning that rich content is not preserved.
• Investigate if this is possible, either by some other Spreadsheet API endpoint or other exposed format.

Reporter: pvincent
Sections: Block: Spreadsheet

Potentially affected repositories: planet4-plugin-gutenberg-blocks