Help with Google Calendar integration bookings

[Mariaclara8]

Good morning! I have this code that I am trying to integrate in my emails as a button to add the reservation to the clients calendar, however everything is perfectly integrated, except the date and time... I understand that it could be a formatting problem, but I have already tried to improve it and I still only showing today's date...

The format date that is in the Hubspot property is: 

<p>

    <a href="https://www.google.com/calendar/render?action=TEMPLATE&text=Tour: {{ personalization_token('p27168940_reservas.productinfo__c', ' ') }} &dates={{ personalization_token('p27168940_reservas.startdatetime__c', ' ') | datetimeformat('%Y%m%dT%H%M%SZ') }}

&details=Número de reserva: {{ personalization_token('p27168940_reservas.n_mero_reserva', ' ') }}%0ALocalizador: {{ personalization_token('p27168940_reservas.localizador_nuevo', ' ') }}%0ATour: {{ personalization_token('p27168940_reservas.productinfo__c', ' ') }}%0AFecha del Tour: {{ personalization_token('p27168940_reservas.startdatetime__c', ' ') }}%0AOpción de Tour: {{ personalization_token('p27168940_reservas.mtt_name', ' ') }}%0APunto de encuentro: {{ personalization_token('p27168940_reservas.punto_de_encuentro', ' ') }}%0AURL Punto de encuentro: {{ personalization_token('p27168940_reservas.url_punto_de_encuentro', ' ') }}&location={{ personalization_token('p27168940_reservas.punto_de_encuentro', ' ') }}" target="_blank" style="background-color: #E54441; color: white; padding: 10px 20px; text-decoration: none; border-radius: 5px; font-family: 'Montserrat', sans-serif;">

        Añadir al calendario

    </a>

</p>

[Jaycee_Lewis]

Hey, @Mariaclara8 👋 Thanks for your quesiton. Have you tried adjusting your dates parameter formatting like this?

&dates={{ personalization_token('p27168940_reservas.startdatetime__c', ' ') | datetimeformat('%Y%m%dT%H%M%S') }}/{{ personalization_token('p27168940_reservas.startdatetime__c', ' ') | datetimeformat('%Y%m%dT%H%M%S') }}

• removed the Z suffix
• Added an end date
• Removed extra white spacing

Additionally, can you verify that your `startdatetime__c` property is a `datetime` field? 

Thanks,

Jaycee

[Mariaclara8]

Hi! Thanks so much, i`ve realized the correct field should be p27168940_reservas.tourdatetime__c , and this is reflected like this format: 04/03/2025, 10:00:00 GMT+1. I`ve tried to replace your formula with the correct field, but the event gets created with this date instead 

Thanks in advance!