Connect TikTok Shop to Gemini Enterprise
Connect your TikTok Shop data to Gemini Enterprise with the Windsor.ai connector, and ask about GMV, orders, products and payouts in plain language.
Ask how GMV and orders change day by day, whether LIVE, video or product cards bring the sales, or how much of your revenue goes to fees, built on your own TikTok Shop data. Gemini Enterprise can also change product prices and turn listings on or off.
Forget CSVs. Stop copy/paste. Connect in minutes. No code required.
Get your TikTok Shop data into Gemini Enterprise
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.
Watch stock levels
Product SKU Inventory Quantity per Product Title and Product SKU ID shows which products are running low.
Using Windsor.ai to connect data from TikTok Shop to Gemini Enterprise
Without Windsor.ai, Gemini Enterprise answers about TikTok Shop data come from a file you exported and pasted in. Through the Windsor.ai connector, Gemini Enterprise reads the live records with their real field names, so the answers match what is in TikTok Shop today.
Connect in minutes, then ask about your GMV, orders, products, inventory, fees and settlement data.
Available actions
Update Product
Update the title, description or key product features of an existing TikTok Shop product, identified by product_id (field product_id of the Product table). Provide only the fields to change; at least one is required. description is HTML. key_product_features replaces the ENTIRE list (at most 5 items, 1,500 characters in total): pass every feature to keep. TikTok audits the edit before it is live: the current version stays live until the audit passes. Use update_price to change prices.
Update Price
Set the price shown on the product page for one or more SKUs of an active TikTok Shop product, identified by product_id and sku_id (fields product_id and product_sku_id of the Product table). All SKUs must belong to the product. The price is in the currency of the shop. The new prices are live immediately; TikTok rejects the change while the product is in a promotion. Reversible by calling update_price with the previous prices, which the result lists.
Activate Products
Activate up to 20 deactivated TikTok Shop products, identified by product_ids (field product_id of the Product table). TikTok audits each product (status Pending) before it is live again. Reversible via deactivate_products.
Deactivate Products
Deactivate up to 20 live TikTok Shop products, identified by product_ids (field product_id of the Product table), so that buyers cannot see or buy them. Reversible via activate_products, after which TikTok audits the products again.
How to connect TikTok Shop to Gemini Enterprise with Windsor.ai
Watch the video tutorial, or follow the step-by-step guide to connect your TikTok Shop data to Gemini Enterprise with Windsor.ai.
Create the Windsor.ai data store in Google Cloud
In the Google Cloud console, open Gemini Enterprise, go to Data stores and click Create data store. Under Third-party data sources, find Windsor.ai and click Add data source. Choose the actions to enable, set the location and create the store.
Create an app and connect the data store
Create a Gemini Enterprise app in the same location as your data store, or pick an existing one. Then open Connected data stores in the app and add the Windsor.ai data store.
Authorize Windsor.ai
Open the app’s web app, click the puzzle piece icon and click Authorize next to Windsor.ai. Allow access, sign in to Windsor.ai if asked, and click Finish.
Ask Gemini about your TikTok Shop data
Ask a question such as “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.” Data can take about 10 minutes to appear after you connect the data store to the app.
FAQs
What TikTok Shop data can Gemini Enterprise use?
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.
What can I ask Gemini Enterprise about my TikTok Shop data?
These prompts name the fields to use, so the answer comes back on your own records:
-
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.
Can Gemini Enterprise change my TikTok Shop data?
Yes. Gemini Enterprise can change SKU prices, edit product titles and descriptions, or activate and deactivate products through Windsor.ai, only when you ask. Execute Action must be enabled on the Windsor.ai data store, and Write actions must be on in your Windsor.ai account. See the full list of write actions.
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 Gemini Enterprise?
Yes. Windsor.ai supports 350+ data sources, so you can connect TikTok Shop alongside tools such as TikTok Ads, Shopify or GA4 and ask about them together. 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 Gemini Enterprise?
No. Connect TikTok Shop in Windsor.ai, add Windsor to Gemini Enterprise, and sign in. After that you ask in plain language.
How much does it cost to integrate TikTok Shop with Gemini Enterprise 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. Gemini Enterprise is billed separately by Google. See the pricing page.
Do you have helpful links to get started with TikTok Shop and Gemini Enterprise?
Yes. These are the resources to start with for the TikTok Shop to Gemini Enterprise integration:
Tired of manual TikTok Shop data exports? Try Windsor.ai today to work on live data

