AppsScriptPulse

Snippet, Solutions, Docs

Google Doc to clean HTML converter for Google Apps Script

Tags:
| | 0 Comments |

Export Google Doc as clean html. Handy to make a WordPress post from Google Doc. – thejimbirch/GoogleDoc2Html

Following on from our previous post highlighting Amit Agarwal’s Send Rich Text HTML Emails with Google Sheet  we received the following recommendation for a Google Doc to HTML converter solution from @IMTheNachoMan:

For those interested in workflows for using Google Docs as an email template this solution already has a emailHtml() function you can build on which appears to already inline images from your Google Doc.

Source: thejimbirch/GoogleDoc2Html

Snippet, Solutions, Docs, Drive

The Gift of Script: Bulk create Google Docs from Google Sheet data

Tags:
| |

The following is designed to bulk create Google Docs from rows of data within a Google Sheet and to include some of that data within the new Doc body (so they become customised files). It also creates a link to the new Google Doc back in the Sheet on the relevant row.

Rows of data in a spreadsheet will transfer into a Doc

Example rows of data in a Google Sheet

Source: The Gift of Script: Bulk create Google Docs from Google Sheet data

Library, Docs, Sheets

RichTextApp – a Google Apps Script library for copying rich text formatting from Google Docs and Sheets

Tags:
| | 0 Comments |

This is a GAS library for copying the rich text with the text styles from Google Document to Google Spreadsheet or from Google Spreadsheet to Google Document using Google Apps Script (GAS). And, also the rich texts in the cells can be converted to HTML format.

Nice little helper library for copying rich text formatting from Google Docs and Sheets. You can view the project README for information on the formats that are currently supported. Personally,  the inclusion of the RichTextToHTMLForSpreadsheet method looks particularly useful for converting rich text formatting in Google Sheets cells to HTML for mail merge applications.

Source: tanaikech/RichTextApp

Solutions, Docs, Web App

Google doc as rest api using Apps Script

Tags:
| | 0 Comments |

After a fight with wordpress, I said to myself: Can I use google doc as content management? .. Join me in this attempt

A simple yet elegant approach to using Google Docs to manage structured content using Google Apps Script.

Source: Google doc as rest api using Apps Script

Solutions, Docs, Forms, Sheets

Create Google Doc from Form submission

Tags:
| | 0 Comments |

Screenshot of spreadsheet with data and Doc link

Screenshot of spreadsheet with data and Doc link

Create a Google Doc for each submission of a Google Form and translate some of that Form data into the Doc. It puts a link to the newly created Google Doc back into the spreadsheet alongside the relevant row. The Name field from the Form is used as part of the filename for the created Doc and there is a Log sheet to support any troubleshooting errors.

Source: The Gift of Script: Create Google Doc from Form submission

Add-on, Docs

Code Blocks – Syntax Highlighting for Google Docs

Tags:
| | 0 Comments |

Syntax highlighting for Google Docs

With the Code Blocks add-on for Google Docs you can create formatted code blocks using a wide variety of themes and language support for syntax highlighting. This is a great add-on for anyone wanting to create technical training materials in Google Docs.

Source: Code Blocks – G Suite Marketplace

Add-on, Docs

Docs to Markdown Add-on

Tags:
| | 0 Comments |

Drive add-on that converts a Google Doc to simple, readable Markdown or HTML.

This add-on is helpful for anyone doing technical writing or producing technical content. With Docs to Markdown, you can easily export the content of your Google doc for publication on a variety of other web-based platforms or CMSs.

Source: Docs to Markdown – G Suite Marketplace

Solutions, Docs

Google Apps Script: Get Google Doc Text Based on Reference Characters – Yagisanatode

Tags:
| | 0 Comments |

This simple tutorial should get you started with grabbing text from a Google Doc for other uses. You could certainly make a lot of changes to the code to introduce more search rules. Likewise, you could use regular expressions to search for some really cool stuff, but for a simple overview this should get you started.

This post provides a detailed how-to of getting a list of information from the document that you have noticed are between two sets of characters.

Source: Google Apps Script: Get Google Doc Text Based on Reference Characters – Yagisanatode

Solutions, Docs, Drive, Forms, Gmail, Sheets, V8

G Suite Solutions —  Apps Script Powered Workflow Automation

Tags:
| | 0 Comments |

Laura Taylor recently spoke at SheetsCon on the topic of Automation with Apps Script. During the presentation, she walked through a simple approval workflow for a hypothetical small business to demonstrate the power of Apps Script to automate workflow inside G Suite. She also showcased modern ECMAScript features supported by the new Apps Script V8 Javascript runtime.

The article is an overview of the workflow covered in the author’s presentation along with install instructions for trying it out in your G Suite domain.

Source: G Suite Solutions —  Apps Script Powered Workflow Automation

Solutions, Docs

Students use Google Apps Script to quickly identify overused words in a body of text

Tags:
| | 0 Comments |

Great to see some new young Google Apps Scripters at work