All work
Airtable · Data quality · 2025
Duplicate clean-up and a contract pipeline for an Airtable base
An Airtable base was audited for duplicate records, cleaned with clear filtering rules, and extended with an opportunity-to-contract workflow.
- Client
- Services company on Airtable
- Engagement
- Fixed-price, 2 milestones (ongoing relationship)
- Stack
- Airtable · Airtable scripting · Automations
The workflow, simplified
ReadyIllustration
Simplified illustration of the delivered workflow, with no client data.
The problem
Duplicates had built up across the base, making reports unreliable and the sales-to-contract hand-off messy.
What I built
- Duplicate analysis with recommendations for filtering rules
- Duplicate clean-up across the base
- Opportunity → contract issue workflow
Related track record
Airtable scripting and automations
19 contracts18 clients
2021–2026
Delivered Upwork contracts that involved this capability, and how many different clients they came from.
Have a process like this?
Next project
A Shopify order desk that schedules itself