Latenode
TikTok
Google sheets

Automatically sync TikTok leads to new Google Sheets worksheets

This automation allows businesses to capture and react to leads generated through TikTok's Lead Generation feature by automatically creating new worksheets within a designated Google Sheets spreadsheet.

Whenever a new lead is created in TikTok, this integration will trigger the creation of a new worksheet in the specified Google Sheets file, making the lead data accessible for further processing and analysis. This streamlines the lead management process by centralizing lead information from TikTok into a familiar spreadsheet platform.

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

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. 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 credits work →
Social media

Workflow preview

What this template does

  • Extracts new lead data from TikTok's Lead Generation feature.
  • Normalizes lead data into a consistent format.
  • Appends lead data as a new row in a designated Google Sheets spreadsheet.
  • Organizes lead data in a centralized spreadsheet for further processing.
  • Enables analysis and management of TikTok leads within a familiar spreadsheet interface.

How it works

1
Trigger

Capture new TikTok leads

Whenever a new lead is created through TikTok's Lead Generation feature, this automation will be triggered to capture the lead data.

2
Action

Create new worksheet in Google Sheets

The automation will create a new worksheet within the designated Google Sheets spreadsheet, with the lead data from TikTok populating the new row.

3
Logic

Process and format lead data

Custom logic will be applied to process and format the lead data from TikTok, ensuring it is structured appropriately for the Google Sheets worksheet.

Setup guide

1

Add TikTok Lead Generation credential

Add your TikTok Lead Generation credential in the Latenode Credentials panel. You'll need to connect your TikTok advertiser or business account to authorize Latenode to access your TikTok Lead Generation data.

2

Configure TikTok Lead Generation node

Add a TikTok Lead Generation node to your workflow. In the node settings, select the TikTok credential you added in the previous step and configure the lead source you want to capture.

3

Add Google Sheets credential

Add your Google Sheets credential in the Latenode Credentials panel. You'll need to connect your Google account and grant Latenode access to your Google Sheets.

4

Configure Google Sheets node

Add a Google Sheets node to your workflow. In the node settings, select the Google Sheets credential you added in the previous step and specify the spreadsheet and worksheet you want to use for the new lead data.

5

Map TikTok lead data to Google Sheets

In the Google Sheets node settings, map the relevant fields from the TikTok Lead Generation data to the corresponding columns in your Google Sheets worksheet.

Requirements

Connect your TikTok Business account to access the Lead Generation API
Authorize the integration to access your Google Sheets account and the specific spreadsheet
Configure the target Google Sheets spreadsheet and worksheet where lead data will be appended
Set up the Latenode workspace with the required 'tiktok', 'google-sheets', and 'code' nodes

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.
Contact support →

More templates

You might also like

Browse all templates →
Social media

Automate and schedule recurring Instagram post liking

This automated workflow allows Instagram users to schedule recurring post liking on a 2-hourly schedule. It uses Phantombuster to scrape recent posts under AI-generated hashtags, GPT-4o for intelligent hashtag selection, and a rotating set of Instagram session cookies to distribute likes across multiple accounts while staying within platform limits. The workflow uploads the posts to be liked to a SharePoint repository, then triggers the Phantombuster 'Auto-like Agent' to interact with the selected content. This streamlined approach helps Instagram users boost engagement and growth on their accounts without manual effort.

28s$0.0018
Social media

Streamline cold calling with automated prospect scraping, AI scripts, and WhatsApp outreach

This workflow automates the entire cold calling pipeline, from prospect identification and research to personalized message creation and delivery. It leverages Apify for web scraping, GPT-4o for intelligent content generation, and WhatsApp integration for automated outreach, transforming raw prospect data into high-converting, personalized cold calling campaigns. The workflow can be triggered manually or via a Google Drive Trigger, and it stores prospect data in a Supabase vector database, processes the data using OpenAI's language models, and sends the personalized messages through the WhatsApp Business API. This solution aims to help sales teams streamline their cold calling efforts, increase reach and response rates, and improve message effectiveness through continuous AI-powered optimization.

22s$0.0014
Social media

Automatically sync LinkedIn Ads lead data to Google Sheets

This automation enables users to seamlessly capture new lead generation form responses from LinkedIn Ads and automatically add them as rows in a designated Google Sheets spreadsheet. This helps consolidate and centralize all LinkedIn Ads lead data in one organized location for further analysis and processing. The automation triggers whenever a new lead form response is received from LinkedIn Ads, and it then creates a new row in the connected Google Sheets spreadsheet, ensuring that users have a comprehensive view of their lead data. This integration streamlines the lead management workflow, saving users time and effort by automating the data transfer process between LinkedIn Ads and Google Sheets.

8s$0.0005