Use the Airtable MCP server with live TikTok and Instagram data

Updated

Virlo is social listening for TikTok and Instagram Reels. The Airtable MCP server lets an assistant read and write your records, but nothing in your base knows which TikToks and Reels are beating their usual views this week. Add Virlo's MCP server to the same assistant and one request can research trends, hooks and sounds from a database of 23.1M viral videos and save them as rows. Airtable is a cloud database and app platform where teams build bases, interfaces and automations on top of shared records.

  • Airtable MCP plus Virlo MCP in Claude, ChatGPT or Cursor: research and save in one chat
  • A Run a script automation that fills a sounds table every morning
  • When webhook received, for Virlo events that should become records

Part of Virlo's AI assistant guides. Planning content in a doc instead? See Notion or Google Sheets.

How do I get TikTok and Instagram data into Airtable?

Two routes, one setup. Steps 2, 3 and 5 pair Airtable's MCP server with Virlo's in an assistant; step 4 adds a scheduled automation that needs no assistant at all.

  1. Step 1: Create your Virlo account for free

    Create your free Virlo account in under a minute. Already signed up? Open API Keys.
  2. Step 2: Add both MCP servers to your assistant

    In Claude Code, run the two commands below. In Claude, ChatGPT or Cursor, add the same two URLs as custom connectors: Airtable's server at mcp.airtable.com/mcp and Virlo's server.

    Claude Code
    claude mcp add --transport http airtable https://mcp.airtable.com/mcp
    claude mcp add --transport http virlo https://dev.virlo.ai/api/mcp/mcp
  3. Step 3: Sign in to Airtable and Virlo

    Run /mcp in Claude Code (or click Connect on each connector) and approve both in the browser. Airtable access follows your own permissions in each base, so read-only collaborators can read records but not create them.

  4. Step 4: Keep a Reels sound log on a schedule

    For a hands-off feed, open the base, click Automations, then + Create automation. Choose the At a scheduled time trigger, add a Run a script action, save a key from API Keys as a secret named VIRLO_API_KEY in the Variables sidebar, and paste the script. It expects a table called Reels sounds with the three fields shown.

    Run a script
    const key = input.secret('VIRLO_API_KEY')
    const res = await fetch(
      'https://api.virlo.ai/v1/sounds/trending?platform=instagram&sort=videos_7d&limit=20',
      { headers: { Authorization: 'Bearer ' + key } }
    )
    const { data } = await res.json()
    const table = base.getTable('Reels sounds')
    await table.createRecordsAsync(
      data.map((s) => ({
        fields: {
          Sound: s.title,
          Credited: s.owner_nickname || '',
          'Reels in 7 days': s.videos_in_window,
        },
      }))
    )
  5. Step 5: Ask the assistant to research and save

    Back in the assistant with both servers on, ask for research and a destination in the same sentence. It reads from Virlo and writes through Airtable.

    Your first prompt
    Use Virlo to find the 10 trends to copy on TikTok this week that fit [your niche], then add each one to the [table name] table in my [base name] base with the trend name, what to keep, what to change and an example link.

Test the automation with the blue test button before switching its toggle from OFF to ON, and open the run history's Execution log if a step fails.

Airtable MCP + Virlo vs Run a script vs When webhook received: which route fits your base?

RouteHow Virlo data reaches AirtableGood for
Airtable MCP and Virlo MCP in one assistantThe assistant researches with Virlo, then creates or updates records through Airtable's toolsContent calendars, idea banks and creator lists built in conversation
At a scheduled time + Run a scriptA script calls an api.virlo.ai/v1 endpoint with fetch and writes rows with createRecordsAsyncDaily sound logs and weekly trend tables nobody has to remember
When webhook receivedVirlo posts an event to the automation's webhook URL and later actions turn it into a recordA row per tracked outlier or finished marketing agent run
Virlo Automations to Google SheetsVirlo keeps a sheet ledger itself, which you can sync into AirtableTeams that already sync a sheet into their base

The MCP route signs in with OAuth on both sides. The script and webhook routes use a Virlo API key stored as an automation secret.

Which Reels sounds would land in your Airtable sound log this week?

These are the rows the Run a script automation above would write today: the sounds used by the most Instagram Reels in Virlo's data over the last 7 days.

In Virlo's data, 75 Reels used "Flower In A Hurricane (feat. Tame Impala, SZA, King Gizzard & the Lizard Wizard) [From GTAVI: Original Score]" in the last 7 days, more than any other sound on Instagram as of November 19, 2026.

As of November 19, 2026 at 12:03 UTC

Which Reels sounds would land in your Airtable sound log this week?
SoundArtistReels using it (7 days)
Flower In A Hurricane (feat. Tame Impala, SZA, King Gizzard & the Lizard Wizard) [From GTAVI: Original Score]Justice, Tame Impala, SZA, King Gizzard & the Lizard Wizard75
Cover art for Dilruba DilnasheenDilruba DilnasheenRito Riba, Siddhant kaushal46
Vintage NovemberPeaceful Reveries25
What's Up - Deep houseHARDMAX24
Saxophone Getting LouderNDIOUGA KÉBÉ RECORDS22

See all 300 trending Reels sounds

Breakout sounds, usage history and the Reels behind each sound are in the Virlo app.

Open sounds in Virlo

How this sample is made

Source
Virlo's sound rankings for Instagram Reels, built from the Reels Virlo collects.
Window
Reels posted in the last 7 days that Virlo collected. Counts are Reels in Virlo's data, not every Reel on Instagram.
Method
Ranked by the number of Reels using each sound in the window.
As of
November 19, 2026 at 12:03 UTC. Rebuilt every day.
Made by
Numbers are pulled automatically from Virlo's data; the text around them is written by the Virlo team.

Suggested citation: Source: Virlo, “Use the Airtable MCP server with live TikTok and Instagram data”, virlo.ai/airtable

How do I build a content calendar in Airtable from Virlo data?

A base works well as the single place where research turns into scheduled posts. Give it three linked tables and let the assistant fill the first two.

  • Trends: name, stage, what to keep, what to make yours, example link, creators this week.
  • Hooks: hook text, hook type, Virality Score, source video, linked trend.
  • Posts: date, platform (TikTok or Instagram), linked trend, linked hook, script, status.
  • Each Monday, ask the assistant to refresh Trends and Hooks from Virlo and suggest five Posts rows for the week.
  • Keep the Run a script automation feeding a Reels sounds table so whoever scripts a post can pick a rising sound from the same base.

Airtable's MCP server can draft automations too, but anything with a Script action has to be created in the Airtable interface, so the scheduled script stays a manual setup step.

What can I ask with Airtable and Virlo connected?

Prompts for an assistant that has both servers on. Replace the brackets with your base, tables and niche.

  • Fill the trends table

    Pull this week's top trends to copy in [your niche] from Virlo and create one record per trend in [Trends table], skipping any already there.

  • Hook bank

    Find 20 TikTok hooks in [your niche] with a Virality Score of 18 or more and add them to [Hooks table] with hook type and source link.

  • Weekly post plan

    Read [Trends table] and [Hooks table] in [base name], then create 5 rows in [Posts table] for next week, one per weekday, each linking a trend and a hook.

  • Creator CRM

    Find 15 creators under [N] followers in [your niche] whose videos beat their follower count and add them to [Creators table] with handle, platform and best video.

  • Competitor log

    Look up @[competitor] on TikTok and Instagram with Virlo and update their record in [Competitors table] with their top 3 videos this month.

  • Sound check

    Compare the sounds in my [Reels sounds table] with this week's breakout Reels sounds in Virlo and flag any that are fading.

  • Client summary

    Summarise what changed in [client niche] on TikTok this month using Virlo, then write it into the Notes field of [client record].

Airtable MCP server vs Airtable AI vs Virlo MCP: what does each one do?

Three AI pieces show up around an Airtable base. Each covers a different part of the job.

Airtable MCP server

Airtable's own server at mcp.airtable.com/mcp. It lets an assistant search, create and update records, build bases and draft interfaces, within your permissions.

Airtable AI

AI fields and assistants inside Airtable that summarise, tag and generate from records already in your bases. It works on data you have, not outside trends.

Virlo MCP server (this guide)

Supplies the outside data: TikTok and Instagram trends, hooks, sounds and outlier videos that your base does not contain yet.

Notion

Prefer Notion databases for planning? The Notion guide pairs Virlo with Notion the same way.

What are the limits?

  • Virlo reads public TikTok and Instagram data and never posts; Airtable stores and organises what it finds.
  • Run a script allows 30 seconds per fetch and 50 fetch requests per run, so pull one or two Virlo endpoints per automation rather than dozens.
  • Record creation through the Airtable MCP server is limited to 10 records per request, so large imports go faster through the scheduled script.
  • Only collaborators who can see every secret in a script can edit it; others can still run the automation without seeing the Virlo key.
  • Virlo plan details: pricing.

Frequently asked questions

What is the Airtable MCP server?

Airtable's hosted MCP server at mcp.airtable.com/mcp. It lets assistants like Claude, ChatGPT, Claude Code and Cursor search, create and update records, create bases and work with interfaces, using your own permissions. Sign in with OAuth or a personal access token.

How do I connect Airtable to Claude with MCP?

In Claude Code, run claude mcp add --transport http airtable https://mcp.airtable.com/mcp, then /mcp to sign in. In Claude, add the same URL as a custom connector. Add Virlo's server the same way and Claude can research TikTok trends and save them to your base.

Can Airtable pull TikTok data automatically?

Yes, with Virlo. An automation with the At a scheduled time trigger and a Run a script action can fetch TikTok trends, sounds or hooks from api.virlo.ai/v1 using a key saved as a secret, then write each item as a record.

How do I add an API key to an Airtable script safely?

Save it as a secret in the Variables sidebar of the Run a script action and read it with input.secret('VIRLO_API_KEY'). Secrets are redacted from console output, and collaborators without access to the secret can run the automation but not view or edit the script.

Can Airtable track trending Instagram Reels sounds?

Yes. Point a scheduled Run a script automation at Virlo's trending or breakout sounds endpoint with platform=instagram and it can add the top Reels sounds to a table every day, with how many Reels used each one in the last 7 days.

Can Virlo send data to Airtable with a webhook?

Yes. Start an automation with When webhook received, copy its URL and register it through POST /v1/webhooks on the Virlo API with events like tracking.outlier_video.detected. Later actions in the automation can then create a record from the event. Each delivery carries an event id you can store to skip repeats.

Can Airtable AI see TikTok trends?

Not by itself, since it works on the records in your base. Fill a table from Virlo first, through the MCP route or a scheduled script, and Airtable AI can summarise, tag and sort those trends like any other data.

Should I use Airtable or Google Sheets for Virlo data?

Airtable suits linked tables, views and interfaces for a content calendar. Sheets suits quick logs, and Virlo's Automations can keep a Sheets ledger with no code. The Google Sheets guide covers that route. Many teams start with the Sheets ledger and move to an Airtable base once the content calendar needs linked records and owners.

Can Airtable post to TikTok through Virlo?

No. Virlo only reads public data and never connects to social accounts. Airtable can hold the plan and the scripts, and posting happens in whichever tool you publish from. A Posts table with status, date and linked trend gives whoever publishes everything they need, and Virlo keeps the research behind each row current.

Turn your Airtable base into a trend desk

Pair Virlo with the Airtable MCP server and let one prompt fill this week's trends table.