Airtable Automation

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.

You're missing out on Airtable's power.

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.

Introducing: Build Your Own Automation Machine

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

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 Airtable Automation Machine.

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 soloentrepreneur or a 100 member organization.

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

What You Will Learn

In Airtable Automation Machine you will learn the exact processes, tools, and guidelines we use to build out our easy to use bases and automations--for a fraction of our $6000+ 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.

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.

Course Outline

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
Student

"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
Student

Choose Your Preferred Plan

COURSE

MACHINE

$1247

Airtable Automation Course
All future course updates
Private Mastermind Access
Ongoing Support (2 months)
(6) 1-on-1 Coaching Sessions with an Airtable Expert
Full day onsite Workshop for your team

BUY FOR $1247

1:1 COACHING

MASTERY

$2747

Airtable Automation Course
All future course updates
Private Mastermind Access
Ongoing Support (6 months)
(6) 1-on-1 Coaching Sessions with an Airtable Expert
Full day onsite Workshop for your team

BUY FOR $2747

WORKSHOP

MAVEN

$9997

Airtable Automation Course
All future course updates
Private Mastermind Access
Ongoing Support (12 months)
(6) 1-on-1 Coaching Sessions with an Airtable Expert
Full day onsite Workshop for your team

BUY FOR $9997

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 hundreds 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.

"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