Select Page

Build Your Own

Airtable Automation Machine

(Imagine quickly building powerful bases that save you time, organize your data & simplify your work life).

I launched GAP consulting in 2017 to help my clients organize and automate their businesses through Airtable.

I focused on building powerful solutions for clients. This meant Airtable bases that were easy to use, gave clarity, and made work-life easier. These solutions saved clients dozens of hours every month through improved workflows, and netted them thousands of dollars in reclaimed efficiency.

 Zero overwhelm. Complete clarity.

 

Today, GAP consulting architects everything from simple, organized bases to bespoke, $6,000+ Airtable automation packages.

In this course, I’ll teach you 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.

We’ve helped companies streamline their workflows in industries as diverse as:

  • Real Estate Agencies
  • Construction
  • Consulting
  • Tech
  • Ecommerce
  • Manufacturing
  • Digital Media Agencies
  • Thought leaders in the author and coaching spaces

Our Airtable Automation systems work in any niche, regardless of whether you’re a 1-man 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

In the last year, we’ve worked with some incredible companies. World famous internet marketers, published authors, and many small to medium sized profitable businesses.

But over half of the companies I spoke with weren’t a good fit to work with us. 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.

In this course, you’ll learn exactly how we harness the full potential of Airtable to plan, prioritize, identify, and automate your low value time sucks. You’ll also learn the strategy and design thinking behind how I create $6000+ bases for my clients.

By the end, you’ll be able to interpret your problems and translate them into powerful, easy to use bases and automations.

And this isn’t some abstract, “internet guru” course where some random guy is speaking 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.

I explain everything as I’m going in clear steps, so you can follow along and duplicate the processes for your own business.

For example – we follow a rule with every build: “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!”

This rule ensures you and your employees remain focused on the most valuable tasks for your business – and not mired in the minutia of clerical work and data entry.

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. 

As an example: In running GAP Consulting, I no longer have to schedule calls, chase payments, invoice clients, send re-schedule emails to prospects who don’t show,  or collect testimonials

Like a good virtual assistant, Airtable does all of this and more for me, saving me over 40 hours every month. What could it do for you?

Your Instructor:

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.

Your Curriculum

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 – Toubleshooting 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

 

F.A.Q.

What is it?

Build Your Own Airtable Automation Machine is a 6-week online course with 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 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.
  • Access to my private Airtable mastermind group.
  • Support through the group & Weekly Q&A’s
  • Lifetime access to the course, including all updates.

WHAT OTHERS SAY

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 is the first time I’m making this material available to the public, this is a one-time low price and enrollment is limited – so don’t wait!

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

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 is the first time I’m making this material available to the public, this is a one-time low price and enrollment is limited – so don’t wait!

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

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