The Google Spreadsheet™ add-on gets a list of all Google Tasks™ into a Google Spreadsheet™.
Some example use case; the spreadsheet with the list can be used to:
View all your Google Tasks per task list
Create Google Tasks in the spreadsheet and sync them to Google Tasks app
Learn from your tasks by viewing insights
Solve Google Tasks problems due to hidden or deleted tasks
Easily print the relevant Google Tasks from your Google Spreadsheet
After installation you will have in the Extension menu of your Google Spreadsheet the entry of ‘123 Sync for Google Tasks’.
Click on ‘Show configuration’ to open the Spreadsheet add-on sidebar.
On the first tab you can get all your existing Google Tasks in your Spreadsheet. As you can have multiple task lists in Google Tasks, select either to list all tasks of all your different task lists or select 1 particular tasklist.
On the second step you can create new tasks in the spreadsheet and sync them back to one of your existing Google Task lists.
On the third step you can optionally create an extra sheet called ‘Insights’. The sheet will provide a few statistics across your Task data.
How to add the Google Workspace extension '123 Sync for Google Tasks' to your Google Spreadsheet as an add-on ?
Start a new Google Spreadsheet in Google Drive. (https://sheets.new)
In the top menu bar of the Google Spreadsheet select Extensions.
Click in the menu “Add-ons” and “ Get add-ons”.
A new pop-up window will show the Google Workspace marketplace.
Search for “123 Sync for Google Tasks”.
Click the button “Individual Install”.
Go to the Google Workspace marketplace: https://workspace.google.com/marketplace
Search for “123 Sync for Google Tasks”
Click the button “Individual Install”
Go to Google Drive and start a new Google spreadsheet (https://sheets.new)
You find the add-on In the top menu bar of the Google Spreadsheet 'Extension'.
Yes a roadmap is available, when there is interest in this add-on. The following features will be added.
default charts to visualize your data
The add-on doesn't support the creation of new Tasks lists. You would need to create the extra list within Google Tasks it self. See Google learning center on how to do so: https://support.google.com/a/users/answer/9310236?hl=en#2.1. Add atleast one task to the new list to ensure that after the sync the new task list will be available in the spreadsheet.
Just sync the Google Task data to your Google Spreadsheet. In the Spreadsheet
you can hide columns which you don't need.
resize columns to your need
It is recommended to use the landscape print option in Google Spreadsheets.
The add-on shows all your deleted tasks. This feature can be used to undelete tasks.
In other cases you might want to hide the Spreadsheet rows which contain tasks that are deleted. For this you can use the filter option within the top row of the Spreadsheet. In column O ("Deleted? ) you can filter on TRUE. See screenshot.
Will be added soon.
There are two known limitations:
API limitations: the API of Tasks is not able to get all the tasks data. E.g. repetition, star, and other values are not visible in the Spreadsheet.
Execution time: This is the Google limitation for the time that the script is allowed to run. See Google documentation for the max execution time. Script will show an error message when you overrun the max allowed time. As a result not all tasks might be visible. A work around might be to sync only 1 task list.
< Back to product description page