Using Data Links
Once you've created a Data Link, you'll be shown options for how to use it. Each Data Link generates a URL of a live CSV that has a row for each Asana task. You can use this CSV URL in any reporting application that can read CSVs via URL, or you can write your own script for reading data from it.
To load the CSV's data into a Google Sheet, use the IMPORTDATA function. This will look like the following, but using your Data Link's CSV URL:
IMPORTDATA will update the data in the Google Sheet about once every hour.
Once you've loaded the data using
IMPORTDATA, you can then perform additional transformations on the data in another tab and/or create a chart or a graph of the data.
Sharing, Exporting, and Notifications