See llms.txt for all machine-readable content.

Back to Templates

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

Created by

Created by: Charbel || scrapelads
Charbel

Last update

Last update 3 days ago

Categories

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

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

Setup

  1. Create an Apify API token and add an HTTP Header Auth credential with Authorization: Bearer <YOUR_APIFY_TOKEN> for the Apify request.
  2. Update the search settings (keywords/hashtags, min/max followers, max results, and email-only filtering) to match your targeting.
  3. 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