Stuck on creating own ai connect to airtable

Hi there,

Brand new to this community and brand new to no coding (or coding for that matter - actually did some coding in year 9 I think it was way back in time on commodore 64 when it was released and another computer I think was called Z81 or something).

However always loved this kind of stuff. Excited to be here.

My Question:
(Context to question) I’m building an AI App that will be able to analyze a personality test I created. I want to be able to feed it the results from the test and I will feed it the results manually (as in that will be the prompt I will give provide it) and then I want the AI to analyze (with my specific criteria for doing it) my knowledge base and provide me with a personality report on the testee’s/respondants test results.

(Question): I was thinking of uploading all my knowledge into airtable (as word docs if thats possible) then have workflow inside bubble that would then connect open ai to the airtable, is that possible? Am I on the right track in my thinking here?

Any help or feedback from you the Pro/Expert in this would be greatly appreciated.

Thank you,
Patrick