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")

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.

Refreshing Google Sheets Data

IMPORTDATA will update the data in the Google Sheet about once every hour, as described in "Choose how often formulas calculate" here.

If you make a change in your Data Link and want to see it reflected in the Google Sheet immediately, you can add a parameter to the Data Link CSV URL. For example, if your original IMPORTDATA function looks like this:

=IMPORTDATA("https://www.getvelocity.co/data_links/LuQqVisp6.csv")

Then you can add ?version=2 to the end of the URL to force the Google Sheet to refresh the data:

=IMPORTDATA("https://www.getvelocity.co/data_links/LuQqVisp6.csv?version=2")

If you make another change and you want to see it reflected, you can change this to ?version=3 (and so on).