Help > Using Data Links

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.

Google Sheets

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("https://www.getvelocity.co/data_links/LuQqVisp6.csv")

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.