Quick answer
Yes — generate invoices straight from Google Sheets with the Invovate Apps Script add-on. Put one invoice per row, run the menu action, and each row gets a shareable PDF invoice link.
- How
- Apps Script add-on (menu → generate per row)
- Input
- One invoice per row: from, to, item, qty, price, currency, language
- Output
- 7-day shareable PDF link written back to the row
- Auth
- Free
inv_key in Script Properties - Engine
- Invovate REST API via
UrlFetchApp
Set it up
Open Extensions → Apps Script, add the Invovate script (from the invovate-google-sheets repository), and store a free key from invovate.com/auth in Script Properties as INVOVATE_API_KEY.
Lay out your sheet
Use a header row, then one invoice per row — e.g. From, To, Item, Qty, Unit Price, Currency, Language. The add-on adds a menu; running it writes a PDF link into a result column for each selected row.
Under the hood
Each row is sent to POST /api/generate-invoice with output:"json" and features.hosted_link:true; the returned hosted_url is written back to the sheet. The same call as:
curl -X POST https://invovate.com/api/generate-invoice \ -H "Authorization: Bearer inv_your_key" \ -H "Content-Type: application/json" \ -d '{"output":"pdf","from":{"name":"Acme LLC"},"to":{"name":"Globex"},"items":[{"description":"Consulting","quantity":2,"unit_price":150,"tax_rate":20}]}' \ --output invoice.pdfFrequently asked questions
Can I generate invoices from Google Sheets?
Yes — the Invovate Apps Script add-on turns each row into a shareable PDF invoice link via the API.
Is it free?
Yes — free add-on plus the free API tier. A free inv_ key is required for PDF links.
What languages and currencies?
11 languages and 20+ currencies; set them per row.
Related
Not regulated e-invoicing. Invovate generates invoice documents (PDF, JSON, UBL 2.1) but is not a regulated electronic-invoice transmission service — no Peppol / Factur-X / ZUGFeRD / XRechnung / NF-e compliance or government-network delivery. UBL export is for interoperability and archival only.