Use the awork add-on for Google Sheets to pull raw data from awork into your spreadsheet in just a few clicks.
You control the import from a dedicated awork sidebar inside Google Sheets.
Key benefits and use cases
Bring awork data into Google Sheets when you want to analyze, report, or build your own views.
Import raw awork data into your open spreadsheet
Choose what you import by selecting the data types you need
Refresh anytime by re-importing from the sidebar
What awork data can be imported into Google Sheets
You can import the following raw data:
Tasks
Users
Times
Projects
How to set up the Google Sheets Integration
Install the awork add-on
Open awork in Google Workplace Marketplace listing
Click Install in the Marketplace
Or install it directly from Google Sheets:
In your spreadsheet, go to Extensions > Add-ons > Add add-on
Search the Marketplace for awork
Click Install
The add-on is now set up for the Google account you are currently logged in with.
How to load awork data into Google Sheets
Open the awork sidebar
In Google Sheets, go to Extensions > awork > Open sidebar.
Note: It may take a few seconds for the add-on to appear in the Extensions menu and for the sidebar to load.
Log in to the awork add-on
In the sidebar, log in once using your awork account.
Important: After a successful login, reload the Google Sheets page once. If the sidebar disappears, open it again via Extensions > awork > Open sidebar.
Import data
In the sidebar, select the checkboxes for the data you want to load
Click Load data
The data is retrieved automatically and displayed in separate spreadsheets.
Best practices for using imported data
Do not edit the automatically created spreadsheets. When you update, any changes in those spreadsheets will be overwritten.
To work with the data safely: Use references and Lookups to evaluate and display the raw data in your own spreadsheets.
How to update data
When you want fresh data, just import again.
Open the sidebar via Extensions > awork > Open sidebar
Click Load data
The raw data in the automatically created spreadsheets is overwritten and updated.
If your evaluation references this raw data, the new data will be imported automatically.
FAQ
What awork data can I import into Google Sheets?
What awork data can I import into Google Sheets?
You can import raw data for Tasks, Users, Times, and Projects.
Where do I find the awork sidebar in Google Sheets?
Where do I find the awork sidebar in Google Sheets?
Go to Extensions > awork > Open sidebar.
Why doesn’t the add-on show up right away?
Why doesn’t the add-on show up right away?
It may take a few seconds for the add-on to load in the Extensions menu and for the sidebar content to appear.
Do I need to reload Google Sheets after logging in?
Do I need to reload Google Sheets after logging in?
Yes. After a successful login, reload the spreadsheet page once. If the sidebar is hidden, open it again via Extensions > awork > Open sidebar.
Can I edit the automatically created spreadsheets?
Can I edit the automatically created spreadsheets?
No. If you edit them, your changes will be overwritten the next time you update by clicking Load data.