Skip to main content
Question

The date is being converted to numbers when sending to Google Sheets

  • 17 July 2024
  • 2 replies
  • 16 views

 

I have a problem that the date information is not being sent correctly to my Google Sheets.Both with my CRM tool (Pipedrive) and with our KPI software (Perspective).The problem always occurs with date information.The date information is not adopted but is converted into arbitrary numbers and the date format no longer appears.Example: Date to be adopted by Zapier: 07/01/2024 - Zapier makes it 45474,64189.

 

2 replies

Userlevel 7
Badge +14

Hi @Moritooo 

GSheets help article about how to format cells as a date: https://support.google.com/docs/answer/56470?hl=en&co=GENIE.Platform%3DDesktop

Userlevel 7
Badge +5

Hi @Moritooo,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.

Reply