Quick overview
Quick overview This workflow runs manually or daily at 09:00, scrapes public TikTok profile data via the Apify FetchCat TikTok Profile Scraper actor, and writes a clean, deduplicated table of metrics and account signals to Google Sheets, updating existing rows by handle. How it works Runs on a manual trigger or every day at 09:00 on a schedule. Reads a list of TikTok handles or profile URLs and a maximum batch size, then validates, deduplicates, and builds the Apify actor input. Starts an Apify Actor run using FetchCat TikTok Profile Scraper and waits for it to finish. Downloads the resulting dataset items from Apify for the requested number of profiles. Normalizes the profile data into human-readable Google Sheets fields (dates, numeric metrics, and clickable profile/bio links). Appends or updates rows in Google Sheets, matching on “TikTok handle” to refresh existing creators instead of creating duplicates. Setup Add FetchCat TikTok Profile Scraper to your Apify account and create an API token. In n8n, create an HTTP Header Auth credential with header Authorization and value Bearer YOUR_APIFY_TOKEN, then select it in both Apify HTTP Request steps. Open the TikTok Profiles spreadsheet template. In Google Sheets, choose File > Make a copy and save your own copy in Google Drive. Do not request edit access to the public template. Connect your Google Sheets account in n8n, then select your copied spreadsheet and its “TikTok Profiles” tab in the final Google Sheets step. The copied sheet already contains the required columns and formatting. Edit the profile list and Maximum Profiles Per Run value in the input step. Run the workflow manually first, confirm rows appear in your copied sheet, then publish it to enable the daily schedule. Requirements An Apify account with FetchCat TikTok Profile Scraper; an Apify API token; a Google account; and n8n Cloud or self-hosted n8n with Google Sheets access. Customization Change the TikTok handles or profile URLs, Maximum Profiles Per Run limit (1–500), daily run time, destination spreadsheet, or mapped output columns. Additional info Make your own copy of the TikTok Profiles spreadsheet template before running the workflow. Connect n8n to your copied spreadsheet; the public template is a read-only starting point and should not be used as the workflow destination. An n8n automation workflow template by Hanna Nosova.
Hanna Nosova
web
free
Others in the same category, ranked by how often they are opened.
