Best answer

Formatting dates in Google Sheet action

  • 7 June 2021
  • 2 replies
  • 760 views

I am trying to send a date and time to a column in a google sheet, using the command {{zap_meta_human_now}}. However, for some reason the data is going in fine to the google sheet, but the data out is just numbers. I’ve tried using the Formatter but no matter what format I use I always receive these numbers in the sheet.

 

 

I am not sure how to fix this issue. I’ve tried looking through the help documentation, but I can’t find anything. Does anyone know what is happening?

icon

Best answer by Troy Tessalone 7 June 2021, 20:12

View original

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

2 replies

Userlevel 7
Badge +14

Hi @Emilio von Ziegler 

In GSheets, try setting the format of the column.

Or you can try using a Formatter > Date & Time > Format step in the Zap.

 

@Troy Tessalone Changing the format in the google sheet worked perfectly! Thank you very much!