This application is automated reporting solution that reads status updates from a project, then appends them to a shareable spreadsheet.
Since the application largely makes use of out-of-the-box Google Apps Scripts features (e.g., UrlFetchApp, SpreadsheetApp), there are no system requirements for this application.
Because the application is designed to run entirely in Google Apps Scripts, please ensure that you have the latest version of your preferred browser installed on your local machine.
View the documentation for this application, which includes a step-by-step tutorial.
The standard information outputted in to the spreadsheet includes the following project metadata:
- Project ID (
current_status_update.gid) - Link (i.e., to the project)
- Status type (
current_status_update.status_type) - Text (
current_status_update.text) - Author (
current_status_update.created_by.name) - Created at (
current_status_update.created_at)
To get information on a single project (including its current status update), you can request the complete project record by sending a request with its GID via the Asana API, as documented here: GET /projects/{project_gid}.
You can also see all status updates belonging to an object (e.g., a project) by making a request to (i.e., GET /status_updates).
Additionally, visit the documentation for input/output options for details on customizing API response.