If you do not have a Google account, you will need to register for one first before you can access the Google suite of products. Within Google Sheets, please first create a brand new (blank) spreadsheet and rename it as you wish.
Please follow these steps to set up a base environment from which we will then install the Activity Tracker. For the best results, please use the latest version of the Google Chrome browserįor more technical information about Google Apps Script for Google Sheets, please review their public documentation by clicking here.flatpickr: A module that allows us to build lightweight and powerful date-time pickers.select2: A module that allows us to build more advanced (and user-friendly) search boxes.We also make use of third-party Javascript modules within some of our Google scripts.Google Apps Script (GAS) allows us to programmatically create (using Javascript-like syntax) custom menus, dialogs, sidebars, as well as manipulate cells within Google Sheets, extending the capabilities of a standard vanilla spreadsheet program.We leverage Google Sheets to organize and display Aircall user availabilities and call activities.In addition, since we are primarily using a REST API, please note that this Activity Tracker will not show user availabilities and call activities in real-time.
This is primarily a read-only tool - that is, we only ask Aircall for information (we never create or update information within Aircall itself), with the exception of the “Switch User Status” feature.
Communicating with Aircall via the classic REST API is critical to the functionality of the tool - we query Aircall for an update on all Aircall user availabilities and call activities, then we use Google Sheets to organize and display the data.The Activity Tracker essentially relies on two main components: Wrong Call History Displayed For Selected User.User ID Non-Existent Using User Call History Feature.Using the Advanced Search for Call History.Reviewing Call History for a Specific User.Copy Scripts from GitHub into Google Apps Script Project.Our Activity Tracker should simply be taken as an example of a useful tool that can be built on top of Aircall with our public API. Review historical call activities (that matches particular search criteria) with just a few clicksĭISCLAIMER: Please note that this is an unofficially supported tool.View Aircall teams' user availability, along with key call activity metrics, at a high-level.Our Google Sheets Activity Tracker implements features important from a "supervisor"-role perspective, allowing these types of users to: To demonstrate the power and flexibility of Aircall’s Public API, the Aircall team has built an Activity Tracker on top of a tool that is utilized by business users everywhere: Google Spreadsheets! Combining the simplicity and universality of Google Sheets with Aircall’s classic REST API, we have created an Activity Tracker wallboard that is intuitive to use and experiment with.