how to change the format data from america to europe in google calendar zapier?
the function of the program is: receive an email, take the data and use it to create an event in google calendar but the problem is the format data.
Best answer
How do I change date format from American to European in Google Calendar using Zapier?
- Beginner
- 3 replies
Best answer by BadgerBest answer by Badger
Here is a workaround to avoid having to upgrade your free account.
- Create a Google Worksheet
Column A Call Date US
Column B Call Date EU
Column C Time
Column D ISO
In column B add the formula =TEXT(A2, "DD/MM/YYYY")
In column D add the code
=TEXT(DATE(RIGHT(B2,4),MID(B2,4,2),LEFT(B2,2)),"YYYY-MM-DD") & "T" & TEXT(C2,"HH:MM:SS") & "Z"
- Use a Google Sheets Zap Step Update Spreadsheet Row
Send your US Date to Row 2 Col A “Date US”
Your Time in a HH:MM:SS format
Once the row is update the Col B “Date EU” will be in the correct format.
Col D will be in the ISO Format with start time
(You should be able to work out how to add an end time by yourself.)
This can now be selected for use in steps below.
I used a Google Calendar Create Detailed Event
I would recommend using the ISO format as you can attach time to it very easily and prevent calendar events all starting at midnight.
I hope that’s useful.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+5
Use a Formatter by Zapier step to convert to a date/time format you require.
Hope that helps
+14- Zapier Expert
- 31524 replies
Hi
Help links for using GCal in Zaps: https://zapier.com/apps/google-calendar/integrations#help
Is the event created on the wrong date, specifically with the month and day switched?
Regardless of the settings in your Google Calendar, data sent through their API (as Zapier does) must be in MM/DD/YYYY format.
So, if you try to send an event for April 7, 2021 as 07/04/2021, Google Calendar will interpret that as July 4, 2021.
The dates need to be in MM/DD/YYYY format to ensure Google Calendar adds the event to the correct date(s).
If your trigger is sending the data in DD/MM format, you can use a Formatter step to reformat the date.
+5
That’s interesting as all the dates that come from my Google Calendar have been in the ISO format YYYY-MM-DD. Creating events using the ISO format with time has also always worked for me. But I have never had to used just a date without time.
I wonder if that’s the difference the time part?
+14- Zapier Expert
- 31524 replies
Help links for using the Formatter Zap app: https://zapier.com/apps/formatter/help
- Beginner
- 3 replies
Badger wrote:
Use a Formatter by Zapier step to convert to a date/time format you require.
Hope that helps
im using the free trial, and i can only use 3 steps, but thank you
- Beginner
- 3 replies
This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.
i only have 2 steps*
for doing for the following steps:
1)Take the email from gmail and send it in automatic to the mailbox zapier, that take the data from the email and send it to the zap
2)Than create a event in google calendar
but it creates with a different format date,
format europe: dd/mm/yyyy
format america: mm/dd/yyyy
Example
date input in europe: 05/12/2024 so i expect an event in the 5 december 2024
event creates in the date america: 12 may 2024
+6- Zapier Staff
- 2754 replies
Hi
Currently, the only way to change the time format is to utilize a Formatter step. You could upgrade your free trial so that your Zap is configured correctly with the time using Google Calendar.
+5
Here is a workaround to avoid having to upgrade your free account.
- Create a Google Worksheet
Column A Call Date US
Column B Call Date EU
Column C Time
Column D ISO
In column B add the formula =TEXT(A2, "DD/MM/YYYY")
In column D add the code
=TEXT(DATE(RIGHT(B2,4),MID(B2,4,2),LEFT(B2,2)),"YYYY-MM-DD") & "T" & TEXT(C2,"HH:MM:SS") & "Z"
- Use a Google Sheets Zap Step Update Spreadsheet Row
Send your US Date to Row 2 Col A “Date US”
Your Time in a HH:MM:SS format
Once the row is update the Col B “Date EU” will be in the correct format.
Col D will be in the ISO Format with start time
(You should be able to work out how to add an end time by yourself.)
This can now be selected for use in steps below.
I used a Google Calendar Create Detailed Event
I would recommend using the ISO format as you can attach time to it very easily and prevent calendar events all starting at midnight.
I hope that’s useful.
+11- Community Manager
- 7871 replies
Hi there,
How did you get on with this—did the workaround Badger suggested do the trick?
Looking forward to hearing from you!
- Beginner
- 3 replies
i just take the data from the mail like:
Europe format: 19/12/2024
Take data: p0/p1/p2
use it in the start date-time in zap calendar like: p1/p0/p2 and it worked
+6- Zapier Staff
- 2754 replies
Wow! Thank you for confirming that Badger’s suggestion got the Zap running. This will significantly help our Community members to have as a reference for the same issue.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.