Portal resmi anggota komunitas Campervan Nyari Angin. Daftar cukup dengan Nama Lengkap dan Nomor WhatsApp Aktif untuk terhubung dengan ratusan pejalan lintas nusantara.
Hubungkan aplikasi Nyari Angin ke Google Sheets (script.google.com)
Status saat ini: Belum terhubung (Menggunakan penyimpanan lokal perangkat)
2. Cara Membuat Database Google Sheets dalam 2 Menit:
Buka sheets.google.com, buat Spreadsheet baru beri nama DB_NyariAngin_Campervan.
Klik menu Ekstensi (Extensions) → Apps Script.
Hapus semua kode bawaan, lalu salin dan tempel kode Code.gs di bawah ini.
Klik tombol Terapkan (Deploy) → Deployment Baru (New deployment).
Pilih jenis Aplikasi Web (Web app), atur Yang memiliki akses (Who has access) menjadi Siapa saja (Anyone), lalu klik Terapkan dan salin URL Web App-nya ke kolom di atas.
3. Skrip Backend Google Apps Script (Code.gs)
// ============================================================================
// GOOGLE APPS SCRIPT BACKEND — KOMUNITAS CAMPERVAN "NYARI ANGIN"
// Paste kode ini ke Extensions > Apps Script di Google Sheets Anda
// ============================================================================
function doGet(e) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
ensureSheetsExist(ss);
var payload = {
status: "success",
members: getSheetData(ss.getSheetByName("Anggota")),
announcements: getSheetData(ss.getSheetByName("Pengumuman")),
events: getSheetData(ss.getSheetByName("Acara")),
finance: getSheetData(ss.getSheetByName("Keuangan")),
forum: getSheetData(ss.getSheetByName("Forum")),
resources: getSheetData(ss.getSheetByName("Materi"))
};
return ContentService.createTextOutput(JSON.stringify(payload))
.setMimeType(ContentService.MimeType.JSON);
}
function doPost(e) {
try {
var ss = SpreadsheetApp.getActiveSpreadsheet();
ensureSheetsExist(ss);
var body = JSON.parse(e.postData.contents);
var action = body.action;
if (action === "SYNC_ALL") {
overwriteSheet(ss.getSheetByName("Anggota"), ["id", "name", "wa", "city", "role", "status", "vehicle", "plate", "bio", "joinedAt"], body.members || []);
overwriteSheet(ss.getSheetByName("Pengumuman"), ["id", "title", "tag", "body", "author", "date"], body.announcements || []);
overwriteSheet(ss.getSheetByName("Acara"), ["id", "title", "date", "location", "quota", "desc"], body.events || []);
overwriteSheet(ss.getSheetByName("Keuangan"), ["id", "memberName", "memberWa", "period", "amount", "method", "status", "date"], body.finance || []);
overwriteSheet(ss.getSheetByName("Forum"), ["id", "category", "title", "content", "author", "date"], body.forum || []);
overwriteSheet(ss.getSheetByName("Materi"), ["id", "title", "category", "summary", "author"], body.resources || []);
} else if (action === "REGISTER_MEMBER") {
var m = body.member;
ss.getSheetByName("Anggota").appendRow([m.id, m.name, "'" + m.wa, m.city, m.role, m.status, m.vehicle, m.plate, m.bio, m.joinedAt]);
}
return ContentService.createTextOutput(JSON.stringify({ status: "success", message: "Data Nyari Angin tersimpan di Google Sheets" }))
.setMimeType(ContentService.MimeType.JSON);
} catch (err) {
return ContentService.createTextOutput(JSON.stringify({ status: "error", message: err.toString() }))
.setMimeType(ContentService.MimeType.JSON);
}
}
function ensureSheetsExist(ss) {
var schemas = {
"Anggota": ["ID", "Nama Lengkap", "No WA", "Domisili", "Peran", "Status", "Unit Campervan", "Nopol", "Bio", "Tanggal Gabung"],
"Pengumuman": ["ID", "Judul", "Kategori", "Isi Pengumuman", "Penulis", "Tanggal"],
"Acara": ["ID", "Nama Acara", "Tanggal", "Lokasi", "Kuota", "Deskripsi"],
"Keuangan": ["No Kuitansi", "Nama Anggota", "No WA", "Periode", "Nominal", "Metode", "Status", "Tanggal"],
"Forum": ["ID", "Kategori", "Judul Topik", "Konten", "Penulis", "Tanggal"],
"Materi": ["ID", "Judul Materi", "Kategori", "Ringkasan", "Kontributor"]
};
for (var name in schemas) {
var sheet = ss.getSheetByName(name);
if (!sheet) {
sheet = ss.insertSheet(name);
sheet.appendRow(schemas[name]);
sheet.getRange(1, 1, 1, schemas[name].length).setFontWeight("bold").setBackground("#254436").setFontColor("#ffffff");
}
}
}
function getSheetData(sheet) {
var rows = sheet.getDataRange().getValues();
if (rows.length <= 1) return [];
var headers = rows[0];
var result = [];
for (var i = 1; i < rows.length; i++) {
var obj = {};
for (var j = 0; j < headers.length; j++) {
obj[headers[j]] = rows[i][j];
}
result.push(obj);
}
return result;
}
function overwriteSheet(sheet, keys, items) {
if (sheet.getLastRow() > 1) {
sheet.getRange(2, 1, sheet.getLastRow() - 1, keys.length).clearContent();
}
if (!items || items.length === 0) return;
var rows = items.map(function(item) {
return keys.map(function(k) {
var val = item[k] !== undefined ? item[k] : "";
return k === "wa" || k === "memberWa" ? "'" + val : val;
});
});
sheet.getRange(2, 1, rows.length, keys.length).setValues(rows);
}