With Sheetgo, you can connect your Shopify account directly to Google Sheets, automating the import of sales, order, and product data for streamlined reporting and analysis.
Follow this guide to set up the Shopify integration using an API connection.
Prerequisites
Before you start, make sure you have:
A Shopify API token (see steps below to generate this token).
The Shopify store URL in the format
https://your-store-name.myshopify.com.
Step-by-Step Guide
In Shopify
Step 1: Generate Your Shopify API Token
Log into your Shopify Admin panel.
Navigate to Settings > Apps and sales channels.
Click Develop apps
After naming and assigning a developer to manage your app, select Create app
Configure ADmin API scopes by accesing Admin API access scopes
Select the permissions needed for your data, such as
read_ordersto retrieve order data.
Click Save, then Install app to generate the API token.
Copy and store the generated token securely, as you’ll need it to connect with Sheetgo. Note that you can only reveal your Admin API token once.
Step 2: Identify the Shopify API Endpoint
Refer to the Shopify API documentation to understand which API endpoint to use based on your needs. For example, to retrieve scheduled events, you would focus on the Orders API endpoints. Browse for the required endpoint. The left-side menu on the Shopify API documentation page contains categorized endpoints.
Here are common endpoints:
Orders:
/admin/api/2024-10/orders.json?status=any&financial_status=paidProducts:
/admin/api/2024-10/products.json
Ensure you have the correct API version and replace 2024-10 with the version specified by Shopify.
In Sheetgo
Step 3: Set Up the Shopify API Connection in Sheetgo
In Sheetgo, create a Blank workflow or open an existing one.
For the source step, select API / HTTP Request.
In the API URL field, enter your Shopify request URL:
bashCopy codehttps://your-store-name.myshopify.com/admin/api/2024-10/orders.json?status=any&financial_status=paid
Replace your-store-name with your actual Shopify store name and adjust parameters as needed.
Step 4: Add Authentication Headers
In the Headers box, add the following JSON headers to authenticate your request:
{ "Content-Type": "application/json", "X-Shopify-Access-Token": "YOUR_ACCESS_TOKEN" }Replace
YOUR_ACCESS_TOKENwith the token you generated in Shopify.
Choose a Data Processor (Optional)
If you’d like to filter the imported data, use the Filter by Condition option in Sheetgo’s data processor step.
Set Your Destination
Choose your Google Sheets file or BigQuery database as the destination for the imported Shopify data.
Finish and Run the Workflow
Click Finish and Save to complete the setup.
Run the workflow to start importing data from Shopify to Google Sheets.
Troubleshooting Tips
Token Errors: Ensure the API token is copied correctly. Tokens are case-sensitive and must match the Shopify-generated version exactly.
Permissions: If your data isn’t displaying, check that the required permissions are enabled in Shopify under Admin API access scopes.
This guide empowers you to set up Shopify data imports quickly, keeping your spreadsheets up-to-date with the latest sales and inventory data from Shopify.