{"product_id":"export-tiktok-profiles-to-google-sheets-with-apify-fetchcat","title":"Export TikTok Profiles to Google Sheets with Apify FetchCat","description":"\u003ch3\u003eExport TikTok profile data to Google Sheets automatically—deduplicated and refreshable\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls public TikTok profile metrics using \u003cstrong\u003eApify FetchCat (fetch_cat\/tiktok-profile-scraper)\u003c\/strong\u003e and writes a clean, updated table into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, matching on \u003cstrong\u003eTikTok handle\u003c\/strong\u003e so you don’t create duplicates.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand or daily at 09:00\u003c\/strong\u003e (manual trigger or scheduled execution).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads a list of TikTok handles or profile URLs\u003c\/strong\u003e, applies a `maximum batch size`, and then \u003cstrong\u003evalidates and deduplicates\u003c\/strong\u003e the inputs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds the Apify actor input\u003c\/strong\u003e for the actor \u003cstrong\u003efetch_cat\/tiktok-profile-scraper\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts the Apify run\u003c\/strong\u003e and waits for it to finish.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads the resulting dataset items\u003c\/strong\u003e from Apify for the requested number of profiles.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes the profile data\u003c\/strong\u003e into human-readable Google Sheets fields (including dates, numeric metrics, and clickable profile\/bio links).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends or updates rows\u003c\/strong\u003e in your spreadsheet by matching on \u003cstrong\u003e“TikTok handle”\u003c\/strong\u003e, refreshing existing creators instead of duplicating them.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInfluencer research:\u003c\/strong\u003e keep a live list of creator performance signals in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompetitive tracking:\u003c\/strong\u003e re-scan known TikTok accounts daily\/weekly and update metrics.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS ops \u0026amp; reporting:\u003c\/strong\u003e maintain a consistent dataset for downstream analysis without manual exports.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e set, code, sticky note, http request, google sheets, manual trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e uses an Apify API token via \u003cem\u003eHTTP Header Auth\u003c\/em\u003e (Authorization: \u003cstrong\u003eBearer YOUR_APIFY_TOKEN\u003c\/strong\u003e) in the Apify HTTP Request steps.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets template:\u003c\/strong\u003e start from the provided spreadsheet template and use \u003cstrong\u003eFile \u0026gt; Make a copy\u003c\/strong\u003e to save your own copy in Google Drive.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eResult:\u003c\/strong\u003e an SEO-friendly, automation-ready Google Sheets dataset of TikTok profiles, updated via \u003cstrong\u003eApify FetchCat\u003c\/strong\u003e on a schedule or whenever you need it.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45748947943603,"sku":"N8N-17676","price":42.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/WOuPSSDFsRlqstbZkgrLk_gL8ngLhw.png?v=1785575738","url":"https:\/\/buyflowscripts.com\/products\/export-tiktok-profiles-to-google-sheets-with-apify-fetchcat","provider":"N8N Commerce","version":"1.0","type":"link"}