Skip to main content
System Status    

How to use Toky Data Importer Add-on for Google Sheets

  • Updated

If you use Google Sheets in your daily tasks you could enjoy out Toky Data Importer add-on for Google Sheets. This add-on will help you to import data from your Toky account directly to your Google Sheets, so you can start analyzing your data and generating your own reports and indicators. 

1. Installing the add-on

You can go to the G Suit Marketplace and click on the install button

tdi_gs_1.png

You can also install the add-on directly from any open Google Sheet, just by clickig on Add-ons / Get Add-ons and looking for Toky Data Importer

tdi_gs_2.png

Next click on the button +Free to install it.

tdi_gs_3.png

You must allow the add-on the proper permissions:

tdi_gs_4.png

After installing you will see the Toky Data Importer option menu under the Add-ons menu.

tdi_gs_5.png

2. Adding your Toky API Key

Click on Import Data

tdi_gs_6..png

Click on the API Key option in the side bar and paste the Toky API Key. If you don't know how to get your API Key click on this link.

tdi_gs_7.png

After pasting right API Key and clicking on the Calls data option, the Not configured label will disappear and a message will inform you that the API Key was added. The Add-on won't ask you for the API Key in the future unless you delete it.

tdi_gs_8.png

3. Importing Data

Important: Toky Data Importer uses Google Apps Script and is limited to the script runtime that it could go from 6 minutes to 30 minutes depending on your Google account type. You can check this and other limits on this link. Try to load few days at a time if you generate many calls or SMS data.

Now you can start importing data from your Toky account. For this you can get:

  • Calls data: You must provide a date range and your current timezone to load the calls data. After clicking on IMPORT a message box will ask you about loading extended fields, these are some calculated fields and makes the importing process slower, so try first if you need this data. If you click in No to the message box the add-on will load the data described in our API.

tdi_gs_9.png

  • Agents: This option will load your current agent list

tdi_gs_10.png

 

  • Contacts: This option will load the contacts registered in Toky's directory.

tdi_gs_11.png

 

  • SMS: This option will load SMS messages in a date range.

Related articles