Save Multiple Phone Number with airSlate SignNow

Upload phone number field

hello so I will teach you how to upload a calling list and call tools using multiple phone numbers so it's very easy all you have to do is first prepare a file write an excel file a file or a Google sheet well it doesn't matter whatever works for you that's fine cuz they they do the same thing alright so for me I use Google sheet because it's easier for me and it will not slow in my computer I don't have to install anything it's plug and play so here we go as you can see here we have different columns well this is gonna be the the exact information that will show on your pop-up and culturals so the target here for this tutorial is how to insert multiple phone numbers into the call hammer of culto so here we go first we have mobile phone and we have seven columns actually we have one two three four five six seven yeah seven columns for the phone numbers alone for one person the reason why we have to insert everything because not all the time we can speak to this person directly what we're trying to do is to identify which one is his direct phone number that's why we're in we are inserting it to the call hammer okay so we have seven columns all you have to do is to click this one as you can see a hand icon it means to say that you are selecting the whole column from top to bottom once you click that and it shows or it highlighted this blue right click on your mouse and add or insert one right now you have to label that one as master master phone why because call tools will identify this phone number and it will be used to it will be used in sequencing on their end I'm not sure how they do that but for us we have to make sure that we are collating all the phone numbers from this column to this column okay as you can see we have cells that are empty it doesn't matter cuz call tools itself will clean that up for you so let's now insert e a formula no for the formula I forgot so let me look it up here hold on a second I'm gonna open my mail here so here a two represents the cell so in our case you have to put equal sign and since the first column for our phone number is e 2 e 2 so you have to click this one and then the sign and then char and then and close then and then you you have to do that again same format so we start with this sign and then click this one this one and then char and until you reach the last oops the last column that you want to have see what is this column this one then char ten and another one this line see so basically the formula is the same all you have to do is just to change the cell number but I'm doing it manually for you to see it so as you can see here what cell is that so we are at I 2 I 2 then char open close number 10 and repeat your j2g to char open close number 10 and lastly k2 k2 char there so I think we're done to see if we have it correctly yep so there you go basically the formula is just the same all you have to do is to change the cell number let's see here e to so if you're gonna change it here you have to make sure you should be in your formula F to get this F - G - H - so on and so forth so basically that's it once you're done with the first one all you have to do is just to drag it slowly up until the bottom part I don't know how a short way to do it but I like doing this way because I can see who are those leads that doesn't even have phone numbers and we can remove that any time [Music] so it will not be included in the predictive dialer or call hammer and call tools so see you just have to drag that down you don't have to type in the formula again cuz automatically Google sheet will detect that and automatically change the cell number itself okay if you know how to do something like this which is easier for you you can do that but for me I'm dragging because I don't know how to make it short or the quicker way let me see there there you go so you're done see as you can see here this is for the column for master master phone this column will be used in call tools so that the system will detect how many phone numbers they should dial so that's the use of master phone next thing you have to do is of course to insert this one and upload and call tools okay let's switch to call tools go to manager's dashboard as you disconnect or as you go to the manager stash where dashboard you will be disconnected to the predictive so you don't have to worry calls are coming in this part you have to click select and then you have to name a your campaign create a campaign oh sorry you have to click the campaign on the left side and then on the upper part you can see here create campaign click this one I like doing Express is it saves a lot of time so for this list I'll name it as Orlando and state in state so I'm gonna use phone number this one the only Nabal agent script whole script enable okay save and a touch lease it's gonna be it okay alright so you have successfully created a campaign list I mean a campaign now what you go back to your excel file and then all you have to do is to download that as Excel or CSV format this one once you downloaded that all you have to do is to drag it and drop it here see it's very easy now once it's done you have to map it out now I'm gonna show you some errors that might you might encounter as well excuse me hold on so first name city select phone number Master File mailing in you have to make sure that everything here is map out correctly otherwise you can see any pop-up on-call tools and it would be very difficult for you to to open a spill without a pop-up so make sure you gotta do things right in this part [Music] zip code status change day so I don't have that here so I'm gonna live it as select tax name I don't have that I live in a select list price I also don't have that so I'm gonna leave it as select master file so this one phone number select make sure guys that you don't have any the same drop-down this we already have though we have multiple phone numbers here but we have to use just one drop-down for the phone number and that's for the master phone so everything here City address hey everything looks good so let's save all right there so your file has been queued for processing you're done all you have to do is just to edit the calling list on your own preference but that's how you add campaign lists or calling lists and call tools with multiple multiple phone numbers thank you