Managing the timezone in SyncWith’s Google Sheets addon

Alex Black

Alex Black

How does SyncWith use Timezone

When SyncWith inserts dates into your google sheets, it needs to use a timezone to indicate what day and time to put. The same moment can be represented by a different day and time in different timezones, for example as I right this its late at night on Thursday, but its likely already Friday in other parts of the world.

Timezone Discrepancies

A difference in timezone can be a common source of small differences between different systems, for example when comparing data from SyncWith in Google Sheets to the original source (eg Facebook Ads, Google Analytics, Shopify, etc).

How does SyncWith handle Timezones

  1. SyncWith uses the timezone from your Google Sheet.
  1. When a new report is created, the current timezone from your Google Sheet is saved into the connection, so that when the report is updated we can use that same timezone

Changing the Timezone that SyncWith uses

  1. First check (or change) the timezone in your Google Sheet
  1. Once the timezone is correct in your google sheet then you will need to recreate any report(s) again, to cause them to use the new timezone.
See below for how to view and change the timezone in Google Sheets:
notion image
notion image