Telegram bot: extract & store TikTok and LinkedIn data to Google Sheets with Dumpling AI

Who's it for This workflow is perfect for marketers, social media managers, recruiters, sales teams, and researchers who need to collect and organize public profile data from TikTok and LinkedIn. Whether you're building influencer databases, enriching CRM data, conducting competitor research, or gathering prospect information, this workflow automates the entire data extraction and storage process. What it does This AI-powered Telegram bot automatically scrapes public profile data from TikTok and LinkedIn, then saves it directly to Google Sheets. Simply send a TikTok username or LinkedIn profile URL via text or voice message, and the workflow handles everything: For TikTok profiles: - Username and verification status - Follower, following, and friend counts - Total hearts (likes) and video count - Bio link and secure user ID For LinkedIn profiles: - Full name and profile picture - Location and follower count - Bio/about section - Recent posts activity link All data is automatically organized into separate Google Sheets tabs for easy reference and analysis. You receive an email notification when extraction is complete. How it works The workflow uses an AI Agent as an intelligent router that determines which platform to scrape based on your input. Here's the flow: 1. Input Processing: Send a message via Telegram (text or voice) 2. Voice Transcription: If you send a voice note, OpenAI Whisper transcribes it to text 3. AI Routing: The agent identifies whether it's TikTok or LinkedIn 4. Profile Scraping: Calls Dumpling AI's specialized scraper for that platform 5. Data Extraction: Parses the profile metrics and details 6. Database Storage: Saves all data to the appropriate Google Sheets tab 7. Confirmation: Sends an email notification when complete The AI agent ensures proper tool pairing - it always scrapes first, then saves, preventing partial data or errors. Setup Requirements Accounts & Credentials Needed: - Telegram Bot Token (create via @BotFather) - OpenAI API Key (for voice transcription and AI routing) - Dumpling AI API Key (for profile scraping) - Google Sheets OAuth2 credentials - Gmail OAuth2 credentials (for notifications) Google Sheets Structure: Create a spreadsheet with two tabs: TikTok Tab - Columns: - Username - verified - secUid - bioLink - followerCount - followingCount - heartCount - videoCount - friendCount LinkedIn Tab - Columns: - name - image - location - followers - about - recentPosts link How to set up Step 1: Create Telegram Bot 1. Open Telegram and message @BotFather 2. Use /newbot command and follow prompts 3. Save your bot token for later Step 2: Configure Credentials 1. Add Telegram bot token to "Receive Telegram Message" node 2. Add OpenAI API key to "OpenAI Chat Model" and "Transcribe Audio" nodes 3. Add Dumpling AI credentials as HTTP Header Auth 4. Connect Google Sheets OAuth2 5. Connect Gmail OAuth2 Step 3: Set Up Google Sheets 1. Create a new Google Spreadsheet 2. Create two tabs: "TikTok" and "LinkedIn" 3. Add column headers as specified above 4. Copy the spreadsheet ID from the URL Step 4: Update Workflow 1. Replace Google Sheets document ID in both database saver nodes 2. Update email address in "Send Completion Email" node 3. Remove personal credential names ("Nneka") Step 5: Test the Workflow 1. Activate the workflow 2. Message your bot with: "Scrape TikTok profile: @charlidamelio" 3. Or try: "Extract this LinkedIn: https://www.linkedin.com/in/example" 4. Check your Google Sheets for the data How to customize Add More Social Platforms: Create new scraper/saver tool pairs for Instagram, Twitter/X, or YouTube by: - Adding new HTTP Request Tool nodes for scraping - Adding corresponding Google Sheets Tool nodes - Updating the AI Agent's system prompt with new protocols Enhance Voice Input: - Add language detection for multilingual voice notes - Implement speaker identification for team usage - Add voice response capability Advanced Data Enrichment: - Chain multiple profile lookups for follower