One Prompt to Search, Update, and Report Across Your Entire Airtable Base
If your team uses Airtable, it is likely the operational heartbeat of your work. It holds the structured data that runs your sales pipelines, inventory trackers, content calendars, and client projects. But maintaining that system of record often means spending hours interpreting data, cross-referencing information, and running routine updates. When database maintenance begins to compete with the actual work it tracks, keeping records updated can become a time-consuming administrative task.
The Airtable connector changes that dynamic. Once you connect and grant permission, you can move from manually managing cells to having an assistant that queries, aggregates, and updates your records for you. You start with a natural language request, and Manus interacts directly with your bases to keep your operations running smoothly.
The Manual Way vs. The Manus Way
The Workflow | The Manual Way | The Manus Way |
Pipeline Enrichment | Manually researching prospects across company websites and news platforms to find recent funding or product launches, then typing notes into each record. | Manus uses Wide Research to scan the web for recent signals on your prospects, updating your Airtable base with contextual notes. |
Inventory Reconciliation | Manually parsing PDF invoices to extract stock levels, or configuring dedicated multi-step document-parsing pipelines to push data into your inventory base. | With your authorization, Manus can process incoming vendor invoices or PDF stock sheets that you share, extract the updated numbers, and stage them for database updates. |
Campaign Reporting | Exporting raw engagement data pulled via API, manually calculating ROI across platforms, and building slides to present the results. | Manus analyzes the raw campaign data already in your base, calculates cross-platform performance, and uses Slides Generation to build a presentation-ready report. |
Executive Reporting | Exporting raw data into spreadsheets to manually build charts and write summaries for leadership. | Manus pulls the specific records from your base and builds a live, hosted visual Dashboard you can share right away. |
Setting Up Your Airtable Connection
Unlike some connectors that use a standard login flow, Airtable uses Personal Access Tokens (PATs) to give you precise control over what data Manus can access. This means you decide exactly which bases Manus can read, which ones it can write to, and which remain completely private.
Here is how to set it up:
Step 1: Open the Airtable Developer Hub. Navigate to airtable.com/create/tokens and click "Create token."
Step 2: Name your token. Give it a clear label like "Manus Integration" so you can identify it later.
Step 3: Choose your scopes. Scopes determine what Manus is allowed to do. Here is a quick breakdown of what each one controls:
Scope | What It Allows |
data.records:read | Read records from your tables |
data.records:write | Create or update records (Note: Manus cannot delete records) |
schema.bases:read | See the structure of your bases and tables |
schema.bases:write | Create new tables, fields, or entirely new bases |
data.recordComments:read | Read comments on records |
data.recordComments:write | Add comments to records |
workspacesAndBases:read | List available workspaces and bases |
webhook:manage | Manage webhook subscriptions |
If you only want Manus to pull data and generate reports without changing anything, you can skip the "write" scopes entirely. If you want Manus to update records or create new ones, include the write scopes for the relevant categories.
Step 4: Select which bases to grant access to. You can choose individual bases, entire workspaces, or all current and future bases. For most setups, granting access to specific bases keeps things tightly scoped.
Step 5: Copy and connect. Copy the generated token, open the Connectors menu in Manus, find Airtable, and paste your token to connect.
Manus only operates within the boundaries you have set. You can always return to the Developer Hub to add more bases, remove access, or regenerate the token if needed.
Manus only accesses connectors you have already authorized. No new permissions are granted automatically.
3 Ways to Put Your Airtable Data to Work
Once connected, here are three workflows that show how Manus pairs your Airtable data with its other capabilities to handle multi-step tasks.
1. Enrich a Pipeline with Live Web Context
If you manage a pipeline of leads, clients, or candidates, your Airtable base is likely filled with names and stages. Having the name is easy, but having the context to make a meaningful connection requires manual research. Someone has to look up recent news, funding rounds, or portfolio updates for every prospect on the list.
You can hand that research and updating process to Manus.
Prompt: "I need to enrich our pipeline base in Airtable. Look at the 'Target Accounts' view and filter for companies tagged as 'Cold Lead.' Use Wide Research to find the most recent major news event, product launch, or funding round for each company. Update the 'Recent Context' field in their Airtable records with a one-sentence summary. Then generate a brief list here in the chat highlighting the ones with the most significant recent growth signals."
Manus pulls the names from your base, browses the web to find their current business context, and updates the specific fields in your Airtable records. You get a refreshed database and a prioritized list of hot leads, without opening a single new tab.
2. Reconcile Records from Incoming Emails
For teams managing physical products or complex logistics, keeping records updated is a constant battle against stale data. Because Airtable does not natively extract text from PDFs, getting data out of supplier invoices or shipping manifests typically requires configuring dedicated document-parsing pipelines or manually copying the numbers into your master base.
You can streamline this process by connecting Manus to both your inbox and your database.
Prompt: "Check my Gmail for the latest email from our supplier with the subject line containing 'Weekly Stock Report.' Extract the updated quantity numbers for the items listed in the attached PDF. Then, go into our inventory Airtable base, find those items, and update the 'Current Stock' field for each one. Use Data and Spreadsheets analysis to calculate the variance between our previous stock levels and the new delivery quantities, and post a summary of any items where the variance is unusually high."
Manus reads the incoming report, identifies the relevant items, and updates the Airtable records based on the data in the PDF. It then runs the variance analysis, giving you immediate visibility into any stock issues without the manual data entry or additional document-parsing setup.
3. Turn Raw Campaign Data into Presentation-Ready Reports
Many teams use API integrations to automatically pull performance metrics from social platforms directly into Airtable. But having the raw data is only the first step. To understand how an influencer campaign actually performed, someone still has to aggregate those metrics across different platforms, calculate overall engagement rates, spot performance trends, and build a report to share with stakeholders.
Instead of exporting that data into a spreadsheet to build charts manually, you can ask Manus to analyze it and generate the final deliverable.
Prompt: "Look at our 'Campaign Tracking' Airtable base. Review the records for the 'Summer Launch' campaign. Analyze the raw metrics pulled from the social platforms to calculate the total cross-platform reach, average engagement rate, and cost-per-engagement for each influencer. Identify the top three performing posts. Then, use Slides Generation to create a 5-slide campaign wrap-up presentation summarizing these insights, and save it to my Google Drive."
Manus processes the raw data already sitting in your base, performs the necessary calculations to find the insights, and builds a presentation for your team to review. It bridges the gap between raw data collection and actionable reporting.
Note: If you want Manus to confirm before making changes to your base, you can include "ask me before updating any records" in your prompt. Manus will show you what it plans to write and wait for your approval.
Pair It With the Rest of Your Stack
The Airtable connector is useful on its own for reading and updating records, but it becomes significantly more powerful when you pair it with other Manus capabilities and connectors.
The Pairing | What It Does |
Airtable + Wide Research | Manus reads a list of companies or contacts from your base, researches each one across the web, and writes the findings back as new fields or updated records. |
Airtable + Google Drive Connector | Manus saves outputs like reports, exports, or summaries directly to a specific folder in your Google Drive, or pulls reference documents from Drive to inform how it updates your Airtable records. |
Airtable + Slides Generation | Manus reads structured data from your base (quarterly results, project statuses, campaign metrics) and generates a presentation-ready slide deck. |
Airtable + Scheduled Tasks | Manus runs a recurring workflow on a set schedule, keeping your base current without manual intervention. |
Airtable + Dashboard creation | Manus pulls records from your base and builds a live, hosted visual dashboard you can share with your team or leadership. |
The Database Becomes the Agent
For years, the goal of a good database was simply to hold accurate information. If it was organized and searchable, it did its job. But a database that just sits there is only half the equation. The real value is not in storing the data, but in acting on it.
Connecting Airtable to Manus shifts your database from a static storage unit into an active participant in your work. It stops being a place where you go to type things in, and starts being the engine that drives your research, emails, and reporting. Your credentials and data stay yours, and Manus only accesses what you authorize for the task at hand. The structure you have already built in Airtable remains exactly the same. The only difference is that now, you have an agent doing the heavy lifting inside it.
