Google-Based Automated Invoicing System Creation
Budget: $250 – $750 USD
We want to create an automated invoicing system using Google. We'd use Google forms to input data and connect it to Google sheets, contacts, calendar and drive. All of the forms should auto populate from and auto save to our Google contacts.
The Gasologist Service Request Form - We would like this form to:
- automatically create an event on our Google Calendar titled, NEW APPOINTMENT REQUEST, and colored yellow.
- automatically connect the address to the google maps in google calendar.
- Input all of the rest of the information from the sheet in the description.
Quotes - We would like this form to:
- automatically populate this spreadsheet, or similar. (We can modify this spreadsheet or scrap it to make our system function properly, whichever you prefer.)
- the spreadsheet should then...
- automatically create a PDF and email it to the customer.
- automatically save the PDF to our Quotes Google Drive Folder
Invoices - We would like this form to:
- automatically populate this same spreadsheet
- the spreadsheet should then...
- automatically create a PDF and email it to the customer.
- automatically save to the Invoices Google Drive Folder
- automatically mark the invoice paid if payment is collected or,
- automatically send reminder emails every 7 days until paid.
The Gasologist Service Request Form - We would like this form to:
- automatically create an event on our Google Calendar titled, NEW APPOINTMENT REQUEST, and colored yellow.
- automatically connect the address to the google maps in google calendar.
- Input all of the rest of the information from the sheet in the description.
Quotes - We would like this form to:
- automatically populate this spreadsheet, or similar. (We can modify this spreadsheet or scrap it to make our system function properly, whichever you prefer.)
- the spreadsheet should then...
- automatically create a PDF and email it to the customer.
- automatically save the PDF to our Quotes Google Drive Folder
Invoices - We would like this form to:
- automatically populate this same spreadsheet
- the spreadsheet should then...
- automatically create a PDF and email it to the customer.
- automatically save to the Invoices Google Drive Folder
- automatically mark the invoice paid if payment is collected or,
- automatically send reminder emails every 7 days until paid.