Admin automation useing google sheets and gmail
Budget: £250 – £750 GBP
I am looking for someone to help me automate an administrative process using both Google Sheets and Gmail. This is the current process:
1. We receive an email with details of the order
2. We calculate a price based on the details
3. We e-mail a 3rd party with the order details and prices
4. The 3rd parts emails us with a purchase order
5. We enter all of the details on a google sheets form that our customer can access (view only)
6. We email our supplier with details of the order for manufacture
7. We raise an invoice to our customer in Xero
8. We update the spreadsheet with our Xero invoice number
I'm open to suggestions if there are ways to optimize the above in a better way. Ideally I would like the process to be fully automated with no input required from ourselves. Thank you for your time and consideration.
1. We receive an email with details of the order
2. We calculate a price based on the details
3. We e-mail a 3rd party with the order details and prices
4. The 3rd parts emails us with a purchase order
5. We enter all of the details on a google sheets form that our customer can access (view only)
6. We email our supplier with details of the order for manufacture
7. We raise an invoice to our customer in Xero
8. We update the spreadsheet with our Xero invoice number
I'm open to suggestions if there are ways to optimize the above in a better way. Ideally I would like the process to be fully automated with no input required from ourselves. Thank you for your time and consideration.