Google Sheets Form Filler with Chrome Extension

Problem and Solution

Jonathan came to me with a problem. He was spending 20 to 40 minutes manually filling in forms, copying and pasting data from a Google Sheet, and he wanted a solution that would drastically reduce the time and errors involved. I proposed a Chrome extension with a secure database that regularly imported data from Google Sheets, allowing him to select records and auto-fill forms, all behind an authenticated login.


Project Overview and Tech Stack

This project involved building a secure database and an importer that regularly pulled data from Google Sheets, with the option to manually import or upload a CSV. The database was hosted behind an authenticated login using Django Python and SQLite. A Chrome extension allowed users to search and select records, automatically filling forms on the web page. Technologies used included Django, SQLite, Docker containers, and JavaScript for the Chrome extension.


Value for Money

Jonathan saw immediate cost savings, as the time spent filling in forms was reduced from 20-40 minutes to less than 5 minutes. This led to significant improvements in efficiency and accuracy.


Experience

With extensive experience in Django, Python, databases, Google Sheets, CSV handling, and Chrome extensions, I was well-equipped to handle this project. My expertise allowed me to deliver the solution within a short timeframe and at an affordable cost, making the project a perfect fit for my skillset.


Client Satisfaction

Jonathan was very happy with the solution. It was delivered ahead of schedule, within his budget, and worked perfectly from the outset. He appreciated the quality and speed of the work, and we continued to collaborate for additional enhancements.


Impact on Business

The impact on Jonathan's business was tremendous. He experienced substantial cost savings and a drastic reduction in errors. What previously took 20-40 minutes was now completed in a matter of minutes, thanks to the automation provided by the Chrome extension.


Final Results

The solution was delivered on time and within budget. After the initial launch, Jonathan requested a few additional features, such as CSV importing, which were implemented quickly and affordably. He was extremely satisfied with the final product.


Review and Rating

Besides having a fantastic name (I'm also Jonathan 😜), Jonathan brought a level of professionalism and transparency that I've yet to experience in working with contractors via the Upwork platform. He was responsive to my feedback, swift to address technical issues, and expedient when it came meeting our project’s deadline. He is a fantastic strategic partner and extremely capable of adding incredible value to your next development project. I would 10/10 hire him again, and I look forward to our next project together!