Skip to content

Instantly share code, notes, and snippets.

@brandonrobertz

brandonrobertz/Google Sheets HTML to Text Apps Script

Created August 5, 2024 04:49
Show Gist options
  • Save brandonrobertz/7515fa5a7508a47048ff039c875dbe91 to your computer and use it in GitHub Desktop.
Save brandonrobertz/7515fa5a7508a47048ff039c875dbe91 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Google Sheets HTML to Text Apps Script
// Extensions -> Apps Script
// Make sure to save project (no need to "Deploy")
function html2text(html) {
const document = XmlService.parse(html);
const strText = XmlService.getPrettyFormat().format(document);
return strText.replace(/<[^>]*>/g,"").trim();
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment