What does this Airtable automation do?
A new spreadsheet lead is scored by AI, then written into the base with its score.
What can you do with it?
- Enrich before the record is created
- Stop importing raw, unscored leads
- Keep the reasoning in the record
The Steps
This automation runs in 3 steps:
- When Google Sheets — New Row
- Then Taskade AI — Ask an agent ("Base Lead Scorer")
- Then Airtable — Create Record
What makes this different from a Zapier-style flow?
The "Base Lead Scorer" step is not a one-off model call. It is a Taskade AI agent that knows your ICP and the fields your base scores against, remembers which scored records became customers, so every run builds on the last one instead of starting from an empty prompt.
A stateless "ask the model" step forgets everything the moment it returns. An agent keeps its knowledge and its memory between runs, carries its own tools, and can be handed work by your other automations.
Who is this automation for?
Built for sales teams using Airtable as a CRM. A new spreadsheet lead is scored by AI, then written into the base with its score.
How do you set it up?
- Open the "Automations" tab in your workspace.
- Click ➕ Add automation, then start from scratch.
- Add the trigger "New Row" from Google Sheets.
- Add the action "Ask an agent" from Taskade AI. Point it at an agent called "Base Lead Scorer".
- Add the action "Create Record" from Airtable.
- Connect your Airtable account when prompted, then enable the toggle in the top-right corner.
Prefer to describe it instead? Click Build this flow with AI above and Taskade wires the trigger, the steps, and the agent for you.