Unlocking Ops Superpowers using Airtable
25th March 2022
Welcome to Ops Hacks Speaker Series
“A community of and by early stage operators”
Join at www.opshacks.co
Introduction - Abhi
A generalist & early stage operator who loves problem solving, embracing the wild roller coaster ride i.e. a startup
S&O Manager,�AGM @Clutch
Moved to Canada
Founded a 3D printing company
2014
2018
2021
Introduction to Clutch
Early stage —> Growth stage
Canada’s largest online used car retailer
Amazon of car buying: Click.Buy.Drive.
5 Locations. 3500+ cars. 300+ employees
Introduction to Clutch
Source Vehicle
Inspection & Reconditioning
List Vehicle
Sale Pending Vehicle
Processing
Delivery
Incredible Clutch Experience
=
Ops @ Clutch
Movement of physical products with regulatory requirements
Multiple touchpoints to deliver an incredible Clutch Experience
Distributed teams
Sales in TO, Field Ops in local markets
Building a LEGO plane while flying it
Capabilities of Airtable
Streamline
Collaborate
Source of truth
No code tool
Scalability
Streamline ops process - defining process & scope of work for each team
Collaboration & Asynchronous communication between teams
Single* source of truth for your org
Anyone can build without eng. help → decentralized problem solving
2 Locations → 5 locations, 10x inventory growth, 5x Ops headcount
Data
Capture & analyze early stage ops data
Limitations of Airtable
Learning curve
Initial ramp up to learn your way around Airtable
$ adds up
Cost could be prohibitive @ scale �i.e. 200+ seats ~$3000/month
Airtable = Spreadsheet ++
Airtable = Spreadsheet ++ Secret Sauces
Relational Databases
Views
Field Types
1-to-1,1-to-many,many-to-many relationships
Same data but different views for different use cases (Composability)
28 field types (Multi Select, Attachments etc.) allow for customized applications
How Ops uses Airtable @ Clutch
Process Overview
Live Demo
Airtable’s Role
Process Overview
Trailer of the OG �(which has evolved over �months of work)
How does Airtable help?
Operational flow of the process
Local Ops
Sales Ops
Finance Ops
Local Ops Inspection & Reconditioning
Purchase Vehicle
Fit for Retail?
Inspection & Reconditioning
List Vehicle
Move to Wholesale
No
Yes
Airtable enables…
Streamlining process: Organizing queues for Ops Team
Collaboration: Easy hand offs between teams
Tracking metrics & KPIs for Inspect & Recondition teams
✅
✅
✅
Sale pending
Approvals
Documentation
Schedule delivery
Airtable enables…
Collaboration: Communication between Sales & Fulfillment Teams
Deal Management: Organizing customer docs for each transaction
Tracking metrics & KPIs for Sales Managers
✅
✅
✅
Extra work required?
Local Ops Fulfillment Ops (Vehicle Delivery Ops)
Sale pending
Extra work required?
Pre-Delivery Inspection
Delivery
Airtable enables…
Streamlining process & capacity planning: Organizing schedule for Delivery Team
Collaboration: Communication between teams / markets
Tracking metrics & KPIs for Fulfillment teams
✅
✅
✅
Type of deal?
No
Finance payment required (trade ins, returns, CX)
Manager approval
Organize payments
Disburse funds
No
Airtable enables…
Tracking Payments: Communication between Finance & other teams
Documentation: Organizing docs for each payment
✅
✅
Collect supporting docs
Missing docs?
Yes
Yes
Good luck 🤞
Level 2
Dashboards Leveraging your ops data
Dashboards Leveraging your ops data
Automations Let AT do the heavy lifting
APIs & App Go Realtime
Airtable APIs will allow you to import your website/app data into airtable
Your Website/ App / Service
Airtable Data
Real time info
APIs & App Pairing AT with other tools
APIs & App Pairing AT with other tools
Use Cases
Best way to learn Airtable TRY IT!
Build a world class consumer brand
Questions?
Reach me at abhijith-shetty
Appendix
Please make a copy of the base (button on the top right) into your own workspace and can edit the base