How To Write A Script For Google Sheets . Find the spreadsheet you want to run a script on, and open it. All macros save to the same file, so if you have a couple of macros saved, you may have to sift through them. Google Sheets script tutorial Beginner guide to coding with Google from www.benlcollins.com There are six types of values in apps script. Add custom menus, dialogs, and sidebars to google docs, sheets, and forms. This article shows how to create a new google sheet and write data into it with google appscript.