💡 Guests can view tickets but cannot comment or change status.
Slack
Post a message when a new ticket is created
Google Sheets
Backup every ticket to a spreadsheet automatically
{}
Webhook
Send a signed JSON payload to any URL on ticket creation
📊 How to set up Google Sheets sync
Step 1 — Create a new Google Sheet. Add these headers in Row 1:
Timestamp | ID | Type | Urgency | Note | URL | Submitter Name | Submitter Email | Status
Step 2 — In the sheet: Extensions → Apps Script
Delete existing code and paste this:
Type: Web app · Execute as: Me · Access: Anyone
Copy the Web App URL → paste it above → click Save ✓
Step 1 — Create a new Google Sheet. Add these headers in Row 1:
Timestamp | ID | Type | Urgency | Note | URL | Submitter Name | Submitter Email | Status
Step 2 — In the sheet: Extensions → Apps Script
Delete existing code and paste this:
function doPost(e) {
var s = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var d = JSON.parse(e.postData.contents);
s.appendRow([d.timestamp,d.id,d.category,d.urgency,d.note,d.url,d.submitter_name,d.submitter_email,d.status]);
return ContentService.createTextOutput('ok');
}
Step 3 — Click Deploy → New deploymentvar s = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var d = JSON.parse(e.postData.contents);
s.appendRow([d.timestamp,d.id,d.category,d.urgency,d.note,d.url,d.submitter_name,d.submitter_email,d.status]);
return ContentService.createTextOutput('ok');
}
Type: Web app · Execute as: Me · Access: Anyone
Copy the Web App URL → paste it above → click Save ✓