Skip to content

Instantly share code, notes, and snippets.

function saveMessage(webhookMessageResult) {
if (webhookMessageResult.type === 'user-answers') {
const dialogs = webhookMessageResult.value.data;
let sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
let sheet = sheets[0];
for (let i = 0; i < dialogs.length; i++) {
const dialog = dialogs[i];
@standuply
standuply / google-sheet-webhook.gs
Last active March 9, 2022 13:07
Save respondents answers only
function saveMessage(webhookMessageResult) {
if (webhookMessageResult.type === 'user-answers') {
for (const question of webhookMessageResult.value.data) {
let sheet = SpreadsheetApp.getActiveSheet();
let lastRow = Math.max(sheet.getLastRow(), 1);
sheet.insertRowAfter(lastRow);
let nowDate = new Date();