Jump to a popular page, or start typing.

    CONNECTIONS / Google Sheets / Google Sheets to TikTok Custom Audience

    Your Google Sheets rows, wired to TikTok audience targeting.

    Connect Google Sheets and point Signals at your Google Sheets rows; it delivers first-party segments to TikTok as match-ready custom audiences each time a new file lands, hashed and consent-checked for TikTok.

    google-sheet -> tiktok-custom-audience :: live

    1. ● google sheets → tiktok.audience :: live
    2. > read segments rows=65,960
    3. hash sha256(email,phone) consent=filtered
    4. route tiktok deliver
    5. ✓ delivered · 57,385 matched

    WHAT THIS ENABLES

    Google Sheets to TikTok Custom Audience

    Google Sheets to TikTok Custom Audience: Signals reads your Google Sheets rows and delivers first-party segments to TikTok as match-ready custom audiences, hashed and consent-checked each time a new file lands.

    • Customer segments from your Google Sheets rows activated for TikTok, as Signals delivers first-party segments to TikTok as match-ready custom audiences.
    • TikTok custom audiences mirroring the segment your data team publishes, drawn from your Google Sheets rows by ops teams maintaining Google Sheets.

    WHAT FLOWS WHERE

    Google Sheets to Custom Audience, mapped.

    Signals picks up the customer segments from your Google Sheets rows; Signals hashes and consent-screens each record before TikTok's Custom Audience API accepts the match-ready audiences for match quality on TikTok.

    Signals picks up the customer segments from your Google Sheets rows; Signals hashes and consent-screens each record before TikTok's Custom Audience API accepts the match-ready audiences for match quality on TikTok.

    WHO THIS IS FOR

    Built for the teams that own the number.

    TikTok advertisers seeding lookalikes and suppressing existing customers, with the records already in Google Sheets tabs and ranges.

    Ops teams maintaining Google Sheets activating TikTok audience targeting straight from Google Sheets rows.

    HOW DATAHASH SETS IT UP

    From kickoff to verified events.

    1. Connect

      Read-only OAuth access to the Google Sheet you name to feed TikTok's Custom Audience API, sized for match quality on TikTok.

    2. Map

      Signals picks up your Google Sheets rows, and its columns map to TikTok's Custom Audience API in the visual mapper, hashed and checked for match quality on TikTok.

    3. Deliver

      On each run, Signals pulls your Google Sheets rows, delivers first-party segments to TikTok as match-ready custom audiences, and processes only the newly dropped file, with match quality on TikTok in the debugger.

    WHAT YOU GET

    What ships with this use case.

    TikTok custom audiences mirroring the segment your data team publishes on every run, as Signals reads your Google Sheets rows and processes only the newly dropped file.

    Targeting that mirrors your live segment from your Google Sheets rows, with transfer overhead steady because Signals processes only the newly dropped file.

    A per-run match report from TikTok's Custom Audience API on match quality on TikTok, straight out of your Google Sheets rows.

    ON THE WIRE

    What Custom Audience actually receives.

    signals :: google-sheet.tiktok-custom-audience :: wire

    1. ● signals :: audience upload
    2. > POST /dmp/custom_audience source=google-sheet.segments
    3. id_schema ["EMAIL_SHA256","PHONE_SHA256"]
    4. action "add" · audience_id "aud_98814"
    5. id_list_size 65,960 · matched 57,385
    6. ✓ accepted match=87%
    FAQ

    Asked on almost every call.

    How often does the Google Sheets TikTok Custom Audience sync run?

    You set the cadence, from near-real-time to a nightly Google Sheets sync of your Google Sheets rows into TikTok. Since Signals processes only the newly dropped file, TikTok custom audiences mirroring the segment your data team publishes keeps pace and ops teams maintaining Google Sheets watch match quality on TikTok. One scoped connection sets it up, cadence adjustable later.

    What match rate should a Google Sheets-sourced TikTok Custom Audience batch expect?

    In Google Sheets, match rate tracks the email and phone quality your Google Sheets rows carry. Clean identifiers land for TikTok; blank ones never will. The first Custom Audience API report shows ops teams maintaining Google Sheets where match quality on TikTok needs work, a data-quality task handled in Google Sheets.

    NEXT STEP

    Google Sheets to TikTok Custom Audience, in production this week.