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:
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.