Connectors

/

Mailchimp

/

Add Mailchimp store products to the HubSpot product library
Write
Cross-Connector

Bring Mailchimp store products into HubSpot with prices you set

For teams who sell through a Mailchimp store and want the same products in the HubSpot product library, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Add Mailchimp store products to the HubSpot product library
Which products in our Northwind Mailchimp store are missing from the HubSpot product library? Add the ones I approve.
3 of the 14 Northwind store products are not in the HubSpot product library yet. - Trail Mug 12oz: recent order prices 18.00 and 16.20 - Canvas Tote: recent order price 24.00 - Gift Wrap: no recent orders - Already in HubSpot: 11 products, left unchanged Which should I create, and at what price for each?
Mailchimp
Sample figures. Your results come from your own account.
mailchimp-get-store
mailchimp-get-product
hubspot-get-products
mailchimp-get-order-line
hubspot-add-product

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Mailchimp

Mailchimp
Run it on your own Mailchimp data.

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

Try PopdockAI free

The problem

Store products that never make it into HubSpot quotes

Products sold through your Mailchimp store often never reach the HubSpot product library, so deals and quotes cannot use them. Copying them means comparing two catalogs by name and guessing a price, since Mailchimp products carry none.

Without PopdockAI

  • Compare the store catalog and HubSpot library by name
  • Dig through orders to guess a list price
  • Pick up a discounted price by mistake
  • Create each missing product by hand

With PopdockAI

  • Store products are checked against HubSpot by name
  • Recent order prices are shown as a reference only
  • You set each price and confirm before anything is created
  • Existing HubSpot products are never 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:** Find products in the Mailchimp store named like `{store-name}` (default every connected store) whose title contains `{product-title}` (default all products) that are missing from the HubSpot product library, and create them in HubSpot after the user confirms each price.

**Step 1: Resolve the store**

If `{store-name}` is not blank, call `mailchimp-get-store` with `name.contains` set to it. If none or several match, list them (name, platform, domain) and stop. Keep its `store-id`.

**Step 2: Products in Mailchimp**

Call `mailchimp-get-product` with `max-records` 200, and `title.contains` set to `{product-title}` when it is not blank. If a store was resolved, keep only products with that `store-id`. Keep `product-id`, `title`, `description`, `type`, `vendor` and `store-id`.

**Step 3: Check the HubSpot product library**

For each product, call `hubspot-get-products` with `name` set to its `title`. If a product comes back, put it in "already in HubSpot" with its HubSpot price and sku. Otherwise put it in "missing".

**Step 4: Reference prices**

Mailchimp products carry no list price. For each missing product, call `mailchimp-get-order-line` with `product-id` set to its `product-id` and `max-records` 5, and show the recent `price` and `quantity` values as a reference only. Do not treat them as the list price, because they can include discounts.

**Step 5: Confirm**

Show the missing products: title, vendor, type, a description cut to 200 characters, and the reference prices. Ask the user to confirm which to create and to give a price for each, or to say to leave the price blank. Do nothing more until they confirm.

**Step 6: Create the products**

Only after confirmation, call `hubspot-add-product` once per confirmed product with `name` set to the Mailchimp `title`, `description` set to the Mailchimp description with HTML tags removed, and `price` only when the user gave one. Leave `sku`, `cost`, `product-type`, `billing-frequency` and `owner-id` out unless the user supplies them. Report each new product id, then the totals: created, failed (with the error), already in HubSpot.

**Rules & Guidelines:**

* `mailchimp-get-store`, `mailchimp-get-product` and `mailchimp-get-order-line` are on the Mailchimp server; `hubspot-get-products` and `hubspot-add-product` are on the hubspot server.
* `hubspot-add-product` is the only write tool this prompt may call, once per confirmed product, after Step 5. Do NOT call `hubspot-update-product` on products already in HubSpot, even when details differ; list the differences instead. Call no other hubspot-add, hubspot-update, hubspot-rename, hubspot-remove, hubspot-subscribe, hubspot-unsubscribe or hubspot-import tool.
* Mailchimp is read-only here. Do NOT call `mailchimp-add-list-member`, `mailchimp-update-list-member`, `mailchimp-add-customer`, `mailchimp-update-customer`, `mailchimp-add-segment-member`, `mailchimp-start-automation`, `mailchimp-pause-automation`, `mailchimp-replicate-campaign`, `mailchimp-update-product` or `mailchimp-update-order`.
* The Mailchimp product-id is not a SKU. Never put it in `sku`.

**Validation:**

* If Mailchimp returns no products, say so and stop.
* If every product is already in HubSpot, report that and stop without asking for confirmation.
* If two Mailchimp stores have products with the same title, create one HubSpot product and say which stores share it.

Who it's for

One answer, three teams that use it

Sales operations

Give reps the products they need on quotes

Fill gaps in the HubSpot product library from the store catalog, so deals and quotes can use every product you sell.

Which products in our Contoso Mailchimp store are not in the HubSpot product library yet?

Ecommerce managers

Keep two catalogs in step

See which store products HubSpot is missing and where the two catalogs differ, without exporting either one.

Check our Mailchimp store products with Gift in the title against HubSpot and list any differences.

Pricing analysts

Set list prices from real order data

Recent order prices are shown as a guide, flagged as possibly discounted, so you choose the list price instead of copying a sale price.

Show me recent Mailchimp order prices for the store products missing from HubSpot so I can set list prices.

How it works

What PopdockAI does when you ask

Your AI assistant reads your Mailchimp store products and finds the ones HubSpot lacks. You choose which to create and set every price yourself.

01

Read

It reads products from your Mailchimp store, filtered by store or title if you like.

Your AI tool

02

Compare

It checks the HubSpot product library for each product by name.

hubspot-get-products

03

Price

For missing products it shows recent order prices as a reference only.

mailchimp-get-order-line

04

Confirm

You choose which to create and set each price, then it creates them and reports the new ids.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

mailchimp-get-store

Returns the e-commerce stores connected to Mailchimp, with platform, domain, currency and linked audience.
get-data

mailchimp-get-product

Returns the products in the e-commerce stores connected to Mailchimp, with type, vendor and product page URL.
get-data

hubspot-get-products

Returns products in the HubSpot product library, with SKU, price, cost, type, status and billing terms from the HubSpot connector. Filter by folder, status, unit price, sku, product type, name.
get-data

mailchimp-get-order-line

Returns the line items on e-commerce orders from the stores connected to Mailchimp: product, variant, quantity, price and discount.
run-action

hubspot-add-product

Creates a product in the HubSpot product library and returns the new product's ID. Required: Name. Optional: SKU, Price, Description, Product type, Billing frequency, Unit cost, Owner ID. Writes to HubSpot.
Read only.Nothing in Mailchimp 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

A HubSpot product library that matches your store

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