Mail server with dovecot and postfix, then a script to verify emails. (Similar to Zerobounce and Millionverifier).
May 5, 2025Voice call agent (From Scratch) using Kokorotts, OpenAi’s Whisper & Openrouter (Llama)
May 5, 2025I was recently asked to create a Google Form for a small community. After designing and sharing the form, I noticed that the email notifications only included a link to the form responses, the submitted details weren't shown in the email body.
The goal was for non-technical users to receive the form details directly to their inbox, without needing to return to the Google Form page.
I searched for an extension that could handle this but couldn’t find one that worked the way I needed. So, I wrote a custom solution using Google Apps Script. Now, when someone submits the form, the details are sent directly to the host's email and also to google sheet.
function sendEmailOnFormSubmit(e) {
const responses = e.values;
const timestamp = responses[0];
const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
const headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
// Skip timestamp and match headers to responses
let bodyLines = [];
for (let i = 1; i < responses.length; i++) {
bodyLines.push(`${headers[i]}: ${responses[i]}`);
}
const emailBody = `
New Form Submission:
Timestamp: ${timestamp}
-----------------------------
${bodyLines.join('\n')}
-----------------------------
This is an automatic email notification.
`;
MailApp.sendEmail({
to: "[email protected]",
subject: "New Form Submission Received",
body: emailBody
});
}
