Connectors

/

BigCommerce

/

Add BigCommerce newsletter subscribers to a HubSpot list
Write
Cross-Connector

Put new BigCommerce subscribers on a HubSpot list

For marketing teams who want recent BigCommerce newsletter signups grouped in a HubSpot list, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Add BigCommerce newsletter subscribers to a HubSpot list
Add everyone who joined our BigCommerce newsletter in the last 14 days to the HubSpot list Spring Newsletter Signups.
18 of 22 recent BigCommerce subscribers are HubSpot contacts, and the list Spring Newsletter Signups does not exist yet. - List: Spring Newsletter Signups, will be created as a manual list - To add: 18 contacts, 2 flagged as unsubscribed in HubSpot - Not in HubSpot: 4 subscribers, reported only Shall I create the list and add the 18 contacts?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-subscriber
hubspot-get-contacts
hubspot-get-contact-subscriptions
hubspot-get-lists
hubspot-get-contact-list-membership
hubspot-add-list
hubspot-add-list-members

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

New store subscribers never make it onto the HubSpot list

Getting BigCommerce newsletter signups into a HubSpot list means exporting subscribers, looking each email up and adding the rest by hand. An email that matches two contacts or a HubSpot unsubscribe is easy to miss along the way.

Without PopdockAI

  • Export recent subscribers from BigCommerce
  • Search HubSpot for each email one at a time
  • Check who is already on the list and who unsubscribed
  • Add the rest by hand and hope none were missed

With PopdockAI

  • Recent subscribers are read from BigCommerce and matched by email
  • Unsubscribed contacts are flagged and duplicate matches left out
  • You see the list, the contacts to add and who is not in HubSpot, then confirm
  • Each new member is checked on the list afterwards

The prompt

Use this prompt

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

Prompt
**Objective:** Put the HubSpot contacts of BigCommerce newsletter subscribers added in the last `{lookback-days}` days (default 30, at most `{max-records}`, default 50) into the manual HubSpot contact list named `{list-name}`, creating the list if it does not exist. Nothing is written until the user confirms.

**Step 1: Read subscribers from BigCommerce**

Call `bigcommerce-get-subscriber` with `date-created.from` set to today minus `{lookback-days}` days (30 if empty) and `max-records` set to `{max-records}` (50 if empty). Keep `id`, `email`, `first-name`, `last-name`, `source` and `date-created`.

**Step 2: Find the contacts in HubSpot**

The join is the BigCommerce subscriber `email` against the HubSpot contact `email`, compared case-insensitively after trimming. For each subscriber, call `hubspot-get-contacts` with `email` set to it and keep `record-id`. If none comes back, list the subscriber as not in HubSpot; if several come back, list them and leave the subscriber out. For each matched contact, call `hubspot-get-contact-subscriptions` with `recipient-email` set to the email and note any subscription whose `status` is not subscribed, so the user sees it.

**Step 3: Find or plan the list in HubSpot**

Call `hubspot-get-lists` with `name` set to `{list-name}` and `object-type` set to 0-1. If one comes back and its `processing-type` is MANUAL, use its `list-id` and call `hubspot-get-contact-list-membership` with `list-id` set to it to drop contacts already in it. If it comes back with any other processing type, say it cannot be changed and stop. If none comes back, plan to create it.

**Step 4: Confirm**

Show the list (existing, with its size, or to be created), the contacts to add (name, email, source, signup date, and a flag where HubSpot shows them unsubscribed), and the subscribers not in HubSpot. Ask for an explicit yes and offer to exclude rows. Do not continue without a yes.

**Step 5: Write and verify**

If the list must be created, call `hubspot-add-list` once with `name` set to `{list-name}`, `object-type` 0-1 and `processing-type` MANUAL, and use the returned `id`. Then call `hubspot-add-list-members` with `list-id` and `record-ids` set to the confirmed contact record-ids, comma-separated, in batches of at most 100. Call `hubspot-get-contact-list-membership` with `list-id` and confirm each contact is now a member. Report added, already present, failed and skipped.

**Rules & Guidelines:**

* `bigcommerce-get-subscriber` is on the bigcommerce server; `hubspot-get-contacts`, `hubspot-get-contact-subscriptions`, `hubspot-get-lists`, `hubspot-get-contact-list-membership`, `hubspot-add-list` and `hubspot-add-list-members` are on the hubspot server.
* The only write tools allowed are `hubspot-add-list`, at most once, and `hubspot-add-list-members`, once per batch, both only after the confirmation in Step 4. Call no other hubspot-add, hubspot-update, hubspot-rename, hubspot-remove, hubspot-subscribe, hubspot-unsubscribe or hubspot-import tool. List membership is not consent: never subscribe or resubscribe anyone from this prompt.
* Never call `bigcommerce-subscriber-add`, `bigcommerce-subscriber-update`, `bigcommerce-subscriber-delete` or any other bigcommerce add, update or delete tool. BigCommerce is only read here.
* Do not create HubSpot contacts for subscribers that are not in HubSpot; report them instead.

**Validation:**

* If `{list-name}` is empty, ask for it and stop.
* If no subscriber matches a HubSpot contact, say so and stop without creating a list.
* If the user declines or does not answer, stop with nothing written.

Who it's for

One answer, three teams that use it

Email marketers

Get new signups into nurture lists quickly

Move this week's store subscribers onto the list your campaign sends to, without an export and a lookup for every email.

Add BigCommerce newsletter subscribers from the last 7 days to the HubSpot list Weekly Deals.

Marketing operations

Keep list membership clean and consent aware

Unsubscribed contacts are flagged and ambiguous emails are left out, so the list only gains the people it should.

Put recent BigCommerce subscribers on the HubSpot list Store Newsletter, but tell me who is unsubscribed in HubSpot first.

Ecommerce managers

See which subscribers HubSpot does not know yet

Subscribers with no HubSpot contact are reported rather than created, so you can decide how to bring them in.

Which BigCommerce newsletter subscribers from the last 30 days have no HubSpot contact, and add the rest to Contoso Spring Promo.

How it works

What PopdockAI does when you ask

You name the HubSpot list and your AI assistant matches recent BigCommerce subscribers to HubSpot contacts. Nothing is added until you have seen the plan and said yes.

01

Read

It pulls BigCommerce newsletter subscribers from the last 30 days or the period you give.

Your AI tool

02

Match

It finds each one in HubSpot by email and notes anyone unsubscribed there.

hubspot-get-contacts
hubspot-get-contact-subscriptions

03

Confirm

You see the list, the contacts to add and the subscribers not in HubSpot, and say yes.

No items found.

04

Add

It creates the manual list if needed, adds the contacts and checks each one is now a member.

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-subscriber

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

hubspot-get-contacts

Returns contact records from HubSpot CRM, with email, phone, company, lifecycle stage, lead status, owner and location from the HubSpot connector. Filter by company id, state region, contact owner, email, last name, create date, company name, record id, lifecycle stage, lead status.
get-data

hubspot-get-contact-subscriptions

Returns each recipient's email subscription statuses and legal basis from the HubSpot connector. Filter by id, name, status, recipient email.
get-data

hubspot-get-lists

Returns HubSpot lists (segments) of any object type, with size and processing type from the HubSpot connector. Filter by size, processing type, name, list id, object type.
get-data

hubspot-get-contact-list-membership

Returns which contacts belong to which contact lists from the HubSpot connector. Filter by list name, contact id, contact email, list id.
run-action

hubspot-add-list

Creates a HubSpot list and returns its ID. Required: Name, Object type, Processing type. Writes to HubSpot.
run-action

hubspot-add-list-members

Adds records to a manual HubSpot list. Required: List ID, Record IDs. Writes to HubSpot.
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

New signups land on the right HubSpot list in one pass

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