Integrations 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick integrations crm b2b segmentation

Export a CRM-Ready Contact List From Shopify Customer Data

Get Sidekick to pull the right customer fields and build a segment formatted for your CRM's import columns — Sidekick cannot connect to HubSpot, Salesforce, or Pipedrive directly.

📋 Prompt
Run in Sidekick
Reality check: Sidekick cannot act on your external CRM — it has no connection to
HubSpot, Salesforce, Pipedrive, or similar tools. It can only work with data that
lives in Shopify (customers, companies/B2B accounts, orders). This prompt has
Sidekick prepare a clean, CRM-shaped export inside Shopify; the import into your CRM
is a manual step.

Build me a customer/company list for CRM import:

CRM I’m importing into: [HUBSPOT / SALESFORCE / PIPEDRIVE / OTHER]
Audience: [e.g., “all B2B companies with an active order in the last 12 months,” “wholesale customers not yet contacted this quarter,” “customers over $[X] lifetime value”]
Include B2B company records: [YES/NO — Sidekick can create/reference Companies for B2B]


  Create a customer segment (or list B2B companies) matching the audience above.
  Confirm how many records match before I proceed.
  List the exact fields available for export: first name, last name, email, phone, company name, total spent, order count, last order date, default address (city/region/country), tags, marketing consent status.
  Flag any records missing a usable field (no email, no company name) so I can decide whether to exclude them from the CRM import.


Manual handoff steps (outside Sidekick):

  Export the segment as CSV from Customers → Segments → Export (or Companies → Export for B2B).
  In my CRM’s import tool, map columns: Email → Email, Company → Company Name, Total Spent → a custom “Lifetime Value” field, Order Count → a custom “Orders” field.
  Tag imported records with a source label (e.g., “Shopify import [DATE]”) so I can distinguish them from contacts added elsewhere in the CRM.
  Repeat this export manually on whatever cadence I need — Sidekick has no live sync to the CRM, so the CRM will drift out of date between exports.

How to Use

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions