Simple tool that allow you to generate invoices from selected sheet rows.
-
Place files from "example" local folder to folder on your Google Drive and convert it to natige Google Docs and Google Sheets formats respectively.
-
Open InvoiceGenerator.gs and edit 3 setting variables: homeFolderId, invoicesFolderId, and invoiceTemplateId.
-
Open, sheet "sales", go "Tools > Script Ediitor".
-
Add InvoiceGenerator.gs and NumberInWordsRus.gs scripts (Englis werion of "number in words" function will be added later).
-
Complete. Now you can select several rows in sheet, click "Actions > Generate Invoice" and popup window will notify you that invoice is ready.