Scrape TikTok Hashtag Metrics to Google Sheets + Gmail Alerts (n8n)

Scrape TikTok Hashtag Metrics to Google Sheets + Get Gmail Alerts (n8n)

Turn 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 Apify’s TikTok Scraper, logs key metrics in Google Sheets, and sends a completion email via Gmail.

What this workflow does

• Receives input: When your n8n Form Trigger is submitted, the workflow captures a TikTok hashtag and an email.
• Creates a new Google Sheet: It generates a new spreadsheet named using the submitted hashtag.
• Scrapes TikTok data: The workflow runs the Apify TikTok Scraper actor (clockworks/tiktok-scraper) for the given hashtag and retrieves the dataset items.
• Extracts key metrics: For each TikTok result, it pulls fields including author name, video URL, views, likes, shares, saves, and comments.
• Appends rows to Google Sheets: It loops through all items and adds each result as a new row.
• Sends a completion email: The workflow waits one minute between batches and then sends a “selesai” completion email via Gmail.

Use cases

• Social media research: Collect competitor or campaign hashtags and quickly compare engagement metrics in Google Sheets.
• Operator dashboards: Run repeatable hashtag scraping jobs from a simple n8n form without manual exporting.
• Campaign monitoring: Trigger a scrape when new hashtag ideas are submitted, then receive a Gmail alert when the sheet is ready.

Technical details (integrations & nodes)

• Form Trigger (captures hashtag + email)
• Google Sheets (OAuth2: create spreadsheet, append rows)
• Apify (TikTok Scraper actor: clockworks/tiktok-scraper, using Apify API token credential)
• Gmail (OAuth2: send completion email)
• Wait node (waits 1 minute between batches)
• Set and Sticky Note nodes

Designed for n8n automation engineers and SaaS operators who need reliable TikTok hashtag scraping with Google Sheets reporting and Gmail notifications.