How to integrate TikTok Lead Generation with Google Sheets
The key benefits of integrating Customer Relationship Management (CRM) systems with TikTok lead generation are:
Real-time lead updates directly in your CRM.
The ability to follow up with gathered leads immediately, increasing your chances of conversion.
Only having to integrate once and continue to receive leads.
Learn more about available CRM integrations for TikTok lead generation with instant form.
Note: This feature is not available to all advertisers yet.
Before you begin
Before you integrate TikTok lead generation with Google Sheets, make sure you have:
Your Google Drive login credentials and editor access to the specific Google Sheets for integration.
A TikTok Ads Manager account and admin access to that account.
At least one instant form in your TikTok Ads Manager.
Learn how to create an instant form in TikTok Ads Manager.
Note: You don't have to have a live campaign to create an instant form.
How to integrate TikTok lead generation with Google Sheets
To integrate TikTok lead generation with Google Sheets:
There are 3 options to access the Google Sheets integration in TikTok Ads Manager:
Select the Tools tab, select Leads, and click Connect CRM.
Select the Campaign tab, go to the Ad section, and then click on Download Lead Data from the Download Leads column on the table.
Select the Tools tab, choose Instant Page under the Creative section, select instant form, and click on Download Lead Data under the form.
Search Google Sheets or find it in the list of CRM options.
Click TikTok direct integration.
Click Apply for Permission under your TikTok Account.
Select Sign into Google Sheets to be directed to the pop-up window for sign-in.
Click Next to continue.
Choose the TikTok instant form you want to connect to your Google Sheets.
Click Choose a spreadsheet from your Google Drive. You will be directed to a pop-up window to select the specific spreadsheet where you want to receive leads from TikTok.
Select the specific worksheet or tab within your Google Spreadsheet in the worksheet dropdown
After selecting your Google Worksheet, the field mapping section will automatically appear below to match your worksheet headers with your TikTok instant form question fields.
Click Next.
If you’ve changed your spreadsheet headers after entering this page, you can click Refresh fields so that the Google Sheets data column is updated. You can match all or a specific number of fields.
You have now set up your Google Sheets direct integration. Click View leads to go to your connected Google Account, or Send test data to test out the integration.
You can, optionally, send a real, customized test lead when previewing a lead generation form under Assets.
Note: Only new leads created after setting up the integration can be synced. You can download past leads and then import them to your CRM.
If you want to connect more than one Google Sheet, you can go back to Connect to CRM to select another Google Sheet and form. You can also connect more than one form to a single Google Sheet, but the leads collected from a particular form can't be sent to multiple sheets.