Connect Shopee to Google Sheets
Easily integrate your Shopee data into Google Sheets with Windsor.ai for sales and fee analysis.
Windsor.ai loads Shopee orders, products, returns, settlements, and wallet data into Google Sheets in a structured format, ready for formulas, pivot tables, and charts.
Forget CSVs. Stop copy/paste. Connect data in 2 minutes. No code required.
Get more from your Shopee data with Google Sheets
Connecting Shopee to Google Sheets with Windsor.ai lets sellers and marketing teams analyze sales, fees, and returns in a tool they already use. Here are the key benefits of this integration:
Spreadsheets you already know
Work with your Shopee data using formulas, pivot tables, and charts, with no new tool to learn.
Easy to share
Share a sheet with colleagues who do not have a Shopee or Windsor.ai login, and keep everyone looking at the same numbers.
Combine Shopee with other channels
Add Google Ads, Facebook Ads, or Shopify data to the same workbook to compare sales channels side by side.
Using Windsor.ai connector to import data from Shopee into Google Sheets
Without Windsor.ai, getting Shopee data into Google Sheets means downloading reports from Seller Centre and importing each file by hand. Windsor.ai’s connector loads your Shopee orders, products, returns, and settlement data into Google Sheets with no code.
Connect in minutes and start working with your Shopee data in a spreadsheet.
How to connect Shopee to Google Sheets in Windsor.ai
Make sure you have the following prerequisites before setting up the connector:
- Shopee seller account
- Google Sheets document
- Active Windsor.ai account
Select your data source
Choose Shopee as your data source and grant access to Windsor.ai.
Select your destination
Set Google Sheets as the destination for your data.
Select the reporting metrics and dimensions
Choose the Shopee fields that you wish to show in your spreadsheet.
Follow the setup instructions to complete the integration
Depending on the integration method you choose, set up the connection by following the prescribed steps, whether through an extension or directly via an in-app destination task.
FAQs
What is Google Sheets?
Google Sheets is Google’s cloud-based spreadsheet tool for creating, managing, and analyzing data, with sharing features that let several people work in the same sheet.
What Shopee data can I load into Google Sheets?
Windsor.ai loads your Shopee data into Google Sheets in six groups. These are some of the fields in each; the Shopee field reference lists all of them:
- Orders: Order ID, Order Status, Order Total Amount, Order Currency, Order Region, Order Payment Method, Order COD, Order Shipping Carrier, Order Days To Ship, Order Ship By Date.
- Products: Product Name, Product SKU, Product Brand, Product Status, Product Current Price, Product Original Price, Product Available Stock, Product Condition, Product Category ID.
- Returns: Return Status, Return Reason, Return Refund Amount, Return Refund Type, Return Amount Before Discount, Return Due Date.
- Settlement: Settlement Commission Fee, Settlement Service Fee, Settlement Buyer Transaction Fee, Settlement Ads Fee, Settlement Campaign Fee, Settlement Escrow Amount, Settlement Seller Discount, Settlement Voucher From Seller, Settlement Voucher From Shopee, Settlement Final Shipping Fee.
- Wallet: Wallet Amount, Wallet Current Balance, Wallet Transaction Type, Wallet Transaction Status, Wallet Money Flow, Wallet Transaction Fee.
- Date and account fields: Date, Week, Month, Year, Account ID, Account Name.
How does Windsor.ai load Shopee data into Google Sheets?
There are two methods: the Windsor.ai extension for Google Sheets, or a destination task in the Windsor.ai app that sends your Shopee data to a spreadsheet. Both are no-code. Step 5 above links to the instructions for each.
Can I combine Shopee with other data sources in one Google Sheet?
Yes. Windsor.ai supports 350+ data sources, so you can connect Shopee alongside tools such as Google Ads, Facebook Ads, or Shopify, or add the Shopee Ads connector for ad performance, and work with them in the same workbook. For example, you can compare ad spend with Shopee order totals, or compare Shopee sales with sales from your own online store.
How much does it cost to integrate Shopee with Google Sheets using Windsor.ai?
The free forever plan covers 1 data source, so connecting Shopee on its own costs nothing and needs no credit card. Combining Shopee with other sources, such as Google Ads or Shopify, needs a paid plan: $19/month for 3 sources or $99/month for 7. See the pricing page.
Do you have helpful links to get started with integrating Shopee and Google Sheets using Windsor.ai?
Yes, we have helpful resources to help you get started. You can explore our official documentation for Shopee to Google Sheets integration with Windsor.ai:
Tired of manual Shopee data exports? Get started with Windsor.ai today to automate your reporting

