Help
Connect Asana
- Open a Google spreadsheet, then Extensions › TaskHistory › Open.
- Click Connect Asana and approve the read-only permissions. TaskHistory never changes anything in Asana. Your Asana tokens are kept in your own Google account, not on our servers.
Set up a sync
- Choose a workspace and the projects to sync. On Pro you can also pick portfolios and teams; a task that is in several of them appears once, with all its projects in one column.
- Choose the fields, including custom fields.
- Choose a schedule: Manual only (use Sync now), or on Pro Every hour or Every day.
- Click Save and sync. The sync writes to a tab with the sync’s name.
The Free plan has 1 sync per spreadsheet of up to 3 projects, run with Sync now. See the plans.
History, change log and report
-
History (Pro) adds one row per task per day to the
<sync> Historytab, for burndown and open-vs-done trends. Choose how many days to keep with “Keep history for (days)”. -
Change log (Pro) records changes to section, assignee, due date, completion and custom
fields in the
<sync> Changestab, for cycle time and “what changed since Monday”. - After a few days of history, click Create report for a Report tab built from plain Sheets formulas.
How TaskHistory updates rows
- Rows of tasks that leave your selection are deleted, including your own columns on those rows. Columns you add to the right of the synced columns stay aligned with their task.
- Each run updates the rows of tasks that changed and adds rows for new tasks. There is no row cap.
- Keep your own copy of anything important. TaskHistory is not a backup service.
Known limits
- If you remove fields from a sync, their old columns stay in the sheet and stop updating. Delete them yourself if you don’t need them.
- Don’t insert columns inside the synced range: TaskHistory does not detect them and overwrites them at the next sync. Add your own columns to the right.
- Changes are seen at each sync (hourly at most), so the change log shows when a change was seen, not the exact minute it happened.
- An edit to only a subtask shows up at the next daily full pass.
- Google limits how large a spreadsheet can be and how long add-ons may run each day. When a limit is reached, syncing or history pauses until the next run, or until you lower the history retention.
Disconnect or delete
- Disconnect Asana in the sidebar revokes the connection and deletes your Asana tokens from your Google account.
- Edit › Delete removes a sync’s settings, status and hidden helper tabs. Its visible tabs stay until you delete them.
- Cancel Pro in Paddle’s customer portal (link in your receipt). See the refund policy.
Contact
Email [email protected]. Include the sync name and the error shown in the sidebar, but no task contents.