• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Google.date.start should be a valid ISO 8601 date string

Antenne

Member
Your Task History ID
IjU3NjEwNTZkMDYzZjA0MzY1MjY1NTUzZDUxMzQ1MTY2NTQzOCI_3D_pc
Hi,

I have started copying my google contacts to Notion upon update/creating new with Pabbly connect. And it basically works fine. Except for the birthday date.

If I format this as text in the Notion database, it works, but not if I try to use date format in my Notion database. I somehow can only transfer the birthday in text format, which prevents me from using it e.g. for a birthday calendar in Notion. Any idea what I am doing wrong?

This is the error message I get: body failed validation: body.properties.Geburtstag Google.date.start should be a valid ISO 8601 date string, instead was `"04.06.1978"` And I cannot find any full date in date format to refer to ... just Birthdays 0 Text for the full date or Birthdays 0 Date Month or Birthdays 0 Date Day or Birthdays 0 Date Year (see attached screenshot).

In case this matters somehow ... I am located in Germany and Google requires me to enter dates in format DD.MM.YYYY. I have already tried to change my settings in Google (change language to English / US) to maybe change the date format as well ... that did not work.

One more thing ... if I export a contact from google contacts, the date format seems to be fine and according to ISO 8601:
[xxx] ,1978-06-04, [xxx]

Thanks in advance for the the info.
 

Attachments

  • Pabbly_Birthday.PNG
    Pabbly_Birthday.PNG
    30.7 KB · Views: 50

Antenne

Member
Hi,

thanks a lot. But unfortunately, this still did not do the magic.

Date/Time Formatter Result: No Data (see screen shot Pabbly_NoDate)

I have also tried to pick the date instead of leaving this field blank (see screen shot Pabbly_Date_ReplaceText).

And I have tried changing the date format in the Date/Time Formatter so that it matches the format in notion (see screen shot Notion_Date_Format).

But none of this works ... even though it looks nice all the way ... (see screen shots Pabbly_DateFormatter_SetUp and Pabbly_Geburtstag_Google)

I have even tried to play around further, but no luck and I am going to skip the details here.

Any other idea? BR, Antenne
 

Attachments

  • Pabbly_NoDate.PNG
    Pabbly_NoDate.PNG
    38.1 KB · Views: 57
  • Pabbly_Date_ReplaceText.PNG
    Pabbly_Date_ReplaceText.PNG
    44.8 KB · Views: 51
  • Notion_Date_Format.PNG
    Notion_Date_Format.PNG
    11.6 KB · Views: 52
  • Pabbly_DateFormatter_SetUp.PNG
    Pabbly_DateFormatter_SetUp.PNG
    51.4 KB · Views: 61
  • Pabbly_Geburstag_Google.PNG
    Pabbly_Geburstag_Google.PNG
    10.3 KB · Views: 50

Antenne

Member
Hi,

me again ... I managed ... I kept playing around and after all it worked ... thank you so much for the support. Let me add with which settings it worked for me (so that this might be of help for another person some day).

Thank you so much for helping me fix this. With this great support, I like this tool more and more.

BR,

Annette
 

Attachments

  • Pabbly_DateFormatter_SetUp_Working.PNG
    Pabbly_DateFormatter_SetUp_Working.PNG
    63.5 KB · Views: 61
  • Pabbly_TextFormatter_SetUp_Working.PNG
    Pabbly_TextFormatter_SetUp_Working.PNG
    56.7 KB · Views: 59

Antenne

Member
Hi,

and me again ... it worked for the test contact ... but it did not work for the next real contact to be transferred.

Task History ID: IjU3NjEwNTZkMDYzZjA0M2M1MjZkNTUzMTUxM2I1MTYyNTQzMyI_3D_pc

The contact is Denise and you can see how her birthday is set in Google Contacts (see screen shot).

I have also attached the date format in Google Contacts of my test contact Martina (see screen shot).

Any idea what is going wrong now? BR, Antenne
 

Attachments

  • Pabbly_Error_Denise.PNG
    Pabbly_Error_Denise.PNG
    32.5 KB · Views: 58
  • Denise_DateFormat_GoogleContacts.PNG
    Denise_DateFormat_GoogleContacts.PNG
    1.3 KB · Views: 59
  • Martina_TestContact_DateFormat_GoogleContacts.PNG
    Martina_TestContact_DateFormat_GoogleContacts.PNG
    1.2 KB · Views: 50

ArshilAhmad

Moderator
Staff member
In order for this automation to work, the input date format coming from Google Contacts has to be constant. It cannot change; otherwise, your Date/Time Formatter will not be able to generate the correct date, and your workflow will fail.
1690656166378.png
1690655802248.png


The way your workflow is currently setup, only DD.MM.YYYY format will work.
1690656076046.png
 

Antenne

Member
In order for this automation to work, the input date format coming from Google Contacts has to be constant. It cannot change; otherwise, your Date/Time Formatter will not be able to generate the correct date, and your workflow will fail.
View attachment 29357View attachment 29355

The way your workflow is currently setup, only DD.MM.YYYY format will work.
View attachment 29356
Hi, thanks a lot. But how can they differ. Because Google Contacts only gives me one way to put the date. I cannot change anything there. I have played around further, then managed to get one more contact synchronized and am now waiting for the next one (checking whether there will be an error message or whether this one will work). How can I make sure that Google Contacts is consistent with the dates? Thanks in advance for your help. Br, Antenne
 

ArshilAhmad

Moderator
Staff member
Based on your task history, it does differ from task to task.
1690665829779.png

1690665847783.png


Anyway, I have made some changes to your workflow which should help you with this issue.
 
Top