Create Your Free Google Sheets Invoice Template for Customer Service

Free google sheets invoice template for Customer Service

hello everyone in this awesome tutorial I will give you a demo of the invoicing web app built on top of Google Sheets using appscript this will allow you to generate invoices for your clients save them in Google Drive and send them via Gmail I will also discuss how to set this up for you before we move forward let me request that you please consider subscribing to this channel when you open this web app you will see three tabs clients invoices and preferences clients to manage all your clients or customers invoices to manage invoices and take further actions preferences to customize your invoice template let's start with the clients page you first need to add new clients you can view edit or delete the selected clients using these action buttons once a client is added click on the raise invoice button this will open the invoice creation form down below you will be able to see the live preview of the invoice you will be generating the invoice number and date will be autop populated if you wish you can edit them as well you can easily add edit or remove invoice items let me add a few invoice items here in the preview you can see it displays the subtotal tax and total you can input your tax type and tax rate in the preference form by going to the preferences tab then save the invoice this action will generate the invoice PDF save it in your Google Drive and create a new invoice record in the linked Google sheet it will store the generated invoice inside a folder named client invoices the folder will be automatically created inside the parent folder containing the Google spreadsheet this is the invoice record that we just generated you can view the generated invoice by clicking this PDF icon furthermore you can also View and edit the selected invoice to send the invoice to your client click this send button this action will send the invoice PDF via Gmail and then update the mail sent status to yes let's view the sent invoice in my Gmail sent folder and here you can see the sent invoice you can also edit the email body I will show you this later you can also change the payment status of the selected invoice you can filter the invoice record by client date and payment status now coming to the preferences tab here you can edit details like company name company logo currency local tax type and tax rate for the company logo you can use this site to upload your logo and copy the URL down below you can add terms and conditions contact details invoice footer text and all that then hit save preferences let me show you again how these are mapped in the actual invoice page now how do you set this up for yourself first you need to make a copy of the spreadsheet from the link given in the description below then open the script editor by going to extensions and then app script here you can edit the test email ID which will be used during testing comment out this line when you are done with the testing the actual client email ID will then be used for the recipient address you can also edit the folder name where you want to store your invoices down below you can edit the email body notice it uses the client name marker to dynamically replace the client name so don't change this marker the subject line is also Dynamic containing the invoice number and the invoice date you may change the subject line but don't edit the variables invoice number and invoice date after you have made all the changes hit the save button now we need to deploy this to get the web app URL for that click on the deploy button and then choose new deployment then SEL cect web app as the deployment type in the description you can type anything in the execute s section choose me in the access section choose only myself and then hit deploy this will ask you to authorize the code go ahead and Grant all the permissions required by the app when the deployment completes you will be presented with the URL open it to check if everything is working fine first go to the preferences Tab and edit your invoice preferences then you can continue by adding new clients and raising invoices now suppose you edited the script again in that case you will need to deploy the script again first save the script then go to deployment and choose manage deployment click on the pencil icon and choose a new version then hit the deploy button this way your web app access URL will not change for further customization you can reach out to me if you like my work please consider supporting me by buying this free tool you will find the links in the description box thanks for watching and see you in the next one