Sure, it sounds like you could do all of that with Airtable’s new automations feature!
Although Automations are still new and are still being tested — so if you’re looking for a no-code automation platform, I highly recommend Integromat, which gives you a lot more control & customizability & power.
Also, if you know JavaScript, you can code your own custom automation script in Airtable.
Lots of options for you!