/GoogleSpreadsheetToAsana

Export tasks in a Google Spreadsheet to an Asana project

MIT LicenseMIT

Export Google Spreadsheet to Asana

This ruby script allows you to load an Asana project with tasks defined in a Google Spreadsheet.

config.yml

You'll need to create a config.yml file with your Asana key and Google drive credentials. A template config.EXAMPLE.yml is provided for your reference. Copy it to config.yml.

Spreadsheet format

The spreadsheet you want to load will require a predefined format (unless you change the script to match your own purpose of course).

An example spreadsheet is available at https://docs.google.com/spreadsheet/ccc?key=0AhGVPUNNMOrfdGxsaU1RbWg4aEFCSnlfUjF2ZDBSeEE&usp=sharing