Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi all,

I have numerous zaps from PPC ads/web leads filtered into Google sheets, this has been running fine until this week. 

All the data is being pulled correctly other than the date and time, which now appears as a random set of numbers. 

e.g 44600.2868055556

Nothing has been edited or changed with Zapier and it seems this issue has literally happened overnight. 

The zaps itself seems to be showing no issues and when I preview the link, the data input all seems to be correct, the issue seems to be at the point of filtering this data into the Google sheet. 

 

Hey @Jet ,

 

From which app are you getting this number? Can you share screenshot from Data Out from Zapier History?

 

Hi Jaye,

These are coming from various apps, Webhooks/Facebook/Google Ads are the 3 main ones I believe. The issue seems to be with all of them.

 

 

Hey @Jet ,

 

This looks like column formatting issue. Can you check what is the format of this column on Google Sheet? You can know this by clicking Selecting whole column → Select Format → Number → Find the format of this column 

Thanks Jaye,

That definitely seems to be what the issue is.

The format on the entire column is set to the Date/Time, however on the recent data that has the issues, these individual fields are set to automatic.

I have changed these fields manually to Date/Time which has fixed the issues on the info that is already on the sheet.

However my concern now would be new leads that are coming through reverting to “automatic” formatting.

Thanks again for your help!

Terms & Conditions