To make sure the format is correct:
Open the destination tab.
Select the entire column.
Go to the spreadsheet menu Format > Number and select the right format.
This action is necessary only once per connected tab. Whenever the connection and data are updated, the formatting will remain the same.
It's also important to make sure you're using the correct settings for your time zone and location.
Open a Google Sheets file.
Go to File > Settings.
Changing these settings will adjust all formatting in your document.
Importing date formatting from Excel or CSV files
If you're importing dates from an Excel or CSV file, you need to tell Sheetgo which format to apply under Settings. Read more here.