Telegram Bot: Extract & Store TikTok and LinkedIn Data to Google Sheets with Dumpling AI

Description

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:

Input Processing: Send a message via Telegram (text or voice)
Voice Transcription: If you send a voice note, OpenAI Whisper transcribes it to text
AI Routing: The agent identifies whether it's TikTok or LinkedIn
Profile Scraping: Calls Dumpling AI's specialized scraper for that platform
Data Extraction: Parses the profile metrics and details
Database Storage: Saves all data to the appropriate Google Sheets tab
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
Open Telegram and message @BotFather
Use /newbot command and follow prompts
Save your bot token for later

Step 2: Configure Credentials
Add Telegram bot token to "Receive Telegram Message" node
Add OpenAI API key to "OpenAI Chat Model" and "Transcribe Audio" nodes
Add Dumpling AI credentials as HTTP Header Auth
Connect Google Sheets OAuth2
Connect Gmail OAuth2

Step 3: Set Up Google Sheets
Create a new Google Spreadsheet
Create two tabs: "TikTok" and "LinkedIn"
Add column headers as specified above
Copy the spreadsheet ID from the URL

Step 4: Update Workflow
Replace Google Sheets document ID in both database saver nodes
Update email address in "Send Completion Email" node
Remove personal credential names ("Nneka")

Step 5: Test the Workflow
Activate the workflow
Message your bot with: "Scrape TikTok profile: @charlidamelio"
Or try: "Extract this LinkedIn: https://www.linkedin.com/in/example"
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 followers
Add sentiment analysis on bios and recent posts
Implement automatic categorization/tagging

Notification Improvements:
Send results directly to Telegram instead of email
Add Slack notifications for team collaboration
Create detailed extraction reports with statistics

Batch Processing:
Modify to accept CSV files with multiple profiles
Add rate limiting to avoid API throttling
Implement queue system for large-scale scraping