How to integrate Google Calendar to Formatter using Appy Pie automate?

How to integrate Google Calendar to Formatter  using Appy Pie automate?

1. Start by creating an account on Appy Pie Automate. Once logged in, click on ‘Create Connect’ to begin setting up your automation.

 

 

2. Select Google Calendar as a Trigger app.

 

 

3. Select New Event as your trigger event and click Continue.

 

 

4. Click Add an Account to add your account to Google Calendar.

 

 

5. Select your account and click Continue.

 

 

6. Provide all the details of the Set Up part and then click Continue & Run Test.

 

 

7. A “Run Test is Successful” message will appear. Click Continue to proceed to the Action application.

 

 

8. Select Formatter by Automate under Appy Pie Apps section as an action app.

 

 

9. Select Date/Time as an Action event and click Continue.

 

 

10. Map all the details of the Set Up part and click Continue & Run Test.

 

 

11. After a successful mapping, click on the plus icon as shown below and select Add App.

 

 

12. Select Formatter by Automate under Appy Pie Apps section as another action app.

 

 

13. Select Date/Time as an Action event and click Continue.

 

 

14. Map all the details of the Set Up part and click Continue & Run Test.

 

 

15. After the run test is successful, click on plus icon again and select Add App.

 

 

16. Select Google Sheet as another action app.

 

 

17. Select Create Spreadsheet Row as an action event.

 

 

18. Click Add an Account to add your account to Google Sheets.

 

 

19. After selecting your account, click Continue.

 

 

20. Map all the details of the Set Up part and then click Continue & Run Test.

 

 

21. A “Run Test is Successful” message will appear. Click Activate Connect to activate it.

 

 

22. Following is the output of the above Connect: 

 

 

A test event is created in Google Calendar. 

• The input time format follows ISO 8601, a standardized method for representing dates and times.
• Ex - 2025-09-27T10:00:00+05:30
• +05:30 signifies a time zone that leads UTC by 5 hours and 30 minutes.

 

 

The input time was taken as UTC format as explained above. With the help of Appy Pie  Formatter, the input date/time mapped from Google Calendar to Google Sheet, was ameliorated to a different time format. 

• Formatter by Appy Pie Automate converts to the output : 2025-09-27 05:30:00

This date-time format, 2025-09-27 05:30:00, does not comply with the full ISO 8601 standard for time exchange because it omits the necessary time zone offset. Therefore, while it clearly shows the date and the local time of 5:30 AM, it can't be used to determine a single, globally consistent point in time without an external reference to its intended time zone.