I’m currently getting 1596229758 for the timestamp in my googlesheet. What format is this? and is there a way to convert it to something normal?
it’s unix timestamp.
unix timestamp is very polular way to present date and time because it’s easy to calculate a difference between two times. but it’s not human-readable.
you can convert it with custom code block but you may need to know about timezone.
this might be help.
Thanks for the info! I ended up using Zapier to convert it in my googlesheet