🚀 AutoSetu

AutoSetu is a backend automation API that connects Google Sheets → MongoDB → WhatsApp Notifications.

Whenever a new row is added in a Google Sheet, AutoSetu automatically:

✅ Row is entered in google sheet, data shared via API
✅ Stores the entry securely in MongoDB
✅ Sends an instant WhatsApp message to the Sheet owner with the submitted details

---

✨ Features

• 📌 Google Sheets row trigger integration
• ⚡ REST API to receive new sheet entries
• 🗄️ Automatically saves records into MongoDB
• 📲 WhatsApp notifications sent instantly to the sheet owner
• 🔒 Secure backend architecture (keys & configs protected)
• 🧩 Scalable design for future integrations

---

🛠 Tech Stack

• Backend: Node.js / Express
• Database: MongoDB
• Messaging: Facebook App
• Integration: Google Sheets Webhook / Apps Script Trigger

---

📌 How It Works

1. Owner creates a Google Sheet
2. A Google Apps Script trigger runs when a new row is added
3. Script sends row data to AutoSetu API endpoint
4. AutoSetu backend:
   • Validates the payload
   • Saves it in MongoDB
   • Sends WhatsApp notification to owner

---

⚙️ API Workflow

📌 Endpoint: Add Sheet Entry

POST /api/sheet-entry

---

🧾 Request Body Example

{
  "sheetId": "xyz123",
  "ownerPhone": "+91XXXXXXXXXX",
  "entry": {
    "name": "Rahul Sharma",
    "sex": "Male",
    "age": 28,
    "location": "India"
  }
}

✅ Response Example

{
  "success": true,
  "message": "Entry saved and WhatsApp notification sent."
}

📲 WhatsApp Notification Example

✅ New Entry Added in Your Sheet

Name: Rahul Sharma  
Sex: Male
Age: 28 
Location: India