Connect Google Sheets to TikTok and automate your tasks

Why integrate Google Sheets with TikTok

The Google Sheets to TikTok integration helps you sync data, automate manual tasks, and keep your stack aligned — without writing code.

Log every Shopify order to a Google Sheet automatically

When an order is placed in Shopify, MESA writes the relevant details — customer, line items, order value, fulfillment status — to the right sheet in real time. Your team works from a current, structured record without anyone running manual exports or copying data out of the Shopify admin.

Build a live ops dashboard your whole team can see

When Shopify order, inventory, and customer events occur, MESA pushes the details to Google Sheets as they happen. Your team tracks what's in motion from a single shared view without digging through the Shopify admin or waiting for a scheduled report.

Trigger Shopify workflows when a Google Sheet is updated

When a row is added or a value changes in a designated sheet — a product approved, a vendor confirmed, a reorder threshold flagged — MESA kicks off the corresponding action in Shopify. Your spreadsheet-based processes connect directly to your store operations without a manual handoff step between them.

Sync Shopify audiences to TikTok Ads in real time

When a customer's tags, purchase history, or lifecycle stage changes in Shopify, MESA updates the corresponding TikTok Ads audience. Your campaigns always target the right people without manual list exports or scheduled syncs.

Build retargeting audiences from Shopify customer behavior

When a customer abandons checkout, completes a first purchase, or crosses a spend threshold, MESA adds them to the right TikTok Ads audience automatically. Your retargeting runs on live customer behavior, not a weekly CSV upload.

Pause or adjust campaigns when inventory runs low

When stock drops below a threshold in Shopify, MESA triggers a TikTok Ads update — pausing a campaign, adjusting a budget, or flagging it for review. You stop spending on products you can't fulfill without monitoring ad accounts separately.

Build any Google Sheets and TikTok automation

MESA helps you connect apps to automate repetitive tasks. A trigger is an event that starts a workflow, and actions are the steps that occur when it's running.

Lead Created

Starts when an instant form lead is submitted.

• Request ID
• Entry
• Time

Row Created

Starts when a row is added to your spreadsheet.

Row Updated (Advanced)

Trigger a workflow after each spreadsheet edit. Requires creating an Apps Script in Google Sheets.

Create Ad

Create a TikTok ad.

• Advertiser ID
• Adgroup ID
• Creatives

Create Ad Group

Create a new ad group.

• Advertiser ID
• Adgroup Name
• Campaign ID
• Budget Mode
• Budget
• Placement Type
• Placement
• External Type
• Location
• Schedule Type
• Schedule Start Time
• Optimize Goal
• Billing Event
• Cpv Video Duration
• Bid
• External Action
• Schedule End Time

Create Campaign

Create a new campaign.

• Advertiser ID
• Budget
• Budget Mode
• Objective Type
• Campaign Name

Custom Report

Create a custom report.

List Ad Group

Obtain a list of ad groups.

• Total Number
• Page
• Page Size
• Total Page

List Ads

Obtain a list of ads.

• Total Number
• Page
• Page Size
• Total Page

List Campaigns

Obtain a list of campaigns.

• Total Number
• Page
• Page Size
• Total Page

Retrieve Ad Group Summary Report

Query the daily reporting data of ad groups within a certain period of time.

Retrieve Auction Campaign Summary Report

Query the daily reporting data of auction campaigns within a certain period of time.

Update Ad

Modify an existing ad.

• Advertiser ID
• Adgroup ID
• Creatives

Update Ad Group

Modify an existing ad group.

• Advertiser ID
• Adgroup Name
• Adgroup ID
• Operation System
• Category
• Keywords
• Location
• Schedule Type
• Schedule End Time
• Dayparting
• Bid
• Conversion Bid
• Budget Mode
• Budget
• Bid Type

Update Ad Group Status

Delete, disable, or enable an existing ad group.

• Advertiser ID
• Adgroup Ids
• Opt Status

Update Ad Status

Delete, disable, or enable an existing ad.

Update Campaign

Modify an existing campaign.

• Advertiser ID
• Budget
• Budget Mode
• Objective Type
• Campaign Name
• Campaign ID

Update Campaign Status

Delete, disable, or enable an existing campaign.

• Advertiser ID
• Campaign Ids
• Opt Status

Upload Image

Upload an image to your TikTok Business account.

• Format
• File Name
• Height
• Image ID
• Create Time
• ID
• Size
• URL
• Displayable
• Material ID
• Width
• Modify Time
• Signature

Upload Video

Upload a video to your TikTok Business account.

• Poster URL
• Format
• URL
• File Name
• Video ID
• Displayable
• Material ID
• Height
• Width
• Bit Rate
• Create Time
• Modify Time
• Allowed Placements
• Signature
• Duration
• Allow Download
• ID
• Size

Add Row

Add a row to an existing Google Sheets document.

• Spreadsheet ID
• Updated Range
• Updated Rows

Add Sheet

Add a new sheet to an existing Google Sheets spreadsheet

• Spreadsheet
• Sheet Name

Bulk Add Rows

Add multiple rows to a Google Spreadsheet

• Spreadsheet
• Sheet Name

Create New Spreadsheet

Create a new Google Sheets spreadsheet.

• Spreadsheet name
• Folder

Query Rows

List a selection of rows in a spreadsheet based on a query.

Update Row

Modify an existing row in your spreadsheet.