Shopify
+
Google Sheets
+
Microsoft Excel

Shopify in your spreadsheet

Import live, refreshable data from your Shopify account in Microsoft Excel and Google Sheets.

Import Shopify data in your spreadsheet

Shopify is a cloud-based, multi-channel e-commerce platform designed for small and medium-sized businesses. This Shopify spreadsheet integration for Google Sheets and Microsoft Excel enables you to import your online store datasets from Shopify. This add-on will enable you to integrate on-demand, refreshable customer and product list data without leaving your spreadsheet.

For example, with this Excel and Google Sheets add-on you can:

  • Import list of customers directly in Excel and Google Sheets, including columns such as name, email, phone, address, order count and total spend.
  • Extract your product list, including title, vendor, product type, creation and published date and tags.

Click here to learn more about the specific syntax for each of the Shopify spreadsheet functions.

Getting Started

Flex.io makes it easy to create, use and share custom spreadsheet functions that import data from services you know and love. Click on the button below to use the Shopify function collection with Microsoft Excel or Google Sheets. Please note that you'll need a Shopify account to use this integration.

Need Help?

Have questions? Need help with installation? Need other Shopify functions for Microsoft Excel or Google Sheets? Chat with us; we're happy to help!

Functions and Syntax

This integration for Microsoft Excel or Google Sheets includes the following functions:

Shopify Customers List

Returns a list of customers from Shopify

Syntax

=FLEX("YOUR_TEAM_NAME/shopify-list-customers", [properties])

Parameters

Property Type Description Required
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

Notes

The following properties are available:

  • id: A unique identifier for the customer.
  • email: The unique email address of the customer.
  • accepts_marketing: Whether the customer has consented to receive marketing material via email.
  • created_at: The date and time (ISO 8601 format) when the customer was created.
  • updated_at: The date and time (ISO 8601 format) when the customer information was last updated.
  • first_name: The customer's first name.
  • last_name: The customer's last name.
  • orders_count: The number of orders associated with this customer.
  • state: The state of the customer's account with a shop: disabled, invited, enabled or declined
  • total_spent: The total amount of money that the customer has spent across their order history.
  • note: A note about the customer.
  • verified_email: Whether the customer has verified their email address.
  • tax_exempt: Whether the customer is exempt from paying taxes on their order. If true, then taxes won't be applied to an order at checkout. If false, then taxes will be applied at checkout.
  • phone: The unique phone number (E.164 format) for this customer.
  • tags: Tags that the shop owner has attached to the customer, formatted as a string of comma-separated values.
  • last_order_id: The ID of the customer's last order.
  • last_order_name: The name of the customer's last order. This is directly related to the name field on the Order resource.
  • currency: The three-letter code (ISO 4217 format) for the currency that the customer used when they paid for their last order.
  • accepts_marketing_updated_at: The date and time (ISO 8601 format) when the customer consented or objected to receiving marketing material by email.
  • marketing_opt_in_level: The marketing subscription opt-in level (as described by the M3AAWG best practices guideline) that the customer gave when they consented to receive marketing material by email: single_opt_in, confirmed_opt_in or unknown
  • tax_exemptions: Whether the customer is exempt from paying specific taxes on their order. Canadian taxes only. See Shopify customer properties for a list of available values.
  • address1: The first line of the customer's mailing address.
  • address2: An additional field for the customer's mailing address.
  • city: The customer's city, town, or village.
  • company: The customer's company.
  • country_code: The two-letter country code corresponding to the customer's country.
  • country_name: The customer's normalized country name.
  • province: The customer's region name. Typically a province, a state, or a prefecture.
  • province_code: The two-letter code for the customer's region.
  • zip: The customer's postal code, also known as zip, postcode, Eircode, etc.

Shopify Products List

Returns a list of products from Shopify

Syntax

=FLEX("YOUR_TEAM_NAME/shopify-list-products", [properties])

Parameters

Property Type Description Required
properties array The properties to return (defaults to all properties). See "Notes" for a listing of the available properties. false

Sample Usage

Notes

The following properties are available:

  • id: A unique identifier for the product.
  • title: The name of the product.
  • body_html: A description of the product. Supports HTML formatting.
  • vendor: The name of the product's vendor.
  • product_type: A categorization for the product used for filtering and searching products.
  • created_at: The date and time (ISO 8601 format) when the product was created.
  • handle: A unique human-friendly string for the product. Automatically generated from the product's title.
  • updated_at: The date and time (ISO 8601 format) when the product was last modified.
  • published_at: The date and time (ISO 8601 format) when the product was published.
  • tags: A string of comma-separated tags that are used for filtering and search.
  • published_scope: Whether the product is published to the Point of Sale channel: web or global
  • product_id: The unique numeric identifier for the product.
  • price: The price of the product variant.
  • sku: A unique identifier for the product variant in the shop.
  • inventory_policy: Whether customers are allowed to place an order for the product variant when it's out of stock: deny or continue
  • compare_at_price: The original price of the item before an adjustment or a sale.
  • taxable: Whether a tax is charged when the product variant is sold.
  • barcode: The barcode, UPC, or ISBN number for the product.
  • grams: The weight of the product variant in grams.
  • weight: The weight of the product variant in the unit system specified with weight_unit.
  • weight_unit: The unit of measurement that applies to the product variant's weight.
  • inventory_item_id: The unique identifier for the inventory item, which is used in the Inventory API to query for inventory information.
  • inventory_quantity: An aggregate of inventory across all locations.
  • requires_shipping: Whether a customer needs to provide a shipping address when placing an order for the product variant.

Use Shopify in your spreadsheet now!