If the timestamps displayed in Google Sheets do not match your time zone, you first need to configure your spreadsheet, then refresh the data in Ubiqod for the changes to take effect. Only after that will the timestamps for future entries reflect the local time zone you have set.

To update the time zone in your Google Sheets file, go to File, Settings and Time Zone. Setup your timezone in Google Sheets, and then click on Retrieve Spreadsheet data in Ubiqod.

The instructions are mentionned in the connector: