Scrape TikTok Influencer Profiles with Bright Data API to Google Sheets

# TikTok Influencer Scraper (URL Input) via Bright Data + n8n & Sheets A comprehensive n8n automation that scrapes TikTok influencer profiles using Bright Data's TikTok dataset and automatically saves detailed profile information to Google Sheets. ## Overview This workflow provides an automated TikTok influencer data collection solution that scrapes comprehensive profile information and saves it to Google Sheets. Perfect for influencer marketing research, competitor analysis, social media monitoring, and marketing campaign planning. ## Key Features - **Form-Based Input**: Simple web form to submit TikTok profile URLs - **Bright Data Integration**: Uses Bright Data's TikTok dataset for reliable scraping - **Status Monitoring**: Intelligent polling system to check scraping progress - **Retry Logic**: Automatic retry mechanism with 30-second intervals - **Data Extraction**: Comprehensive profile data including engagement metrics - **Google Sheets Storage**: Automatic data storage and organization - **Error Handling**: Built-in error handling and status reporting - **Custom Fields**: Configurable output fields for specific data needs ## What This Workflow Does ### Input - **Profile URLs**: TikTok profile URLs submitted through web form - **Custom Fields**: Configurable data fields for extraction - **Country Settings**: Geo-targeting for accurate data collection ### Processing 1. **Form Submission**: User submits TikTok profile URL through web form 2. **API Trigger**: Sends profile data to Bright Data for scraping 3. **Status Polling**: Continuously checks scraping progress 4. **Wait & Retry**: Implements 30-second delays between status checks 5. **Data Retrieval**: Fetches complete profile data when ready 6. **Sheet Update**: Saves extracted data to Google Sheets 7. **Status Reporting**: Provides completion status and messages ### Output Data Points | Field | Description | Example | |-------|-------------|---------| | Account ID | Unique TikTok account identifier | @username123 | | Nickname | Display name on profile | John Doe | | Biography | Profile bio/description | Content creator & influencer | | Followers | Number of followers | 1,250,000 | | Following | Number of accounts following | 500 | | Likes | Total likes across all videos | 50,000,000 | | Videos Count | Total number of videos posted | 1,200 | | Profile URL | Direct link to TikTok profile | https://www.tiktok.com/@username | | Profile Picture | Profile image URL | https://p16-sign-sg.tiktokcdn.com/... | | Profile Picture HD | High-definition profile image | https://p16-sign-sg.tiktokcdn.com/... | | Is Verified | Verification status | true/false | | Bio Link | External link in bio | https://linktr.ee/username | | Like Engagement Rate | Engagement rate based on likes | 5.2% | | Comment Engagement Rate | Engagement rate based on comments | 2.1% | | Top Videos | List of top performing videos | [video_objects] | | Region | Geographic region | US | | Is Under Age 18 | Age status indicator | true/false | ## Setup Instructions ### Prerequisites - n8n instance (self-hosted or cloud) - Google account with Sheets access - Bright Data account with TikTok dataset access - Valid TikTok profile URLs for testing - 10-15 minutes for setup ### Step 1: Import the Workflow 1. Copy the JSON workflow code from the provided file 2. In n8n: **Workflows** → **+ Add workflow** → **Import from JSON** 3. Paste JSON and click **Import** ### Step 2: Configure Bright Data 1. **Set up Bright Data credentials:** - In n8n: **Credentials** → **+ Add credential** → **HTTP Request Generic Credential** - Name: Bright Data API - Authentication: Bearer Token - Token: Your Bright Data API key - Test the connection 2. **Configure dataset:** - Ensure you have access to TikTok dataset (`gd_l1villgoiiidt09ci`) - Verify dataset permissions in Bright Data dashboard - Check dataset limits and pricing ### Step 3: Configure Google Sheets Integration 1. **Create a Google Sheet:** - Go to Google Sheets - Create a new spreadsheet named TikTok Influencer Data - Create a sheet tab named TikTok profile by URL - Copy the Sheet ID from URL: `https://docs.google.com/spreadsheets/d/SHEET_ID_HERE/edit` 2. **Set up Google Sheets credentials:** - In n8n: **Credentials** → **+ Add credential** → **Google Sheets OAuth2 API** - Complete OAuth setup and test connection 3. **Prepare your data sheet with columns:** - Column A: Account ID - Column B: Nickname - Column C: Biography - Column D: Followers - Column E: Following - Column F: Likes - Column G: Videos Count - Column H: Profile URL - Column I: Is Verified - Column J: Bio Link - Column K: Like Engagement Rate - Column L: Comment Engagement Rate - Column M: Region - Column N: Status - Column O: Message ### Step 4: Update Workflow Settings 1. **Update API credentials:** - Open Sends profile URLs to Bright Data to trigger

Platform

n8n

Category

Social Media

Price

Free

Creator

ankitkansaldev

• if
• wait
• stickyNote
• formTrigger
• httpRequest
• googleSheets