-
AutoSheets Step-by-step
Inspiration
The inspiration for AutoSheets came from observing the struggles students face in managing their finances. Traditional expense tracking apps are often too complex and time-consuming, leading to inconsistent use. We wanted to create a solution that simplifies this process, making it easier for students to stay on top of their finances without the hassle of learning new apps or manually inputting data.
What it does
Send your receipt picture to discord. Your expenses will updated automatically in google sheet
How we built it
AutoSheets was built using:
Discord API: For receipt upload and interaction with the bot. Google Sheets API: For automatic structuring and categorizing of expenses. Python: For backend development and handling bot logic. OpenAI: To strcuturize from receipt to an input format for gsheet OAuth 2.0: For secure authentication and authorization with Google services. The process involved setting up a Discord bot that listens for receipt uploads in a chat, processes the receipt data, and updates a Google Sheet in real-time. We ensured that the system is robust and user-friendly, providing a seamless experience for students.
Challenges we ran into
One of the major challenges was ensuring accurate receipt data extraction and categorization. We had to implement and fine-tune algorithms to handle various receipt formats and ensure the data is correctly categorized. Another challenge was integrating the Discord bot with Google Sheets in a secure and efficient manner, which required careful handling of API credentials and data synchronization.
Accomplishments that we're proud of
We aim to further enhance AutoSheets by incorporating advanced OCR (Optical Character Recognition) technology for better accuracy in receipt data extraction. Additionally, we plan to add more features based on user feedback, such as expense summaries and budgeting tools.
What we learned
Through this project, we learned the importance of user-centered design and simplicity. By conducting interviews with students from the University of Melbourne and Monash University, we gained valuable insights into their pain points and preferences. This helped us focus on creating a solution that prioritizes ease of use and convenience.
What's next for AutoSheets
Additionally, we plan to add more features based on user feedback, such as expense summaries, budgeting tools, and multi-currency support. We also intend to expand our marketing efforts to reach more students and educational institutions.
Log in or sign up for Devpost to join the conversation.