How to Connect TikTok with Google Sheets

The integration will allow you to get new leads from TikTok and transfer them to Google Sheets. This allows you to efficiently automate workflows and save a lot of time by not having to manually add each row to the table.

Navigation:

1. What will integration TikTok with Google Sheets do?
2. How to connect your TikTok account?
3. How to connect your Google Sheets account to?
4. How to set up data transfer to Google Sheets in the selected action? 
5. An example of the data that will be sent to your Google Sheets.
6. Auto-update.

To start setup click "Create Connection".

Select a system as the Data Source. In this case, you must specify TikTok.

Next, you need to specify the system to which the data from the TikTok will be transmitted. In this case, you must specify Google Sheets.

The next step is to select the TikTok account from which SaveMyLeads will get the data.
If there are no account connected to the system, click "Connect account".

Enter your email and password and give all access to work with this account.

When the connected account is displayed in the "active accounts" list, select it for further work.

Select the Advertising Account and Page from the drop-down list and click Continue.

The next step is to select a Google Sheets account to which leads will be sent.

If there are no accounts connected to the system, click "Sing in with Google".

Enter your Google Sheets account login and password and give SaveMyLeads permission to work with this account.

Next click "Select file" and select the file you want to transfer the leads to.

When the connected account is displayed in the "active accounts" list, select it for further work.

Attention! If your account is in the "inactive accounts" list, check your access to this account!

Now you need to assign variables from the Data Source system to the columns of the table you need.

In this section, the fields will be assigned according to the template. You can completely change it or leave it as is.
To add a variable, click on the column field and select the desired variable from the drop-down list. Please note that you can use not only Data Source variables, but also manually entered data.  

Click "Continue" when you're done with assigning fields, but first select the Sheet to which the data will be sent.

Now you see the test data to send to Google Sheets.

Click "Send test data to Google Sheets" and test the table and sheet in Google Sheets.

In order for data from TikTok to be transferred multi-venously to Google Sheets, click "Finish setup".

Note! If you get an "HTTP ERROR 500" error when submitting test data, it means that your table has too many rows. In this case, you need to transfer data to another table or sheet.

On the main screen, click on the gear icon to select name of the connection and select a group for it, if necessary.

When the slider is in the position as shown in the picture - auto-update works. If you want to disable communication, click this slider.

This completes the integration setup between TikTok with Google Sheets! See how easy it is!?

Now you don't have to worry, SaveMyLeads will do everything on its own!