Hey all,
I’m looking to create a webhook automation that will add events to an outlook calendar upon saving a form in appsheet. I’m currently using the free version of appsheet but my company is signed up with microsoft. Has anyone done this before? This is where my brain goes dumb..
Thanks
You’d need to create a script that would accomplish what you’re wanting, and I don’t think that’s allowed under the free plan.
But you could go to your favorite LLM and ask it for a google apps script that you could call from your app that would integrate with Microsoft’s APIs.
Would I get a 403 error code due to using the free version of appsheet?
Here’s my testing setup (so you can copy and try yourself):
If things work, you’ll receive an email from the script.
First you need to create the API, which sounds more complicated than it actually is. 
Open Apps Script | Google for Developers
Create a new project
Add the following code
// Set your email here
const MY_EMAIL = 'YOUR_EMAIL'; // CHANGE THIS TO YOUR EMAIL
function doPost(e) {
let debugInfo = {};
let emailSubject = 'Webhook Debug';
let emailBody = '';
try {
const timestamp = new Date().toISOString();
debugInfo.timestamp = timestamp;
debugInfo.receivedEvent = true;
// Capture everything about the request
debugInfo.hasParameter = !!e.parameter;
debugInfo.hasPostData = !!e.postData;
debugInfo.hasParameters = !!e.parameters;
if (e.parameter) {
debugInfo.parameter = e.parameter;
}
if (e.postData) {
debugInfo.postData = {
length: e.postData.length,
type: e.postData.type,
contents: e.postData.contents
};
}
if (e.parameters) {
debugInfo.parameters = e.parameters;
}
// Try to parse body if it exists
let parsedBody = null;
if (e.postData && e.postData.contents) {
try {
parsedBody = JSON.parse(e.postData.contents);
debugInfo.parsedBodySuccess = true;
debugInfo.parsedBody = parsedBody;
} catch (parseError) {
debugInfo.parsedBodySuccess = false;
debugInfo.parseError = parseError.toString();
debugInfo.rawContents = e.postData.contents;
}
}
emailSubject = `Webhook SUCCESS - ${timestamp}`;
emailBody = `Webhook received successfully!\n\nDebug Info:\n${JSON.stringify(debugInfo, null, 2)}`;
// Send success email with fallback methods
try {
// Try multiple email methods
const userEmail = Session.getActiveUser().getEmail();
debugInfo.userEmail = userEmail;
if (!userEmail) {
// Try hardcoded email if session fails
GmailApp.sendEmail(MY_EMAIL, emailSubject, emailBody);
} else {
GmailApp.sendEmail(userEmail, emailSubject, emailBody);
}
debugInfo.emailSent = true;
} catch (emailError) {
debugInfo.emailSent = false;
debugInfo.emailError = emailError.toString();
// Try MailApp as fallback
try {
MailApp.sendEmail(MY_EMAIL, emailSubject, emailBody);
debugInfo.fallbackEmailSent = true;
} catch (fallbackError) {
debugInfo.fallbackEmailError = fallbackError.toString();
}
}
// Return success response
return ContentService
.createTextOutput(JSON.stringify({
status: 'success',
message: 'Webhook processed',
timestamp: timestamp,
debug: debugInfo
}))
.setMimeType(ContentService.MimeType.JSON);
} catch (mainError) {
// Something went wrong - send error email
debugInfo.mainError = mainError.toString();
debugInfo.errorStack = mainError.stack;
try {
GmailApp.sendEmail(
Session.getActiveUser().getEmail(),
'Webhook ERROR',
`Webhook failed!\n\nError: ${mainError.toString()}\n\nStack: ${mainError.stack}\n\nDebug Info:\n${JSON.stringify(debugInfo, null, 2)}`
);
} catch (emailError) {
// Can't even send email
}
return ContentService
.createTextOutput(JSON.stringify({
status: 'error',
message: mainError.toString(),
debug: debugInfo
}))
.setMimeType(ContentService.MimeType.JSON);
}
}
function doGet(e) {
try {
GmailApp.sendEmail(
Session.getActiveUser().getEmail(),
'Webhook GET Test',
`GET request received.\n\nParameters: ${JSON.stringify(e.parameter || {}, null, 2)}`
);
return ContentService
.createTextOutput(JSON.stringify({
status: 'success',
message: 'Webhook tester is running',
timestamp: new Date().toISOString()
}))
.setMimeType(ContentService.MimeType.JSON);
} catch (error) {
return ContentService
.createTextOutput(JSON.stringify({
status: 'error',
message: error.toString()
}))
.setMimeType(ContentService.MimeType.JSON);
}
}
function testWebhook() {
const testData = {
parameter: {},
postData: {
length: 45,
type: 'application/json',
contents: '{"event":"test","data":{"id":123,"name":"test"}}'
},
parameters: {}
};
const result = doPost(testData);
return `Test completed. Check email for results. Response: ${result.getContent()}`;
}
Save everything, then deploy as a web app
Deploy (blue button, bottom right)
Copy the “Web app URL”
Authorize the script by hitting the “Run” button
Next you need to create a test automation in your app, with a webhook task to send some test data to your test API.
Open your app, go to Automation, make a new automation (doesn’t matter what table)
Configure event > Create new event (bottom option)
Add a new step
{
"Test": "Value",
"Another": "Value"
}
Save everything
Now that everything is in place, let’s actually test things.
Click the “Run” button for your scheduled automation
You should receive an email with the contents.
To debug what’s not working, take a look at the automation monitor, and the audit logs.