Google Sheets Setup
🚀
Active Projects
4
2 in review
📊
Avg. Completion
38%
across all projects
💬
Open Feedback
3
needs attention
Delivered
12
this quarter
Recent Projects
Zara India
Website Redesign
In Progress
Progress47%
👤 Rohan M.
📅 May 30, 2025
💬 1 open feedback
Current phase
Frontend Development
Bombay Bicycle Club
E-Commerce Store
In Review
Progress61%
👤 Sana K.
📅 Jun 15, 2025
💬 1 open feedback
Current phase
Backend / CMS Integration
Mumbai Mavericks
Brand Landing Page
In Progress
Progress28%
👤 Dev T.
📅 Apr 25, 2025
Current phase
UI Design (Mockups)
Lenskart
Campaign Microsite
On Hold
Progress16%
👤 Priya S.
📅 TBD
💬 1 open feedback
Current phase
Wireframing / UX Design
All Projects
4 projects
Zara India
Website Redesign
In Progress
Progress47%
👤 Rohan M.
📅 May 30, 2025
💬 1 open feedback
Current phase
Frontend Development
Bombay Bicycle Club
E-Commerce Store
In Review
Progress61%
👤 Sana K.
📅 Jun 15, 2025
💬 1 open feedback
Current phase
Backend / CMS Integration
Mumbai Mavericks
Brand Landing Page
In Progress
Progress28%
👤 Dev T.
📅 Apr 25, 2025
Current phase
UI Design (Mockups)
Lenskart
Campaign Microsite
On Hold
Progress16%
👤 Priya S.
📅 TBD
💬 1 open feedback
Current phase
Wireframing / UX Design
Mumbai Mavericks
Brand Landing Page
In Progress Lead: Dev T. · Due: Apr 25, 2025
Overall Completion 28%
Phases
Feedback
Files & Links
Discovery & Requirements
Completed
100%
Wireframing / UX Design
Completed
100%
3
UI Design (Mockups)
In progress
80%
4
Client Design Approval
In progress
50%
5
Frontend Development
Not started
0%
6
Backend / CMS Integration
Not started
0%
7
Content Upload
Not started
0%
8
QA & Testing
Not started
0%
9
Client Review & Feedback
Not started
0%
10
Revisions
Not started
0%
11
Final Approval
Not started
0%
12
Launch / Go Live
Not started
0%
Preview which project:
E-Commerce Store
Bombay Bicycle Club
61% Complete
61%
Project Completion
Discovery & Requirements
Done
Wireframing / UX Design
Done
UI Design (Mockups)
Done
Client Design Approval
Done
Frontend Development
Done
Backend / CMS Integration
90%
Content Upload
70%
QA & Testing
40%
Client Review & Feedback
30%
Revisions
Upcoming
Final Approval
Upcoming
Launch / Go Live
Upcoming
Connect this app to Google Sheets as your free database. No server costs — data lives in a spreadsheet your team already knows.
✓ Google Sheet connected successfully. App is now pulling live data.
1
Create your Google Sheet
Create a new Google Sheet and add 4 tabs: Projects, Phases, Feedback, Files.
Projects tab columns: ID | ClientName | ProjectName | Status | Lead | DueDate Phases tab columns: ProjectID | PhaseName | Completion | Status | Notes Feedback tab columns: ProjectID | Author | Text | Phase | Date | Resolved Files tab columns: ProjectID | FileName | URL | Type | Date
2
Open Apps Script
In your Sheet: go to Extensions → Apps Script. Delete the default code and paste this:
function doGet(e) { const ss = SpreadsheetApp.getActiveSpreadsheet(); const tab = e.parameter.tab || 'Projects'; const sheet = ss.getSheetByName(tab); const data = sheet.getDataRange().getValues(); const headers = data[0]; const rows = data.slice(1).map(row => { let obj = {}; headers.forEach((h, i) => obj[h] = row[i]); return obj; }); return ContentService .createTextOutput(JSON.stringify(rows)) .setMimeType(ContentService.MimeType.JSON); } function doPost(e) { const payload = JSON.parse(e.postData.contents); const ss = SpreadsheetApp.getActiveSpreadsheet(); const sheet = ss.getSheetByName(payload.tab); sheet.appendRow(payload.row); return ContentService.createTextOutput('OK'); }
3
Deploy as Web App
Click Deploy → New Deployment → Web App.
Set Execute as: Me and Who has access: Anyone.
Click Deploy and copy the Web App URL.
4
Paste your Web App URL below
Once connected, the app will fetch and save data directly to your Google Sheet.
✓ Connected
5
Upload to Hostinger
Save this HTML file, then in Hostinger → File Manager → public_html, upload the file. Rename it to index.html or portal.html. Done — your app is live!
Google Sheet connected!