{"product_id":"scrape-tiktok-hashtag-metrics-to-google-sheets-gmail-alerts-n8n","title":"Scrape TikTok Hashtag Metrics to Google Sheets + Gmail Alerts (n8n)","description":"\u003ch3\u003eScrape TikTok Hashtag Metrics to Google Sheets + Get Gmail Alerts (n8n)\u003c\/h3\u003e\n\u003cp\u003eTurn any TikTok hashtag submission into a ready-to-analyze Google Sheet—automatically. This n8n workflow collects a hashtag from a form, scrapes matching TikTok videos using \u003cstrong\u003eApify’s TikTok Scraper\u003c\/strong\u003e, logs key metrics in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends a completion email via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives input\u003c\/strong\u003e: When your \u003cem\u003en8n Form Trigger\u003c\/em\u003e is submitted, the workflow captures a TikTok \u003cstrong\u003ehashtag\u003c\/strong\u003e and an \u003cstrong\u003eemail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a new Google Sheet\u003c\/strong\u003e: It generates a new spreadsheet named using the submitted hashtag.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrapes TikTok data\u003c\/strong\u003e: The workflow runs the \u003cstrong\u003eApify TikTok Scraper actor\u003c\/strong\u003e (clockworks\/tiktok-scraper) for the given hashtag and retrieves the dataset items.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts key metrics\u003c\/strong\u003e: For each TikTok result, it pulls fields including \u003cstrong\u003eauthor name\u003c\/strong\u003e, \u003cstrong\u003evideo URL\u003c\/strong\u003e, \u003cstrong\u003eviews\u003c\/strong\u003e, \u003cstrong\u003elikes\u003c\/strong\u003e, \u003cstrong\u003eshares\u003c\/strong\u003e, \u003cstrong\u003esaves\u003c\/strong\u003e, and \u003cstrong\u003ecomments\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends rows to Google Sheets\u003c\/strong\u003e: It loops through all items and adds each result as a new row.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a completion email\u003c\/strong\u003e: The workflow waits one minute between batches and then sends a “\u003cstrong\u003eselesai\u003c\/strong\u003e” completion email via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSocial media research\u003c\/strong\u003e: Collect competitor or campaign hashtags and quickly compare engagement metrics in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOperator dashboards\u003c\/strong\u003e: Run repeatable hashtag scraping jobs from a simple n8n form without manual exporting.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCampaign monitoring\u003c\/strong\u003e: Trigger a scrape when new hashtag ideas are submitted, then receive a Gmail alert when the sheet is ready.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details (integrations \u0026amp; nodes)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eForm Trigger\u003c\/strong\u003e (captures hashtag + email)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (OAuth2: create spreadsheet, append rows)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify\u003c\/strong\u003e (TikTok Scraper actor: \u003cem\u003eclockworks\/tiktok-scraper\u003c\/em\u003e, using Apify API token credential)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e (OAuth2: send completion email)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWait\u003c\/strong\u003e node (waits 1 minute between batches)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSet\u003c\/strong\u003e and \u003cstrong\u003eSticky Note\u003c\/strong\u003e nodes\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eDesigned for n8n automation engineers and SaaS operators who need reliable \u003cstrong\u003eTikTok hashtag scraping\u003c\/strong\u003e with \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e reporting and \u003cstrong\u003eGmail\u003c\/strong\u003e notifications.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45758752719027,"sku":"N8N-17790","price":49.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/CEJgvnWe1_6MamSN6N1XL_JKH5jl58.png?v=1785834389","url":"https:\/\/buyflowscripts.com\/products\/scrape-tiktok-hashtag-metrics-to-google-sheets-gmail-alerts-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}