Google Sheet in IFrame
//HTML CODE //
<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<h3>This is test1</h3>
<style>
iframe {
width: 100%;
height: 1600px;
background: url('data:image/svg+xml;charset=utf-8,<svg xmlns="http://www.w3.org/2000/svg" width="100%" height="100%" viewBox="0 0 100% 100%"><text fill="%23FF0000" x="50%" y="50%" font-family="\'Lucida Grande\', sans-serif" font-size="24" text-anchor="middle">Loading...</text></svg>') 0px 0px no-repeat;
}
</style>
<iframe class="second-row" src="https://docs.google.com/spreadsheets/d/GOOGLE_SHEET-ID/edit?&rm=minimal" frameborder="0"></iframe>
</body>
</html>
//GS CODE //
function doGet() {
return HtmlService
.createTemplateFromFile('FileNameHTML')
.evaluate();
}
On Form Submit
function setUpTrigger() {
ScriptApp.newTrigger('sendConfirmationEmail')
.forForm('your google form id')
.onFormSubmit()
.create();
}
function sendConfirmationEmail(e) {
const recipient = e.response.getRespondentEmail();
const subject = "Email Confirmation";
const body = 'Write your text here what you want , please follow this URL: ${e.response.getEditResponseUrl()}';
GmailApp.sendEmail(recipient, subject, body);
}