January 22, 2026

Telegram to Google Sheets, clean TikTok and LinkedIn

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Building a list of TikTok creators or LinkedIn prospects sounds simple until you’re 30 profiles deep, juggling tabs, reformatting URLs, and second-guessing whether you copied the right follower count.

This hits marketers hardest, but recruiters and sales teams feel it too. With this Telegram Sheets automation, you send a handle or profile link in Telegram and it lands in Google Sheets as a clean, structured row.

No more “I’ll fix the sheet later.” You’ll see how the workflow routes TikTok vs. LinkedIn, extracts the right fields, and logs everything where your team actually works.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Telegram to Google Sheets, clean TikTok and LinkedIn

Click to explore

flowchart LR

    subgraph sg0["Receive Telegram Message Flow"]
        direction LR
        n0@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model", pos: "b", h: 48 }
        n1@{ icon: "mdi:web", form: "rounded", label: "tiktok_profile_scraper", pos: "b", h: 48 }
        n2@{ icon: "mdi:database", form: "rounded", label: "tiktok_database_saver", pos: "b", h: 48 }
        n3@{ icon: "mdi:web", form: "rounded", label: "linkedin_profile_scraper", pos: "b", h: 48 }
        n4@{ icon: "mdi:database", form: "rounded", label: "linkedin_database_saver", pos: "b", h: 48 }
        n5["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/telegram.svg' width='40' height='40' /></div><br/>Receive Telegram Message"]
        n6@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Check for Voice Message", pos: "b", h: 48 }
        n7["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/telegram.svg' width='40' height='40' /></div><br/>Fetch Voice File from Telegram"]
        n8@{ icon: "mdi:robot", form: "rounded", label: "Transcribe Audio with Whisper", pos: "b", h: 48 }
        n9@{ icon: "mdi:swap-vertical", form: "rounded", label: "Format Transcription", pos: "b", h: 48 }
        n10@{ icon: "mdi:swap-vertical", form: "rounded", label: "Format Text Message", pos: "b", h: 48 }
        n11@{ icon: "mdi:robot", form: "rounded", label: "Social Media Extraction Agent", pos: "b", h: 48 }
        n12@{ icon: "mdi:message-outline", form: "rounded", label: "Send Completion Email", pos: "b", h: 48 }
        n0 -.-> n11
        n10 --> n11
        n9 --> n11
        n2 -.-> n11
        n1 -.-> n11
        n6 --> n7
        n6 --> n10
        n4 -.-> n11
        n5 --> n6
        n3 -.-> n11
        n11 --> n12
        n8 --> n9
        n7 --> n8
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n5 trigger
    class n8,n11 ai
    class n0 aiModel
    class n6 decision
    class n2,n4 database
    class n1,n3 api
    classDef customIcon fill:none,stroke:none
    class n5,n7 customIcon

The Problem: Messy Profile Data Ruins Your Lists

When you’re collecting profiles for influencer outreach, competitor research, or lead enrichment, the sheet is the source of truth. Except it rarely stays truthful. Someone pastes a TikTok handle without the “@”. Another person grabs an old LinkedIn URL that redirects. Follower counts get typed by hand, bios get chopped, and profile pictures never make it in. Then you try to segment creators by reach or filter prospects by location and… it’s chaos. Honestly, the worst part is the doubt: you’re never fully sure your list is accurate.

The friction compounds. Here’s where it breaks down in real life.

Copy-pasting from TikTok and LinkedIn forces you to format data twice, once for capture and again for analysis.
Manual entry invites small errors that become big ones when you’re sending outreach or reporting results.
Teams collect data in different places, so the “final” sheet turns into five versions floating around.
Voice notes and quick messages get ignored because nobody has time to turn them into structured rows.

The Solution: Send a Profile in Telegram, Log It Cleanly

This workflow turns Telegram into your intake inbox for TikTok and LinkedIn profile research. You send either a TikTok username (like @creatorname) or a LinkedIn profile URL, and the automation handles the rest. If the message is a voice note, it gets transcribed first. Then an AI agent figures out which platform you meant, triggers the correct scraper, and pulls the public profile details you actually need for analysis. Finally, it writes a clean, consistent row into the right Google Sheets tab (TikTok or LinkedIn), and sends a completion email so you know it finished. One input. Structured output.

The workflow starts with a Telegram message (text or voice). From there, OpenAI handles transcription and routing logic, Dumpling AI scrapes the profile, and Google Sheets receives the final row. Gmail sends the confirmation once the data is safely stored.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

Accepts TikTok handles or LinkedIn URLs directly inside Telegram.
Transcribes voice notes into text using OpenAI Whisper.
Routes to the correct scraper automatically (TikTok vs. LinkedIn) with an AI agent.
Writes the extracted fields into the correct Google Sheets tab with consistent columns.

Most teams get about 2 hours back each week once the list grows.
Cleaner rows, which means sorting and filtering actually works.
Far fewer “wrong profile” mistakes when you start outreach.
A reliable TikTok and LinkedIn database you can reuse for future campaigns.
Faster handoffs between research, outreach, and reporting because everyone shares one sheet.

Example: What This Looks Like

Say you’re building a list of 40 TikTok creators and 20 LinkedIn prospects for a campaign. Manually, even a “quick” capture is maybe 5 minutes per profile once you copy follower counts, bios, links, and paste everything into the right columns, so you’re looking at about 5 hours of busywork. With this workflow, you can drop each handle or URL into Telegram in a few seconds and let it run. Even if you budget about 1 minute per profile to submit and sanity-check, you’ve turned half a day of copy-paste into a short batch you can do between calls.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Telegram to receive handles, links, and voice notes.
Google Sheets to store TikTok and LinkedIn rows.
OpenAI API Key (get it from your OpenAI dashboard).
Dumpling AI API Key (get it from your Dumpling AI account).
Gmail to send the “done” notification email.

Skill level: Intermediate. You’ll connect accounts, paste a spreadsheet ID, and verify the column headers match.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A Telegram message triggers the run. You send a TikTok handle or a LinkedIn URL to your bot. If it’s text, it moves straight into processing.

Voice notes get transcribed. When the workflow detects audio, it pulls the voice file from Telegram and uses OpenAI Whisper to turn it into usable text.

An AI agent chooses the right scraper. The “Social Data Extraction Agent” looks at the content and decides if it should fetch TikTok profile metrics or LinkedIn profile details, then calls the matching Dumpling AI-powered HTTP request tool.

Google Sheets receives a clean row and Gmail confirms it. TikTok data goes to the TikTok tab with fields like followerCount and videoCount, while LinkedIn data goes to the LinkedIn tab with fields like location and recentPosts link. After the write succeeds, a completion email is sent so you don’t have to keep checking the sheet.

You can easily modify the fields you store to match your research goals (for example, add tags or a campaign name column). See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Telegram Trigger

Set up the trigger that listens for incoming Telegram messages (text or voice) and downloads media if present.

Add Telegram Message Intake as your trigger.
In Telegram Message Intake, set Updates to message and enable Download in Additional Fields.
Credential Required: Connect your telegramApi credentials in Telegram Message Intake.

Flowpast Branding is a visual sticky note and does not affect execution.

Step 2: Configure Voice/Text Routing

Route voice messages to transcription, and text messages directly to the agent pipeline.

Open Voice Message Check and set the condition to check Exists for {{ $json.message.voice }}.
Connect Telegram Message Intake → Voice Message Check.
Ensure the True path from Voice Message Check connects to Retrieve Voice File, and the False path connects to Map Text Content.

Voice Message Check routes voice input to Retrieve Voice File and text input to Map Text Content, so only one branch runs per message.

Step 3: Set Up Audio Transcription and Text Mapping

Transcribe voice messages and normalize both voice and text into a shared Text field for the agent.

In Retrieve Voice File, set Resource to file and File ID to {{ $json.message.voice.file_id }}.
Credential Required: Connect your telegramApi credentials in Retrieve Voice File.
In Whisper Audio Transcription, set Resource to audio and Operation to transcribe.
Credential Required: Connect your openAiApi credentials in Whisper Audio Transcription.
In Map Voice Text, create the field Text with value {{ $json.text }}.
In Map Text Content, create the field Text with value {{ $json.message.text }}.

Step 4: Set Up Social Data Extraction Agent

Configure the AI agent to detect TikTok or LinkedIn requests, call scraping tools, and save results to Google Sheets.

In Social Data Extraction Agent, set Text to User message: {{ $json.Text }} and keep Prompt Type as define.
Attach OpenAI Chat Engine as the language model and set Model to gpt-4.1-mini.
Credential Required: Connect your openAiApi credentials in OpenAI Chat Engine.
Connect both Map Voice Text and Map Text Content into Social Data Extraction Agent.
Add the tools TikTok Profile Fetcher, TikTok Sheet Recorder, LinkedIn Profile Fetcher, and LinkedIn Sheet Recorder to Social Data Extraction Agent as AI tools.
Credential Required: Connect your httpHeaderAuth credentials for TikTok Profile Fetcher and LinkedIn Profile Fetcher in the parent Social Data Extraction Agent tool setup.
Credential Required: Connect your googleSheetsOAuth2Api credentials for TikTok Sheet Recorder and LinkedIn Sheet Recorder in the parent Social Data Extraction Agent tool setup.

Step 5: Configure Data Storage and Notifications

Define the scraping endpoints, map the output fields, and notify when extraction is complete.

In TikTok Profile Fetcher, set URL to https://app.dumplingai.com/api/v1/get-tiktok-profile and Method to POST, with body parameter handle set to {{ /*n8n-auto-generated-fromAI-override*/ $fromAI('parameters0_Value', ``, 'string') }}.
In LinkedIn Profile Fetcher, set URL to https://app.dumplingai.com/api/v1/linkedin/profile and Method to POST, with body parameter url set to {{ /*n8n-auto-generated-fromAI-override*/ $fromAI('parameters0_Value', ``, 'string') }}.
In TikTok Sheet Recorder, set Operation to append, Sheet Name to gid=0 (TikTok), and map the fields using the existing expressions (e.g., {{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Username', ``, 'string') }}).
In LinkedIn Sheet Recorder, set Operation to append, Sheet Name to 1956409676 (LinkedIn), and map the fields using the existing expressions (e.g., {{ /*n8n-auto-generated-fromAI-override*/ $fromAI('name', ``, 'string') }}).
Set Document ID in both sheet recorder nodes to your Google Sheet (replace [YOUR_ID]).
In Dispatch Completion Email, set Send To to [YOUR_EMAIL], Subject to Extraction complete, and Message to Extraction complete. I have scraped the profile and successfully saved all data points to your spreadsheet.
Credential Required: Connect your gmailOAuth2 credentials in Dispatch Completion Email.

⚠️ Common Pitfall: Replace [YOUR_EMAIL] and [YOUR_ID] placeholders before testing, or the workflow will fail to send notifications or write to Sheets.

Step 6: Test and Activate Your Workflow

Validate the end-to-end flow with a test message, then activate for production use.

Click Execute Workflow and send a Telegram message to your bot with either a TikTok username or a LinkedIn URL.
For voice tests, send a voice note and confirm Whisper Audio Transcription produces text and that Map Voice Text passes it to Social Data Extraction Agent.
Verify that the agent calls the appropriate tools and appends a new row in the matching Google Sheet.
Confirm the email from Dispatch Completion Email arrives with subject Extraction complete.
Toggle the workflow to Active to begin processing live Telegram messages.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Google Sheets credentials can expire or need specific permissions. If things break, check the n8n Credentials panel and confirm the connected Google account still has edit access to the spreadsheet.
If you’re leaning on audio input, transcription and scraping times vary. If a downstream node receives an empty value, increase the wait time (or avoid sending very long voice notes).
The AI Agent prompt determines routing behavior. If your team sends shorthand like “LI: john smith” or messy URLs, tighten the system prompt early or you’ll be cleaning misrouted runs later.

Frequently Asked Questions

How long does it take to set up this Telegram Sheets automation?

About 30 minutes if your keys and Google Sheet are ready.

Do I need coding skills to automate Telegram to Google Sheets logging?

No. You’ll mainly connect accounts and paste in your spreadsheet ID.

Is n8n free to use for this Telegram Sheets automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs and Dumpling AI scraping costs.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this Telegram Sheets automation workflow for adding Instagram profiles too?

Yes, but you’ll want to do it deliberately. Add a new HTTP Request scraping tool for Instagram, add a matching Google Sheets recorder node (new tab, new columns), then update the Social Data Extraction Agent instructions so it always follows the same pattern: scrape first, then save. Common customizations include tagging rows with a campaign name, adding an “owner” column for assignment, and sending the results back to Telegram instead of email.

Why is my Telegram connection failing in this workflow?

Usually it’s the bot token. Regenerate it in @BotFather and update it in the Telegram Message Intake node credentials. Also confirm the bot is added correctly and you’re messaging the right bot, not a personal account chat. If voice notes are failing but text works, the “Retrieve Voice File” node often needs permission to fetch files for that bot session.

How many profiles can this Telegram Sheets automation handle?

Practically, hundreds per day for most small teams.

Is this Telegram Sheets automation better than using Zapier or Make?

For profile scraping and AI routing, n8n is usually a better fit because it handles branching logic cleanly, supports self-hosting for high volume, and makes it easier to keep the “scrape then save” sequence consistent. Zapier or Make can work, but the moment you add voice transcription, conditional routing, and two different data schemas (TikTok vs. LinkedIn), it gets fiddly and can get expensive. n8n also gives you more control over retries and data shaping, which matters when you care about clean rows. If you’re only logging plain text into one sheet tab, the simpler tools can be fine. Talk to an automation expert if you want a quick recommendation based on your volume.

Once this is running, your list stops being a fragile spreadsheet and starts acting like a system. The workflow handles the repetitive capture so you can focus on decisions, outreach, and results.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": "",
"meta": {
"instanceId": "ab9f3c6fc6ead73e14a51f5ad898323bcd0475f7d519610288e537eb4b2ecb0a"
},
"name": "Automated Social Profile Data Extraction",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-11546",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 1384,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "3cc2bb52-55ba-4c86-bb00-083a321fa3f8",
"name": "Telegram Message Intake",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
1284,
226
],
"webhookId": "5e72112e-15da-4d37-919b-fbf6900a0d5b",
"parameters": {
"updates": [
"message"
],
"additionalFields": {
"download": true
}
},
"credentials": {
"telegramApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "3b8636d6-5473-4a31-8963-b9c25ae45131",
"name": "Voice Message Check",
"type": "n8n-nodes-base.if",
"position": [
1035,
258
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "a32a6a89-05c5-468e-af62-10d6229e84d0",
"operator": {
"type": "object",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.message.voice }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "8f3e957f-a0fd-4a84-9dbe-97523596f9cc",
"name": "Retrieve Voice File",
"type": "n8n-nodes-base.telegram",
"position": [
810,
172
],
"webhookId": "8ad24c26-6620-4990-b6fb-853315f8112b",
"parameters": {
"fileId": "={{ $json.message.voice.file_id }}",
"resource": "file",
"additionalFields": []
},
"credentials": {
"telegramApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "4c5feeb1-84f3-4a9a-955a-bc91b2304fcf",
"name": "Whisper Audio Transcription",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
584,
136
],
"parameters": {
"options": [],
"resource": "audio",
"operation": "transcribe"
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.8
},
{
"id": "7fd25573-e8e0-4202-a52f-690bbe283035",
"name": "Map Voice Text",
"type": "n8n-nodes-base.set",
"position": [
370,
120
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "00b6d8f5-3303-4cbc-8ed7-c3f96ff5fbe3",
"name": "Text",
"type": "string",
"value": "={{ $json.text }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "0479485a-d08e-4318-9981-c84749f08aed",
"name": "Map Text Content",
"type": "n8n-nodes-base.set",
"position": [
824,
400
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "9432a30e-67a3-4073-81a9-d5f96a1572bd",
"name": "Text",
"type": "string",
"value": "={{ $json.message.text }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "c2061e4b-f957-4ae0-9062-db845f7ededc",
"name": "Social Data Extraction Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
538,
306
],
"parameters": {
"text": "=User message: {{ $json.Text }}",
"options": {
"systemMessage": "You are the \"Social Data Miner,\" a specialized AI agent responsible for extracting profile data from social media platforms and archiving it into a database (Google Sheets).\n\n### YOUR TOOLKIT\nYou have two sets of tools. You must always use them in pairs: one to **GET** the data, and one to **SAVE** the data.\n\n**Set A: TikTok Operations**\n1. `TikTok Profile Fetcher`: gets the data.\n2. `TikTok Sheet Recorder`: saves the data.\n\n**Set B: LinkedIn Operations**\n1. `LinkedIn Profile Fetcher`: gets the data.\n2. `LinkedIn Sheet Recorder`: saves the data.\n\n### OPERATION PROTOCOLS\n\n**PROTOCOL 1: TikTok Extraction**\nIf the user provides a TikTok username or link:\n1.  **Scrape:** Call `TikTok Profile Fetcher` with the username.\n2.  **Process:** Wait for the JSON result.\n3.  **Save:** Immediately call `TikTok Sheet Recorder` mapping the scraper's output to these exact fields:\n    - `Username`\n    - `verified`\n    - `secUid`\n    - `bioLink`\n    - `followerCount`\n    - `followingCount`\n    - `heartCount`\n    - `videoCount`\n    - `friendCount`\n4.  **Report:** Confirm to the user: \"TikTok profile for [Username] scraped and saved to database.\"\n\n**PROTOCOL 2: LinkedIn Extraction**\nIf the user provides a LinkedIn profile URL:\n1.  **Scrape:** Call `LinkedIn Profile Fetcher` with the URL.\n2.  **Process:** Wait for the JSON result.\n3.  **Save:** Immediately call `LinkedIn Sheet Recorder` mapping the scraper's output to these exact fields:\n    - `name`\n    - `image` (Profile picture URL)\n    - `location`\n    - `followers`\n    - `about` (Bio/Summary)\n    - `recentPosts` (Link to recent activity)\n4.  **Report:** Confirm to the user: \"LinkedIn profile for [Name] scraped and saved to database.\"\n\n### ERROR HANDLING\n- If a scraper returns \"Null\" or fails to find the profile, do **not** call the database saver. Instead, inform the user: \"I could not retrieve data for that profile. Please check the link/username.\"\n- Do not make up data. Only save what the scraper returns.\n\nBegin by identifying which platform the user wants to scrape."
},
"promptType": "define"
},
"typeVersion": 2.2
},
{
"id": "bf2e23ff-22f1-4329-9911-d38e2724f4f8",
"name": "OpenAI Chat Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
708,
566
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": []
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "ba7f8f39-6f52-4b8d-bae0-e63071bd03ec",
"name": "TikTok Profile Fetcher",
"type": "n8n-nodes-base.httpRequestTool",
"position": [
144,
462
],
"parameters": {
"url": "https://app.dumplingai.com/api/v1/get-tiktok-profile",
"method": "POST",
"options": [],
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "handle",
"value": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('parameters0_Value', ``, 'string') }}"
}
]
},
"genericAuthType": "httpHeaderAuth",
"toolDescription": "Scrapes a TikTok profile to retrieve public metrics and user details."
},
"credentials": {
"httpHeaderAuth": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.2
},
{
"id": "0063c43e-d4e8-43cc-a0aa-f3f3da119f74",
"name": "TikTok Sheet Recorder",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
4,
586
],
"parameters": {
"columns": {
"value": {
"secUid": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('secUid', ``, 'string') }}",
"bioLink": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('bioLink', ``, 'string') }}",
"Username": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Username', ``, 'string') }}",
"verified": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('verified', ``, 'string') }}",
"heartCount": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('heartCount', ``, 'string') }}",
"videoCount": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('videoCount', ``, 'string') }}",
"friendCount": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('friendCount', ``, 'string') }}",
"followerCount": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('followerCount', ``, 'string') }}",
"followingCount": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('followingCount', ``, 'string') }}"
},
"schema": [
{
"id": "Username",
"type": "string",
"display": true,
"required": false,
"displayName": "Username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "verified",
"type": "string",
"display": true,
"required": false,
"displayName": "verified",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "secUid",
"type": "string",
"display": true,
"required": false,
"displayName": "secUid",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "bioLink",
"type": "string",
"display": true,
"required": false,
"displayName": "bioLink",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "followerCount",
"type": "string",
"display": true,
"required": false,
"displayName": "followerCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "followingCount",
"type": "string",
"display": true,
"required": false,
"displayName": "followingCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "heartCount",
"type": "string",
"display": true,
"required": false,
"displayName": "heartCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "videoCount",
"type": "string",
"display": true,
"required": false,
"displayName": "videoCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "friendCount",
"type": "string",
"display": true,
"required": false,
"displayName": "friendCount",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=0",
"cachedResultName": "TikTok"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit",
"cachedResultName": "Spreadsheet"
},
"descriptionType": "manual",
"toolDescription": "Saves extracted TikTok data into the Google Sheet."
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "c8c2e6f8-4837-47eb-99ab-eca7d7520185",
"name": "LinkedIn Profile Fetcher",
"type": "n8n-nodes-base.httpRequestTool",
"position": [
160,
608
],
"parameters": {
"url": "https://app.dumplingai.com/api/v1/linkedin/profile",
"method": "POST",
"options": [],
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "url",
"value": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('parameters0_Value', ``, 'string') }}"
}
]
},
"genericAuthType": "httpHeaderAuth",
"toolDescription": "Scrapes a LinkedIn profile to retrieve professional details."
},
"credentials": {
"httpHeaderAuth": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.2
},
{
"id": "d9bd7e1f-e9b8-405a-a8bf-8b08605a9e03",
"name": "LinkedIn Sheet Recorder",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
0,
446
],
"parameters": {
"columns": {
"value": {
"name": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('name', ``, 'string') }}",
"about": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('about', ``, 'string') }}",
"image": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('image', ``, 'string') }}",
"location": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('location', ``, 'string') }}",
"followers": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('followers', ``, 'string') }}",
"recentPosts link": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('recentPosts_link', ``, 'string') }}"
},
"schema": [
{
"id": "name",
"type": "string",
"display": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "image",
"type": "string",
"display": true,
"required": false,
"displayName": "image",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "location",
"type": "string",
"display": true,
"required": false,
"displayName": "location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "followers",
"type": "string",
"display": true,
"required": false,
"displayName": "followers",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "about",
"type": "string",
"display": true,
"required": false,
"displayName": "about",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "recentPosts link",
"type": "string",
"display": true,
"required": false,
"displayName": "recentPosts link",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1956409676,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=1956409676",
"cachedResultName": "LinkedIn"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit",
"cachedResultName": "Spreadsheet"
},
"descriptionType": "manual",
"toolDescription": "Saves extracted LinkedIn data into the Google Sheet."
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "94f08ef8-13fa-4c43-8c60-0c6067980b42",
"name": "Dispatch Completion Email",
"type": "n8n-nodes-base.gmail",
"position": [
304,
312
],
"webhookId": "d6f5bb11-6891-4500-b1c4-e67984d08ba0",
"parameters": {
"sendTo": "[YOUR_EMAIL]",
"message": "Extraction complete. I have scraped the profile and successfully saved all data points to your spreadsheet",
"options": {
"appendAttribution": false
},
"subject": "Extraction complete",
"emailType": "text"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": "",
"connections": {
"OpenAI Chat Engine": {
"ai_languageModel": [
[
{
"node": "Social Data Extraction Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Map Text Content": {
"main": [
[
{
"node": "Social Data Extraction Agent",
"type": "main",
"index": 0
}
]
]
},
"Map Voice Text": {
"main": [
[
{
"node": "Social Data Extraction Agent",
"type": "main",
"index": 0
}
]
]
},
"TikTok Sheet Recorder": {
"ai_tool": [
[
{
"node": "Social Data Extraction Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"TikTok Profile Fetcher": {
"ai_tool": [
[
{
"node": "Social Data Extraction Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Voice Message Check": {
"main": [
[
{
"node": "Retrieve Voice File",
"type": "main",
"index": 0
}
],
[
{
"node": "Map Text Content",
"type": "main",
"index": 0
}
]
]
},
"LinkedIn Sheet Recorder": {
"ai_tool": [
[
{
"node": "Social Data Extraction Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Telegram Message Intake": {
"main": [
[
{
"node": "Voice Message Check",
"type": "main",
"index": 0
}
]
]
},
"LinkedIn Profile Fetcher": {
"ai_tool": [
[
{
"node": "Social Data Extraction Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Social Data Extraction Agent": {
"main": [
[
{
"node": "Dispatch Completion Email",
"type": "main",
"index": 0
}
]
]
},
"Whisper Audio Transcription": {
"main": [
[
{
"node": "Map Voice Text",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Voice File": {
"main": [
[
{
"node": "Whisper Audio Transcription",
"type": "main",
"index": 0
}
]
]
}
}
}