Find TikTok creator leads with Apify and save them to Google Sheets

Description

Quick overview
This workflow searches TikTok creators by keyword or hashtag using Apify’s TikTok Profile Scraper, filters for profiles within a follower range that include a contact email, and upserts the resulting creator leads into a Google Sheets document deduplicated by username.

How it works
Runs manually to start the lead collection.
Sets the search keywords/hashtags, follower range, maximum results, and whether to only keep creators with an email.
Calls Apify’s TikTok Profile Scraper actor via the Apify API to fetch matching TikTok profile results with enriched bio links.
Extracts lead fields such as username, display name, followers, average likes per post, email, bio, social links, profile URL, and the keyword source.
Appends or updates rows in Google Sheets, matching on the username column to avoid duplicates.

Setup
Create an Apify API token and add an HTTP Header Auth credential with Authorization: Bearer for the Apify request.
Update the search settings (keywords/hashtags, min/max followers, max results, and email-only filtering) to match your targeting.
Connect Google Sheets, set the target spreadsheet and sheet, and ensure the sheet has a header row that includes username as the matching column.

Requirements
Apify account and API token (pay per result, free tier available)
Google Sheets credential with edit access to the target spreadsheet
A sheet with a header row including a "username" column

Customization
Swap the follower range and keywords on the settings node to target a different niche.
Replace the Google Sheets node with Airtable, Notion or a database if you don't use Sheets.
Add a Schedule trigger to refresh the lead list weekly.

Additional info
Uses the TikTok Profile Scraper actor: https://apify.com/scrape-lads/tiktok-profile-scraper
More data tools: https://scrapelads.com