Latenode

Automatically sync TikTok lead data to a Google Sheets spreadsheet

This template receives TikTok Lead Generation form submits on a Latenode webhook, maps name, email, phone, and custom answers in JavaScript, and appends a row in Google Sheets.

If the webhook only includes a lead id, the same JavaScript node loads the full lead from the TikTok Marketing API with your token stored in that node. Connect Google Sheets, then point the TikTok form webhook at the Latenode URL. Add a new worksheet when you want each campaign on its own tab.

Updated Sep 16, 2026Est. run: 7sEst. cost: $0.0004
How Latenode estimates time and cost

Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how CPU seconds work →

Workflow preview

What this template does

  • Writes each TikTok lead as a Google Sheets row
  • Maps form fields in JavaScript, including a Marketing API fetch when the webhook sends an id
  • Creates a worksheet when you want a new campaign tab
  • Keeps the TikTok Marketing API token on the JavaScript node

How it works

1
Trigger

Receive the lead webhook

The scenario starts when TikTok Lead Generation posts a new lead to your Latenode webhook URL.

2
Logic

Map the lead fields

JavaScript turns the payload into sheet columns. If TikTok only sent a lead id, the same node calls the TikTok Marketing API with the token stored in that JavaScript node.

3
Action

Write the row in Google Sheets

Google Sheets appends the mapped fields. Create a new worksheet first when you want a campaign on its own tab.

Setup guide

1

Create the Latenode webhook

Add a webhook trigger and copy its URL into the TikTok Lead Generation form webhook or CRM destination.

2

Map fields in JavaScript

Add a JavaScript node to map name, email, phone, and custom answers. If the body is only a lead id, store your TikTok Marketing API token in that JavaScript node and fetch the lead there.

3

Connect Google Sheets

Add a Google Sheets connection with access to the spreadsheet. Map the JavaScript output into a new row. Create a worksheet first when you want a new campaign tab.

Requirements

A TikTok Lead Generation form that can POST to a webhook URL
A Latenode webhook URL
A TikTok Marketing API token in the JavaScript node if you fetch the lead by id
A Google Sheets spreadsheet Latenode can write

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.

More templates

You might also like

Browse all templates →