Help

Troubleshooting Data Links

A few important things to keep in mind while using data links:

1. Access to see data is dependent on the user who initially created the data link, not the person accessing it. So if the user who created the link does not have access to a particular task/project, it will not be displayed in the data link.

2. The delay between an update in Asana and the data being updated in Google Sheets is between approximately 0-60 minutes.

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

If data links are not working please try the following steps:

1. Manually sync your data:

• Open the dropdown menu from on the top right of the page (when you are logged in).

• Click “Sync Data.” This will manually pull data from Asana. It will begin the sync process and can take a few minutes.
  (Note: data is automatically pulled from Asana every 5 minutes)

2. Manually Refresh Google Sheets:

• 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).