The most efficient (not easiest) way to do this would be to use the API offered by airtable
This is the easier less efficient way:
Here is a great example of working with airtable API the more efficient way