Is there any way to create a back up and restore the entire data in appsheet.

You may want to focus on functionality available within your data source. In Google Sheets, you could even automate periodic data backups using Apps Script.

Within AppSheet, pertinent functionality that you could utilize includes: