TikTok Analytics: Scrape, Store, and Notify with Apify, Google Sheets, and Slack

This workflow scrapes TikTok for social media analytics using Apify’s API, storing data in Google Sheets and sending Slack notifications. Key nodes include Execute Workflow Trigger for input, Condition for validation, HTTP Request for Apify scraping, Wait for retry logic, Google Sheets for storage, Aggregate for data collection, and HTTP Request for Slack alerts. To set up, install n8n from n8n.io for self-hosting or sign up at cloud.n8n.io for cloud hosting. Obtain an Apify API key from apify.com under account settings. Create a Google Sheets OAuth2 credential via console.cloud.google.com. Get a Slack webhook URL from your Slack workspace under Apps > Incoming Webhooks. In n8n, import the workflow JSON. Replace “<YOUR_API_KEY>” in HTTP Request nodes (Apify Scraper, Data Retrieval) with your Apify API key. Configure the Google Sheets node with OAuth2 credentials, specifying your spreadsheet ID and sheet name (e.g., “Social Media”). Update the Slack webhook URL in the Notification Center node. Set the Execute Workflow Trigger’s JSON input template (e.g., {hashtag: 'landscaping'}). Ensure the Condition node validates hashtag length (≥2 characters). Test by manually triggering the workflow in n8n with a valid JSON input via the Execute Workflow Trigger. Verify the Success Response node outputs a JSON with status: “success”, data_count, and execution_id. Check Google Sheets for entries (e.g., ID, Hashtag, Caption). Confirm Slack receives a notification with status and metrics. Handle errors like HTTP 401 (invalid Apify API key), validation errors (empty hashtag), or empty data (no results found). Regenerate API keys or check Slack webhook if failures occur. Deploy by activating the workflow in n8n, ensuring valid hashtag inputs. Monitor logs for Apify rate limits or Sheets write failures. Validate the Success Response for structured data with timestamp and hashtag_processed. Ensure Google Sheets data includes Profile and Caption, and Slack notifications reflect accurate data_count.