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
Watch video Client Data Entry App with Google Sheets & Excel Integration | Python + PyQt5 Portfolio Project online without registration, duration hours minute second in high quality. This video was added by user Excel VBA Automation 27 March 2025, don't forget to share it with your friends and acquaintances, it has been viewed on our site 92 once and liked it 2 people.