How to Import Shopify Selling Plan Groups Data into Google Sheets

Managing subscription offerings in Shopify requires clear visibility into your Selling Plan Groups. But jumping between platforms to analyze this data wastes time.

Importing Selling Plan Groups into Google Sheets lets you build custom reports and analyze subscription performance alongside other business metrics.

Step-by-step guide to importing Shopify Selling Plan Groups

Step 1: Install Coefficient and connect to Shopify

First, you’ll need to install the Coefficient add-on and connect it to your Shopify account:

1. Open your Google Sheet
2. Click on Extensions > Add-ons > Get add-ons
3. Search for “Coefficient” and install it from the Google Workspace Marketplace
4. Once installed, open the Coefficient sidebar by clicking Extensions > Coefficient > Launch
5. Click “Import Data” to begin

Step 2: Select Shopify as your data source

Now, connect to your Shopify store and select the Selling Plan Groups object:

1. In the Coefficient sidebar, select “Import from”
2. Under the Ecommerce category, click on “Shopify”
3. If this is your first time, you’ll need to authenticate your Shopify account
4. Once connected, select “Import from Objects”
5. Scroll down and select “Selling Plan Groups” from the list of available objects

Step 3: Configure and import your data

Now you can customize what data you want to import:

1. Select the fields you want to import (e.g., name, summary, merchant_code, options)
2. Apply any filters if you only want specific Selling Plan Groups
3. Choose where in your spreadsheet you want the data to appear
4. Click “Import” to bring the data into your Google Sheet

Step 4: Set up auto-refresh (optional)

Keep your Selling Plan Groups data fresh with automatic updates:

1. Click on the Coefficient icon next to your imported data
2. Select “Schedule Refresh”
3. Choose your preferred frequency (hourly, daily, weekly)
4. Optionally, set up Slack or email notifications for when data changes

What you can do with Shopify Selling Plan Groups data in Google Sheets

Once you’ve imported your Selling Plan Groups data, you can:

• Create dashboards to track subscription offerings performance
• Analyze which subscription plans drive the most revenue
• Compare subscription vs. one-time purchase metrics
• Share real-time subscription data with your team

Next steps

Importing Shopify Selling Plan Groups into Google Sheets is just the beginning. With your subscription data now accessible, you can build comprehensive dashboards that combine this information with other business metrics.

The real power comes from the automation. No more manual exports or outdated data. Your subscription information stays fresh with scheduled refreshes.

Teams across your organization can now access the same subscription data, ensuring everyone makes decisions based on accurate information.

Plus, with Coefficient’s alerting capabilities, you’ll know immediately when important changes occur in your subscription offerings.

Try Coefficient todayReady to streamline your Shopify subscription reporting?and transform how you manage your Selling Plan Groups data.