# Main Chat Room
Connecting Spreadsheet
Fetching row data from Google Sheets...
Fetching row data from Google Sheets...
NChatSheets works by interacting with a Google Apps Script API mapped to your Spreadsheet. Follow these 3 swift integration steps:
function doGet(e) {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var data = sheet.getDataRange().getValues();
var headers = data[0];
var jsonArray = [];
for (var i = 1; i < data.length; i++) {
var row = data[i];
var record = {};
for (var j = 0; j < headers.length; j++) {
record[headers[j]] = row[j];
}
jsonArray.push(record);
}
return ContentService.createTextOutput(JSON.stringify(jsonArray))
.setMimeType(ContentService.MimeType.JSON);
}
function doPost(e) {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var params = JSON.parse(e.postData.contents);
var timestamp = new Date().toISOString();
sheet.appendRow([
timestamp,
params.username,
params.channel,
params.message,
params.avatar
]);
return ContentService.createTextOutput(JSON.stringify({ status: "success" }))
.setMimeType(ContentService.MimeType.JSON);
}