Hi @Matthew_Borton ,
I generally use Make (cannot stand Zapier -slow to build, poor branching, need a step for formula, horrible debugging) or Pipedream (when you need to add some custom code or have higher volume of transactions and Make gets too expensive). In both cases don't remember ever rate liming being an issue.
Even if, both Make and Pipedream can run sequentially to avoid rate limiting, so that would be 5*60*60*24 = 400k+ read/writes per day at max - seems a lot.
Going further not all reads actually need to go to Airtable. My own website is 100% on Airtable ( https://business-automated.com/ WIP... ) but it is statically generated on Vercel, and revalidation is set to at max 1 per hour - meaning it will not run into API rate limit.
If you built e.g. customer facing front on Softr.io I believe they also have data caching.