The Scenario
A new sales ops manager joined last week and inherited a CRM deduplication project on their first day. They need to export all Quaderno contacts whose company name contains GmbH — the German entities — and cross-reference them against the CRM records to find duplicates before a data merge next month. The Quaderno contact list has several hundred entries. They need the filtered slice in a Google Sheet by tomorrow afternoon.
They've spent the first hour looking for an export button that filters by company name substring. There isn't one that does exactly that. The full export dumps everything.
The bad version:
- Export the full Quaderno contact list as CSV
- Open the CSV in the sheet, scan the company name column for GmbH entries using a filter, manually delete all the non-matching rows
- Realize the export only included the first 100 contacts because of a pagination limit you didn't notice — you have to export page 2 and page 3 separately, combine them, and re-apply the filter
- End up with the right rows three exports later, each with slightly different column formatting
It's your first week. This is not the best use of it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that can query your Quaderno contacts with a filter and land the results directly in the sheet.
List all Quaderno contacts whose name contains GmbH and write contact ID, name, email, country, and tax ID into columns A through E of this sheet
What You Get
- Only contacts whose company name contains GmbH are returned — no manual filtering needed after the fact
- The results land in the sheet with the columns in the order you specified
- The fetch paginates through the full Quaderno contact base automatically — no 100-row export limit
- You get a clean slice ready for CRM cross-referencing
What If the Data Is Not Quite Ready
I need to capture a broader set — GmbH, AG, and KG entities all count as German corporate structures
List all Quaderno contacts whose name contains GmbH, AG, or KG and write contact ID, name, email, country, and tax ID into columns A through E of this sheet
I also need to filter by country code — German country code is DE
List all Quaderno contacts with country code DE and write contact ID, name, email, and tax ID into columns A through D
I need to cross-reference the results against the CRM tab immediately after fetching
List all Quaderno contacts whose name contains GmbH and write contact ID, name, email, country, and tax ID into columns A through E; then for each row, check if the email in column C appears in column B of the CRM tab — write Matched or Not Found to column F
Pull the filtered contacts, cross-reference the CRM, flag duplicates, and compute coverage in one pass
List all Quaderno contacts whose name contains GmbH and write contact ID, name, email, country, and tax ID into columns A through E; for each row, check if the email in column C exists in column B of the CRM tab and write Matched or Not Found to column F; then count how many rows are Matched and write that count to cell H1 with a label in G1
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where you're staging the CRM deduplication work, then ask it to pull the filtered Quaderno contact slice you need. Also see: bulk creating contacts from a sheet, and the hub overview of all Quaderno connection methods.