Automate Google Sheets to fill a webpage form in another Chrome tab

I hope you all are well. My Google Form populates a new Google Sheets row with demographic information. I need 5-6 separate cells to be transferred into an Electronic Medical Record for patient registration. The EMR ( can be opened as a webpage in Chrome or as an AP. To what degree can I automate this process: 5-6 single line form fills transferred from an updated row, one checked box, then click the submit button. Even if I have to manually open the page first that would be an improvement. Looking forward to any possible solutions.

I think that can be fully automated. I would export the Google Sheets data as CSV, and then import it into the RPA software. Then UI.Vision can simply read all the data from the CSV file and populate the new EMR website.