Hi,
I was trying to build an app to book time in 4 different conference rooms. Each room has its own google calendar that I would like to link to and allow people to book time. I can figure out how to add a link to each calendar to see if time is available (this is just via an external link). I am just not sure how I could actually allow people to book time within the app and have it reflect in the shared google calendar. Any help would be great!
It could be initiated and the information keyed in within the Glide app but you would have to write a Google script to actually get it into the corresponding Google calendar.
Can you point me in the direction of any helpful documentation for this. I have never dealt with google scripts, and the more I look the more confusing info I seem to find
Wow, interacting with the Google calendar is not that hard for someone who has some experience with javascript, but for a complete novice it would be very challenging. So not only do you have to learn to code in javascript (the basic syntax that Google script uses), but you then have to learn how to interact with Google calendar. I’m sorry but I would have no idea where to point you except to tell you to search out some beginner tutorials on Google script. You would need to start out very simply, nothing to do with interacting with the Calendar. If it’s a business need and there is a budget you may want to get some expert help with just that piece of the app.
Here is the Google reference regarding interaction with the calendar. https://developers.google.com/apps-script/reference/calendar
But as I said in the prior post, you really can’t start here, you need to first learn about scripting and the nuances and flow of code as it relates to your spreadsheet data. If you wanted a true integration to the calendar, you wouldn’t have external links to view the calendar. The calendar would sort of be the backend of the app and the app would push and pull information from it. You could add events to each calendar from within a normal Google account, however those events added outside of the app would have to be pulled into the app in order to keep everything in sync.
1 Like
Thanks so much George! I was hoping someone had done this or something like it before and could share the scripting. Appreciate you looking in to it for me
Some more resources to check out. (Disclaimer: I don’t have any experience with any of these.)
Zapier may be the easiest. Looks like it would allow you to add and update calendar entries. Not sure if you would need more advanced integration or what it is all capable of. Maybe this will help get you started.
1 Like
bonjour, as tu réussi ? je cherche a faire la même chose avec également peu de connaissance!
si tu peux m’aider, merci!
Erwan
You can use the method @Jeff_Hager mentioned just above. It should work pretty well with an integration between Google Calendar and your Google Sheet.
1 Like