Overview

We've developed a Google Sheets Add-on which can be used in conjunction with our API for easy and simple sync of dashboard data into a Google spreadsheet.

NOTE: To make use of the API Add-On for reporting, you will need account ID and API token to make use of the add-on.
​
1. Go to Settings > LinkedIn Account Settings > Generate API token
​

2. While you are in your LinkedIn Account Settings page, go to the URL and you will find your account ID at the end.
​

How to create an API Add-on for reporting

1. Install the add-on using this private link, here.

2. To start setting up your API reporting, got to Extensions" > DotSimple Data Add-on > Install API tabs.
   ​
   ​

   

   
   ​

3. Next step will be to configure your settings.
   Go to Settings
   Enter your account ID and Token as shown below ​

   Select if you want specific data only or all triggers

   Click save
   ​

   

   
   ​

4. Once done, you will see two worksheets split by "Settings" and "Campaign data"
   ​

   

   
   ​
   ​

5. The following step will be adding the campaigns that you want to get reported. For this, you now need to add campaign ID(s) within the Settings. You can find campaign ID by going to your DotSimple campaign and checking the digits at the end of the URL.
   ​

   

   
   ​

6. Once you have your campaign ID, you will need to add it to the Settings tab under the column "Campaign ID"
   ​

   

   ​

Data will be pushed to your spreadsheet automatically at 00:00 every 24 hours.

If you want to add multiple accounts, you simply need a separate spreadsheet for each one.