Yes, this can be automated with Make's Gmail integrations and Make's Airtable integrations. It can monitor a certain email address, and then it can create a record in Airtable with the contents of the email.
If you've never used Make before, there is a small learning curve, so I created this basic Make navigation video to help. In that thread, I also provide the links to a few other Make training resources there as well.
p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consultant — ScottWorld