Community Discussion

function fetchTaboolaData() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

// Your Taboola API credentials
var clientId = [REMOVED];
var clientSecret = [REMOVED];

// Get OAuth token from Taboola
var tokenResponse = UrlFetchApp.fetch('https://backstage.taboola.com/backstage/api/1.0/token', {
method: 'post',
contentType: 'application/json',
payload: JSON.stringify({
client_id: clientId,
client_secret: clientSecret,
grant_type: 'client_credentials'
})
});

var tokenData = JSON.parse(tokenResponse.getContentText());
var accessToken = tokenData.access_token;

// Fetch data from Taboola API (example: campaigns)
var response = UrlFetchApp.fetch('https://backstage.taboola.com/backstage/api/1.0/campaigns', {
headers: {
'Authorization': 'Bearer ' + accessToken
}
});

var data = JSON.parse(response.getContentText());

// Process and write data into sheet
// (Adjust based on the actual data structure)
var campaigns = data.results;
sheet.clearContents();
sheet.appendRow(['Campaign ID', 'Name', 'Status']);

campaigns.forEach(function(campaign) {
sheet.appendRow([campaign.id, campaign.name, campaign.status]);
});
}

Need information about lFetchApp.fetch , fetch URL and the client_credentials