One click from the plan offer to checkout
Improvements
- The plan button in the add-on now opens that plan's checkout directly, with your Google account already filled in. It used to open the pricing page first.
A faster start, and your first sync in view
Improvements
- The add-on opens right away the first time. The Quick Start Guide tab is now a button on the welcome screen, so nothing lands in your file until you ask for it.
- Connect is ready to press. Connecting accepts the Terms, which sit right under the button, so there's no checkbox to tick first.
- After you start a sync, the add-on shows it running. Press Refresh to check on it, then Open sheet to jump to your new tab. If a sync fails, you see why and can try again from the same screen.
- The plan offer waits until your first sync has finished, and names the plan that fits the syncs you set up.
Fixes
- When Asana is down or busy, the add-on says so and offers Refresh. Before, it said your Asana connection had expired and asked you to reconnect.
Scheduled syncs that stay on
Improvements
- To sync on a schedule, set the sync to Scheduled. The separate Scheduled sync switch on the home screen is gone, since the schedule now follows your syncs.
- Scheduled is always in the sync's list when your plan includes it. Before, it sometimes didn't show until a schedule was already running.
Fixes
- If Google's scheduler had a short outage at the wrong moment, your hourly syncs could stop for good without telling you. They now keep running, and the add-on tries again when Google doesn't answer.
- Refresh all no longer touches your hourly schedule. It runs once, and your scheduled syncs carry on as before.
Safer syncs and upgrades
Fixes
- When you upgrade from the add-on, the paid plan now turns on for the Google account you use in Sheets, even if you type another email at checkout.
- Pushing your sheet to Asana by hand now sends only the cells you edited. A due date someone changed in Asana since your last sync stays as it is.
- If a sync fails partway, your sheet keeps the rows from the last good sync. It used to be left half empty, or empty.
- Your own formula column now keeps working after every sync, even when it sits between 2 synced columns. Edits in the column right after it go to the right Asana field.
- If Google won't let the add-on write to your sheet, the sync now says it failed. It used to finish over blank rows. A task you created from the sheet isn't created a second time.
- Several syncs in one scheduled run no longer run past Google's time limit and leave a sheet half written. A sync that runs out of time picks up at its next run.
- When the add-on can't reach Asana, the live sync repair screen now shows why. It used to say you had no live syncs.
Scheduled syncs keep running
Fixes
- A big sync that ran out of time used to stop for good and show as failed. It now picks up again at its next scheduled run.
- When Google's scheduler had a brief hiccup, the add-on skipped that hour's syncs. It now runs them anyway.
Two-way sync stays on
Fixes
- Two-way sync used to switch itself off when you saved a one-way sync, deleted a sync, or opened the sidebar with no two-way sync set up. It now stays on until you turn it off, and each sync's Direction menu keeps offering Two-way.
Clearer live sync errors
Fixes
- When you can't turn on live sync, the message now says why. It used to be a bare script error.
- Saving or deleting a sync while another one runs now says to try again in a minute.
Quick edits stay put
Improvements
- A scheduled sync now shows how often it really runs, such as about every 3 to 4 hours.
Fixes
- In a live two-way sheet, a second edit made right after the first no longer gets the old value written back over it.
- Saving a sync's settings while a sync runs on the same sheet can no longer mix up your saved settings. The add-on asks you to try again in a minute.
- A sheet with only a scheduled time export now opens on My Syncs, where you'll find your export.
Two-way columns stay in place
Fixes
- Turning on two-way sync no longer moves new columns ahead of Task ID and Name.
- Updating a saved Live sync on a plan without live sync no longer fails.
- A scheduled time export of one project now holds only that project's time.
- The update card shows a sync's schedule only when your plan runs it.
Project time exports fill up
Improvements
- Deleting a sync, or all of them, now asks first on a card in the sidebar with Delete and Cancel buttons. The old pop-up over the sheet could stop the delete halfway when you answered late.
- Dashboard charts now use the add-on's colours.
Fixes
- A project time export came out empty unless your workspace tracked time by project. It now holds the time logged on the project's tasks.
- Saved weekly and monthly time exports now run on time, even when no task sync is due.
- A scheduled time export with a long project name no longer fails on the sheet's tab name limit.
- If you delete a dashboard tab, the next sync builds it again right away.
- A scheduled sync that starts while another run is already syncing the same sheet no longer shows as failed. It skips that turn and lets the other run finish.
- If you replace a sync while it runs, the new sync no longer shows as failed.
- A sync held back while your sheet edits are still going to Asana now says so on My Syncs, and asks you to sync again in a minute.
- A sync you just started no longer shows as failed on My Syncs for a moment before it begins.
Sheet edits always reach Asana
Improvements
- Edits Asana refuses no longer disappear. The sync's row lists them with the value you typed, a Retry button and a Discard button, and the sheet keeps updating meanwhile.
- When your plan stops including a sync mode, your saved settings stay and that part pauses. Change your plan back and live and scheduled syncs start again on their own.
- If you buy a plan during your trial, the add-on follows that plan from the day you buy it.
Fixes
- An edit you typed just before pressing Sync could be lost. It now always reaches Asana.
- A start date typed on its own now reaches Asana, which used to refuse it without the due date beside it.
- A new row with a Section filled in now creates the task in that section.
- Your own columns next to the synced ones keep what you typed through Sync now.
- The task dashboard shows Time Spent only when a task has tracked time, and the users dashboard keeps its second chart.
Edits from your teammates reach Asana
Fixes
- When someone outside your Google Workspace edited a synced sheet, some of their edits never reached Asana. They now go through under your account, like your own edits do.
- If you lose Google access to a sheet, live sync now pauses and asks you to reconnect. It used to keep trying and fail without telling you.
Request a feature from the sidebar
Features
- A Request a feature link now sits beside Help at the bottom of the sidebar. It opens our feature board, where you can post an idea or vote on one.
The Team Dashboard opens again
Fixes
- Team Dashboard in the sidebar opens your team page on our website. It used to show Google's "unable to open the file" page. Owners and admins can add, remove and promote teammates there, and manage billing.
Asana to Sheets launches
Features
- Sync tasks: pick a team and a project and every task lands in your sheet, with sections, subtasks, assignee, followers, tags, dates, and notes.
- Custom fields keep their type: dropdowns, multi-select, dates, numbers, people, and formulas arrive as readable values.
- 3 sync modes: manual on demand, scheduled every 3 hours on Pro, and live on Business.
- Two-way sync (Business): edit tasks in Sheets and push the changes back to Asana.
- Time entries and users (Pro and Business): pull Asana time tracking and workspace members into a sheet. Time tracking needs Asana Advanced or higher.
- Filtered sync: narrow a sync by section, assignee, completed state, or due date.