Coach Portal to house clients data and update automatically

Would Airtable be a good choice to create a Coaching portal?

Lets say I have 100 Coaches and each Coach has 50 clients. Data for each client would come from a survey in Typeform and a few course in Thinkific or Teachable. I want to be able to automatically update each client as data comes in from Typeform/Thinkific. Would this work?

Anyone ever done anything like this?