Google Workspace kit · Google Sheets · Moneybird

Invoice Batch Kit

Create many Moneybird invoices from one Google Sheet: check every row, make drafts first, and send only the ones you mark after a confirmation. Contacts, VAT per line, categories and status back in the sheet. One payment, no subscription.

Invoice Batch Kit cover

Why this one

Turns sheet rows into Moneybird invoices in bulk. Moneybird itself has no invoice import from a spreadsheet.
Several lines per invoice, mixed 21%, 9% and 0% VAT. A Zapier zap makes one invoice per trigger with one line.
Checks every row first and names the problem; a rerun never creates duplicates.
Drafts first; sending needs an explicit confirmation and only touches rows marked "yes".
€15 one-time, no monthly automation plan.

Check every row before anything reaches Moneybird

Concept invoices created, marked rows sent, invoice numbers written back

VAT, due days, workflow and limits in plain settings

Every concept and send logged with its total

Buy on Gumroad €15, one payment. No subscription.

Try it first: free SAMPLE on Gumroad — values-only workbook from one demo batch run: checked rows, flagged rows and draft invoices (the Apps Script is in the paid kit).

Create many Moneybird invoices from one Google Sheet. Fill in a row per invoice line, check the batch, and the kit makes draft invoices in your administration. You look at them in Moneybird first; sending is a separate step that only touches the rows you marked. Price: €15, one payment, no subscription.

What you get

One sheet row per invoice line; rows with the same Invoice key become one invoice with several lines.
A check before anything is created: missing contact, wrong price, unknown VAT rate or category, bad email address and conflicting rows are listed in the Note column.
Draft invoices with VAT per line (21%, 9%, 0% or the exact rate name), category, reference, invoice date and payment term.
Contacts found by customer ID, name or email address, and created when they do not exist yet (you can switch that off).
Workflow and layout per batch from the settings tab.
Sending only for rows with "yes" in the Send column, after a confirmation prompt. An invoice that was already sent is never sent again.
Status and invoice number back in the sheet, a log tab, and one menu item to delete the drafts you no longer want.

How it works

The script runs in your own Google account and talks to the official Moneybird API with your own Moneybird app or token. It stays below Moneybird's limit of 150 requests per 5 minutes and creates at most 40 invoices per run by default.

Privacy

Your invoice data goes from your sheet to your Moneybird administration and nowhere else.

Limits

You need a Moneybird account and permission to create an app or API token for the administration.
Prices are excluding VAT unless you set pricesInclVat to yes.
Invoices in another currency than the administration default, discounts per line and recurring invoices are not part of this kit.
Large batches run in parts: about 40 invoices per run, so 200 invoices take five runs or a few minutes of waiting.
Moneybird only allows deleting drafts. Sent invoices are changed or credited in Moneybird itself.

What we tested — and what not

Tested against a Moneybird sandbox administration.

Questions

Ask on the support page. You get a reply from a real person.