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
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
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions