Timestamp data fetching into google sheet
Status: Closed · Asked by shambhuraj khamkar on · 0 views
I have connected Razorpay to Google Sheets and whenever my transaction happens that time data is transferred to Google Sheets but I want timestamp ( date and time ) data with that when the transaction is happening.
Ex - Rohan made a payment of XYZ amount so, this data of payment will get transferred into Google Sheets but with this data, I want real-time ( Date and Time ) with that transaction data so I can analyze that when my payment or the transaction is happening. so howm can i do that ?
Hey @shambhuraj khamkar
You can use Date/Time Formatter's "Current Date" for this use case. Kindly add a step before Google Sheets and choose the action "Current Date". Also, you can change the format of the date and time as you prefer. Then you can map the result in Google Sheets.
Refer to the image below,
