Streamline personnel management with airSlate SignNow's crm contact for Personnel

How to create outlook signature

giving your team off of spreadsheets and onto CRM is a huge First Step but it is only the first step what's going on everybody it's your dude Devin and today I'm going to show you how to bring contacts in the HubSpot and I'm not just talking about one by one we're talking all of your spreadsheet into HubSpot at once before we get started few things to keep in mind as a wise Uncle once said with great power comes great responsibility this is a very powerful tool and it's very tempting to abuse but don't do it first thing you don't want to do is import hold lists you don't want to bring in something that's old where you can have old names old email addresses because what can happen is you can send emails to these people they no longer exist completely ruins your email deliverability also you don't want to import bot lists you don't even want to buy lists you want to only bring in people who have opted in people who know that they're going to hear from you be a good purse next thing skip your data clean remember that garbage in means garbage out there's no need to have a messed up spreadsheet and try and figure it out later we can clean up your spreadsheet first well let's actually talk about how to prep your spreadsheet so this is an example of a good spreadsheet perfect for HubSpot import has a first name last name email the three most important things that you're going to need if you plan on importing we've also got phone numbers and we have the company field now what we're going to do is we're going to leave the company field out but instead of deleting it out of the spreadsheet we're just not going to import it into the system show you how to do that later but let's say you have a spreadsheet that doesn't have first name last name as the entire name in the same field easy way to fix this is to take this field select it we're going to do the whole column and go to split text into columns then we're going to go down here and select space and that's it now we have your first name and last name split and you're ready for a clean import into HubSpot speaking of which let's go ahead and get started right now in HubSpot what you want to do is go to contacts and then select contacts and right over here in the upper right hand corner is import so we have a couple different options here you have start and import or sync sync is very powerful sync is great if you want to connect to a legacy CRM or if you're using is something older like a different marketing automation tool or email tool you can connect directly to it and bring all your data right over but for this case we're going to go with starting an import so here we have three different options we can repeat a past import and we'll use that as a template for the new import but that's not what we're doing today you can import an opt-out list this one is extremely important you want to make sure that the people who have opted out in your previous email marketing tools or your previous CRM don't accidentally get email sent to them from this one so we're going to make sure that we're importing clean lists but in this case we're going to be importing a file from the computer so we can import multiple files with associations or we can import one file multiple files is something you can do but it's really a tool for advanced users it's not something that I would recommend if you're just getting started out with HubSpot so we're going to go ahead and select one file now one object or multiple objects this one can be kind of tricky technically technically we could use our existing spreadsheet to import multiple objects but we're not going to do that today now if you're curious about what objects are let's go and select one object and go to next and we can break it down objects within HubSpot are companies contacts deals products shipments tickets but you can also import activities like calls emails meetings notes tasks all of these are able to be imported into HubSpot from a spreadsheet but what we're doing today is importing contacts so the next thing we're going to do is to choose R in this case CSV and now we have the options of how we want to import these contacts we can create and update contacts create new contacts only or update existing contacts the reason why this is important is because you might have to import from multiple data sources but if you've ever worked with numerous systems you know typically only one of them is your source of Truth so you want to make sure that whatever it is that you're importing first is your source of Truth and if you need to add data to that but don't want to corrupt your existing data that's when you start relying on whether or not to only add new names or only update the existing names so that way you're not messing anything up in your CRM like I said before garbage in garbage out we want to make sure our data comes in clean but in this case since it's going to be our first one we're going to go ahead and select create and update contacts now you can see here it's scanning for some of your common errors and it's in it didn't find anything that's great news but if it does it'll let you do something about it we'll talk about that a little later but first let's look at what we want to import so we can import our contact properties we can use our record ID which is something if we're using a unique identifier to make sure that we don't want to duplicate we don't have to worry about today or you can select don't import column we are going to be using that today we're going to be doing contact properties we know that this is the first name field we know that this is the last name field and if we look we can see it's already selected emails it's already selected phone number and we are not going to import company names even though there already is a space for it so what we'll do is we'll select don't import now we've identified everything however let's say that this column doesn't have a property that we want to associate with it what we can do is we can create a new property creating new properties can be very tempting but what you don't want to do is completely inundate your system with new properties especially properties that you might never use again we don't necessarily need to import all of the data that comes in from the system what I'd recommend is taking a moment to think before you create new properties ask yourself does this data really need to be in the CRM do I really need to know this about this person is it relevant or is there already a property that exists that I can use to put this in in this case we're not going to create a new one so what we're going to do is we're going to go over to cancel and we're going to make sure that we do not import this column and as you can see now everything's clear we can hit next and we can name this import and so I highly recommend naming your imports not just going off of the file name so we can go back and find them later so we can do full CRM list and we can put in the date here the reason why I'm selecting create a list from this import is because maybe you want to go back and just use the names that came in off the spreadsheet for a targeted email or maybe I want to enroll them in a workflow and I'm going to be able to easily access them later this is how you do it and of course the all important I agree that all contacts in this import are expecting to hear from my organization now that I've clicked finish you can see that the import is processing it's going to let me know when the import is done so we can sit back relax do other things or we can see how this was in okay so we see that there were some errors it went to import 511 rows but it only added 30 new records something must be wrong and the error is in the email there was duplicate IDs so we can click on that and it'll give us more information on what that means once you read through it you can see what errors it was giving how to fix it and you can even download the errors as a CSV so you can correct it manually simple as that I happen to know that there were duplicates in this I kind of did it on purpose just so you can see how it works and that's it you're all done uploading from spreadsheets is a huge Time Saver it can be tempting to rush through it and fix it later but what you really want to do is make sure your data is clean before you put it in remember be responsible don't get into bad habits doing bad things before you go be sure to click the link below and try HubSpot for free today that's it for me everybody hope to talk to you soon until then take it easy