I agree with Rose on the use of a web form tool. Recently built an intake form Jot Forms for a client in the mental health sector that had drop down menus and conditional formatting to help expedited filling if say a set of questions were “no”. Then the user wouldn’t need to read through questions that did not apply. Once the user hit submit, then all this sync’d to a Google sheet where they then built various reports. For some of the clients they interacted with, I built in a function to have the completed form print to PDF so the client had a copy of their submission.
There are so many options with these form tools, like integration with apps like dropbox, salesforce, slack and a host of others. Lastly, since it appears your capturing health related info, Jot Forms has security feature which comply with HIPAA rules if your based in USA.