Webhooks & Integrations

{
  "event": "submission.created",
  "form": {
    "id": "abc-123",
    "name": "Contact Form"
  },
  "submission": {
    "id": "xyz-789",
    "data": {
      "name": "John Doe",
      "email": "john@example.com",
      "message": "Hello!"
    },
    "createdAt": "2024-01-15T10:30:00.000Z"
  },
  "meta": {
    "ipAddress": "192.168.1.1",
    "userAgent": "Mozilla/5.0...",
    "referer": "https://yoursite.com"
  }
}

const crypto = require('crypto');

function verifyWebhook(payload, signature, secret) {
  const expectedSignature = crypto
    .createHmac('sha256', secret)
    .update(payload)
    .digest('hex');
  
  return signature === `sha256=${expectedSignature}`;
}

// In your webhook handler
app.post('/webhook', (req, res) => {
  const signature = req.headers['x-townhall-signature'];
  const payload = JSON.stringify(req.body);
  
  if (!verifyWebhook(payload, signature, process.env.WEBHOOK_SECRET)) {
    return res.status(401).send('Invalid signature');
  }
  
  // Process the webhook
  console.log('Valid webhook:', req.body);
  res.status(200).send('OK');
});

function doPost(e) {
  const sheet = SpreadsheetApp.getActiveSheet();
  const data = JSON.parse(e.postData.contents);
  
  // Get or create headers
  let headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
  if (headers[0] === '') {
    headers = ['Timestamp', 'Submission ID', ...Object.keys(data.submission.data)];
    sheet.getRange(1, 1, 1, headers.length).setValues([headers]);
  }
  
  // Add row
  const row = headers.map(h => {
    if (h === 'Timestamp') return new Date().toISOString();
    if (h === 'Submission ID') return data.submission.id || '';
    return data.submission.data[h] || '';
  });
  
  sheet.appendRow(row);
  
  return ContentService.createTextOutput(JSON.stringify({success: true}))
    .setMimeType(ContentService.MimeType.JSON);
}