{:title=>"Google Sheets Icon", :file=>#<Contentful::File: @properties={:fileName=>"google-sheets-icon.png", :contentType=>"image/png", :details=>{"size"=>18047, "image"=>{"width"=>262, "height"=>262}}, :url=>"//images.ctfassets.net/ccli4xdzdc9p/0131othimPb09aDqejIm4r/5746e936bd7d82dee75c2d7800455714/google-sheets-icon.png"}>}

Google Sheets

The Boords Google Sheets integration creates new spreadsheet rows when you export your storyboard. Perfect for moving into the next stage of production!


Step 1) Create a Zapier Starter plan account

Zapier is an automation service which connects the apps you use every day with one another. To use Google Sheets with Boords, you’ll need a Zapier starter plan in order to use the ‘Formatter’ app. If you have a Zapier account, sign in to it now.

Create my Zapier Account

Step 2) Connect Boords with Zapier

Connecting your Boords account with Zapier is simple. Just click the link below, and you’ll be guided through the process.

Connect my Boords Account

Step 3) Create a Zap

Select Boords as your Trigger App, and name it something like ‘Boords to Google Sheets’. Select ‘Download Images’ from the Boords Triggers dropdown.

image

Next, select the Project you’d like to ‘watch’ for exports.

image

Once you’ve selected your project, Zapier will look for an export which it can use to test your Zap. Go ahead and click ‘Download ZIP file’ within the ‘Export > Images’ menu.

Note: We won’t be using the ZIP file you just downloaded. Downloading a ZIP file triggers this process independently.

image The ‘Images’ export option

Once Zapier has found an export, it’s time to add your formatter!


Step 4) Add a Formatter

Zapier’s Formatter app turns our storyboard export into a format we can use with Google Sheets. Select ‘Utitlies’ from the menu. Note you’ll need a Starter Plan to add a Formatter.

image

Select ‘Line Itemizer’ under the Transform menu:

image

Enter ‘Frame’ into the field marked ‘Line-item(s) Group Name’ field:

image

Add the fields you’d like to export to your spreadsheet under the ‘Line-Item Properties’ section. When you’re happy with your template, click ‘Next’.

image


Step 5) Add your Google Sheets step

Click ‘Add Step’ to add a third step to your Zap, then select ‘Google Sheets’ from the menu. Choose the ‘Create Spreadsheet Row’ action:

image

Set up your Google Sheets template. Note that it’s important to add a header row to your Google Sheet. In this case, we have added Sound and Action headers.


Step 8) Test your action

Click ‘Send test to Boords’ and each frame of your storyboard will be added to your sheet as a new row. Lastly, set your Zap live and you’re good to go! Every time you export your storyboard images, they will be added as new rows to your spreadsheet.