Hi guys,
I wonder why my automation dos’t work.
I have a google sheet data base for my article.
Each line is an article that i want to publish. All Article have a publication date.
The date format is : 1 May 2024 12:00 (for exemple)
And my autmation never worked.
The problem is on make automation in Shopify Article.
There is a field for “published at”.
When i start a test, it can work but on shopify the article is instant publish and not like “programmed” or something like that.
I have test multiple date format, and no one working. I have test this "{{formatDate(parseDate(result; “X”); “MM/DD/YYYY”)}}
" in the make field (but not working)
The for you help make communauty !
@Mathieu_Malige
It seems the issue lies with the ‘Published at’ field, which requires date-type data. Please ensure that the mapped value is converted into a date field using ‘parseDate’.
Additionally, I couldn’t seen any data in the mapped variable. Could you please provide the google sheet out?
If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel
Hi @Msquare_Automation thanks for your reply.
Here’s the google sheet : Articles Miyota / Seagull - Google Sheets
Go on seagull tab and see on colomn “date-publi”.
Can you say me what i’m supposed to optimise for make my automation live.
Thanks a lot for the help provided
@Mathieu_Malige
Please use the parseDate function in this format: {{parseDate("{{4.date-publi(W)}}", "DD MMM YYYY hh:mm")}} . Map the field within the parseDate function.
If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel
1 Like
There is an error :
Did i make a misstake ? @Msquare_Automation
Ok i’ve done a misstake.
Now, i’m like you describe me :
It marked sucess on make :
But on Shopify :
It’s not set for the day i want…
Here’s the data outbout from the tool :
What’s wrong here ? thanks for help @Msquare_Automation
