Hi, I have a spreadsheet that will be filled out by clients and I want the event information to create a Google Calendar entry. However, I need to assign it based on a specific client as they have different calendars, is this possible?
This use case can be done using a lookup sheet. The lookup sheet will have the name/email of the client and the ID of the calendar for the respective client. You can reach out to Support and they will guide you on how to find the calendar ID.
Hope this helps :)