Welcome to the community, @Justin_Gilbert!
Yes, you can easily do this with Integromat, which is a no-code/low-code, point-and-click, automation & integration tool.
Just use Integromat’s FTP module (or SFTP module) to monitor for new files, then use the CSV module to parse the data, then use the Airtable module to sync the data into Airtable.
Once you set it up once, it will work automatically from that point forward.
p.s. I am a professional Airtable consultant and an Integromat Partner, and the Integromat links contain my partner referral code. If you have a budget for your project and you’d like to hire an expert consultant to help, please feel free to contact me through my website at ScottWorld.com.