The Scenario
Your digital agency is switching to Lexoffice. The accounting migration is done, the contacts are imported — but the service catalog is still empty. Invoicing can't start until every billable service line is in the Lexoffice article catalog: consulting, design sprints, development retainers, QA, strategy workshops. You have all 60 of them in a spreadsheet that the previous tool used as its source. Someone needs to move them over.
The bad version:
- Open Lexoffice, navigate to Products and Services, click Add Article, enter the title, select SERVICE, enter the net price, pick the VAT rate — and repeat for all 60 entries
- Get through 30 of them and realize you've been entering prices inclusive of VAT instead of net, meaning half the catalog is wrong and will generate incorrect invoices
- Fix the first 30, finish the remaining 30, and discover on the first invoice that the naming convention in the sheet doesn't match what Lexoffice shows in the line item dropdown
Invoicing is blocked until this is done. Every day the catalog sits empty is a day invoices go out late.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the service catalog and creates each article in Lexoffice from the row data — correctly typed, correctly priced, no form fatigue.
Open the service catalog sheet and type:
Create a Lexoffice article for each row in this sheet using column A (title), B (type: PRODUCT or SERVICE), C (net price), D (VAT rate)
What You Get
- A Lexoffice article created for each row, with the correct type, net price, and VAT rate applied
- The Lexoffice article ID written back into the sheet for each successful creation
- Any rows that fail written with an error note — so you know which ones to investigate before invoicing starts
What If the Data Is Not Quite Ready
All services should be type SERVICE but the sheet doesn't have a type column
Create a Lexoffice article for each row in this sheet using title in column A, net price in column B, and VAT rate in column C — set the type to SERVICE for all rows
Prices in the sheet are gross (VAT-inclusive) but Lexoffice requires net prices
For each row in this sheet, calculate the net price from the gross amount in column C using the VAT rate in column D, then create a Lexoffice SERVICE article using the title in column A and the calculated net price
Only the rows marked active in the catalog column should be imported
Add all rows where Catalog in column E is "active" as Lexoffice service articles using the title in column A, net price in column B, and VAT rate in column C
Full catalog migration pass: filter, normalize, and create in one shot
In this sheet: skip rows where Catalog in column E is "inactive", convert any gross prices in column C to net prices using the VAT rate in column D, then create a Lexoffice article for each remaining row using title in column A, the normalized net price, and VAT rate — write the resulting article ID into column F
One prompt clears the migration backlog.
Try It
Get the 7-day free trial of SheetXAI and open your service catalog sheet — ask it to populate the Lexoffice article catalog and you can start invoicing today. You can also look at how to bulk-create invoices from project data, or return to the full Lexoffice integration overview.