How to add more than 20 google calendars to a base

[harimonthstayz]

Currently Airtable limits the a maximum of 20 google calendars to be added to a base. I am in need of adding more than 20 google calendars. In fact searching for a solution where there is no limit to add google calendars to a base in Airtable. Is there a workaround for this? 

[ScottWorld]

You could create your own automatic syncing solution using Make’s Google Calendar integrations & automations.

However, if you’ve never used Make before, there is quite the learning curve, so I’ve assembled a bunch of Make training resources in this thread: https://air.tableforums.com/t/make-com-basic-navigation-tips/277

Hope this helps!

– ScottWorld, Expert Airtable Consultant

[harimonthstayz]

Thank you @ScottWorld. May be I need to be more specific. We run a long term rental company at Thailand and we manage 100+ listings (rooms which include villas and apartments at different cities). We have created one google calendar for each listing (which means number of calendars we have would be equal to number of listings - currently we have around 130). 

Whenever we have a booking the google calendar for that particular listing is updated. Our team members need to go into that specific calendar to see the booking. In order to check whether a room is free or not, the team members need to go into google calendar of that particular room. 

We are aware that google calendar can be synced to Airtable and we are using it for other purposes. But the limitation for room booking checking is a maximum of only 20 calendars can be linked in a base in Airtable. We are using MAKE but the solution is to add more than 20 calendars to a base in Airtable so that team members need not keep switching between Airtable and google calendar

[ScottWorld]

There is no limit on the number of calendars you can integrate with when using Make to communicate between Airtable and Google Calendar. 

[harimonthstayz]

Thanks @ScottWorld - understood about no limits on number of calendars using MAKE. I have configured a scenario using MAKE to create a record in Airtable whenever there is an event created in google calendar. I wanted to know how can we get the name of the calendar to Airtable.

Getting the description of an event, start and end dates are pretty straight forward but would love to know if there is a way to get the name of a google calendar into Airtable. (for your reference I have attached a screen grab of the calendars I have with customised names - text in red boxes are the calendar names - would love to have these names in Airtable when an event is created to any or all these calendars)

[ScottWorld · Accepted solution]

Just like Airtable’s Google Calendar integrations, you need to specify in advance the calendar that you’re pulling from, so you already know in advance which calendar your events are coming from.

Make also lets you push to calendars and create new calendars, so you can add all sorts of advanced functionality. 

[harimonthstayz]

Thanks @ScottWorld figured it out ....very helpful 🙌