google-apps-scriptgoogle-sheetstimestampzapier

Getting exact date and time by new row in Google Sheets via Zapier


I have a simple but stubborn problem. I have data from our ESP which I send via Zapier into a Google Sheet. Unfortunately, I can not send the SignUp date from the ESP via Zapier, so I am looking for a solution to create the date by a new entry within the Google Sheet.

I've tried =TODAY() and =NOW() inside the row in Zapier, so the function will be put in every single time from Zapier. The problem is, that both of these functions give me every time the time of just right now, so if I have a week-old entry, it still shows me that it is from today.

Next, I've tried to use an array function.

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

But I have the same exact problem, the momentary date of the input is not saved but always just right now overwritten.

Does anybody have any idea how I could create a date & time by entry?

Thankful for any ideas!


Solution

  • Zapier supports date/time commands in the action fields. All you need to do is add one of these commands when you're setting up the action.

    You can use one of the following entries:

    There are also entries for all the US timezones

    For more info see https://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field

    Source data (without date/time)

    Source worksheet

    Destination data (with date/time added by Zap)

    Destination worksheet

    Example set-up to add date/time

    Iso date command

    Adding iso date to field