Building a dynamic scheduling assistant with Zobot!

Building a dynamic scheduling assistant with Zobot!

We received requirement for a bot that can dynamically generate date-time slots which do not overlap existing event timings in Google Calendar ie., if a slot is booked then it will fade away from the time-slot widget.

Bot Requirements:    
A bot that can:  
  • Construct dynamic non overlapping date-time slots  
  • Exclude a specific date or week days while generating the slots 

What does this Zobot do ?  

  • When a visitor lands on the site, the bot displays a welcome message and asks for the visitor's name and email.
  • The bot will then display a list of date-time slots for the visitor to pick one to schedule the appointment. The slots displayed:
                        a) Do not overlap any existing appointments or events in the synced Google Calendar.
                        b) Do not include any dates in 'dates to exclude' and 'days to exclude' lists that were configured by you.
  • Once the visitor picks a slot, an event is created in the synced google calendar. The slot hence forth will not be displayed to visitors anymore.
  • If every slot has been filled and there are no slots to display, the Zobot will display a 'Sorry' message to the visitor and send out an email to a configured email ID with the visitor details. 

Bot flow :



Capabilities: 

  • Dynamic date-time slot generation : Generate and display slots that do not overlap existing appointments and events 
  • Configurable list : You can include/exclude any number of dates and days in the calendar. You can configure the slots that should be initially available for all the dates and the number of dates from the current date to display in the slot . 

Integrations : 

  • Google Calendar : To retrieve events in the calendar 
Steps to configure the bot :

      1. Navigate to  Settings > Zobot > Add. Provide the required information and choose the SalesIQ Script platform.   
      2. Copy and paste the Trigger Handler and Message Handler scripts from the sample script link below.
      3. You should make the following changes in both Trigger Handler and Message Handler scripts: 
                  •   You should mention the number of dates to be display in the 'dateLimits' list.
                  •   Add the the Initial set of time slots to be displayed for all the dates in 'staticTimeSlots' list.
                  •   Mention the dates you wish to exclude from the list in the 'datesToExclude' list.
                  •   If it is Week days ie., (Monday or Tuesday) you wish to exclude then mention the days in the 'daysToExculde' list.
  1.  //Number of dates to display
  2.  dateLimits = {"1","2","3","4","5","6","7","8","9","10"};
  3. //Static time slots that will be initially available for all days
  4. staticTimeSlots = {"10:00","12:00","15:00","17:00"};
  5. //Dates to exclude from the slots
  6. datesToExclude = {"02-04-2019"};
  7. //Days to exclude from the slot
  8. daysToExclude = {"Sunday","Saturday"};
                To integrate with google calendar, 
                  •   Replace the existing one with your connection name
                  •   Replace the calendar ID (if required.) By default, the events are created in the primary calendar of the synced Google account.    
  1. cal = invokeurl
  2. [
  3.      url :"https://www.googleapis.com/calendar/v3/calendars/Calendar-ID/events"
  4.     type :GET
  5.     connection:Google-calendar-connection-name
  6. ]

     4. Then, copy the context handler script from the sample script link below and paste it in the Zobot Context handler  section and make the following changes 
            •  You should customise the email recipient address and the email subject and body content
  1. sendmail
  2. [
  3.     from : zoho.adminuserid
  4.     to : recipient-email-id 
  5.     subject : email-subject 
  6.     message : email-body
  7. ]

To avail the sample scripts for this bot click on this link  

Here is a small visual as on how this bot works:

 

To learn more about Zobot, visit our Developer guides. Happy Zobotting !!

Regards, 
Fiaz  

    Access your files securely from anywhere









                          Zoho Developer Community




                                                • Desk Community Learning Series


                                                • Digest


                                                • Functions


                                                • Meetups


                                                • Kbase


                                                • Resources


                                                • Glossary


                                                • Desk Marketplace


                                                • MVP Corner


                                                • Word of the Day


                                                • Ask the Experts





                                                          Manage your brands on social media



                                                                Zoho TeamInbox Resources



                                                                    Zoho CRM Plus Resources

                                                                      Zoho Books Resources


                                                                        Zoho Subscriptions Resources

                                                                          Zoho Projects Resources


                                                                            Zoho Sprints Resources


                                                                              Qntrl Resources


                                                                                Zoho Creator Resources



                                                                                    Zoho CRM Resources

                                                                                    • CRM Community Learning Series

                                                                                      CRM Community Learning Series


                                                                                    • Kaizen

                                                                                      Kaizen

                                                                                    • Functions

                                                                                      Functions

                                                                                    • Meetups

                                                                                      Meetups

                                                                                    • Kbase

                                                                                      Kbase

                                                                                    • Resources

                                                                                      Resources

                                                                                    • Digest

                                                                                      Digest

                                                                                    • CRM Marketplace

                                                                                      CRM Marketplace

                                                                                    • MVP Corner

                                                                                      MVP Corner







                                                                                        Design. Discuss. Deliver.

                                                                                        Create visually engaging stories with Zoho Show.

                                                                                        Get Started Now


                                                                                          Zoho Show Resources


                                                                                            Zoho Writer Writer

                                                                                            Get Started. Write Away!

                                                                                            Writer is a powerful online word processor, designed for collaborative work.

                                                                                              Zoho CRM コンテンツ



                                                                                                Nederlandse Hulpbronnen


                                                                                                    ご検討中の方




                                                                                                          • Recent Topics

                                                                                                          • openUrl in blueprints

                                                                                                            My customer wants to open a URL at the end of a blueprint transition. Seems this isn't possible right now but it would be very useful. In this thread, https://help.zoho.com/portal/en/community/topic/openurl-not-working the Zoho agent said that it's logically
                                                                                                          • Is it possible to pull the Zoho desk data into Zoho analytics in real time

                                                                                                            Hi - I am looking to add more dashboards and reports of Zoho Desk in analytics. I see there is a schedule to pull the data into analytics, but I'm wondering if there is an option to pull the data in real time instead of a specific interval?
                                                                                                          • Turning off the new UI

                                                                                                            Tried the new 'enhanced' UI and actively dislike it. Anyone know how to revert back?
                                                                                                          • Update Subform in specific field(Status) without affecting other fields in Zoho CRM using Deluge?

                                                                                                            Scenario: PRODUCT Module(change name Plot) in any product status change From Available to Booked then on PROJECT Custom Module have Subform So, Subform name is Property Details now in that Subform 1 field is STATUS that update according to  product status
                                                                                                          • Item Details Field - New Barcode / Document option?

                                                                                                            Is this a new feature??? its in both books and inventory.
                                                                                                          • CRM x WorkDrive: File storage for new CRM signups is now powered by WorkDrive

                                                                                                            Availability Editions: All DCs: All Release plan: Released for new signups in all DCs. It will be enabled for existing users in a phased manner in the upcoming months. Help documentation: Documents in Zoho CRM Manage folders in Documents tab Manage files
                                                                                                          • Introducing the revamped What's New page

                                                                                                            Hello everyone! We're happy to announce that Zoho Campaigns' What's New page has undergone a complete revamp. We've bid the old page adieu after a long time and have introduced a new, sleeker-looking page. Without further ado, let's dive into the main
                                                                                                          • Ability to Add YouTube Video to Playlist During Publishing

                                                                                                            Hi Zoho Social Team, How are you? While publishing YouTube videos through Zoho Social, we noticed that the platform currently does not allow selecting a playlist at the time of publishing. Instead, we can only add the video to a playlist after it has
                                                                                                          • Nouveauté dans Zoho Writer - Création de documents et de modèles assistée par l'IA

                                                                                                            Zia, l’assistant IA de Zoho Writer, soutient les utilisateurs dans l’amélioration de leur écriture et la création de contenus : correction orthographique et grammaticale en temps réel, suggestions adaptées au contexte, détection du plagiat, révisions
                                                                                                          • Canvas View in Zoho Recruit

                                                                                                            Is it possible or would it be possible to have the new 'Canvas View' in Zoho Recruit?
                                                                                                          • Sharing Form Ownership Among Multiple Users

                                                                                                            I would really like the ability to share form ownership among multiple users. It's frustrating to me that if a co-worker wants to make an edit to a form, I have to transfer ownership to them. It would be great if forms could act like google forms, where multiple people can edit a form and view responses. 
                                                                                                          • How to go to the next open ticket in the queue when agents closes ticket

                                                                                                            Zoho Desk When agent closes a ticket - eg when they choose 'Send and Close" - where is the setting that automatically redirects them to the next open ticket in the queue?
                                                                                                          • How to Automate Email Sequence

                                                                                                            I'm having trouble trying to set up a workflow to automate an email sequence. Once a group of emails in a Task has been tagged by a certain tag, I want an instant email template to be sent. After 7 days with no response, another email template would be
                                                                                                          • Marketer’s Space - Ace Your Spooky-Season Marketing with Pre-designed Templates in Zoho Campaigns

                                                                                                            Hello marketers, Welcome back to another post in Marketer’s Space! We’re in Q4, which means that you have endless opportunities to connect with your audience, starting with Halloween campaigns! In this post, we’ll show you how to design the perfect Halloween
                                                                                                          • Zia expands to China with native features and DeepSeek-powered generative AI features

                                                                                                            Hello everyone, We are glad to support Zia native features and Zia generative AI features for our customers in China. From hereon, all AI-features in Desk will be accessible in China data center with the integration of DeepSeek generative AI model. DeepSeek
                                                                                                          • Email in each module

                                                                                                            We have a contact ,module which then has a link to customer assets which in turn the asset has a multiple link to service visits. When we link assets to customers we choose by name and it brings over the associate email via the lookup. Great feature.
                                                                                                          • Create custom rollup summary fields in Zoho CRM

                                                                                                            Hello everyone, In Zoho CRM, rollup summary fields have been essential tools for summarizing data across related records and enabling users to gain quick insights without having to jump across modules. Previously, only predefined summary functions were
                                                                                                          • Global Search placement in the new UI

                                                                                                            Having a hard time with the global search placement in the UI redesign. Surely I can't be the only one. Previously global search placement was perfect. A bar at the top/center of the page. Exactly where you would expect it to be. Since the new UI has
                                                                                                          • Introducing Skill-Based Ticket Assignment

                                                                                                            The goal of every support team is to provide great support, and to do so as fast as they can. To make this possible, it is important that agents spend their time judiciously, especially when they're dealing with a large number of tickets of varying urgency
                                                                                                          • Empowered Custom Views: Cross-Module Criteria Now Supported in Zoho CRM

                                                                                                            Hello everyone, We’re excited to introduce cross-module criteria support in custom views! Custom views provide personalized perspectives on your data and that you can save for future use. You can share these views with all users or specific individuals
                                                                                                          • Kaizen #213 - Workflow APIs - Part 1

                                                                                                            Welcome to another week of Kaizen! If you have ever managed complex business processes, you know that Workflows are the quiet backbone of any well-run business process. They keep things moving; assigning owners, sending alerts, keeping deals on track,
                                                                                                          • Browser and address bar hide

                                                                                                            Hi, How i can do hide the address bar with browser headline when i am working on the sheet, because i am using (freeze panes) which i want visible for full work. For your reference here i am attached the screen shot and marked yellow lines which really
                                                                                                          • Cells Border

                                                                                                            Hi I am using Zoho Sheet on S Tab , is there any option to make all border of any cell at once. I think this is very basic which we are missing. This is available in mobile but not in tab or suggest if i am missing this function. And for Tab can you give
                                                                                                          • Credit Management: #2 Configuring Right Payment Terms for Credit Control

                                                                                                            Think about the last time you ordered something online and saw that little note at the checkout, "Pay on Delivery" or "Pay later". It's simple, but it actually sets the tone. As a business owner, you know exactly when payment is expected. Now, imagine
                                                                                                          • Zobot and Sales IQ

                                                                                                            What will happen to the Zoho Sales IQ being integrated to the website after creating the Zobot on the website too
                                                                                                          • Workflow workdrive rollout

                                                                                                            Hi! When will workflow be rolled out to all users? Thanks.
                                                                                                          • Task Due Date greater than 10 years.

                                                                                                            We use recurring tasks in Projects where every week, month, year etc Some of our projects are greater than 10 years and we are unable to set a new due date because the difference between start date and due date is greater than 10 years. As an example
                                                                                                          • Zoho Analytics - Make text clickable in underlying data

                                                                                                            Hi Community, I have a simple sales report based on a Invoice query table. I have included a link on to each invoice on the table and sent the Invoice number URL to the link. This works find in the query table, but when I click underlying data on the
                                                                                                          • Mapping a new Ticket in Zoho Desk to an Account or Deal in Zoho CRM manually

                                                                                                            Is there any way for me to map an existing ticket in Zoho desk to an account or Deal within Zoho CRM? Sometimes people use different email to put in a ticket than the one that we have in the CRM, but it's still the same person. We would like to be able
                                                                                                          • ZOHO TEAM INBOX Calendar Integration

                                                                                                            The Problem: Clients send meeting invitations to our TeamInbox address. TeamInbox receives these invites, but we cannot accept them. We do not use individual inboxes for transparency purposes. Ideal Solution: A way to accept calendar invites sent to our
                                                                                                          • Help Center and SEO: Any Benefit to My Domain-Mapped Website Ranking?

                                                                                                            First of, I love the Help Center which I've just decided to integrate into my website to replace its old-fashioned FAQs. So much more to achieve there now! Lots of new benefits to the site visitors and to me in terms of organizing and delivering all the
                                                                                                          • Blueprint status change

                                                                                                            I want to change the Blueprint status of a workflow. The status is completed automatically when I added the record through API call. But I want to make it active, I don't see any options for this. Even if I draw transition from any stage , it is not visible
                                                                                                          • Support french language options

                                                                                                            Greetings, I want to use Zoho with the french language portal, however the supplied translation is not very good (google translate). There are many basic mistakes on the main most important sections (my requests, submit a request). Is there a way for
                                                                                                          • Automation #7 - Auto-update Email Content to a Ticket

                                                                                                            This is a monthly series where we pick some common use cases that have been either discussed or most asked about in our community and explain how they can be achieved using one of the automation capabilities in Zoho Desk. Email is one of the most commonly
                                                                                                          • filter broke my data

                                                                                                            I uploaded a file recently from Sheets and it has top 2 rows frozen, with table headers in second row and each one is filterable. somehow my first 2 columns became unfiltered and no matter what I do I cannot reapply the filter?? also didn't realize they
                                                                                                          • Introducing the Workflow and Actions APIs for Zoho CRM

                                                                                                            We are absolutely thrilled to announce the release of Workflow APIs and Actions APIs in Zoho CRM’s v8 API suite! This powerful new set of endpoints gives developers unprecedented programmatic control over business automation. For years, Workflow Rules
                                                                                                          • How to apply customized Zoho Crm Home Page to all users?

                                                                                                            I have tried to study manuals and play with Zoho CRM but haven't found a way how to apply customized Zoho CRM Home Page as a (default) home page for other CRM users.. How that can be done, if possible? - kipi Moderation Update: The option to mark a customized
                                                                                                          • Zoho CRM Analytics - Allow To Reorder Dashboards

                                                                                                            I would like to suggest that you add the ability to reorder dashboards in the Analytics Module. I can see that this has been requested some time ago, the latest 9 years ago. I am not sure if this is a big or small endeavor, but such a small fix can go
                                                                                                          • Zoho Form URL displays incorrect name

                                                                                                            Hi, I have a form I created called "Design Request form". It displays this way everywhere I look. However, in the URL, it shows up as "DesignJobRequestFormFINAL011325PROOFV1B" and I'm not sure why. I can't find where to fix this. Does anyone have any
                                                                                                          • Consumers are talking about your business. Are you listening?👂

                                                                                                            A loyal customer might be praising your product in a forum. A frustrated user could be posting a harsh review on a public site. An excited partner may have left a comment on your campaign. A domain expert might be deconstructing your product. A prospect
                                                                                                          • Next Page