Website Design and Development

@ 6225’

Custom Billing Application with Google Drive

A growing lawn care business was looking for a way to streamline their billing process and was in need of a custom billing solution that created monthly invoices that get emailed to their various clients. By utilizing the API available in Google Drive, the lawn business recorded their work through Google’s Spreadsheets. Then at end of the month, the custom billing application would run a loop through the Spreadsheet, and create an PDF invoice of the recorded services, and send in an email through Gmail with the attached invoice.

Screenshot of some of the code to assign spreadsheet cells to variables

When the custom application was completed, it greatly reduce the amount of time it took to send out the monthly billing. With just a click of a button, the custom application runs runs through the spreadsheet, creates and saves invoices, and emails clients with a formal message and attachment.

Example of invoice sent in email