How can we get the entry/record URL?

You can easily generate the URL of an entry as a field value by creating an auto generate field in the sheet. On the field settings' formatting list, scroll down and choose "Record URL" format.

With this format, the system will auto-populate the field with the URL of each entry created in the sheet.