im trying to add time to my script here

[F.A.N.]

Hello 

I generated this script with chatgpt , since I'm not developer i would like to ask how can i add a time stamp to it , it shows me only date in 1 column in my google sheet , but i need a second column for time ( HH:MM) . 

  function doPost(e) { const sheet = SpreadsheetApp.openById("PUT-YOUR-SHEET-IDHERE").getSheetByName("Sheet1"); const data = JSON.parse(e.postData.contents); sheet.appendRow([ new Date(), data.phone || "", data.gclid || "", data.source || "", data.medium || "", data.campaign || "", data.term || "", data.content || "", data.userAgent || "", data.referrer || "" ]); return ContentService.createTextOutput("success");   

[Google Ads Scripts Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads Scripts Support team.

On reviewing the reported script, I would like to inform you that it was a third party script and we cannot provide support to third party scripts. In order to include the date and time usage in Google Ads Scripts, you can refer to the documentation for more information.

Thanks,
 

Google Ads Scripts Team

Feedback
How was our support today?

               
[2025-07-23 19:40:41Z GMT] This message is in relation to case "ref:!00D1U01174p.!500Ht01swX9d:ref" (ADR-00319934)