For the past couple of years, GAP Consulting has managed all of our ongoing leads, projects, payments, etc. (basically our entire business) from an Airtable database. I hope this comes as no surprise, seeing as this is exactly how we help our clients. As I mentioned in an email from a couple of weeks ago, we realized that we essentially help create low-code apps for our clients. To...

Last week, I showed the power of using Conditional Form Logic - the end result is a form that adjusts as it is answered. Different questions become available based on inputs as they are received. As you might imagine, building automation for this type of form is more advanced, giving us the perfect excuse to explore Zapier's Paths.

Before we get too far, I would be remiss not to mention...

There are two common ways to get data into a database. You can either:

1. Import a dataset in bulk
2. Bring in data one with each new record submitted

For the most part, I recommend the first option, bulk imports, only when first setting up a database. Ideally, once the base is established, it makes the most sense to bring new records in automatically (saving you the need to import data...

When building automation to support your Airtable databases, you’ll likely encounter the need to FIND A RECORD in Airtable. This is one of the action steps that Zapier makes available with the Airtable integration. Finding a record is commonly used in situations when you need to update a record (you have to locate it before you can update it) or when you need to link one record to...

Revenue. One of the most exciting words to business owners. It’s the fuel in our engines of change and the catalyst for a better life. Without revenue, every business would be little more than a shell of ideas and good intentions.

Why then do so many businesses neglect to pay attention to their revenue? Putting it simply, failing to track revenue is like sailing a ship without a compass....

I struggle with business email in a big way – the main issues I have are as follows:

1. I hate having multiple ‘systems’ in my business – why can’t everything happen from one place?
2. Along those same lines, with a new system comes new procedures and practices… no thanks!
3. The decision fatigue is real – there are so many Email Service Providers (ESPs) to...

My recent posts have covered a variety of use cases for automation. However, in all the commotion of “create documents in the cloud” or “automatically create folders for projects,” I realize there’s a complicated (and critical) step that we’ve never taken the time to address. Specifically: building an automation between multiple tables.

Imagine this...

Many of the clients we work with are looking for highly unique and customized solutions. This is always fun, because it gives my team and I the chance to stretch and grow our automation skillset. However, there are also those automated processes that seem to be required for many businesses that we work with. One such example is the need for automated document creation.

Several months ago, I...