Single Task Tools

Auto Documents: Invoices, Contracts & PDF per Row

An add-on for Google Sheets™ by Single Task Tools. One task: invoices, contracts, certificates, receipts and letters from your spreadsheet, one Google Docs™ file and one PDF per row, from a template you write once with <<Column>> tags, logo included. Menus in English, Spanish, Portuguese, French, German and Italian.

Install it from the Google Workspace Marketplace™ (search for “Auto Documents”), or from Extensions › Add-ons › Get add-ons inside Google Sheets™.

How to use it

  1. Put the column names in the first row of your sheet (Client, Invoice no., Date, Amount…).
  2. Open Extensions › Auto Documents › Create the template. A Google Docs™ file appears in your Drive with one tag per column; it works as it is, so you can try it straight away. To give it your own design, write your document around the tags: text, headings, tables, bold, lists. Keep the exact column name inside the << >>. Each tab of your spreadsheet has its own template.
  3. Generate documents (all rows, or only the rows you select). One row = one document: the add-on copies the template, replaces the tags with the values of that row, saves the Google Docs™ file and a PDF in a folder of your Drive named after the sheet, and writes the links in two new columns, Document link and PDF link.

What you get

Free and Pro

Buy Pro · 49 € a year
Secure checkout by Stripe (invoice included). Use the email of the Google account where you will paste the code; the code arrives by email within minutes. Renews yearly with a reminder first; cancel any time from the link in your receipt or by writing to support@singletasktools.com.

Questions

What does it access?
Only the spreadsheet that is open and the files it creates in your Drive: the template, the output folder, the documents and the PDFs. It cannot see your other documents or files, it sends no email and it has no server: your data stays in your Google account.
Does the PDF keep my logo and formatting?
Yes: the PDF is built from the document’s text, images, tables and formatting (headings, bold, italic, colours, lists, page breaks, header and footer), so the logo, signature or letterhead of the template appear in it. Drawings made inside Google Docs™ are not included; the Google Docs™ copy keeps everything.
Can it email the documents?
Not yet: this first version makes the files and writes their links in the sheet. Sending each document by email will come in a later version.
My invoices have several line items. Can one row hold them?
Not yet: one row makes one document. Put the line items in the template itself, or in one column (e.g. “Items”) with one item per line of the cell.
I already have a template document.
Create the template from the menu and paste the content of your document into it; the tags work anywhere in the text, headings and tables.
Can two people use it in the same spreadsheet?
The template and the folder with the documents are files in the Drive of the person who created them, and the add-on can only open the files it created in that same account; sharing the template in Drive does not change that. So in a shared spreadsheet, the documents are generated by the person who created the template. If someone else tries, the add-on says so, and it asks before creating another template: if they do create one, the documents of that sheet are made with theirs from then on, and then it is the first person who gets that notice. To let the rest of the team open the documents, share the output folder in Drive.
I made a copy of my spreadsheet. Does the copy keep the template?
No. The copy keeps the Document link and PDF link columns, which still point to the documents of the original, but not the template, the folder or the options, and the add-on tells you so. Choose Create the template in the copy and paste into it the content of your original template; set the options again if you had changed them. Rows that already have a link are skipped, as always: delete the links of the rows you want to generate again.
Does it work in the mobile app?
No. Google Sheets™ add-ons run in the web version only.

Anything else: support@singletasktools.com.