Sorry for the confusion on this one - I finally tracked down the root cause of the issue and am in the process of putting a fix together for it. I will update this thread once the fix goes live.
I just deployed the fix for the time format issues with live publish. Let me know if you still see issues with it once you try setting up the zap again.
I am trying to import 9000 articles from a previous site into Webflow. I can’t change the Created Date built in to Webflow, so I’m including a Date field in my Collection settings to receive data from Google Sheets via a Zapier zap.
In order for a date field to accept a date string from google sheets via zapier, the date string coming in via Zapier needs to be in the format you’ve shown us above, correct?
Also, does this apply any differently whether the Date field includes the TimestampPicker option or not?
Also, this is the hint format that your app shows:
I think I’ve cracked this problem for me. I’ve tried myriad date formats hoping to pass through the correct format into Zapier and thinking it would send Webflow the correct format. Incorrect assumption.
In Google Sheets, you’ll need to format your date as above, exactly (the only problem is if you change something, there’s a chance you’ll get a duplicate).
In my case, I have thousands of articles to replublish. Reformatting more than 100 cells like this manually is dumb. Let’s try a formula: =LEFT(C:C,10)&"T00:00:00.000Z" This is in essence: Take the first ten characters of the column "C" and add to that the Time string all the way to the Z at the end. (where “C” is the column where I have the publish date string from the other platform you are migrating from)
Change this letter to match which column in your spreadsheet holds your desired date data.
If you’d like to include the timestamp, you’ll have to add in your own changes to that formula. You could also use some of the other DATE and TIME formulas for this, but that’s beyond scope for me.
I’m no spreadsheet guru, so I hope this helps someone else, too, in their migration to Webflow.