Meta Creator Pro automatically exports each verified Instagram / Meta account directly to your Google Spreadsheet via a fast Google Apps Script Webhook. Follow this 1-minute setup guide to connect your sheet:
1
Create a Google Spreadsheet (গুগল শিট তৈরি করুন)
Open Google Sheets (sheets.new) in your browser and create a new blank spreadsheet (e.g. name it Meta Accounts Database).
2
Open Apps Script Editor (অ্যাপস স্ক্রিপ্ট ওপেন করুন)
In your spreadsheet top menu, click: Extensions (এক্সটেনশন) ➔ Apps Script (অ্যাপস স্ক্রিপ্ট).
3
Paste the Meta Creator Code (কোড পেস্ট করুন)
Delete any existing code in the editor (Code.gs) and paste the exact script below:
function doGet(e) {
return ContentService.createTextOutput("Meta Creator Sheet API is Active! ✅");
}
function doPost(e) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var data = JSON.parse(e.postData.contents);
var tabName = data.tab || "Sheet1";
var sheet = ss.getSheetByName(tabName);
// 1. Create sheet with 4 clean columns if not exists: [Email, Password, Status, Timestamp]
if (!sheet) {
sheet = ss.insertSheet(tabName);
var header = ["Email", "Password", "Status", "Timestamp"];
sheet.appendRow(header);
sheet.getRange(1, 1, 1, 4).setBackground("#1A73E8").setFontColor("#FFFFFF").setFontWeight("bold").setHorizontalAlignment("center");
}
// 2. Append Verified Account
if (data.action === "append") {
var statusVal = data.status || "";
if (data.username && statusVal.indexOf("(") === -1) {
statusVal = statusVal + "(" + data.username + ")";
}
sheet.appendRow([data.email, data.password, statusVal, data.timestamp]);
var lastRow = sheet.getLastRow();
var isVerified = String(statusVal).toUpperCase().indexOf("VERIFIED") !== -1 || String(statusVal).toUpperCase() === "SUCCESS";
var rowRange = sheet.getRange(lastRow, 1, 1, 4);
var statusCell = sheet.getRange(lastRow, 3);
if (isVerified) {
rowRange.setBackground("#F0FDF4");
statusCell.setBackground("#D1E7DD").setFontColor("#0F5132").setFontWeight("bold");
} else {
rowRange.setBackground("#FEF2F2");
statusCell.setBackground("#F8D7DA").setFontColor("#842029").setFontWeight("bold");
}
return ContentService.createTextOutput(JSON.stringify({status: "SUCCESS", sheet_url: ss.getUrl()})).setMimeType(ContentService.MimeType.JSON);
}
// 3. Test ping
if (data.action === "test") {
return ContentService.createTextOutput(JSON.stringify({status: "SUCCESS", title: ss.getName(), sheet_url: ss.getUrl()})).setMimeType(ContentService.MimeType.JSON);
}
return ContentService.createTextOutput("SUCCESS");
}
4
Deploy as Web App (ডিপ্লয় করুন - খুবই গুরুত্বপূর্ণ!)
- Click top-right blue button: Deploy (ডিপ্লয়) ➔ New deployment (নতুন ডিপ্লয়মেন্ট).
- Click the Gear icon ⚙️ on the left ➔ Select Web app.
- Description:
Meta Creator Auto-Sync
- Execute as: Select
Me ([email protected])
- Who has access: Select Anyone (খুবই গুরুত্বপূর্ণ: Anyone সিলেক্ট করতে হবে যাতে VPS ডাটা পাঠাতে পারে).
- Click Deploy, and click Authorize access if Google prompts for permission.
5
Copy Web App URL & Test in Web Panel (ইউআরএল কপি ও টেস্ট করুন)
Copy the Web app URL (starts with https://script.google.com/macros/s/.../exec) and paste it into the Google Apps Script Webhook URL box in your Web Panel, then click "🔍 Test Connection with Sheet".
💡
Automated Formatting: The script will automatically format the columns [Email, Password, Status, Timestamp] with blue headers, green rows for verified accounts, and red rows for issues. No manual table setup is required!