How can I capture the precise date and time when a new row is added in Google Sheets through Zapier?

Other Questions Zapier
1

I am facing a challenging issue with my Google Sheets integration using Zapier. I send data from our email service provider, but I’m unable to pass the SignUp date through Zapier. Therefore, I’m seeking a method to automatically generate the date when a new entry is added to the Google Sheet.

I initially attempted using functions like =TODAY() and =NOW() directly through Zapier, expecting them to populate every time. However, these functions always yield the current date and time, which leads to old entries showing today’s date instead.

Next, I tried applying an array formula:

=ARRAYFORMULA(IF(ISBLANK($B4376:$B), "", NOW()))

But I encountered the same issue where the date isn’t retained, as it continuously updates to the current timestamp.

Is there anyone who can suggest a reliable method to log the original date and time for each entry? I appreciate any guidance!

2

I suggest using a Google Apps Script to automatically timestamp when a row is added. You’ll need to write a script that assigns the current time to a cell whenever new data is added to the sheet. This approach should accumulate your desired timestamps without them changing like with NOW().