Hello -
I’m trying to take dated journal entries from my CRM and put them in a table in a google doc.
I was able to extract the data via webhook and format via JavaScript. Still need to figure out how to format the date which is the number in the screen shot.
I guess I have two questions, how do I transform the highlighted number to a date, then put each entry into a row in either sheets or docs?
+9
Hi
These are Unix timestamp in milisecond. Zapier’s internal date-time formatter doesn’t directly support unix millisecond formatter I think, you can probably substring the length and get it to work. Since you are already using JS to achieve some of it I think you should keep use the same JS code step to
Better use chatgpt to generate the code piece
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
