Format Your Google Spreadsheet Using App Scripts

Chip Oglesby bio photo By Chip Oglesby

In a follow up to yesterday’s post about how to pull Youtube Trueview metrics through the Adwords API, this post will show you how to automatically format your spreadsheet for a more beautiful report.

This script will go in the Google Spreadsheet that you created yesterday in the Script Editor. You can access that by going to Tools > Script Editor. When you start Script Editor for the first time, you’ll want to choose ‘blank script’ and give your project a name, something that will make sense to you in the future. You’ll also need to authorize your script the first time.

You can erase the information in the and replace it with the gist above. This app script code will do a few things. First, it will create a menu item that will allow you to click and automatically format your spreadsheet. It will also rename your spreadsheet columns to reflect the actual metric names in the Trueview columns of Adwords.