Looking for a script to use on this Google Site, with <> EMBED, EMBED CODE to get the content of a cell in a Google Spreadsheet and place it as text with HTML to be formatted with CSS.
The dark grey box (right or below) is created with embedding the value manually written in the HTML.
Notice how this box scales perfectly in different views.
The white box (right or below) is an URL embed from the published sheet
I included range=A5&widget=false&headers=false&chrome=false to grab A5 and remove all 'sheets' menu & title headers.
using EMBED CODE with HTML and CSS with <iframe>, <object> or <embed> gives the same result.
I have been able to format the size for the embedded object, but not to break or scale the text.
I'm pretty new to this but willing to learn.
Is something like this even possible with new sheets?
What should the Apps Script output to integrate with the embed function on Google Sheets?