Enter your admin password to manage the Night Owl knowledge base.
Your sheet should have two tabs: Playbook (Situation / What to do) and Logins (Username / Password).
This script reads both your Playbook and Logins tabs and sends them to the site.
function doGet() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
// Read Playbook tab
var playbook = ss.getSheetByName('Playbook');
var pbData = playbook.getDataRange().getValues();
var scenarios = [];
for (var i = 1; i < pbData.length; i++) {
if (pbData[i][0] && pbData[i][1]) {
scenarios.push({
situation: pbData[i][0],
action: pbData[i][1]
});
}
}
// Read Logins tab
var logins = ss.getSheetByName('Logins');
var lgData = logins.getDataRange().getValues();
var users = [];
for (var j = 1; j < lgData.length; j++) {
if (lgData[j][0] && lgData[j][1]) {
users.push({
username: String(lgData[j][0]).toLowerCase(),
password: String(lgData[j][1])
});
}
}
return ContentService
.createTextOutput(JSON.stringify({ scenarios: scenarios, users: users }))
.setMimeType(ContentService.MimeType.JSON);
}