Within Teamwork, you can filter both tasks and time to export them from your site to Google Sheets.
Note: The Google Sheets export feature is available on Scale subscriptions.
Connecting your Google account
You can connect your Google account during the export process. The Google Sheets export option is accessible in the following subsections of the Everything area:
Note: Collaborators do not have access to the Google Sheets export feature.
Click the options button (three dots) in the top right of the relevant area and hover over Export to reveal the Google Sheets export option.
For the initial use of the export, you will be redirected to a Google Sheets sign in page where you will be required to log in to your Google account.
You will need to allow third-party access to Teamwork in order to proceed. Once connected, you will no longer need to authenticate for future exports.
Exporting to Google Sheets
Once you authorize your Google account, the export will occur automatically and a new Google Sheet will open.
Every export will take into account any active filters in place in the relevant area at the time of export.
Each subsequent time you choose to export to Google Sheets, a message will be displayed informing you of the connection to Google Sheets.
Once complete, your export will open in a new Google Sheets tab.
Disconnecting your Google account
You can disconnect Teamwork from your Google account via your Google account security settings.
You can then manage Teamwork access via the Third-party apps with account access section.
You can find more information on managing third-party access to Google here.
Once revoked, Google account authorization will be required the next time you use the export. You can choose the previously used account or an alternative.
For more information, see: Using the Google Sheets Add-on