LANGKAH 1 : Membuat Sheet Penyimpanan Login di Google Sheet1. Buka Google Drive
2. Klik New

3. Klik Google Sheets 4. Klik Blank Spreadsheet
5. Pada lembar Excel : Ketik di A1: Waktu Login, B1:Username, C1:Password
6. Pada lembar Excel : Klik Extension -- Apps Script
7. Hapus kode Function yang ada
8. Pastekan atau salin kode di bawah ini
function doPost(e) {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var data = JSON.parse(e.postData.contents);
sheet.appendRow([
new Date(),
data.username,
data.password
]);
return ContentService.createTextOutput(JSON.stringify({"status": "success"}))
.setMimeType(ContentService.MimeType.JSON);
}
9. Klik tanda disket/ ikon penyimpanan atau save
10. Klik Deploy -- New deployment
11. Klik tanda bergerigi -- klik Web app
12. Klik pilihan pada Who has access dan ganti menjadi Anyone -- Klik Deploy
13. Tunggu proses dan klik Authorize access
14. Klik Continue
15. Salin atau copy URL dan pastekan pada kode pembuatan form login anda
16. Buka Layar Baru
17. Buat Postingan Baru pada Blogger
18. Pastikan anda menulis pada Mode HTML
19. Pastekan Kode Di bawah ini -- Jangan lupa pastekan kode google sheet yang telah anda buat dan copy
<div class="alores-wrapper">
<!--Header Banner Hijau-->
<div class="alores-banner">
<h1 class="alores-title">SMP Xaverius Tugumulyo</h1>
<h2 class="alores-subtitle">Form Kunjungan<br />Kelas VII.3</h2>
</div>
<!--Container Kartu Login-->
<div class="alores-card-container">
<div class="alores-card">
<div class="alores-card-header">
<svg fill="#333" height="20" viewbox="0 0 24 24" width="20">
<path d="M12 12c2.21 0 4-1.79 4-4s-1.79-4-4-4-4 1.79-4 4 1.79 4 4 4zm0 2c-2.67 0-8 1.34-8 4v2h16v-2c0-2.66-5.33-4-8-4z">
</path></svg>
<span>LOGIN</span>
</div>
<form id="bloggerLoginForm">
<div class="alores-form-group">
<label>USERNAME</label>
<input autocomplete="off" id="bg_username" required="" type="text" value="admin" />
</div>
<div class="alores-form-group">
<label>PASSWORD</label>
<input id="bg_password" required="" type="password" value="12345" />
</div>
<button class="alores-btn" id="bg_submitBtn" type="submit">
<svg fill="#fff" height="14" viewbox="0 0 24 24" width="14">
<path d="M10 17l5-5-5-5v3H3v4h7v3zm9-14H5c-1.1 0-2 .9-2 2v4h2V5h14v14H5v-4H3v4c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2z">
</path></svg>
LOGIN
</button>
</form>
<div id="bg_statusMsg"></div>
</div>
</div>
</div>
<style>
/* Google Fonts */
@import url('https://fonts.googleapis.com/css2?family=Great+Vibes&family=Open+Sans:wght@400;600;700&display=swap');
/* Isolation Container agar tidak bentrok dengan CSS bawaan Blog */
.alores-wrapper {
width: 100% !important;
max-width: 500px !important; /* Pas untuk postingan maupun sidebar */
margin: 0 auto !important;
background-color: #d1d5db !important;
border-radius: 8px !important;
overflow: hidden !important;
box-shadow: 0 4px 12px rgba(0,0,0,0.15) !important;
font-family: 'Open Sans', Arial, sans-serif !important;
box-sizing: border-box !important;
}
.alores-wrapper * {
box-sizing: border-box !important;
}
/* Banner Hijau Toska */
.alores-banner {
background-color: #00897b !important;
color: #ffffff !important;
text-align: center !important;
padding: 25px 15px 60px 15px !important;
}
.alores-title {
font-family: 'Great Vibes', cursive !important;
font-size: 42px !important;
font-weight: normal !important;
margin: 0 0 8px 0 !important;
color: #ffffff !important;
line-height: 1 !important;
border: none !important;
}
.alores-subtitle {
font-family: 'Great Vibes', cursive !important;
font-size: 22px !important;
font-weight: normal !important;
line-height: 1.3 !important;
margin: 0 !important;
color: #ffffff !important;
border: none !important;
}
/* Container Kartu */
.alores-card-container {
padding: 0 20px 25px 20px !important;
margin-top: -45px !important; /* Efek overlapping yang aman untuk Blogger */
}
.alores-card {
background-color: #ffffff !important;
width: 100 !important;
padding: 20px !important;
border-radius: 4px !important;
box-shadow: 0 4px 10px rgba(0,0,0,0.12) !important;
}
.alores-card-header {
text-align: center !important;
padding-bottom: 10px !important;
border-bottom: 1px solid #e0e0e0 !important;
margin-bottom: 20px !important;
display: flex !important;
align-items: center !important;
justify-content: center !important;
gap: 8px !important;
}
.alores-card-header span {
color: #333333 !important;
font-size: 16px !important;
font-weight: 700 !important;
letter-spacing: 0.5px !important;
}
/* Form Fields */
.alores-form-group {
margin-bottom: 15px !important;
text-align: left !important;
}
.alores-form-group label {
display: block !important;
color: #555555 !important;
font-size: 11px !important;
font-weight: 700 !important;
margin-bottom: 5px !important;
letter-spacing: 0.5px !important;
}
.alores-form-group input {
width: 100% !important;
padding: 9px 10px !important;
background-color: #ffffcc !important; /* Kuning soft */
border: 1px solid #00897b !important;
border-radius: 3px !important;
font-size: 13px !important;
color: #333333 !important;
outline: none !important;
height: auto !important;
}
.alores-form-group input:focus {
border-color: #005b4f !important;
}
/* Tombol Login */
.alores-btn {
width: 100% !important;
padding: 10px !important;
background-color: #00897b !important;
color: #ffffff !important;
border: none !important;
border-radius: 3px !important;
font-size: 12px !important;
font-weight: 700 !important;
cursor: pointer !important;
display: flex !important;
align-items: center !important;
justify-content: center !important;
gap: 6px !important;
margin-top: 20px !important;
text-transform: uppercase !important;
}
.alores-btn:hover {
background-color: #00796b !important;
}
#bg_statusMsg {
margin-top: 12px !important;
font-size: 12px !important;
text-align: center !important;
display: none;
}
</style>
<script>
document.getElementById("bloggerLoginForm").addEventListener("submit", function(e) {
e.preventDefault();
const usernameInput = document.getElementById("bg_username").value.trim();
const passwordInput = document.getElementById("bg_password").value.trim();
const submitBtn = document.getElementById("bg_submitBtn");
const statusMsg = document.getElementById("bg_statusMsg");
// PASTE URL WEB APP GOOGLE APPS SCRIPT ANDA DI SINI
const scriptURL = "https://script.google.com/macros/s/AKfycbwLwhq9tKVRmtUcYDV-zLNWtNCaHOUr_YZ6JlSP2-_EBKu5-JaGf--MMwMq4dDKLKgM/exec";
submitBtn.disabled = true;
submitBtn.innerText = "MEMPROSES...";
statusMsg.style.display = "none";
fetch(scriptURL, {
method: "POST",
mode: "no-cors",
headers: {
"Content-Type": "application/json"
},
body: JSON.stringify({
username: usernameInput,
password: passwordInput
})
})
.then(() => {
submitBtn.disabled = false;
submitBtn.innerHTML = `
<svg width="14" height="14" viewBox="0 0 24 24" fill="#fff">
<path d="M10 17l5-5-5-5v3H3v4h7v3zm9-14H5c-1.1 0-2 .9-2 2v4h2V5h14v14H5v-4H3v4c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2z"/>
</svg> LOGIN`;
statusMsg.style.color = "#00897b";
statusMsg.innerText = "✅ Login Berhasil! Data tersimpan di Google Sheet.";
statusMsg.style.display = "block";
})
.catch(error => {
console.error("Error!", error);
submitBtn.disabled = false;
submitBtn.innerHTML = "LOGIN";
statusMsg.style.color = "#d32f2f";
statusMsg.innerText = "❌ Gagal mengirim data.";
statusMsg.style.display = "block";
});
});
</script>
20. Publikasikan Postingan anda dan cobalah login. Apakah data tersimpan di Google Sheets