The Scenario
Someone from a previous project left the company six months ago and maintained the Lexoffice contact database. The 200 contact IDs are all in a master tracking sheet — but half the rows are missing email addresses, and a third are missing country codes. The ops team has been routing around it by looking contacts up manually whenever they need to send something. It works until it doesn't, and this week it stopped working: a bulk mailing bounced because half the emails were blank.
The bad version:
- Open Lexoffice, navigate to Contacts, search each contact ID one at a time, open the record, copy the email address, switch back to the sheet, paste it in — repeat for 200 rows
- Get through 60 rows before an afternoon meeting derails the effort, resume the next morning, and realize you're not sure which rows you already checked because you forgot to mark them
- Finish after two days and discover that 12 of the contact IDs in the sheet don't exist in Lexoffice anymore — those contacts were deleted or merged — and you're not sure which data to trust
Two days of lookup work for 200 contacts. And next month, there will probably be 50 more.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the contact IDs, fetches the full Lexoffice record for each one, and writes the missing fields back into the sheet — no tab-switching, no manual lookup.
Open the contact master sheet and type:
For each contact ID in column A fetch the full contact record from Lexoffice and write the email, country, and customer/vendor roles into columns B, C, and D
What You Get
- Email address, country code, and customer/vendor role populated from Lexoffice for every contact ID in column A
- Blank cells filled in where the data was missing
- A "not found" note in column B for any contact ID that no longer exists in Lexoffice — so you know which rows to investigate or remove
What If the Data Is Not Quite Ready
You only want to enrich rows where the email column is currently blank
For each row where column B is blank, look up the contact ID in column A in Lexoffice and write the email address into column B, the country code into column C, and the customer/vendor role into column D
You also need the company address, not just the country
Look up every Lexoffice contact ID in column A and fill in the company name, email, street address, city, and country into columns B through F from the Lexoffice records
Some IDs in the sheet are stale — you want to flag which ones are no longer in Lexoffice
For each contact ID in column A, attempt to fetch the Lexoffice record — write the email and country into columns B and C if found, and write "not found" into column D for any ID that doesn't resolve
Full enrichment and cleanup pass in one shot
For each contact ID in column A: fetch the Lexoffice contact record, write email into B, country code into C, and customer/vendor role into D — for any ID that doesn't resolve, write "not found" in column E and highlight the row so it's easy to spot, then sort the sheet with "not found" rows at the bottom
One prompt enriches the full dataset and surfaces the bad records.
Try It
Get the 7-day free trial of SheetXAI and open your contact master sheet — ask it to fill in the missing Lexoffice data and you'll have a complete record in minutes instead of days. You can also look at how to export the full voucher list for reporting, or return to the full Lexoffice integration overview.