I’m looking to turn several scattered workflows into one cohesive Airtable base that can serve multiple purposes: a lightweight CRM today, plus project-tracking and other functions as we evolve. I’ve sketched a rough base, but the tables aren’t linked and nothing is automated yet. Here’s what I need: • A clean data model with linked records—companies, contacts, deals, projects—using look-ups and roll-ups where helpful. • Views, forms and interfaces that make it simple for the team to input data and follow a sales pipeline. • Airtable Automations and Make.com scenarios to handle reminders, stage changes, and email touchpoints. • Email integration so messages land on the right contact or deal automatically. • A short hand-off guide so I can maintain and extend the setup. Acceptance criteria 1. Contacts, deals and related emails live in one base with no duplicates. 2. Deals advance through pipeline stages automatically based on triggers we define. 3. Key emails can be sent and logged from inside Airtable. 4. Make.com automations run error-free and are clearly documented. 5. The structure remains flexible enough to add project or inventory tables later. If you’ve built similar multi-function Airtable CRMs, I’d love to see an example. I’m ready to start as soon as we agree on the approach and timeline.