The Scenario
End of quarter. The ops manager has a Google Sheet with 35 new service SKUs the agency is adding to its catalog — name in column A, price in B, tax rate in C, unit in D. The deadline for getting them into sevdesk is Friday so billing can start using them next week. The ops manager doesn't have access to the person who normally handles the data entry, who is out of office.
The bad version:
- Open sevdesk, navigate to Products, click New Part, type in the name, set the price, select the tax rate from a dropdown, enter the unit, save. Click New Part again for row 2.
- The tax rate dropdown requires a specific sevdesk format — 19 doesn't work, it has to be a rate object. You don't realize this until row 7, and now you have to go back and fix the first six.
- By row 20 you're making errors from fatigue. You create a duplicate when you accidentally submit the same row twice.
The new SKUs need to exist in sevdesk before billing can start. Manually creating 35 parts is an hour of work that doesn't produce anything except the records themselves — no analysis, no insight, just data entry.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside Google Sheets that reads your product catalog and creates each sevdesk part through the integration. You ask once and it handles the whole batch.
Create a sevdesk part for each row in my Service Catalog sheet using column A for name, B for price, C for tax rate, and D for unit — write the returned part ID back into column E
What You Get
- One sevdesk part created per row in the sheet.
- Part IDs written into column E as confirmation for each successful creation.
- Any row that fails (unsupported tax rate, missing required field) surfaces an error in column E instead of stopping the whole run.
- The 35 parts exist in sevdesk and are ready to add to invoices and orders.
What If the Data Is Not Quite Ready
Only some rows are new — the sheet has existing SKUs mixed in with the new additions
Read my Products sheet and create sevdesk parts only for rows where column F says 'new' — use column A for name, B for price, C for tax rate, D for unit — write the returned part ID into column G and update column F to 'created' on success
The price column has inconsistent formatting — some values have commas as decimal separators
Normalize column B of my Service Catalog sheet — replace any comma decimal separators with periods and strip currency symbols — then create a sevdesk part for each row using column A for name, cleaned column B for price, C for tax rate, D for unit, and write the part ID into column E
The catalog spans two tabs: Digital Services and Physical Products, with slightly different tax rates
Create sevdesk parts from both the Digital Services tab (column A for name, B for price, 0% tax, D for unit) and the Physical Products tab (column A for name, B for price, 19% tax, D for unit) — write returned part IDs into column E on each tab
Full catalog rollout: deduplicate, create, verify, and summarize
In my Service Catalog sheet: first flag any duplicate names in column A with DUPLICATE in column F — then for all non-duplicate rows where column F is blank, create a sevdesk part using columns A through D — write the part ID in column E and the word 'created' in column F — then write the total number of parts created into cell A1
Ask for the deduplication and the creation in one prompt so you don't end up with duplicate parts cluttering the sevdesk catalog.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where your product catalog lives, then ask it to push all new items into sevdesk as parts. Once the parts exist, you can generate bulk invoices from line-item data that reference those parts, or create orders from a sales pipeline sheet.