Submit form results into a live google sheet automatically

If I’m understanding you correctly, you can do this in Google forms directly then link the sheet in your portal.

Inside the form, you can link responses to a sheet and create a spreadsheet, and every new form response will automatically go onto that sheet.