Web Bespokers
  • Home
  • Portfolio
  • About Us
  • Contact

Google Add-On

Project Summary

Our client was moving to a new project management system – Target Process. To keep the workflow consistent, the integration between Google Spreadsheets and Target Process had to be developed.

After an analysis of the requirements and possible solutions we advised our client that creating a Google Add-on in this case would be the best solution.
Project Goals
Client
Technologies Involved
Project Goals
To create a Login function on Google Spreadsheet and to choose the Project in Target Process to be integrated with the given Google Spreadsheet document

To prepare the Google Spreadsheet to be integrated with Target Process

To implement push and pull functionalities

To assign users from Target Process to be responsible for particular tasks, bugs or user stories on Google Spreadsheet.

Client

Ironbelly Studios a game development company, based in Montreal, Canada.

Technologies Involved
  • JavaScript
  • Google Script
  • API integration
  • 3rd Party intergration

API Integration

The integration with Target Process API to provide functionality of login and choosing a project in Target Process to connect with the given Google Spreadsheet went smoothly. There were a few issues to think about:

  • checking whether credentials are correct
  • checking whether the Project that the user wants to choose had no other Google Spreadsheet attached to it
  • sending notifications to the user if any of these processes failed (error handling)

Read more

The integration with Target Process API to provide functionality of login and choosing a project in Target Process to connect with the given Google Spreadsheet went smoothly. There were a few issues to think about:

  • checking whether credentials are correct
  • checking whether the Project that the user wants to choose had no other Google Spreadsheet attached to it
  • sending notifications to the user if any of these processes failed (error handling)

To ensure that each project in Target Process has only one unique spreadsheet attached to it, the ID of the spreadsheet and link to the spreadsheet are automatically saved in Target Process in custom fields associated to the particular project. Only project admin can detach a spreadsheet from the project the spreadsheet is attached to by deleting values stored in the custom fields of the project.

Close

Pull Functionality

Pulling all of the entities from Target Process  (i.a. User Stories, Tasks, Bugs, Releases) was developed with great care about performance of the script (taking into account the amount of requests sent to Target Process API). Progress of the pulling data process is also shown to the user (e.g. cells already pulled into the spreadsheet are marked in green).

Push Functionality

Pushing all of the entities from Google Spreadsheet to Target Process was developed with great care about what data should be protected from unintentional changes by users of the Spreadsheet (some fields were protected from being edited by users with limited permission). Progress of the pushing data process is also shown to the spreadsheet user (e.g. cells already pushed into the spreadsheet are marked in green).

Drop-Down Feature

To assign a ‘User’ to be responsible for a particular Task, Bug or User Story you need to choose them from a drop-down field. In the drop-down field we obtained all of the users associated with a particular project via Target Process API. The same drop-down feature works also for the ‘Owners’ or ‘Business Value’ of a Task, Bug or User Story.

Initializing Function

The ‘Initialize Spreadsheet’ function was created to automatically prepare a spreadsheet (give it the right structure, order of the columns, type of columns or permissions to edit or not edit particular columns for users with certain permissions) after the add-on is installed.
E-cats
E-cats
Profile9
Profile9
  • Home
  • Portfolio
  • About Us
  • Contact
© Copyright Web Bespokers. All rights reserved.