Connect TikTok Shop to Google Sheets

Bring your TikTok Shop data into Google Sheets with Windsor.ai, so your sheets read live order, product and sales data.

Pick the TikTok Shop fields you need, and Windsor.ai keeps them flowing without a CSV export in between.

Forget CSVs. Stop copy/paste. Connect in minutes. No code required.

Try It Free

Free forever plan

No credit card needed

Windsor.ai is your proven TikTok Shop to Google Sheets connector

Get your TikTok Shop data into Google Sheets

TikTok Shop is connected once in Windsor.ai, and these are the use cases the fields support:

Track GMV and orders

Shop Performance GMV Amount, Shop Performance Orders and Shop Performance Units Sold by Date show how the shop sells day by day.

Compare LIVE, video and product cards

Shop Performance GMV Breakdowns Live Amount, Shop Performance GMV Breakdowns Video Amount and Shop Performance GMV Breakdowns Product Card Amount show which content type brings the sales.

Check fees and payouts

Statement Revenue Amount, Statement Fee Amount and Statement Settlement Amount show how much of the revenue reaches your account.

Using Windsor.ai to connect data from TikTok Shop to Google Sheets

Supported fields: 369 metrics226 dimensions

Windsor.ai moves your TikTok Shop fields into Google Sheets on a connection you set up once, so the sheets stay on live records rather than a CSV someone exported last week.

Pick the fields you need and Windsor.ai handles the rest.

With Windsor.ai, your spreadsheet can:

Show Shop Performance GMV Amount, Shop Performance Orders, Shop Performance Units Sold and Shop Performance Average Order Value Amount by Date for the last 30 days.
Split last month’s GMV into Shop Performance GMV Breakdowns Live Amount, Shop Performance GMV Breakdowns Video Amount and Shop Performance GMV Breakdowns Product Card Amount.
List the products with the most orders in the last 30 days, using Order Line Item Product Name and Order ID, with the Order Payment Total Amount for each.
Compare Statement Revenue Amount, Statement Fee Amount, Statement Shipping Cost Amount and Statement Settlement Amount for each statement in the last 30 days.
Which products have fewer than 20 units left? Show Product Title, Product SKU ID, Product SKU Inventory Quantity and Product SKU Sale Price.

Join over 25,000+ businesses that trust Windsor.ai to streamline TikTok Shop to Google Sheets integration

How to connect TikTok Shop to Google Sheets with Windsor.ai

Explore a step-by-step guide to integrate your TikTok Shop data into Google Sheets with the Windsor.ai connector.

Register and log in to Windsor.ai

Create a new Windsor.ai account or log in if you already have one.

Select your data source

Choose TikTok Shop as your data source and click Grant TikTok Shop Access. Sign in to your TikTok Shop seller account and approve access for Windsor.ai.

Select your destination

Set Google Sheets as the destination for your data.

Select the reporting fields

Choose the TikTok Shop fields you want 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 TikTok Shop?

TikTok Shop is the e-commerce part of TikTok. Sellers sell products to shoppers inside TikTok through shoppable videos, LIVE streams, creators and product cards.

What TikTok Shop data can I load into Google Sheets?

Windsor.ai gives access to 595 TikTok Shop fields. These are the groups; the TikTok Shop field reference lists all of them:

Shop performance: Shop Performance GMV Amount, Shop Performance Orders, Shop Performance Units Sold, Shop Performance Buyers, Shop Performance Average Order Value Amount, Shop Performance Refunds Amount, Shop Performance Cancellations and Returns.
Sales by content type: Shop Performance GMV Breakdowns Live Amount, Shop Performance GMV Breakdowns Video Amount, Shop Performance GMV Breakdowns Product Card Amount, Shop Performance Product Impressions, Shop Performance Product Page Views, Shop Performance Live Views.
Orders: Order ID, Order Status, Order Create Datetime, Order Payment Total Amount, Order Line Item Product Name, Order Shipping Provider, Order Cancel Reason.
Products and inventory: Product Title, Product Status, Product SKU ID, Product SKU Sale Price, Product SKU Inventory Quantity.
Statements and fees: Statement Revenue Amount, Statement Fee Amount, Statement Shipping Cost Amount, Statement Settlement Amount, Statement Transaction Fee Platform Commission, Statement Transaction Fee Affiliate Commission.
Date and shop: Date, Month, Year, Shop Name, Shop Region, Account Name.

How does Windsor.ai load TikTok Shop data into Google Sheets?

Windsor.ai sends your chosen TikTok Shop fields straight into a sheet, either through the Google Sheets add-on or through an in-app destination task. You can set it to refresh on a schedule.

Does the TikTok Shop connector include customer details?

Yes. Order fields include the buyer email, which TikTok anonymizes, and the recipient name, address and phone number. TikTok hides the phone number on orders that use platform logistics. Select only the fields you need, and leave out the recipient fields when you do not need them.

Can I combine TikTok Shop data with other sources in my sheets?

Yes. Windsor.ai supports 350+ data sources, so TikTok Shop data can sit next to other connected sources in the same sheets. For example, put TikTok Shop Shop Performance GMV Amount by Date next to TikTok Ads Cost for the same days, to compare ad spend with the sales the shop records.

Do I need to code to connect TikTok Shop to Google Sheets?

No. You connect TikTok Shop in the Windsor.ai dashboard, pick the fields you want, and Windsor.ai handles the transfer.

How much does it cost to integrate TikTok Shop with Google Sheets using Windsor.ai?

The free forever plan covers 1 data source, so connecting TikTok Shop on its own costs nothing and needs no credit card. Combining TikTok Shop with other sources 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 TikTok Shop and Google Sheets?

Yes. These are the resources to start with for the TikTok Shop to Google Sheets integration:

Tired of manual TikTok Shop data exports? Try Windsor.ai today to work on live data

Access all your data from various sources in one place. Get started for free.

Start for Free Book a Demo