How to Get Shopify Data in Google Sheets

With Two Minute Reports, you can connect your Shopify store and fetch performance data directly into Google Sheets for reporting and analysis.

Required Permissions

You must have store owner access or staff access with all permissions to establish a connection and access Shopify store data.

How to Grant Permission

To grant access in Shopify Admin:

1. Go to Settings -> Users and permissions.
2. Select the user you want to update.
3. Click the staff member's name (or Add staff to create a new one).
4. Scroll to the Permissions section.
5. Enable the following:
   • App development
   • Manage and install apps and channels

Permissions Needed

1. App development

2. Manage and install apps and channels

Once you confirm these prerequisites, follow the steps below to connect your Shopify store with Google Sheets through Two Minute Reports.

Step 1: Install and Launch Two Minute Reports

Install the add-on first if you have not already:

• Install Two Minute Reports in Google Sheets

Once installed, open your spreadsheet and launch TMR from the Extensions menu.

Step 2: Create a New Shopify Connection

In the TMR sidebar:

1. Click Menu and go to Connections.
2. Click Add to create a new connection.
3. Select Shopify from the list of options to connect your Shopify store to Google Sheets.

In the authentication step:

1. Enter a name for your connection.
2. Select Shopify Public App as the app type.
3. Provide your Shopify store name.

Then: 4. Click Test and Save. A new window opens asking you to authorize and install the Two Minute Reports app. 5. Review permissions and click Install to continue. 6. After authorization is complete, you can safely close the window.

After authentication:

1. Enable the store accounts you want to use.
2. Click Refresh Connections so enabled accounts appear in the sidebar.

Step 3: Fetch Shopify Data into Google Sheets

To pull Shopify data:

1. Go to Data Queries and click Add.
2. Select one or more Shopify accounts.
3. Choose the metrics and dimensions you want to analyze.
4. Set your date range.
5. Configure sorting and filters.
6. Click Run Query.

Once your data is in Sheets, you can build dashboards using pivots, formulas, and charts.

Step 4 (Optional): Schedule Automatic Data Refresh

After creating your report, you can schedule refreshes to keep data up to date and share reports by email.

Use the scheduling workflow here:

• Scheduling auto-refresh in Google Sheets

Next Steps

• Running queries
• Managing reports
• Google Sheets troubleshooting

If you need help, contact [email protected].