Import TikTok Data to Google Sheets (RapidAPI)

In this guide, we will walk through how to pull data from TikTok to Google Sheets, using the ScrapTik API from RapidAPI and the API Connector add-on for Sheets.

ScrapTik is a service that scrapes public data out of TikTok and packages it into an API, and RapidAPI is the marketplace which provides access to ScrapTik (and thousands of other APIs). Fetching data this way is quite a bit easier than fetching it from the official TikTok API.

Contents

• Before You Begin
• Part 1: Subscribe to the ScrapTik API
• Part 2: Create your API Request
• Part 3: Pull TikTok API Data into Sheets
• Part 4: Notes
• Part 5: API Documentation

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Subscribe to the ScrapTik API

1. Create an account at RapidAPI and log in. While logged in, navigate to the ScrapTik API located at https://rapidapi.com/scraptik-api-scraptik-api-default/api/scraptik/
   
2. Click Subscribe to Test
   
3. You will now see a list of pricing plans. Click Subscribe on plan for which you'd like to subscribe.
   
4. Whichever plan you choose (even the free one), you'll need to enter your credit card details at this point, and can then return to the list of endpoints.
   

Part 2: Create Your API Request

1. Available endpoints are listed in the lefthand sidebar. Select an endpoint, e.g. Get User.
2. In the center section, scroll down and fill out any parameters of interest. For example, under Get User, you can enter a username.
   
   
3. Now click the Code Snippets tab, and choose (Shell) cURL from the dropdown. Click Copy Code to grab the entire curl snippet; we'll use that next.
   

Part 3: Pull TikTok API Data into Sheets

We can now enter this cURL snippet into API Connector using API Connector's cURL import tool.

1. Open up Google Sheets and click Extensions > API Connector > Import/Export > Import cURL
2. Paste in the cURL snippet we retrieved above. Click Import.
   
3. You'll see the entire request pre-configured in the sidebar.
4. Create a new tab and click Set current to use that tab as your data destination.
5. Name your request and click Run. A moment later you’ll see the response from the unofficial TikTok API appear in your sheet.
   

Part 4: Notes

1. If you want to grab the associated images, you can use Google Sheets' native IMAGE() function.
   
   
2. Play around with the endpoint list in the left pane in RapidAPI to retrieve other information like expiring releases, country IDs, title details, etc. Each time you click an endpoint, the new URL will appear in the code snippet box, where you can copy and paste it into API Connector.
3. RapidAPI offers thousands of APIs on their platform, for all different categories and interests, so check out their other APIs too.

Part 5: API Documentation

ScrapTik TikTok API documentation: https://rapidapi.com/scraptik-api-scraptik-api-default/api/scraptik