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
- Put the column names in the first row of your sheet (Client, Invoice no., Date, Amount…).
- 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.
- 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
- Values exactly as they are shown in the cells: dates, currencies and numbers keep your sheet’s format.
- File names from a pattern you choose, for example Invoice <<Invoice no.>> – <<Client>>.
- Rows that already have a link are skipped: add rows and run it again without duplicates. Up to 80 documents each time you run it; if there are more, run it again and it continues where it stopped.
- Images stay: the logo, signature or letterhead of the template appear in the Google Docs™ file and in the PDF.
- To redo one row, delete its links and run it again. At the 101st free document the add-on stops and tells you.
- Options: Docs only, PDF only or both. Create example sheet adds a sheet with invoices ready to try.
Free and Pro
- Free: up to 100 documents a month (one row = one document, whether you make the Docs file, the PDF or both), with a small line at the end of each document: “Created with Auto Documents · singletasktools.com”.
- Pro: 49 € a year (the exact price in your currency is shown at checkout, with an invoice) for one Google account: no footer line and no monthly limit. Renews each year with a reminder email first; cancel any time. You pay below and receive a code by email; paste it in Extensions › Auto Documents › Pro code. The code only works in the Google account whose email you use at checkout; to move it to another account, write to support.
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
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.
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.
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.
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.
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.
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.
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.
No. Google Sheets™ add-ons run in the web version only.
Anything else: support@singletasktools.com.