Tracker and Google Sheets Integration
You can easily integrate Generation of tracker urls into Google Sheets via custom Javascript function.
Step 1: Open the Spreadsheet and navigate to Tools -> Script Editor
Step 2: Add Function Definition for Tracker Integration
/**
* Tradable Bits Tracker
* @customfunction
*/
function createTracker(name, group, url, network, tracker_key) {
// tracker_name, tracker_group_name and tracker_url are required
// network and tracker_key are optional
var tracker_name = name;
var tracker_group_name = group;
var tracker_url = url;
var network = network;
var tracker_key = tracker_key;
if (!(tracker_name && tracker_group_name && tracker_url)) {
return null
}
// TradableBits Public API Key goes here
var api_key = 'XXXX-XXXX-XXXXX-XXXXX';
var data = {
'api_key': api_key,
'tracker_name': tracker_name,
'tracker_group_name': tracker_group_name,
'tracker_url': tracker_url,
'tracker_key': tracker_key,
'network': network,
'virtual_domain': 'tradablebits.com'
}
var url = 'https://tradablebits.com/api/v1/trackers/';
var options = {
'method': 'post',
'payload': data
}
var response = JSON.parse(UrlFetchApp.fetch(url, options).getContentText())
return 'https://' + response.virtual_domain + '/trk/' + response.tracker_key
}
Step 3: Enter the value in the cell as
=createTracker(A1,B1,C1,D1,E1)
Step 4: Assuming that values in A1,B1,C1,D1,E1 are correct and you put correct API KEY, tracker shortened url will show up in the cell