Invovate for Google Sheets

A Google Apps Script add-on that turns spreadsheet rows into PDF invoices via the Invovate API — in 11 languages. Each selected row becomes one invoice; the 7-day PDF link is written back into a PDF Link column.

Install (copy into your sheet — 2 min)

1. Open your Google Sheet → Extensions → Apps Script.
2. Replace the default Code.gs with the contents of Code.gs.
3. (Optional) Click the gear → Show appsscript.json and paste appsscript.json for the right scopes.
4. Save, then reload the spreadsheet. An Invovate menu appears.

Use

1. Invovate → Insert example header row (adds: From Name, To Name, Description, Quantity, Unit Price, Tax %, Currency, Language, PDF Link).
2. Fill rows with your invoice data.
3. (Optional) Invovate → Set API key… — a free key from https://invovate.com/auth. JSON totals & PDF links work without one.
4. Select the data rows → Invovate → Generate invoices for selected rows. The PDF link for each row lands in the PDF Link column.

Notes

• Languages: en, nl, de, fr, es, it, pt, ar, ja, ru, hi. Currency: ISO 4217 (USD, EUR…).
• Uses minimal scopes: current spreadsheet only + external request + menu UI.
• Not regulated e-invoicing (no Peppol/Factur-X/XRechnung/NF-e).

To publish on the Google Workspace Marketplace, attach this script to a Google Cloud project, configure the OAuth consent screen, and submit for review.

License

MIT © Invovate