Client Data Entry App with Google Sheets & Excel Integration | Python + PyQt5 Portfolio Project
In this video, I walk through a custom Python desktop app I built using PyQt5 and Qt Designer — designed to simplify client data entry and automate cloud + local record-keeping.
🧩 App Features:
Dual-tab interface: Settings + Data Entry
Syncs data to Google Sheets using a user-specified Sheet ID
Settings saved locally via JSON file
Optional Excel file export (auto-updates on each entry)
Add timestamps to each submission
Show a success message when data is submitted
Track client type: Prospect, Lead, Client, Partner
Checkbox to log contact status (Contacted: Yes/No)
⚙️ Tech Stack:
Python
PyQt5 / Qt Designer
Google Sheets API
Pandas / OpenPyXL (for Excel automation)
JSON for settings storage
🎯 Perfect for:
Freelancers
Client-based businesses
Sales teams
Data automation enthusiasts
📱 Follow me for more automation content:
Instagram: @excel_vba_automation
TikTok: @excel.jacob
📩 Want help building automation tools for your business? Let’s connect.
#python #pyqt5 #googlesheets #excelautomation #automationtools #freelancedeveloper #clientmanagement #portfolio #pythonproject #desktopapp