Skip to main content
Question

How can I record date in Google Sheets via Zapier?

  • 13 June 2024
  • 4 replies
  • 15 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.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @LeasingXpert 

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

Formatter > Date & Time > Format

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
L

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

Troy Tessalone
Userlevel 7
Badge +14

@LeasingXpert 

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

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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
ken.a
Userlevel 7
Badge +6

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!

Terms & Conditions