Skip to main content
Question

How can I record date in Google Sheets via Zapier?

  • 13 June 2024
  • 4 replies
  • 16 views

I am looking to record an event date in google sheets.  I tried the =today() formula in google sheets, but the date changes as time passes.   What can I input in Zapier, to record the correct date in a google sheet row, and it not change as days pass.

Hi @LeasingXpert 

Timestamps: https://zapier.com/help/create/customize/insert-the-time-your-zap-runs-into-a-field

Formatter > Date & Time > Format


Thank you, but I am looking to do this without the time stamp.  I only want the date. 


@LeasingXpert 

Use this Zap action: Formatter > Date & Time > Format

You can change the format of the timestamp to be only the date


Hi @LeasingXpert,

+1 to what Troy suggested. You can use Date & Time formatter format function to remove the timestamp. Here’s how to set it up:

cce60b79a3d7a5059886172c76bcb3fe.png
(view larger)

3a31db3ab9b7b08376f0952d9370a474.png
(view larger)

Hopefully, this helps!