I am familiar with the "send me a copy of my response" on a sheet's form. The format of the email the user receives is nice and looks similar to the form itself. I would like to have that same (or very similar) email sent to the Admin of the sheet as an automation.
I am also familiar with automating a notification from the sheet itself to th Admin. That email contains the information as it appears on the sheet — in one long row of columns, which is much more difficult to read than the email the user received when they filled out the form to begin with.
Is there a way to have the sheet notification automation send the Admin email in the same format that the user receives? I want my Admin notification that a form has been submitted to look the same as the one the user can elect to receive.
This is what the form user receives:
But this is what the automation sends out to notify us Admins of the entry:
How do I get something more like the first image instead of the second?