Connectors

/

BigCommerce

/

Find BigCommerce customers missing from Nutshell
Report
Cross-Connector

Find new BigCommerce customers missing from Nutshell

For sales teams who want new store customers in Nutshell, by asking their AI assistant to compare the two.

Try PopdockAI free
Get a live demo
Find BigCommerce customers missing from Nutshell
Which BigCommerce customers from the last 14 days are not contacts in Nutshell? Check up to 20.
5 of the 20 customers checked have no Nutshell contact. - Missing: Dana Whitfield, dana@northwindtraders.com, Northwind Traders, created 3 Oct - Missing: Sam Patel, sam@contoso.com, Contoso, created 6 Oct - Matched: 14 - Possible duplicates: 1, same email under a different spelling of the name Want the full list of all 5 missing customers?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-customer
nutshell-get-contact

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

BigCommerce

BigCommerce
Run it on your own BigCommerce data.

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

Try PopdockAI free

The problem

Different spellings hide real gaps in Nutshell

Someone exports new BigCommerce customers and searches Nutshell for each one by hand. Names are spelled differently in each system, so real gaps are missed and real matches look like gaps.

Without PopdockAI

  • Export new customers from BigCommerce
  • Search Nutshell for each name
  • Try other spellings when nothing comes back
  • Guess whether a match is the same person

With PopdockAI

  • Recent customers are read, up to your limit
  • Nutshell is searched by name and each match confirmed by email
  • The last name is tried before a customer is called missing
  • Weak matches are listed apart, and nothing is changed

The prompt

Use this prompt

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

Prompt
**Objective:** List BigCommerce customers created in the last `{lookback-days}` days (default 30) that have no matching contact in Nutshell, up to `{max-customers}` customers (default 25).

**Step 1: List recent customers**

Call `bigcommerce-get-customer` with `date-created.from` set to today minus `{lookback-days}` days and `max-records` set to `{max-customers}`. Keep `id`, `name`, `email`, `company` and `date-created`.

**Step 2: Check each one in the CRM**

For each customer, call `nutshell-get-contact` with `name` set to the customer `name`. A customer matches when a returned contact has `emails` containing the customer `email`. If the name search returns nothing, try `name.contains` with the last name before declaring a miss.

**Step 3: Report**

Report a table of the customers with no CRM contact: name, email, company and created date. Then give counts: customers checked, matched, missing. For matched customers with a different name spelling, list them separately as possible duplicates.

**Rules & Guidelines:**

* `bigcommerce-*` tools are on the bigcommerce server and `nutshell-*` tools are on the nutshell server. Both servers must be connected.
* This is read-only. Never call any add, update or delete tool on either server (for example `bigcommerce-customer-update`, `nutshell-add-person`, `nutshell-update-lead`, `nutshell-delete-company`).
* Keep to the requested number of customers; do not page through the whole customer list.

**Validation:**

* If BigCommerce returns no customers, say so and stop.
* A customer with an empty email can only be matched by name; mark it as a weak match.

Who it's for

One answer, three teams that use it

Sales reps

Follow up on new store customers

Customers with no Nutshell contact are people your team has not reached.

Which BigCommerce customers from the last 7 days are not in Nutshell?

Sales managers

Check new buyers reach the pipeline

Counts of matched and missing show whether store customers are making it into the CRM.

Of the last 40 BigCommerce customers, how many are missing from Nutshell?

CRM administrators

Clean up misspelled contacts

Weak matches with a different spelling point to contacts that need tidying or merging.

Show BigCommerce customers from last month that only weakly match a Nutshell contact.

How it works

What PopdockAI does when you ask

You say how far back to look and how many to check, and your AI assistant checks new BigCommerce customers against Nutshell. Weak matches are kept apart from real gaps.

01

Ask

You say how many days back to look and how many customers to check.

Your AI tool

02

List

It reads recent BigCommerce customers up to that number.

bigcommerce-get-customer

03

Match

It searches Nutshell by name, confirms by email and retries with the last name before declaring a miss.

nutshell-get-contact

04

Report

It lists customers with no contact, counts matched and missing, and sets weak matches apart.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

bigcommerce-get-customer

Returns customers from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
get-data

nutshell-get-contact

Returns Nutshell people (contacts) with their emails, phones and linked companies. Filter by name, email, owner and other fields.
Read only.Nothing in BigCommerce 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

Real gaps in Nutshell, with weak matches set apart

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