Connectors

/

Nutshell

/

Compare a Nutshell account with BigCommerce purchases
Report
Cross-Connector

Compare a Nutshell account with its BigCommerce purchases

For sales reps who want a Nutshell account's CRM history set beside its BigCommerce orders by asking their AI assistant.

Try PopdockAI free
Get a live demo
Compare a Nutshell account with BigCommerce purchases
Compare the Nutshell account Northwind Traders with what they bought on BigCommerce in the last 180 days.
Northwind Traders spent 14,200.00 across 9 orders in 180 days, and follow-up looks light. - CRM: owner Sam Patel, last contacted 62 days ago, 1 open lead worth 8,000 - Spend per person: Dana Whitfield 9,800.00, Lee Chen 4,400.00 - Buyer not in CRM: Priya Rao placed 2 orders - Never bought: Tom Alvarez Want the order list for each buyer?
Nutshell
Sample figures. Your results come from your own account.
nutshell-get-account
nutshell-get-contact
nutshell-get-lead
bigcommerce-get-customer
bigcommerce-get-order

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Nutshell

Nutshell
Run it on your own Nutshell data.

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

Try PopdockAI free

The problem

Account calls without knowing what they buy

Before an account call, a rep checks Nutshell for contacts and leads, then searches the store separately to learn what the account buys. Buyers not in the CRM, and contacts who never bought, are easy to miss.

Without PopdockAI

  • Open the account in Nutshell
  • Note each contact's email
  • Search BigCommerce for each one
  • Total orders by person by hand

With PopdockAI

  • The account, its contacts and leads are read
  • BigCommerce customers are found by email and company name
  • Spend, order count and spend per person are reported
  • Unmatched buyers and non-buying contacts are listed, nothing 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:** For the Nutshell account named `{account-name}`, compare its CRM relationship with its BigCommerce purchases over the last `{lookback-days}` days (default 180).

**Step 1: Find the account**

Call `nutshell-get-account` with `name` set to `{account-name}`. If nothing matches, retry with `name.contains`. If more than one matches, list them and stop. Keep `id`, `owner`, `last-contacted`, `open-leads`.

**Step 2: Find its people and leads**

Call `nutshell-get-contact` with `company-id` set to the account `id`, and `nutshell-get-lead` with `company-id` set to the same id. Keep each contact's `name` and `emails`.

**Step 3: Find store customers**

For each contact email, call `bigcommerce-get-customer` with `email` set to it. Also call `bigcommerce-get-customer` with `company.contains` set to `{account-name}` to catch buyers missing from the CRM.

**Step 4: Pull their orders**

For each store customer found, call `bigcommerce-get-order` with `customer-id` set to the customer `id` and `date-created.from` set to today minus `{lookback-days}` days.

**Step 5: Report**

Report: the account owner and last-contacted date, open leads and value, total store spend and order count in the period, spend per person, buyers in the store who are not CRM contacts, and CRM contacts who have never bought. End with a line saying whether the sales follow-up matches the buying activity.

**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`).

**Validation:**

* If the account has no contacts with emails, rely on the company search alone and say so.
* If no store customers match, report zero spend rather than an error.

Who it's for

One answer, three teams that use it

Account executives

Prepare for an account call

Spend, orders and open leads in one view tell you where the account stands.

Compare the Nutshell account Fabrikam with their BigCommerce orders this year.

Account managers

Find buyers missing from the CRM

Store buyers who are not CRM contacts show who else you should be talking to.

Who at Contoso buys on BigCommerce but is not a contact in Nutshell?

Sales managers

Check follow-up matches buying

Last contacted date beside spend shows whether high value accounts are getting attention.

When did we last contact Northwind Traders in Nutshell, and what have they spent on BigCommerce in 90 days?

How it works

What PopdockAI does when you ask

You give the account name, and your AI assistant compares the Nutshell account with what it buys on BigCommerce. It refuses an ambiguous name and only reads.

01

Ask

You give the account name and optionally a lookback.

Your AI tool

02

Read

It finds the Nutshell account, its contacts and its leads.

nutshell-get-account
nutshell-get-contact
nutshell-get-lead

03

Match

It finds BigCommerce customers by contact email and company name, then reads their orders.

bigcommerce-get-customer
bigcommerce-get-order

04

Report

It shows spend, orders, unmatched buyers and contacts who never bought.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

nutshell-get-account

Returns Nutshell companies (accounts) with their contact details, owner and related fields. Filter by name, owner and other company fields.
get-data

nutshell-get-contact

Returns Nutshell people (contacts) with their emails, phones and linked companies. Filter by name, email, owner and other fields.
get-data

nutshell-get-lead

Returns Nutshell leads (deals) with status, value, confidence, close date, owner and source. Filter by status, owner and dates.
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

bigcommerce-get-order

Returns orders from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
Read only.Nothing in Nutshell 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

Know what the account buys before you call

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