Extension Based Call Routing

providing callers with dedicated extensions allowing them to quickly connect with a specific user/agent advantages of extension based dialing add professionalism to your customer experience make your business look bigger with extensions for separate departments distribute the calls evenly to team members or to the next available agent with customizable call routing extensions it adds a structure to your support or sales operations identify customers calling from unregistered numbers and provide them with a seamless support/service experience automate number masking for the last mile delivery delivery partner can enter the order id and get connected to the respective customer spend less on numbers and allocate pins to your vendors/consultants extremely cost efficient in marketplace uses cases(one to many connects) dedicated relationship/account managers can be connected based on their allocated pin sample call flow steps goto to app bazaar > click on create > enter the flow name implementation applets to be used gather connect the gather applet helps in reading out a customary greeting and collecting the dtmf codes punched in by your caller the connect applet is used to connect the caller and the callee in the connect applet, you have a section “dial a number returned by this url” here, you will need to host a url that returns the phone number of that particular vendor with whom the caller wants to get in touch if the correct phone number has been returned, then the call will get connected successfully creating the flow once you have logged in to your exotel dashboard, please go to app bazaar create a new call flow by clicking on custom apps create this will open up the app builder page drag and drop the gather applet drag and drop the connect applet use the web app url that was created earlier in the connect applet drag and drop any other applet you need save the flow based on the extension entered by the user, the corresponding number in the spreadsheet will be returned by the url which in turn will be called by exotel assign an exophone to the newly created flow how to implement extension based routing using exotel and spreadsheets? open a new spreadsheet upload the below code in the script editor of the spreadsheet publish the code to get a web app url once deployed, copy the web app url which will be used later in the exotel flow open your exotel account and create the flow below in the app builder //id of the spreadsheet //for spreadsheet https //docs google com/spreadsheets/d/1bsalnni5 ybrke6brwk5g54qwm5dgonn ynlxja" // has id as 1ewel9zxdtntdeffchvcggytnqhrmgrrphaub7o9 qic var id = "1ewel9zxdtntdeffchvcggytnqhrmgrrphaub7o9 qic" //nme of the specific sheet inside the spreadsheet where data to be dumped var sheet name = "sheet1" //name of the specific sheet inside the spreadsheet where numbers are available function doget(e) { var params = e parameters; var abc = e parameters\["digits"]\[0] var output = retrievedata(abc) return contentservice createtextoutput(output) } //retrievedata function to retrieve data from sheet function retrievedata(paramm) { var sheet = spreadsheetapp openbyid(id) getsheetbyname(sheet name) var data = sheet getdatarange() getvalues(); for (var j in data) { if (paramm == data\[j]\[0]) { return data\[j]\[1] } } return "no data found" } process the excel sheet replace the sheet id (var id) from the url as in the screenshot below replace the sheet name (var sheet name) from the sheet as in the screenshot below deploy the script as a web app once the script is done, select the menu item publish > deploy as web app a window will pop up on your screen under project version, type the name of the project under execute the app as a section, select me (email) under who has access to the app, select anyone, even anonymous this helps make the web app accessible to exotel you can then click on deploy to get the web app url, which can be used in the exotel flow use the webhook created in the call flow, in the connect applet s ample spreadsheet https //docs google com/spreadsheets/d/1ewel9zxdtntdeffchvcggytnqhrmgrrphaub7o9 qic/edit?usp=sharing