Skip to main content
Answered

Correct Typeform time stamps for GSheet Integration

  • 2 June 2024
  • 1 reply
  • 14 views

My Type form is adding rows to a Google Sheeet with each new form entry using the standard Tyepform GSheet Integration. The Timestamps being added to the Gsheet with each new entry from Typeform are set to the incorrect time.
Where can I adjust this setting in Typeform.

1 reply

Userlevel 7
Badge +6

@Dutchy - the timestamps from Typeform are in UTC as they are stored in the server. This ensures consistency in the data regardless of geolocation. 

you’ll need to convert the timestamps in the Google sheet to match the timezone you wish to use: suggest though that you create an additional field in the Sheet to do this conversion 

 

des

Reply