{"id":40580,"date":"2026-11-05T10:28:29","date_gmt":"2026-11-05T03:28:29","guid":{"rendered":"https:\/\/meeycrm.com\/tin-tuc\/?p=40580"},"modified":"2026-11-05T10:28:29","modified_gmt":"2026-11-05T03:28:29","slug":"quan-ly-nguoi-lien-he","status":"publish","type":"post","link":"https:\/\/meeycrm.com\/tin-tuc\/quan-ly-nguoi-lien-he","title":{"rendered":"Qu\u1ea3n L\u00fd Ng\u01b0\u1eddi Li\u00ean H\u1ec7 L\u00e0 G\u00ec? H\u01b0\u1edbng D\u1eabn T\u1eeb A-Z &#038; Top Gi\u1ea3i Ph\u00e1p T\u1ed1t Nh\u1ea5t"},"content":{"rendered":"<p><b>Qu\u1ea3n l\u00fd ng\u01b0\u1eddi li\u00ean h\u1ec7<\/b><span style=\"font-weight: 400;\"> kh\u00f4ng ch\u1ec9 \u0111\u01a1n thu\u1ea7n l\u00e0 vi\u1ec7c l\u01b0u l\u1ea1i s\u1ed1 \u0111i\u1ec7n tho\u1ea1i hay \u0111\u1ecba ch\u1ec9 email. Trong k\u1ef7 nguy\u00ean k\u1ef9 thu\u1eadt s\u1ed1, \u0111\u00e2y l\u00e0 quy tr\u00ecnh t\u1ed5 ch\u1ee9c, l\u01b0u tr\u1eef, \u0111\u1ed3ng b\u1ed9 v\u00e0 khai th\u00e1c d\u1eef li\u1ec7u danh b\u1ea1 hi\u1ec7u qu\u1ea3\u2014gi\u00fap c\u00e1 nh\u00e2n kh\u00f4ng bao gi\u1edd th\u1ea5t l\u1ea1c th\u00f4ng tin quan tr\u1ecdng v\u00e0 gi\u00fap doanh nghi\u1ec7p t\u1ed1i \u01b0u h\u00f3a quy tr\u00ecnh ch\u0103m s\u00f3c kh\u00e1ch h\u00e0ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n chi ti\u1ebft c\u00e1ch qu\u1ea3n l\u00fd danh b\u1ea1 tr\u00ean c\u00e1c thi\u1ebft b\u1ecb ph\u1ed5 bi\u1ebfn, cung c\u1ea5p file m\u1eabu qu\u1ea3n l\u00fd mi\u1ec5n ph\u00ed v\u00e0 gi\u1edbi thi\u1ec7u c\u00e1c gi\u1ea3i ph\u00e1p ph\u1ea7n m\u1ec1m chuy\u00ean nghi\u1ec7p nh\u1ea5t hi\u1ec7n nay.<\/span><\/p>\n<h2><b>1. Qu\u1ea3n l\u00fd ng\u01b0\u1eddi li\u00ean h\u1ec7 tr\u00ean c\u00e1c thi\u1ebft b\u1ecb c\u00e1 nh\u00e2n<\/b><\/h2>\n<h3><b>1.1. C\u00e1ch qu\u1ea3n l\u00fd ng\u01b0\u1eddi li\u00ean h\u1ec7 tr\u00ean Gmail (Google Contacts)<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Google Contacts l\u00e0 c\u00f4ng c\u1ee5 qu\u1ea3n l\u00fd danh b\u1ea1 tr\u1ef1c tuy\u1ebfn ph\u1ed5 bi\u1ebfn nh\u1ea5t hi\u1ec7n nay, t\u01b0\u01a1ng th\u00edch ho\u00e0n h\u1ea3o v\u1edbi h\u1ec7 sinh th\u00e1i Google.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>\u0110\u1ed3ng b\u1ed9 h\u00f3a t\u1ef1 \u0111\u1ed9ng:<\/b><span style=\"font-weight: 400;\"> M\u1ecdi ng\u01b0\u1eddi li\u00ean h\u1ec7 m\u1edbi khi l\u01b0u tr\u00ean \u0111i\u1ec7n tho\u1ea1i k\u1ebft n\u1ed1i t\u00e0i kho\u1ea3n Gmail s\u1ebd l\u1eadp t\u1ee9c xu\u1ea5t hi\u1ec7n tr\u00ean m\u00e1y t\u00ednh.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Ph\u00e2n lo\u1ea1i b\u1eb1ng Nh\u00e3n (Labels):<\/b><span style=\"font-weight: 400;\"> T\u1ea1o c\u00e1c nh\u00e3n nh\u01b0 <\/span><i><span style=\"font-weight: 400;\">Kh\u00e1ch h\u00e0ng<\/span><\/i><span style=\"font-weight: 400;\">, <\/span><i><span style=\"font-weight: 400;\">\u0110\u1ed1i t\u00e1c<\/span><\/i><span style=\"font-weight: 400;\">, <\/span><i><span style=\"font-weight: 400;\">Gia \u0111\u00ecnh<\/span><\/i><span style=\"font-weight: 400;\"> \u0111\u1ec3 nh\u00f3m danh b\u1ea1 nhanh ch\u00f3ng.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Xu\u1ea5t\/Nh\u1eadp d\u1eef li\u1ec7u:<\/b><span style=\"font-weight: 400;\"> D\u1ec5 d\u00e0ng sao l\u01b0u danh b\u1ea1 ra \u0111\u1ecbnh d\u1ea1ng <\/span><span style=\"font-weight: 400;\">.vcf<\/span><span style=\"font-weight: 400;\"> ho\u1eb7c <\/span><span style=\"font-weight: 400;\">.csv<\/span><span style=\"font-weight: 400;\"> \u0111\u1ec3 chuy\u1ec3n sang n\u1ec1n t\u1ea3ng kh\u00e1c.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_40600\" aria-describedby=\"caption-attachment-40600\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-40600\" src=\"https:\/\/meeycrm.com\/tin-tuc\/wp-content\/uploads\/2026\/11\/quan_ly_nguoi_lien_he_danh_cho_doanh_nghiep.png\" alt=\"\u1ea2nh 1: qu\u1ea3n l\u00fd ng\u01b0\u1eddi li\u00ean h\u1ec7 tr\u00ean c\u00e1c thi\u1ebft b\u1ecb c\u00e1 nh\u00e2n\" width=\"1024\" height=\"572\" srcset=\"https:\/\/meeycrm.com\/tin-tuc\/wp-content\/uploads\/2026\/11\/quan_ly_nguoi_lien_he_danh_cho_doanh_nghiep.png 1024w, https:\/\/meeycrm.com\/tin-tuc\/wp-content\/uploads\/2026\/11\/quan_ly_nguoi_lien_he_danh_cho_doanh_nghiep-300x168.png 300w, https:\/\/meeycrm.com\/tin-tuc\/wp-content\/uploads\/2026\/11\/quan_ly_nguoi_lien_he_danh_cho_doanh_nghiep-768x429.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption id=\"caption-attachment-40600\" class=\"wp-caption-text\">\u1ea2nh 1: qu\u1ea3n l\u00fd ng\u01b0\u1eddi li\u00ean h\u1ec7 tr\u00ean c\u00e1c thi\u1ebft b\u1ecb c\u00e1 nh\u00e2n<\/figcaption><\/figure>\n<h3><b>1.2. C\u00e1ch qu\u1ea3n l\u00fd danh b\u1ea1 v\u00e0 ng\u01b0\u1eddi li\u00ean h\u1ec7 tr\u00ean iPhone (iCloud)<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">H\u1ec7 \u0111i\u1ec1u h\u00e0nh iOS cung c\u1ea5p kh\u1ea3 n\u0103ng b\u1ea3o m\u1eadt v\u00e0 l\u01b0u tr\u1eef danh b\u1ea1 tuy\u1ec7t v\u1eddi th\u00f4ng qua iCloud:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>B\u1eadt sao l\u01b0u iCloud:<\/b><span style=\"font-weight: 400;\"> V\u00e0o <\/span><b>C\u00e0i \u0111\u1eb7t<\/b><span style=\"font-weight: 400;\"> &gt; <\/span><b>T\u00ean t\u00e0i kho\u1ea3n<\/b><span style=\"font-weight: 400;\"> &gt; <\/span><b>iCloud<\/b><span style=\"font-weight: 400;\"> &gt; B\u1eadt xanh m\u1ee5c <\/span><b>Danh b\u1ea1<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>T\u1ea1o danh s\u00e1ch li\u00ean h\u1ec7 (Lists):<\/b><span style=\"font-weight: 400;\"> T\u1eeb iOS 16 tr\u1edf \u0111i, \u1ee9ng d\u1ee5ng Danh b\u1ea1 cho ph\u00e9p t\u1ea1o c\u00e1c danh s\u00e1ch ri\u00eang bi\u1ec7t ngay tr\u00ean m\u00e1y m\u00e0 kh\u00f4ng c\u1ea7n qua m\u00e1y t\u00ednh.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>G\u1ed9p li\u00ean h\u1ec7 tr\u00f9ng:<\/b><span style=\"font-weight: 400;\"> Tr\u1ef1c ti\u1ebfp ph\u00e1t hi\u1ec7n v\u00e0 h\u1ee3p nh\u1ea5t c\u00e1c s\u1ed1 \u0111i\u1ec7n tho\u1ea1i b\u1ecb l\u1eb7p ch\u1ec9 v\u1edbi m\u1ed9t ch\u1ea1m trong \u1ee9ng d\u1ee5ng.<\/span><\/li>\n<\/ul>\n<h3><b>1.3. Qu\u1ea3n l\u00fd ng\u01b0\u1eddi li\u00ean h\u1ec7 tr\u00ean \u0111i\u1ec7n tho\u1ea1i Android<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Tr\u1ef1c quan v\u00e0 \u0111a d\u1ea1ng t\u00ednh n\u0103ng l\u00e0 \u0111i\u1ec3m m\u1ea1nh c\u1ee7a h\u1ec7 \u0111i\u1ec1u h\u00e0nh Android trong qu\u1ea3n l\u00fd danh b\u1ea1:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Ch\u1ecdn v\u1ecb tr\u00ed l\u01b0u m\u1eb7c \u0111\u1ecbnh:<\/b><span style=\"font-weight: 400;\"> B\u1ea1n c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp l\u01b0u ng\u01b0\u1eddi li\u00ean h\u1ec7 v\u00e0o SIM, b\u1ed9 nh\u1edb m\u00e1y ho\u1eb7c t\u00e0i kho\u1ea3n Google\/Samsung Account.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Chia s\u1ebb danh b\u1ea1 nhanh:<\/b><span style=\"font-weight: 400;\"> H\u1ed7 tr\u1ee3 chia s\u1ebb th\u00f4ng tin li\u00ean h\u1ec7 qua QR code, Bluetooth ho\u1eb7c li\u00ean k\u1ebft tr\u1ef1c ti\u1ebfp.<\/span><\/li>\n<\/ul>\n<h3><b>1.4. \u0110\u1ed3ng b\u1ed9 v\u00e0 qu\u1ea3n l\u00fd ng\u01b0\u1eddi li\u00ean h\u1ec7 trong Microsoft Outlook<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi m\u00f4i tr\u01b0\u1eddng d\u00e2n v\u0103n ph\u00f2ng, Outlook l\u00e0 trung t\u00e2m qu\u1ea3n l\u00fd li\u00ean l\u1ea1c kh\u00f4ng th\u1ec3 thi\u1ebfu:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>T\u1ea1o Danh s\u00e1ch ph\u00e2n ph\u1ed1i (Contact Group):<\/b><span style=\"font-weight: 400;\"> Gom nhi\u1ec1u email v\u00e0o m\u1ed9t nh\u00f3m \u0111\u1ec3 g\u1eedi th\u00f4ng b\u00e1o h\u00e0ng lo\u1ea1t ch\u1ec9 b\u1eb1ng m\u1ed9t thao t\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>\u0110\u1ed3ng b\u1ed9 v\u1edbi thi\u1ebft b\u1ecb di \u0111\u1ed9ng:<\/b><span style=\"font-weight: 400;\"> K\u1ebft n\u1ed1i t\u00e0i kho\u1ea3n Outlook Exchange l\u00ean \u0111i\u1ec7n tho\u1ea1i gi\u00fap c\u1eadp nh\u1eadt danh b\u1ea1 c\u00f4ng ty theo th\u1eddi gian th\u1ef1c.<\/span><\/li>\n<\/ul>\n<h2><b>2. Qu\u1ea3n l\u00fd ng\u01b0\u1eddi li\u00ean h\u1ec7 d\u00e0nh cho doanh nghi\u1ec7p (CRM)<\/b><\/h2>\n<h3><b>2.1. T\u1ea1i sao doanh nghi\u1ec7p c\u1ea7n h\u1ec7 th\u1ed1ng qu\u1ea3n l\u00fd danh b\u1ea1 kh\u00e1ch h\u00e0ng?<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Khi quy m\u00f4 doanh nghi\u1ec7p m\u1edf r\u1ed9ng, vi\u1ec7c l\u01b0u tr\u1eef th\u00f4ng tin tr\u00ean \u0111i\u1ec7n tho\u1ea1i c\u00e1 nh\u00e2n hay file Excel l\u1ebb t\u1ebb s\u1ebd d\u1eabn \u0111\u1ebfn r\u1ee7i ro r\u00f2 r\u1ec9 d\u1eef li\u1ec7u, th\u1ea5t l\u1ea1c th\u00f4ng tin khi nh\u00e2n s\u1ef1 ngh\u1ec9 vi\u1ec7c v\u00e0 thi\u1ebfu s\u1ef1 ph\u1ed1i h\u1ee3p gi\u1eefa c\u00e1c ph\u00f2ng ban.<\/span><\/p>\n<h3><b>2.2. C\u00e1c t\u00ednh n\u0103ng c\u1ed1t l\u00f5i c\u1ee7a h\u1ec7 th\u1ed1ng CRM<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>L\u01b0u tr\u1eef t\u1eadp trung:<\/b><span style=\"font-weight: 400;\"> To\u00e0n b\u1ed9 th\u00f4ng tin \u0111\u1ed1i t\u00e1c, kh\u00e1ch h\u00e0ng \u0111\u01b0\u1ee3c l\u01b0u tr\u00ean m\u1ed9t n\u1ec1n t\u1ea3ng \u0111i\u1ec7n to\u00e1n \u0111\u00e1m m\u00e2y an to\u00e0n.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>L\u1ecbch s\u1eed t\u01b0\u01a1ng t\u00e1c:<\/b><span style=\"font-weight: 400;\"> Ghi l\u1ea1i to\u00e0n b\u1ed9 l\u1ecbch s\u1eed cu\u1ed9c g\u1ecdi, email, tin nh\u1eafn, h\u1ee3p \u0111\u1ed3ng c\u1ee7a t\u1eebng ng\u01b0\u1eddi li\u00ean h\u1ec7.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Ph\u00e2n quy\u1ec1n truy c\u1eadp:<\/b><span style=\"font-weight: 400;\"> Qu\u1ea3n l\u00fd ch\u00ednh x\u00e1c ai l\u00e0 ng\u01b0\u1eddi \u0111\u01b0\u1ee3c xem, s\u1eeda ho\u1eb7c x\u00f3a th\u00f4ng tin li\u00ean h\u1ec7.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_40602\" aria-describedby=\"caption-attachment-40602\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-40602\" src=\"https:\/\/meeycrm.com\/tin-tuc\/wp-content\/uploads\/2026\/11\/quan_ly_nguoi_lien_he_danh_cho_doanh_nghiep-1.png\" alt=\"\u1ea2nh 2: qu\u1ea3n l\u00fd ng\u01b0\u1eddi li\u00ean h\u1ec7 d\u00e0nh cho doanh nghi\u1ec7p\" width=\"1024\" height=\"572\" srcset=\"https:\/\/meeycrm.com\/tin-tuc\/wp-content\/uploads\/2026\/11\/quan_ly_nguoi_lien_he_danh_cho_doanh_nghiep-1.png 1024w, https:\/\/meeycrm.com\/tin-tuc\/wp-content\/uploads\/2026\/11\/quan_ly_nguoi_lien_he_danh_cho_doanh_nghiep-1-300x168.png 300w, https:\/\/meeycrm.com\/tin-tuc\/wp-content\/uploads\/2026\/11\/quan_ly_nguoi_lien_he_danh_cho_doanh_nghiep-1-768x429.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption id=\"caption-attachment-40602\" class=\"wp-caption-text\">\u1ea2nh 2: qu\u1ea3n l\u00fd ng\u01b0\u1eddi li\u00ean h\u1ec7 d\u00e0nh cho doanh nghi\u1ec7p<\/figcaption><\/figure>\n<h3><b>2.3. Top 3 gi\u1ea3i ph\u00e1p ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd ng\u01b0\u1eddi li\u00ean h\u1ec7 chuy\u00ean nghi\u1ec7p<\/b><\/h3>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>HubSpot CRM:<\/b><span style=\"font-weight: 400;\"> Gi\u1ea3i ph\u00e1p mi\u1ec5n ph\u00ed m\u1ea1nh m\u1ebd cho doanh nghi\u1ec7p v\u1eeba v\u00e0 nh\u1ecf, theo d\u00f5i h\u00e0nh vi ng\u01b0\u1eddi li\u00ean h\u1ec7 t\u1ef1 \u0111\u1ed9ng.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Salesforce:<\/b><span style=\"font-weight: 400;\"> H\u1ec7 th\u1ed1ng qu\u1ea3n l\u00fd quan h\u1ec7 kh\u00e1ch h\u00e0ng chuy\u00ean s\u00e2u, ph\u00f9 h\u1ee3p v\u1edbi c\u00e1c t\u1eadp \u0111o\u00e0n l\u1edbn.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Zoho CRM:<\/b><span style=\"font-weight: 400;\"> Chi ph\u00ed t\u1ed1i \u01b0u, giao di\u1ec7n th\u00e2n thi\u1ec7n v\u00e0 d\u1ec5 d\u00e0ng t\u00f9y ch\u1ec9nh theo quy m\u00f4 doanh nghi\u1ec7p.<\/span><\/li>\n<\/ol>\n<h2><b>3. H\u01b0\u1edbng d\u1eabn t\u1ea1o file Excel \/ Google Sheets qu\u1ea3n l\u00fd ng\u01b0\u1eddi li\u00ean h\u1ec7 mi\u1ec5n ph\u00ed<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n l\u00e0 c\u00e1 nh\u00e2n kinh doanh t\u1ef1 do ho\u1eb7c doanh nghi\u1ec7p nh\u1ecf ch\u01b0a s\u1eb5n s\u00e0ng d\u00f9ng CRM, m\u1ed9t b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c chu\u1ea9n h\u00f3a l\u00e0 l\u1ef1a ch\u1ecdn t\u1ed1i \u01b0u.<\/span><\/p>\n<h3><b>B\u1ea3ng c\u1ea5u tr\u00fac file qu\u1ea3n l\u00fd danh b\u1ea1 chu\u1ea9n:<\/b><\/h3>\n<table>\n<tbody>\n<tr>\n<td><b>M\u00e3 KH<\/b><\/td>\n<td><b>H\u1ecd v\u00e0 T\u00ean<\/b><\/td>\n<td><b>S\u1ed1 \u0111i\u1ec7n tho\u1ea1i<\/b><\/td>\n<td><b>Email<\/b><\/td>\n<td><b>C\u00f4ng ty \/ Ch\u1ee9c v\u1ee5<\/b><\/td>\n<td><b>Nh\u00f3m kh\u00e1ch h\u00e0ng<\/b><\/td>\n<td><b>Ghi ch\u00fa t\u01b0\u01a1ng t\u00e1c<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">KH01<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Nguy\u1ec5n V\u0103n A<\/span><\/td>\n<td><span style=\"font-weight: 400;\">0901234xxx<\/span><\/td>\n<td><span style=\"font-weight: 400;\">anva@gmail.com<\/span><\/td>\n<td><span style=\"font-weight: 400;\">C\u00f4ng ty ABC \/ Tr\u01b0\u1edfng ph\u00f2ng<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Kh\u00e1ch h\u00e0ng VIP<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u0110\u00e3 b\u00e1o gi\u00e1 ng\u00e0y 10\/10<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">KH02<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Tr\u1ea7n Th\u1ecb B<\/span><\/td>\n<td><span style=\"font-weight: 400;\">0987654xxx<\/span><\/td>\n<td><span style=\"font-weight: 400;\">btran@outlook.com<\/span><\/td>\n<td><span style=\"font-weight: 400;\">C\u00f4ng ty XYZ \/ Gi\u00e1m \u0111\u1ed1c<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u0110\u1ed1i t\u00e1c ti\u1ec1m n\u0103ng<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Ch\u1edd g\u1eedi h\u1ee3p \u0111\u1ed3ng m\u1eabu<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><b>M\u1eb9o:<\/b><span style=\"font-weight: 400;\"> S\u1eed d\u1ee5ng t\u00ednh n\u0103ng <\/span><i><span style=\"font-weight: 400;\">Data Validation<\/span><\/i><span style=\"font-weight: 400;\"> (X\u00e1c th\u1ef1c d\u1eef li\u1ec7u) trong Google Sheets \u0111\u1ec3 t\u1ea1o danh s\u00e1ch ch\u1ecdn (Dropdown) cho c\u1ed9t <\/span><b>Nh\u00f3m kh\u00e1ch h\u00e0ng<\/b><span style=\"font-weight: 400;\">, gi\u00fap d\u1eef li\u1ec7u lu\u00f4n \u0111\u1ed3ng b\u1ed9.<\/span><\/p>\n<figure id=\"attachment_40603\" aria-describedby=\"caption-attachment-40603\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-40603\" src=\"https:\/\/meeycrm.com\/tin-tuc\/wp-content\/uploads\/2026\/11\/huong_dan_tao_file_excel_google_sheets_quan_ly.png\" alt=\"\u1ea2nh 3: h\u01b0\u1edbng d\u1eabn t\u1ea1o file excel google sheets qu\u1ea3n l\u00fd\" width=\"1024\" height=\"559\" srcset=\"https:\/\/meeycrm.com\/tin-tuc\/wp-content\/uploads\/2026\/11\/huong_dan_tao_file_excel_google_sheets_quan_ly.png 1024w, https:\/\/meeycrm.com\/tin-tuc\/wp-content\/uploads\/2026\/11\/huong_dan_tao_file_excel_google_sheets_quan_ly-300x164.png 300w, https:\/\/meeycrm.com\/tin-tuc\/wp-content\/uploads\/2026\/11\/huong_dan_tao_file_excel_google_sheets_quan_ly-768x419.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption id=\"caption-attachment-40603\" class=\"wp-caption-text\">\u1ea2nh 3: h\u01b0\u1edbng d\u1eabn t\u1ea1o file excel google sheets qu\u1ea3n l\u00fd<\/figcaption><\/figure>\n<h2><b>4. C\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 c\u00e1ch kh\u1eafc ph\u1ee5c<\/b><\/h2>\n<h3><b>4.1. C\u00e1ch l\u1ecdc v\u00e0 x\u00f3a ng\u01b0\u1eddi li\u00ean h\u1ec7 tr\u00f9ng l\u1eb7p (Duplicate Contacts)<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Tr\u00ean Google Contacts:<\/b><span style=\"font-weight: 400;\"> Truy c\u1eadp <\/span><span style=\"font-weight: 400;\">contacts.google.com<\/span><span style=\"font-weight: 400;\"> &gt; Ch\u1ecdn m\u1ee5c <\/span><b>Ph\u1ea7n h\u1ee3p nh\u1ea5t v\u00e0 kh\u1eafc ph\u1ee5c<\/b><span style=\"font-weight: 400;\"> (Merge &amp; Fix) \u1edf menu b\u00ean tr\u00e1i &gt; Ch\u1ecdn <\/span><b>H\u1ee3p nh\u1ea5t t\u1ea5t c\u1ea3<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Tr\u00ean iPhone:<\/b><span style=\"font-weight: 400;\"> M\u1edf app <\/span><b>Danh b\u1ea1<\/b><span style=\"font-weight: 400;\"> &gt; Ch\u1ecdn <\/span><b>B\u1ea3n tr\u00f9ng l\u1eb7p t\u00ecm th\u1ea5y<\/b><span style=\"font-weight: 400;\"> (Duplicates Found) ngay \u0111\u1ea7u m\u00e0n h\u00ecnh &gt; Ch\u1ecdn <\/span><b>H\u1ee3p nh\u1ea5t t\u1ea5t c\u1ea3<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ul>\n<h3><b>4.2. Kh\u00f4i ph\u1ee5c danh b\u1ea1 b\u1ecb m\u1ea5t ho\u1eb7c v\u00f4 t\u00ecnh x\u00f3a<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Kh\u00f4i ph\u1ee5c t\u1eeb Gmail:<\/b><span style=\"font-weight: 400;\"> V\u00e0o Google Contacts &gt; C\u00e0i \u0111\u1eb7t (Bi\u1ec3u t\u01b0\u1ee3ng b\u00e1nh r\u0103ng) &gt; <\/span><b>H\u1ee7y c\u00e1c thay \u0111\u1ed5i<\/b><span style=\"font-weight: 400;\"> &gt; Ch\u1ecdn th\u1eddi \u0111i\u1ec3m kh\u00f4i ph\u1ee5c (t\u1ed1i \u0111a 30 ng\u00e0y tr\u01b0\u1edbc).<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Kh\u00f4i ph\u1ee5c t\u1eeb iCloud:<\/b><span style=\"font-weight: 400;\"> Truy c\u1eadp <\/span><span style=\"font-weight: 400;\">icloud.com<\/span><span style=\"font-weight: 400;\"> &gt; C\u00e0i \u0111\u1eb7t t\u00e0i kho\u1ea3n &gt; Ch\u1ecdn <\/span><b>Kh\u00f4i ph\u1ee5c danh b\u1ea1<\/b><span style=\"font-weight: 400;\"> t\u1ea1i m\u1ee5c N\u00e2ng cao.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Vi\u1ec7c <\/span><b>qu\u1ea3n l\u00fd ng\u01b0\u1eddi li\u00ean h\u1ec7<\/b><span style=\"font-weight: 400;\"> m\u1ed9t c\u00e1ch khoa h\u1ecdc ch\u00ednh l\u00e0 b\u01b0\u1edbc \u0111\u1ea7u ti\u00ean \u0111\u1ec3 x\u00e2y d\u1ef1ng m\u1ed1i quan h\u1ec7 b\u1ec1n v\u1eefng v\u1edbi \u0111\u1ed1i t\u00e1c v\u00e0 kh\u00e1ch h\u00e0ng. H\u00e3y b\u1eaft \u0111\u1ea7u b\u1eb1ng vi\u1ec7c d\u1ecdn d\u1eb9p danh b\u1ea1 c\u00e1 nh\u00e2n tr\u00ean Gmail\/iPhone h\u00f4m nay ho\u1eb7c thi\u1ebft l\u1eadp ngay m\u1ed9t h\u1ec7 th\u1ed1ng qu\u1ea3n l\u00fd chu\u1ea9n ch\u1ec9nh cho doanh nghi\u1ec7p c\u1ee7a b\u1ea1n!<\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Qu\u1ea3n l\u00fd ng\u01b0\u1eddi li\u00ean h\u1ec7 kh\u00f4ng ch\u1ec9 \u0111\u01a1n thu\u1ea7n l\u00e0 vi\u1ec7c l\u01b0u l\u1ea1i s\u1ed1 \u0111i\u1ec7n tho\u1ea1i hay \u0111\u1ecba ch\u1ec9 email. Trong k\u1ef7 nguy\u00ean k\u1ef9 thu\u1eadt s\u1ed1, \u0111\u00e2y l\u00e0&#8230; <\/p>\n","protected":false},"author":1,"featured_media":40603,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-40580","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"_links":{"self":[{"href":"https:\/\/meeycrm.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/40580","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/meeycrm.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/meeycrm.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/meeycrm.com\/tin-tuc\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/meeycrm.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=40580"}],"version-history":[{"count":4,"href":"https:\/\/meeycrm.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/40580\/revisions"}],"predecessor-version":[{"id":40605,"href":"https:\/\/meeycrm.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/40580\/revisions\/40605"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/meeycrm.com\/tin-tuc\/wp-json\/wp\/v2\/media\/40603"}],"wp:attachment":[{"href":"https:\/\/meeycrm.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=40580"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meeycrm.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=40580"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meeycrm.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=40580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}