Webhook setup instructions 
for google sheets

When you create a new product or website, you may need to connect your database with other platforms through an API. It is not an easy task, at least because there is more than one way to do it, and each one has its own specs.

Not everyone can afford to waste their time for searching the best solution. Effebot can help: our experts prepared a simple step-by-step guide which will allow you 
to pass the integration process quickly and painlessly.

Case 2 You need to provide access to other integrations via Google sheets that client already has.

2. Go to the extensions and choose the Apps script.

// Required function for publishing Google script app




// This funciton fires when a GET message is recieved

function doGet(e) {


return HtmlService.createHtmlOutput(

"doGet request");


}


function flattenObject(obj) {


const flattened = {}


Object.keys(obj).forEach((key) => {


const value = obj[key]


if (typeof value === 'object' &&

value !== null && 
!Array.isArray(

value)) {


Object.assign(flattened,

flattenObject(value))


} else {


flattened[key] = value


}


})
 return flattened


}

// Required fucntion for publishing Google script app




// This fucntion fires when a POST message is recieved

function doPost(e) {
 //Name of Sheet to be used.




var sheetName = "Sheet1";


try {
 // convert payload into js object


 // webhook events are only for one document so we can just extract the first array object





var data = JSON.parse(e.postData.contents);


var sheet
 = SpreadsheetApp.getActiveSpreadsheet()

.getSheetByName(sheetName);
 // write some data to Google sheet. There is other data that can be used but these are common data point for every document




// sheet.appendRow([data.id, data.name]);





sheet.appendRow(Object.values(

flattenObject(data)));


} catch (error) {
 // if something goes wrong we will append message to google sheet so it can be easily found





var sheet = 
SpreadsheetApp.getActiveSpreadsheet()

.getSheetByName(sheetName);


sheet.appendRow([error])


}


return HtmlService.createHtmlOutput(

"doPost received");


}