It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Butler finding time on Goolge Calendar

Hello! Has anyone been able to create a Butler card button to search for availability in their google calendar?

I'd like to not leave my card to find a time slot to schedule my card. (similar to what Calendly does to set appointments....I want to set an appointment for my card :p)

 

(not sure if I'm explaining myself clearly, but hopefully)

1 answer

1 accepted

0 votes
Answer accepted
Iain Dooley Community Leader Apr 25, 2019

@elise_williams Butler doesn't have access to the Google Calendar API directly, but you could create a button that sends an email (so long as you're on a paid Trello plan) into Zapier email parser that would then extract the data and create an event in Calendar.

This won't search for availability though. For that, you need to have something written that has access to your Calendar API. Google Apps Script is the best way to do that.

I have created a Trellinator package that I use internally with my clients to schedule recurring meetings.

Currently it works from Trello card descriptions that are formatted like this:

Emails: person1@domain.com,person2@domain2.com
Days: Monday,Tuesday,Wednesday
Times: 11:30,14:30
Location: https://zoom.us/j/MEETINGID
Duration: 30

The Trellinator runs as a G-Suite user, so as long as person1@domain.com and person2@domain2.com are both on Google Calendar and the Trellinator user has free/busy access (at least) to those calendars, it will look for a spot with shared availability and automattically schedule it in.

In the above example, it would look for a time on those days, in that time range, for a shared slot of 30 minute availability.

You can also set more than 2 people, so for example if you need to regularly schedule meetings with 8 different people in various configurations, on a monthly or weekly basis, this is what it's for.

The same package could be reconfigured so that, for example, you request a meeting on an ad-hoc basis with one or more people by creating a new card in a "Meetings" Trello board and it would find the next spot you were all available and put it in the calendar, or that it would only search availability in YOUR calendar to undertake a specific task, for example you add a due date to a card with a custom field value called "Duration" and it will then look for availability in your calendar to get that done by that date and if it can't find enough time will warn you that you can't do it.

Usually I post code examples when I share Trellinator solutions, but this is quite complicated and the code isn't open source. However you can find out more about Trellinator here:

https://community.atlassian.com/t5/Marketplace-Apps-articles/Introducing-Trellinator-Automate-Trello-with-Google-Apps-Script/ba-p/925271

@Iain Dooley You are a genius! Thank you!

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

Develop a new Habit during Lockdown

If you had to thrive a new habit during a lockdown, what would it be? Trello

1,627 views 15 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you