Select Page

Build Your Own

Airtable Automation Machine

Build powerful bases that save you time, organize your data & simplify your work life.

Airtable is a powerful tool. But all of that power can feel overwhelming when it’s time to learn how to use it.

  • You want to know how to structure your bases correctly.
  • You want to set-up powerful automations that save you time.
  • You want to create a ‘brain’ for your business.

The problem is time–there’s never enough of it.

So you just go along with the existing templates. Or you continue using a bunch of spreadsheets.

 It’s time to learn how to put Airtable to work for you.

For the past two years, I’ve used Airtable to save clients dozens of hours every month through improved workflows, and netted them thousands of dollars in reclaimed efficiency. Today my consultancy architects everything from simple, organized bases to bespoke, $6,000+ Airtable automation packages.

 Zero overwhelm. Complete clarity.

 

In this course, you’ll learn how I use Airtable to organize and automate businesses so you can do the same for yours.

This is the only course where you get to see over the shoulder of an Airtable Automation & Organization specialist. You’ll have a step-by-step guide through the strategies we’ve used to save companies 1,000’s of hours by harnessing the full potential of Airtable and its powerful integrations.

 

Our Airtable Automation systems work in any niche, regardless of whether you’re a solo entrepreneur or a 100 member organization.

 

And now, you can learn how to Organize and Automate your business using my exact system.

Introducing: Build Your Own Automation Machine

Not everyone can afford $6,000+ to have us organize their data, or identify and automate their time consuming, low value processes. Not yet anyway.

 That’s why we created “Build Your Own Airtable Automation Machine.” So that you’d have the exact processes, tools, and guidelines we use to build out our easy to use bases and automations, and do it yourself for a fraction of the price.

By the end of the course, you will be able to:

  • Strategize and build Airtable bases that save you time and decomplicate your work life.
  • No longer see Airtable as just a spreadsheet replacement.
  • Avoid the most common traps for using Airtable incorrectly.
  • Take advantage of Airtable’s most powerful feature- Relational Databases.
  • Use my favorite blocks to get key business insights from your data.

 

But most importantly, you’ll come out of the course with a plan in hand for structuring your data and workflows in a way that’s designed to make you deadly efficient.

 

In fact, you could sign up for the course today, take the course over the next 6 weeks, and by the end of it, have completely transformed the way you work.

In Case You Were Wondering…

This isn’t some abstract, “internet guru” course where some random guy is talking at you over a bunch of slides.

It’s a ride-a-long with me while I plan out and build something I’d create for my clients, doing all the work in a way you can easily follow along with on your own.

 Just like on YouTube, but better.

“Never do something yourself that you can delegate, never delegate anything that you can automate, and never automate anything you should have eliminated in the first place!”

Your Curriculum

(Over 8 Hours of Instruction)

Module 1 – Strategizing Your Build

A successful build is measured by whether or not you look forward to using it every day. If it’s powerful, easy to use, and saves you time, you’ll be pleased with your Base. This is why we start by detailing your current processes.

  • Map Out Your Processes
  • The Importance of Mind Mapping
  • Guidlines To Get All The Right Details
  • The Best Tools for Mapping

 

Module 2 – Planning Tables & Fields

Before you can begin automating and organizing data, you have to understand what Airtable is capable of. In this module, I’ll show you how powerful Airtable is and how to use it in a way that makes Excel or Google Sheets feel archaic. Then, you’ll learn how to organize data in a way that gives you clarity and insight, rather than overwhelm.

  • Airtable Terminology
  • Your Tool For Planning Tables & Fields (custom built this for our students)
  • Exploring Airtable Field Types
  • Dependent vs Independent Data
  • Identifying Data Sources

 

Module 3 – Architecting Your Base

Time to build out Bases!  You’ll learn to avoid the most common mistakes people make in Airtable, and my best practices for organizing and managing data.

  • Building the Framework
  • Linking Your Tables
  • Using Lookup Fields
  • Using Roll-up Fields
  • Using Formula Fields

 

Module 4 – Automation Design

How much time do you spend at work on activities that aren’t related to your highest value activities? Be it sending emails, chasing invoices, rescheduling, repetitive data entry – this module is about identifying what you should automate, and how to translate that into Airtable.

  • Zapier Terminology
  • Your Tool For Planning Automations (Custom built for our students)
  • Zapier Built-ins
  • Zapier Resources
  • My personal list of favorite software choices

 

Module 5 – Building Your Automations

After designing your automations comes building them. In this module, I’ll walk you through the most common automations and how to make them automatically “fire” using triggers.

  • Connecting Your Accounts
  • All Available Triggers (Airtable, Zapier, Other sources)
  • Action Steps For Each Type of Trigger

 

Module 6 – Troubleshooting Your Systems

Before “Setting & Forgetting” your automations, you need to stress test them to ensure you can rely on them. In this module, I’ll show you how to do just that.

  • Test Zaps Before Enabling Them
  • Zaps From Updated Records
  • Zapier Task History
  • Unpacking A Zapier Status
  • Common Problems with Airtable Zaps

 

Bonus Module: The Most Useful Airtable Blocks

 Airtable’s blocks are mini apps that add layers of functionality on top of your workflow. The problem is the sheer number of blocks! It’s easy to get overwhelmed and paralyzed by the choices. In this module, I’ll take you through the few highly useful blocks I use to get the insights you actually need.

  • Do You Need A Block?
  • How I use Summary Blocks
  • How to use Chart Blocks

We appreciated the step-by-step process that started us at the very beginning of mapping out our processes, taking us through data choices and then into the “harder” stuff! This made us back up from what we were doing and helped us better SEE where we needed Airtable to take us.

–Julie Kessler  

 

I loved the structure of the course. My favorite chapter was the first one: so helpful for the structure of my database! I’m really excited about the result! Loved  your teaching method too! So much clearer than when I try to explain to my colleagues what I’m trying to build…

–Laurence Rivard

Space is limited – Sign up today to reserve your seat.

Gareth Pronovost

Airtable Expert, YouTuber, GAP Consulting CEO 

Hi, I’m Gareth.

In 2017, I was working for a billion-dollar public company that still used spreadsheets to report their data. Reports had to be manually updated and printed on 11x17 paper. I spent hours on redundant data entry and administrative tasks, which prevented me from doing the work I had been hired to do as a financial analyst.

It was a slow, confusing, and inefficient way to work.

With Airtable, all of that changed. I was able to organize data and eliminate hours of daily administrative tasks through automations. Since then, I’ve helped dozens of businesses harness the power of Airtable to do the same.

With an optimized Airtable set up, your time, money, and focus stays on growing your business.

     

    F.A.Q.

    What is it?

    Build Your Own Airtable Automation Machine is a 6-week online course with over 8 hours of guided instruction, live Q&A calls, and a community of entrepreneurs. The course is the most comprehensive program available on how to organize data and optimize workflows in your business using Airtable.

    Do you help us build our bases?

    The course is designed so you’ll learn how to build complex bases alongside me – all of which translates directly over to any base you’d like to build. If you have questions beyond what’s covered in the course, great! I will help you through your specific scenarios inside the private Facebook group.

    What if I’m not happy with the course?

    I made this course to be tactical and immediately relevant in any business. That being said, if you’re not  satisfied, contact us in the first 30 days of instruction and we’ll honor a full refund!

    How much experience do we need?

    If you can use a computer and Excel or Google Sheets, you’re all set!

    What’s included with the Course?

    • 6 guided, in depth, recorded modules (and a bonus) which you can access at any time. (Over 8 hours of instruction)
    • Access to my private Airtable mastermind group.
    • Support through the group & Weekly Q&A’s
    • Lifetime access to the course, including all updates.
    • Certificate of Completion

    Working with Gareth gave me a new level of clarity into the key metrics of our business. Not only did I know exactly what I needed to do to increase revenue, but thanks to the automations, eliminated over 10 hours of weekly repetitive tasks.

    Srini Rao,
    CEO
     Unmistakable Media

     

    I always look forward to my meetings with Gareth due to his seemingly endless knowledge in finances and accounting. Simply put, getting my business off the ground was much easier thanks to having Gareth in my corner!

    Ryan Coon,
    Founder 
    Switchboard Games

    What you learn in this course are the same skills I use to build $6000+ custom Airtable bases & automations for my clients. I can’t wait to share what I know with you.

     

    Because this course is in beta, enrollment is limited – so don’t wait!

    Space is limited – Sign up today to reserve your seat.

    Questions? Email me! Gareth@garethpronovost.com.

    It doesn't have to be crazy at work

    It doesn't have to be crazy at work

    Subscribe and get my best lessons on how to harness the power of Airtable for your business.

    You have Successfully Subscribed!

    Pin It on Pinterest