How To Write A Script In Google Docs . Custom menus and user interfaces. It will help you keep track of your ideas, the files and folders that you create, and where you saved them (if you have multiple scripts and folders, you can keep a separate folder for each script). Script for generating Google documents from Google spreadsheet data source from opensourcehacker.com Tick the box labelled header, uncheck the option show on first page. Function ctofh (input) { return input * 1.8 + 32; Create or open a spreadsheet in google sheets.