Razorpay to Google sheets > How to configure column for date?

[h1seera]

My workflow is that, when a user places an order it gets updated on a google sheet. I am able to configure: Name, Email and Phone number. However, I want to add a column with 'order date' as well.
I am not able to find any option to do so. Kindly guide.

PS: I tried timestamp using google script but it doesn't let me add any.

 

[Pabbly]

You can convert the timestamp to regular date format as shown below -

You can then add the order date in your Google Sheet then.