Connectors

/

Attio

/

Reconcile Attio companies with Teamwork.com clients
Report
Cross-Connector

Reconcile Attio companies with Teamwork.com clients

For operations teams who want to find missing or duplicate clients between Attio and Teamwork.com by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Attio companies with Teamwork.com clients
Compare our Attio companies with our Teamwork.com clients and show me which ones are in only one of them.
Of 25 companies from each system, 18 are in both, 4 are only in Attio and 3 only in Teamwork.com. - In both: 18, including Northwind Traders matched by domain - Probable match: Contoso Ltd and Contoso, matched on name only - Only in Attio: Fabrikam, Adatum, Litware, Tailspin Toys - Only in Teamwork.com: Wingtip Toys, Proseware, Lucerne Publishing Results are capped at 25 per system and may be incomplete. Want to narrow it to one company?
Attio
Sample figures. Your results come from your own account.
attio-get-record-companies
teamwork-com-get-companies

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Attio

Attio
Run it on your own Attio data.

Connect Attio, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Company and client lists drift apart

Someone compares the Attio company list with Teamwork.com clients by hand, and spelling differences such as Inc or Ltd hide missing or duplicate clients. The two lists drift apart and nobody knows which side is right.

Without PopdockAI

  • Export companies from Attio and Teamwork.com
  • Line them up by name in a spreadsheet
  • Guess when Inc or Ltd makes names differ
  • Miss clients that exist in only one system

With PopdockAI

  • Companies are read from both systems, up to 25 each
  • Matches are made on domain first, then name
  • Name only matches are marked probable
  • Several candidates are listed, never picked

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Reconcile Attio companies with Teamwork client companies for `{company-name}` (optional; when empty, compare up to 25 companies from each system) and report which are in both, only in Attio, or only in Teamwork.

**Step 1: Read Attio companies**

Call `attio-get-record-companies` (attio server) with `name.contains` set to `{company-name}` when given, and `max-records` 25. Keep `record-id`, `name` and `domains` for each.

**Step 2: Read Teamwork companies**

Call `teamwork-get-companies` (teamwork server) with `name.contains` set to `{company-name}` when given, and `max-records` 25. Keep `company-id`, `name` and `website`.

**Step 3: Match**

Match on the company domain first (Attio `domains` against the host part of Teamwork `website`), then on the name ignoring case, punctuation and suffixes such as Inc, Ltd, LLC. Mark a name-only match as "probable".

**Step 4: Report**

Three tables: in both (Attio name, Attio record-id, Teamwork name, Teamwork company-id, match basis), only in Attio, only in Teamwork. End with counts.

**Rules & Guidelines:**

* Attio tools (`attio-*`) come from the attio server; Teamwork tools (`teamwork-*`) come from the teamwork server. Both servers must be connected; if a tool is missing, say which server is not connected and stop.
* This prompt is read-only. Never call `attio-add-company`, `attio-update-company`, `attio-upsert-company`, `attio-delete-company`, `attio-add-person`, `attio-update-person`, `attio-upsert-person`, `attio-delete-person`, `attio-add-deal`, `attio-update-deal`, `attio-delete-deal`, or any `teamwork-create-*`, `teamwork-update-*`, `teamwork-complete-*`, `teamwork-assign-*` or other Teamwork tool that changes data.

**Validation:**

* If one system returns nothing, report that and list the other side as unmatched without guessing.
* If one record could match several on the other side, list the candidates and do not pick one.
* Say plainly that a result capped at 25 may be incomplete.

Who it's for

One answer, three teams that use it

Operations managers

Keep client lists in step

Tables for both, Attio only and Teamwork.com only show where the lists have drifted.

Which Attio companies are missing as clients in Teamwork.com?

Project managers

Check a new client is set up

Confirm a customer exists in both systems before you start a project for them.

Is Fabrikam set up in both Attio and Teamwork.com?

CRM admins

Find duplicates hidden by spelling

Domain first matching catches the same company spelled differently, and probable matches are left for you to confirm.

Reconcile Attio companies with Teamwork.com clients and list probable name only matches.

How it works

What PopdockAI does when you ask

You name a company or compare a batch, and your AI assistant reconciles Attio with Teamwork.com. It says when a capped result may be incomplete and changes nothing.

01

Ask

You name a company, or leave it blank to compare up to 25 from each system.

Your AI tool

02

Read

It reads the companies from Attio and from Teamwork.com.

attio-get-record-companies
teamwork-com-get-companies

03

Match

It matches on domain first, then on name, and marks name only matches as probable.

No items found.

04

Report

You get tables for in both, only in Attio and only in Teamwork.com, with counts.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Attio and one secure connection to your AI tool. No code, no exports.

get-data

attio-get-record-companies

Returns companies from Attio CRM. Read-only; filter by the fields the tool offers.
get-data

teamwork-com-get-companies

Returns client and owner companies from Teamwork.com with contact details and project counts. Filter by country code, industry, company ID, status, city, name and state.
Read only.Nothing in Attio Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

How Popdock AI secures your data

The outcome

See which companies are in one system only

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

Try PopdockAI Free
See Documentation