It looks like you are already using a built in form with it’s own submit button at the top right. Just curious why you are creating a separate button with an Add Row action? The top right button will already submit the data to the sheet.
If you are actually looking to create a custom form with a custom button, then I would recommend looking at this thread:
Your current approach seems confusing and probably why it’s not working like you think it should.