Using Airtable as a CRM | Airtable Tutorial
This recurring thing has been happening to me lately and it’s driving me mad. On multiple occasions in the past several months, businesses have taken time and money to market to me. Then, when I’m ready to buy, I hear nothing but crickets from them! Most recently, this occurred when an arborist came to my door to introduce himself and offer his services. I was happy to take his card, because we have a tree in our front yard that needs some help - it has a broken bough and we need to fix it soon before it impacts more of the tree. So of course, I call the guy back. Only to not hear back for a few days. Then, after I reach out again, I finally talk with him. He instructs me to send him some info in a text and he promises to follow up. Fast forward a few more days and several follow up texts from me. I’ve heard nothing more from him and now I’m looking for another arborist. Why does this happen? This individual took money and time to print cards and then canvas neighborhoods in an effort to generate business. Why would anyone spend that effort upfront without a reliable system to support the operations? Here’s the reality: if you business operations don’t give your customers a seamless experience from “introduction” to “project complete” then you have room for improvement. Hopefully your system isn’t resulting in dead leads like I’ve been experiencing, but either way there’s likely room for improvement! In this video, I show the most common two tables for any CRM. Also, we discuss how to use a Rollup + Lookup combo to bring in only the most recent information to the contact level. This specific use-case is one of those things that we see time and time again, especially when tracking contacts and interactions. P.S. I know I promised to showcase a sales dashboard this week - I’ll have to take a raincheck for next week - this was just too pressing and I had to get this out right away! P.P.S. If you know a good arborist in the Denver area, please let me know! _________________________________________ Learn more at these links: 🔗 👇 Join us for our next live training! https://www.garethpronovost.com/webin... Take our free Airtable Crash Course! https://garethpronovost.com/airtable-... Getting Stuck? See how we can help! https://garethpronovost.com Get our Airtable Field Type download! https://www.gapconsulting.io/airtable... _________________________________________ Table of Contents: 📖 👇 00:00 - What this video covers 02:44 - Starting from Scratch 03:36 - Setting up some easy fields 05:17 - Building our 'Interactions' 09:55 - Setting a 'Next Step' 10:50 - Bringing the Current 'Next Step' in to 'Contacts' _________________________________________ Software Resources (may contain affiliate links): 💻 👇 Airtable - https://airtable.com/invite/r/v0eI3ASY Zapier - https://zapier.com Kajabi - https://app.kajabi.com/r/JPqop9kN/t/v... _________________________________________ #GAPConsulting #GarethPronovost #Airtable

How to Include Color in Airtable Records

Lookup vs Rollup Fields

Billionaire's WARNING: I'm SELLING. The Crash Is Already Here!

Understanding IF and SWITCH Formulas in Airtable | GAP Consulting

Master Full-Stack Docker & CI/CD – Build a Production-Ready Pipeline

MIT Just Revealed the AI Bubble's Fatal Flaw

How to Actually Build Mobile Apps with AI in 2026 | A Complete Beginner's Tutorial

Airtable as a CRM: My Exact Setup for Consultants & Small Businesses

Exploring Airtable (Internal) Automations

How to Use Airtable Sync

Introduction to QuickBooks Desktop - 4hr Full Tutorial

SUMMER DEEP HOUSE Musics Mix 2026 ♫ Bruno Mars, Lady Gaga,Dua Lipa, Adele,Ed Sheeran, The Weeknd #02

A Beginners Guide to Airtable | Updated for 2022

How to Write Difficult Formulas in Airtable

Tracking Projects & Tasks in Airtable

Page Designer App (Advanced) | Airtable Tutorial

AI Agents Full Course 2026: Master Agentic AI (2 Hours)

SUMMER DEEP HOUSE Musics Mix 2026 ♫ Bruno Mars, Lady Gaga,Dua Lipa, Adele,Ed Sheeran, The Weeknd #29

Free Event: Power BI Beginner to Pro 2026 Edition - Full Hands-On Tutorial

