Best answer

Calendly to Slack

  • 22 May 2020
  • 2 replies
  • 188 views

Userlevel 1

Hi all 

 

We’re using a  Calendly booking system to ensure our office doesn’t go over the allowed 32 spots. 

 

The idea is for people to book in a spot whenever they want but once a day at 9:00am the bot posts the event which contains the number of spots filled along with the names of the people who have booked in. 
 

My thinking is calendly- append data - release to slack at 9:00am each weekday  

 

problem is how do I ensure it’s just grabbing data for that day? 
 

thanks  

 

 

icon

Best answer by BowTieBots 22 May 2020, 13:27

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 4
Badge +4

Hi @Bazdoctor,

You can use Zapier Formater to get today’s date and then use a  filter step to compare the Calendly booked time trigger against the formatter.  If they match → Append data.

Do you restrict your Calendly to allow bookings to 1 day in the future?  If you want more than 1 day out you need to have multiple data stores for each day. Otherwise you Slack post will be missing bookings.

 

An alternative is to create a Digest based on month/day input where each record is a booking.  Your work flow would be:

Zap1: 

Calendly Booking → Append booking data to Digest (Digest name is booking date)

 

Zap2:

Everyday at 9:00am → get todays date (Must match digest reference) → Get digest that matches todays date → Release digest to slack.

Userlevel 7
Badge +12

Hi @Bazdoctor, did @BowTieBots’ suggestion help here?