If I want to run a python script when an item is created in a table using pyairtable, is this possible or will I only be able to do this through an IDE/terminal? If I can import my script to the website, will I need the plus, pro, or enterprise-level account?
I think Pro or better allows you to use the Airtable API.
If your goal is to use data from Airtable to create a web app, you might want to take a look at Streamlit.
Pro or higher (not a Pro trial) is required to run an automation script, which is what could call your endpoint on your server.