# Google Calendar Action not adding correct time from Google Sheet **URL:** \ **Category:** Ask for Help\ **Created:** [September 25, 2023, 10:43pm UTC](https://community.glideapps.com/t/google-calendar-action-not-adding-correct-time-from-google-sheet/66517 "2023-09-25T22:43:33Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![AlphaBCD](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alphabcd/32/56402_2.png) [@AlphaBCD](https://community.glideapps.com/u/AlphaBCD)\ **Post date:** [September 25, 2023, 10:43pm UTC](https://community.glideapps.com/t/google-calendar-action-not-adding-correct-time-from-google-sheet/66517/1 "2023-09-25T22:43:34Z")
I am using a Google Sheet with the time and date of the meeting invite, when I add the invite, it does not go to the correct time. Do you know what I can do or how to fix this? Here is a loom video: ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 27, 2023, 12:50am UTC](https://community.glideapps.com/t/google-calendar-action-not-adding-correct-time-from-google-sheet/66517/2 "2023-09-27T00:50:25Z")
May we know what timezone are you in? Is it UTC-4? ---
**Author:** ![AlphaBCD](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alphabcd/32/56402_2.png) [@AlphaBCD](https://community.glideapps.com/u/AlphaBCD)\ **Post date:** [September 27, 2023, 10:23am UTC](https://community.glideapps.com/t/google-calendar-action-not-adding-correct-time-from-google-sheet/66517/3 "2023-09-27T10:23:08Z")
I am eastern time zone New York - GMT - 5 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 28, 2023, 12:27am UTC](https://community.glideapps.com/t/google-calendar-action-not-adding-correct-time-from-google-sheet/66517/4 "2023-09-28T00:27:03Z")
Can you help me test this? - Create a new Glide Table with the same basic columns as what you have in the video. - The “Showing Time and Date” has the “Respect time zones” box checked. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/5/d5c8ecbb4bcc9effd6d66c6a6bb84b1d254eaa7f.png) - You try to add an event to your calendar using the Google Calendar integration to see if it works correctly. ---
**Author:** ![AlphaBCD](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alphabcd/32/56402_2.png) [@AlphaBCD](https://community.glideapps.com/u/AlphaBCD)\ **Post date:** [October 2, 2023, 2:11pm UTC](https://community.glideapps.com/t/google-calendar-action-not-adding-correct-time-from-google-sheet/66517/5 "2023-10-02T14:11:05Z")
That works! But is there a fix for when using a regular GoogleSheet? I tried to adjust the settings on Google Sheet, Google Calendar but that did not seem to work. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 4, 2023, 2:15am UTC](https://community.glideapps.com/t/google-calendar-action-not-adding-correct-time-from-google-sheet/66517/6 "2023-10-04T02:15:43Z")
I think we’ll have to use a workaround here. Can you try: - Adding a JavaScript column in your Glide data view for the relevant Sheet. - Write “return p1”. - In the p1 variable, point to your date/time column. Please let me know what it returns, I’m thinking we can leverage this to append a timezone. ---
**Author:** ![AlphaBCD](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alphabcd/32/56402_2.png) [@AlphaBCD](https://community.glideapps.com/u/AlphaBCD)\ **Post date:** [October 4, 2023, 2:36pm UTC](https://community.glideapps.com/t/google-calendar-action-not-adding-correct-time-from-google-sheet/66517/7 "2023-10-04T14:36:31Z")
I think almost there. Some reason the time is not converting correctly. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/a/7af5bf82ce8255ad912a19e2ffe3606205bf6495.jpeg) For example where it should be 6pm in the Showing Time. In the JavaScript time, it shows up at 22:00 which is 10pm. Is there anything I can add to the code to fix that? Maybe that can be a workaround. Here is what I put so far. Thanks for your help!! ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/b/8b5b40d31e6aa8bf1d57f0757444756d6cd5055c.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 5, 2023, 12:26am UTC](https://community.glideapps.com/t/google-calendar-action-not-adding-correct-time-from-google-sheet/66517/8 "2023-10-05T00:26:42Z")
Since you have ‘Respect Time Zones’ checked I believe that it stores UTC/GMT time as the underlying value and then does the conversion to the users local time based on their individual time zone offset within the app. If you are sending UTC time to Google, does it also do the conversion on Google’s side? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 5, 2023, 12:54am UTC](https://community.glideapps.com/t/google-calendar-action-not-adding-correct-time-from-google-sheet/66517/9 "2023-10-05T00:54:56Z")
I think he has that date/time from Google Sheets, which does not allow you to check “Respect time zones”, the box was only checked from my example, which was on Glide Tables. > [@Jeff\_Hager](#): > > If you are sending UTC time to Google, does it also do the conversion on Google’s side? I believe this is the case. However I find it surprising that the JS column returns the timestamp in UTC as well, even if you don’t check Respect Time Zones. I can reproduce this. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/f/bffca8012eb6ba8312d0e371c788bdd4c36139d1.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 5, 2023, 2:36am UTC](https://community.glideapps.com/t/google-calendar-action-not-adding-correct-time-from-google-sheet/66517/10 "2023-10-05T02:36:03Z")
Yeah, I don’t know. Definitely seems to be doing something in relation to each of your respective timezones. Reviewing the video again, I do see that the google sheet is applying formatting on top of the underlying date, so I’m not sure if that’s doing something to cause a problem. Also, the underlying date is not in a true ISO format. Just that alone could potentially lead to unexpected results. Maybe Glide is trying to interpret it into an ISO format and maybe using the timezone of the google sheet somehow. I don’t know. 🤷‍♂️. I guess I’d like to see the dates stored in the sheet in a more stable format.