Yes, for each contact, in your new column just type the value.
The values in the spreadsheet column need to match the values of the property you've created exactly. If your HubSpot property can have two values, e.g. "Member" and "Non-Member", you should put the exact spelling / upper and lower case in the spreadsheet column, for example:
First Name
Last Name
E-Mail
Membership status
John
Doe
johndoe@gmail.com
Member
Jane
Doe
janedoe@gmail.com
Non-Member
The column name / column header does not have to have the same name as the property. However, if it does, HubSpot will automatically recognize it and match automatically. (If it doesn't, you have to manually check during the import process whether the column is assigned to the corresponding property.)
Hope this helps!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
If you know the value before importing, I'd recommend that you simply add another column to your import file and quickly fill in the values (member / non-member) manually for each contact there.
During the import process, make sure to match this new column to the corresponding property in HubSpot. HubSpot will then automagically fill in the value for each contact.
If you want to assign the value after importing, a workflow will probably be your best friend. The exact workflow steps depend on how you determine whether someone is a member or non-member.
If workflows aren't included in your HubSpot subscription, an alternative could be lists. Collecting members in one list, non-members in another, you can bulk-edit and assign the value to the property. (This also works from the contacts menu. Just select the contacts that you want to bulk edit!)
Hope this helps!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
Yes, for each contact, in your new column just type the value.
The values in the spreadsheet column need to match the values of the property you've created exactly. If your HubSpot property can have two values, e.g. "Member" and "Non-Member", you should put the exact spelling / upper and lower case in the spreadsheet column, for example:
First Name
Last Name
E-Mail
Membership status
John
Doe
johndoe@gmail.com
Member
Jane
Doe
janedoe@gmail.com
Non-Member
The column name / column header does not have to have the same name as the property. However, if it does, HubSpot will automatically recognize it and match automatically. (If it doesn't, you have to manually check during the import process whether the column is assigned to the corresponding property.)
Hope this helps!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
To do the above you could use a workflow. You could set up your enrollment trigger to enroll a contact when their Create Date = is known. This will enroll any new contacts to this workflow.
The next action of the workflow would be to set the property value of the property you choose to update. More on this here.