{"id":40493,"date":"2026-11-03T13:46:45","date_gmt":"2026-11-03T06:46:45","guid":{"rendered":"https:\/\/meeycrm.com\/tin-tuc\/?p=40493"},"modified":"2026-11-03T13:46:53","modified_gmt":"2026-11-03T06:46:53","slug":"cach-dong-bo-data-tu-google-sheet-vao-crm-bds","status":"publish","type":"post","link":"https:\/\/meeycrm.com\/tin-tuc\/cach-dong-bo-data-tu-google-sheet-vao-crm-bds","title":{"rendered":"C\u00e1ch \u0110\u1ed3ng B\u1ed9 Data T\u1eeb Google Sheet V\u00e0o CRM B\u0110S T\u1ef1 \u0110\u1ed9ng & Chi Ti\u1ebft Nh\u1ea5t"},"content":{"rendered":"

Trong ng\u00e0nh b\u1ea5t \u0111\u1ed9ng s\u1ea3n (B\u0110S), <\/span>t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd data kh\u00e1ch h\u00e0ng quy\u1ebft \u0111\u1ecbnh \u0111\u1ebfn 80% t\u1ef7 l\u1ec7 ch\u1ed1t h\u1eb9n th\u00e0nh c\u00f4ng<\/b>. Tuy nhi\u00ean, nhi\u1ec1u doanh nghi\u1ec7p v\u00e0 \u0111\u1ed9i ng\u0169 m\u00f4i gi\u1edbi v\u1eabn \u0111ang s\u1eed d\u1ee5ng quy tr\u00ecnh th\u1ee7 c\u00f4ng: ch\u1ea1y qu\u1ea3ng c\u00e1o Facebook\/Google -> Data \u0111\u1ed5 v\u1ec1 Google Sheet -> Nh\u00e2n vi\u00ean copy-paste th\u1ee7 c\u00f4ng v\u00e0o CRM -> M\u1edbi b\u1eaft \u0111\u1ea7u chia lead cho Sale. Quy tr\u00ecnh n\u00e0y khi\u1ebfn lead b\u1ecb “ngu\u1ed9i”, r\u00f2 r\u1ec9 th\u00f4ng tin v\u00e0 sai l\u1ec7ch d\u1eef li\u1ec7u.<\/span><\/p>\n

B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n <\/span>c\u00e1ch \u0111\u1ed3ng b\u1ed9 data t\u1eeb google sheet v\u00e0o crm b\u0111s<\/b> t\u1ef1 \u0111\u1ed9ng 100%, gi\u00fap d\u1eef li\u1ec7u \u0111\u1ed5 v\u1ec1 CRM ch\u1ec9 trong v\u00e0i gi\u00e2y v\u00e0 s\u1eb5n s\u00e0ng cho telesale ch\u0103m s\u00f3c ngay l\u1eadp t\u1ee9c.<\/span><\/p>\n

1. V\u00ec Sao Doanh Nghi\u1ec7p B\u0110S C\u1ea7n \u0110\u1ed3ng B\u1ed9 Data T\u1eeb Google Sheet V\u00e0o CRM Ngay?<\/b><\/h2>\n

T\u1ed1c \u0111\u1ed9 “v\u00e0ng” trong x\u1eed l\u00fd Lead B\u0110S<\/b><\/h3>\n

Theo c\u00e1c nghi\u00ean c\u1ee9u v\u1ec1 ti\u1ebfp th\u1ecb B\u0110S, kh\u00e1ch h\u00e0ng \u0111\u0103ng k\u00fd t\u01b0 v\u1ea5n d\u1ef1 \u00e1n th\u01b0\u1eddng c\u00f3 t\u00e2m l\u00fd so s\u00e1nh nhi\u1ec1u b\u00ean c\u00f9ng l\u00fac. N\u1ebfu telesale li\u00ean h\u1ec7 trong <\/span>5 ph\u00fat \u0111\u1ea7u ti\u00ean<\/b> k\u1ec3 t\u1eeb khi kh\u00e1ch \u0111i\u1ec1n form tr\u00ean Landing Page hay Facebook Ads, kh\u1ea3 n\u0103ng k\u1ebft n\u1ed1i th\u00e0nh c\u00f4ng v\u00e0 h\u1eb9n g\u1eb7p tr\u1ef1c ti\u1ebfp cao g\u1ea5p 9 l\u1ea7n so v\u1edbi vi\u1ec7c \u0111\u1ec3 sau 30 ph\u00fat. \u0110\u1ed3ng b\u1ed9 t\u1ef1 \u0111\u1ed9ng gi\u1ea3i quy\u1ebft tri\u1ec7t \u0111\u1ec3 \u0111\u1ed9 tr\u1ec5 n\u00e0y.<\/span><\/p>\n

H\u1ea1n ch\u1ebf r\u00f2 r\u1ec9 v\u00e0 m\u1ea5t m\u00e1t d\u1eef li\u1ec7u<\/b><\/h3>\n

Qu\u1ea3n l\u00fd kh\u00e1ch h\u00e0ng b\u1eb1ng file Google Sheet chia s\u1ebb chung d\u1ec5 d\u1eabn \u0111\u1ebfn t\u00ecnh tr\u1ea1ng m\u00f4i gi\u1edbi l\u00e0m r\u00f2 r\u1ec9 t\u1ec7p data, t\u1ef1 \u00fd ch\u1ec9nh s\u1eeda ho\u1eb7c v\u00f4 t\u00ecnh x\u00f3a m\u1ea5t b\u1ea3n ghi. Khi d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c \u0111\u1ea9y tr\u1ef1c ti\u1ebfp v\u00e0o CRM B\u0110S, to\u00e0n b\u1ed9 th\u00f4ng tin s\u1ebd \u0111\u01b0\u1ee3c ph\u00e2n quy\u1ec1n b\u1ea3o m\u1eadt ch\u1eb7t ch\u1ebd.<\/span><\/p>\n

\"\u1ea2nh
\u1ea2nh 1: v\u00ec sao doanh nghi\u1ec7p b\u0111s c\u1ea7n \u0111\u1ed3ng b\u1ed9 data t\u1eeb google sheet<\/figcaption><\/figure>\n

Lo\u1ea1i b\u1ecf thao t\u00e1c th\u1ee7 c\u00f4ng (Copy – Paste)<\/b><\/h3>\n

M\u1ed7i ng\u00e0y, chuy\u00ean vi\u00ean Marketing ho\u1eb7c Admin s\u00e0n ph\u1ea3i m\u1ea5t 2 – 3 gi\u1edd \u0111\u1ec3 l\u1ecdc data, x\u00f3a d\u00f2ng tr\u00f9ng v\u00e0 g\u00e1n th\u1ee7 c\u00f4ng cho telesale. T\u1ef1 \u0111\u1ed9ng h\u00f3a quy tr\u00ecnh k\u1ebft n\u1ed1i gi\u1eefa Google Sheet v\u00e0 CRM gi\u1ea3i ph\u00f3ng th\u1eddi gian l\u00e0m vi\u1ec7c, lo\u1ea1i b\u1ecf ho\u00e0n to\u00e0n l\u1ed7i nh\u1eadp sai S\u1ed1 \u0111i\u1ec7n tho\u1ea1i hay Email.<\/span><\/p>\n

2. So S\u00e1nh 3 C\u00e1ch \u0110\u1ed3ng B\u1ed9 Data T\u1eeb Google Sheet V\u00e0o CRM B\u0110S Ph\u1ed5 Bi\u1ebfn Nh\u1ea5t<\/b><\/h2>\n\n\n\n\n\n\n\n\n
Ti\u00eau ch\u00ed<\/b><\/td>\nC\u00e1ch 1: N\u1ec1n t\u1ea3ng trung gian (Make \/ Zapier)<\/b><\/td>\nC\u00e1ch 2: Webhook API & Apps Script<\/b><\/td>\nC\u00e1ch 3: T\u00ednh n\u0103ng s\u1eb5n c\u00f3 c\u1ee7a CRM (Native)<\/b><\/td>\n<\/tr>\n
\u0110\u1ed9 kh\u00f3 thi\u1ebft l\u1eadp<\/b><\/td>\nD\u1ec5 (No-code, K\u00e9o – Th\u1ea3)<\/span><\/td>\nPh\u1ee9c t\u1ea1p (C\u1ea7n hi\u1ec3u bi\u1ebft v\u1ec1 code\/API)<\/span><\/td>\nR\u1ea5t d\u1ec5 (B\u1eadt\/t\u1eaft trong giao di\u1ec7n CRM)<\/span><\/td>\n<\/tr>\n
Chi ph\u00ed v\u1eadn h\u00e0nh<\/b><\/td>\nMi\u1ec5n ph\u00ed g\u00f3i c\u01a1 b\u1ea3n, t\u1ed1n ph\u00ed khi scale l\u1edbn<\/span><\/td>\nMi\u1ec5n ph\u00ed 100%<\/span><\/td>\n\u0110\u00e3 t\u00ednh trong g\u00f3i b\u1ea3n quy\u1ec1n CRM<\/span><\/td>\n<\/tr>\n
T\u00f9y bi\u1ebfn lu\u1ed3ng chia Lead<\/b><\/td>\n\u0110a d\u1ea1ng, linh ho\u1ea1t<\/span><\/td>\nT\u00f9y bi\u1ebfn tuy\u1ec7t \u0111\u1ed1i theo logic kinh doanh<\/span><\/td>\nPh\u1ee5 thu\u1ed9c v\u00e0o t\u00ednh n\u0103ng ph\u1ea7n m\u1ec1m cung c\u1ea5p<\/span><\/td>\n<\/tr>\n
\u0110\u1ed9 tr\u1ec5 \u0111\u1ed3ng b\u1ed9<\/b><\/td>\n1 ph\u00fat \u2013 15 ph\u00fat (T\u00f9y g\u00f3i c\u01b0\u1edbc)<\/span><\/td>\nT\u1ee9c th\u00ec (Real-time)<\/span><\/td>\nT\u1ee9c th\u00ec (Real-time)<\/span><\/td>\n<\/tr>\n
\u0110\u1ed1i t\u01b0\u1ee3ng ph\u00f9 h\u1ee3p<\/b><\/td>\nTeam Marketing, S\u00e0n B\u0110S v\u1eeba & nh\u1ecf<\/span><\/td>\nDoanh nghi\u1ec7p B\u0110S c\u00f3 Dev \/ Automation Specialist<\/span><\/td>\nS\u00e0n B\u0110S d\u00f9ng CRM \u0111\u00f3ng g\u00f3i (SaaS)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

C\u00e1ch 1: S\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng h\u00f3a trung gian (Make.com \/ Zapier \/ Pabbly)<\/b><\/h3>\n

\u0110\u00e2y l\u00e0 <\/span>c\u00e1ch \u0111\u1ed3ng b\u1ed9 data t\u1eeb google sheet v\u00e0o crm b\u0111s<\/b> ph\u1ed5 bi\u1ebfn nh\u1ea5t cho c\u00e1c nh\u00f3m ti\u1ebfp th\u1ecb kh\u00f4ng c\u00f3 chuy\u00ean vi\u00ean IT. B\u1ea1n ch\u1ec9 c\u1ea7n k\u1ebft n\u1ed1i t\u00e0i kho\u1ea3n Google v\u1edbi c\u00f4ng c\u1ee5 trung gian, ch\u1ecdn Google Sheet l\u00e0m ngu\u1ed3n (Trigger) v\u00e0 CRM B\u0110S l\u00e0m \u0111i\u1ec3m \u0111\u1ebfn (Action).<\/span><\/p>\n

C\u00e1ch 2: K\u1ebft n\u1ed1i qua Webhook API & Google Apps Script<\/b><\/h3>\n

Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y s\u1eed d\u1ee5ng \u0111o\u1ea1n m\u00e3 Google Apps Script \u0111\u00ednh k\u00e8m tr\u1ef1c ti\u1ebfp v\u00e0o Trang t\u00ednh. M\u1ed7i khi c\u00f3 d\u00f2ng d\u1eef li\u1ec7u m\u1edbi, Script s\u1ebd t\u1ef1 \u0111\u1ed9ng g\u1eedi m\u1ed9t y\u00eau c\u1ea7u <\/span>HTTP POST<\/span> ch\u1ee9a d\u1eef li\u1ec7u qua Webhook API c\u1ee7a CRM B\u0110S. C\u00e1ch l\u00e0m n\u00e0y mang l\u1ea1i t\u1ed1c \u0111\u1ed9 t\u1ee9c th\u00ec v\u00e0 ho\u00e0n to\u00e0n kh\u00f4ng t\u1ed1n chi ph\u00ed duy tr\u00ec h\u00e0ng th\u00e1ng.<\/span><\/p>\n

C\u00e1ch 3: \u0110\u1ed3ng b\u1ed9 qua t\u00ednh n\u0103ng t\u00edch h\u1ee3p s\u1eb5n (Native Integration) c\u1ee7a CRM B\u0110S<\/b><\/h3>\n

C\u00e1c gi\u1ea3i ph\u00e1p CRM B\u0110S hi\u1ec7n \u0111\u1ea1i t\u1ea1i Vi\u1ec7t Nam (nh\u01b0 Getfly, Pancake CRM, MISA AMIS CRM, SlimCRM…) \u0111\u1ec1u cung c\u1ea5p s\u1eb5n t\u00ednh n\u0103ng “K\u1ebft n\u1ed1i Google Sheets”. Ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u1ea7n d\u00e1n URL b\u1ea3ng t\u00ednh v\u00e0 x\u00e1c th\u1ef1c t\u00e0i kho\u1ea3n Google l\u00e0 h\u1ec7 th\u1ed1ng t\u1ef1 \u0111\u1ed9ng nh\u1eadn di\u1ec7n data.<\/span><\/p>\n

\"\u1ea2nh
\u1ea2nh 2: so s\u00e1nh 3 c\u00e1ch \u0111\u1ed3ng b\u1ed9 data t\u1eeb google sheet<\/figcaption><\/figure>\n

3. H\u01b0\u1edbng D\u1eabn 5 B\u01b0\u1edbc \u0110\u1ed3ng B\u1ed9 Data Google Sheet V\u00e0o CRM B\u0110S (Th\u1ef1c H\u00e0nh Chi Ti\u1ebft)<\/b><\/h2>\n

\u0110\u1ec3 b\u1ea1n d\u1ec5 h\u00ecnh dung, d\u01b0\u1edbi \u0111\u00e2y l\u00e0 quy tr\u00ecnh 5 b\u01b0\u1edbc chu\u1ea9n h\u00f3a \u00e1p d\u1ee5ng cho c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng h\u00f3a ho\u1eb7c thi\u1ebft l\u1eadp qua CRM API.<\/span><\/p>\n

[Kh\u00e1ch \u0111i\u1ec1n Form] \u2794 [Google Sheet nh\u1eadn D\u00f2ng m\u1edbi] \u2794 [C\u00f4ng c\u1ee5 K\u1ebft n\u1ed1i \/ Apps Script] \u2794 [CRM B\u0110S ti\u1ebfp nh\u1eadn & Ph\u00e2n lead]<\/span><\/p>\n

B\u01b0\u1edbc 1: Thi\u1ebft l\u1eadp v\u00e0 \u0111\u1ecbnh d\u1ea1ng B\u1ea3ng t\u00ednh Google Sheets chu\u1ea9n<\/b><\/h3>\n

Trang t\u00ednh Google Sheet c\u1ea7n \u0111\u01b0\u1ee3c c\u1ea5u h\u00ecnh chu\u1ea9n ngay t\u1eeb \u0111\u1ea7u. H\u00e0ng \u0111\u1ea7u ti\u00ean (Row 1) b\u1eaft bu\u1ed9c ph\u1ea3i l\u00e0 ti\u00eau \u0111\u1ec1 c\u1ed9t (Header) r\u00f5 r\u00e0ng, kh\u00f4ng vi\u1ebft g\u1ed9p \u00f4 (Merge cells):<\/span><\/p>\n

    \n
  • C\u1ed9t A: <\/span>Full_Name<\/span> (H\u1ecd v\u00e0 t\u00ean)<\/span><\/li>\n
  • C\u1ed9t B: <\/span>Phone<\/span> (S\u1ed1 \u0111i\u1ec7n tho\u1ea1i)<\/span><\/li>\n
  • C\u1ed9t C: <\/span>Email<\/span> (Email)<\/span><\/li>\n
  • C\u1ed9t D: <\/span>Project<\/span> (D\u1ef1 \u00e1n B\u0110S quan t\u00e2m)<\/span><\/li>\n
  • C\u1ed9t E: <\/span>Source<\/span> (Ngu\u1ed3n Lead: Facebook Ads, Google Ads, Tiktok…)<\/span><\/li>\n
  • C\u1ed9t F: <\/span>Created_At<\/span> (Th\u1eddi gian \u0111\u0103ng k\u00fd)<\/span><\/li>\n<\/ul>\n

    B\u01b0\u1edbc 2: T\u1ea1o Trigger ghi nh\u1eadn h\u00e0ng m\u1edbi (New Spreadsheet Row)<\/b><\/h3>\n

    Tr\u00ean c\u00f4ng c\u1ee5 k\u1ebft n\u1ed1i (Zapier\/Make) ho\u1eb7c Apps Script, thi\u1ebft l\u1eadp s\u1ef1 ki\u1ec7n k\u00edch ho\u1ea1t.<\/span><\/p>\n

      \n
    • Khi ch\u1ecdn s\u1ef1 ki\u1ec7n <\/span>New Spreadsheet Row<\/b>, h\u1ec7 th\u1ed1ng s\u1ebd li\u00ean t\u1ee5c l\u1eafng nghe v\u00e0 b\u1eaft tr\u1ecdn t\u1eebng d\u00f2ng d\u1eef li\u1ec7u ngay khi c\u00f3 kh\u00e1ch h\u00e0ng v\u1eeba ho\u00e0n t\u1ea5t \u0111i\u1ec1n form.<\/span><\/li>\n<\/ul>\n

      B\u01b0\u1edbc 3: Gh\u00e9p n\u1ed1i tr\u01b0\u1eddng d\u1eef li\u1ec7u (Field Mapping) sang CRM B\u0110S<\/b><\/h3>\n

      \u0110\u00e2y l\u00e0 b\u01b0\u1edbc quan tr\u1ecdng nh\u1ea5t quy\u1ebft \u0111\u1ecbnh d\u1eef li\u1ec7u c\u00f3 \u0111\u1ed5 v\u1ec1 \u0111\u00fang v\u1ecb tr\u00ed hay kh\u00f4ng. B\u1ea1n ti\u1ebfn h\u00e0nh map t\u1eebng tr\u01b0\u1eddng t\u01b0\u01a1ng \u1ee9ng:<\/span><\/p>\n

        \n
      • Gi\u00e1 tr\u1ecb c\u1ed9t <\/span>Full_Name<\/span> tr\u00ean Sheet <\/span> Tr\u01b0\u1eddng <\/span>T\u00ean kh\u00e1ch h\u00e0ng<\/span> tr\u00ean CRM.<\/span><\/li>\n
      • Gi\u00e1 tr\u1ecb c\u1ed9t <\/span>Phone<\/span> tr\u00ean Sheet <\/span> Tr\u01b0\u1eddng <\/span>S\u1ed1 \u0111i\u1ec7n tho\u1ea1i ch\u00ednh<\/span> tr\u00ean CRM.<\/span><\/li>\n
      • Gi\u00e1 tr\u1ecb c\u1ed9t <\/span>Project<\/span> tr\u00ean Sheet <\/span> Tr\u01b0\u1eddng <\/span>Nhu c\u1ea7u d\u1ef1 \u00e1n<\/span> tr\u00ean CRM.<\/span><\/li>\n<\/ul>\n

        B\u01b0\u1edbc 4: C\u1ea5u h\u00ecnh b\u1ed9 l\u1ecdc ch\u1ed1ng tr\u00f9ng l\u1eb7p Lead (De-duplication)<\/b><\/h3>\n

        \u0110\u1ec3 tr\u00e1nh t\u00ecnh tr\u1ea1ng 1 kh\u00e1ch h\u00e0ng \u0111\u0103ng k\u00fd nhi\u1ec1u l\u1ea7n t\u1ea1o ra v\u00f4 s\u1ed1 b\u1ea3n ghi r\u00e1c tr\u00ean CRM, b\u1ea1n c\u1ea7n thi\u1ebft l\u1eadp lu\u1eadt ch\u1ed1ng tr\u00f9ng theo <\/span>S\u1ed1 \u0111i\u1ec7n tho\u1ea1i<\/b>:<\/span><\/p>\n

          \n
        • N\u1ebfu S\u0110T \u0111\u00e3 t\u1ed3n t\u1ea1i tr\u00ean CRM:<\/b> Kh\u00f4ng t\u1ea1o m\u1edbi kh\u00e1ch h\u00e0ng m\u00e0 ch\u1ec9 c\u1eadp nh\u1eadt th\u00eam th\u00f4ng tin d\u1ef1 \u00e1n m\u1edbi v\u00e0o ph\u1ea7n Ghi ch\u00fa\/L\u1ecbch s\u1eed ch\u0103m s\u00f3c.<\/span><\/li>\n
        • N\u1ebfu S\u0110T ch\u01b0a t\u1ed3n t\u1ea1i:<\/b> T\u1ea1o m\u1edbi h\u1ed3 s\u01a1 kh\u00e1ch h\u00e0ng ti\u1ec1m n\u0103ng.<\/span><\/li>\n<\/ul>\n

          B\u01b0\u1edbc 5: K\u00edch ho\u1ea1t chia Lead t\u1ef1 \u0111\u1ed9ng cho Sales v\u00e0 Test v\u1eadn h\u00e0nh<\/b><\/h3>\n

          C\u1ea5u h\u00ecnh quy t\u1eafc chia lead tr\u00ean CRM (Chia xoay v\u00f2ng Round-Robin cho sale tr\u1ef1c ca, ho\u1eb7c chia theo khu v\u1ef1c \u0111\u1ecba l\u00fd). Sau \u0111\u00f3, h\u00e3y t\u1ef1 \u0111i\u1ec1n m\u1ed9t d\u1eef li\u1ec7u m\u1eabu tr\u00ean Google Sheet \u0111\u1ec3 ki\u1ec3m tra:<\/span><\/p>\n

            \n
          1. Data c\u00f3 nh\u1ea3y v\u1ec1 CRM trong d\u01b0\u1edbi 10 gi\u00e2y kh\u00f4ng?<\/span><\/li>\n
          2. Th\u00f4ng tin t\u00ean, S\u0110T, d\u1ef1 \u00e1n c\u00f3 hi\u1ec3n th\u1ecb ch\u00ednh x\u00e1c kh\u00f4ng?<\/span><\/li>\n
          3. Sale c\u00f3 nh\u1eadn \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o (b\u1eafn qua Zalo\/Telegram\/App CRM) hay kh\u00f4ng?<\/span><\/li>\n<\/ol>\n

            4. Chu\u1ea9n H\u00f3a D\u1eef Li\u1ec7u Google Sheet Tr\u01b0\u1edbc Khi \u0110\u1ed3ng B\u1ed9 \u0110\u1ec3 Tr\u00e1nh L\u1ed7i H\u1ec7 Th\u1ed1ng<\/b><\/h2>\n

            X\u1eed l\u00fd \u0111\u1ecbnh d\u1ea1ng S\u1ed1 \u0111i\u1ec7n tho\u1ea1i Vi\u1ec7t Nam (Tr\u00e1nh m\u1ea5t s\u1ed1 0 \u1edf \u0111\u1ea7u)<\/b><\/h3>\n

            M\u1eb7c \u0111\u1ecbnh Google Sheet s\u1ebd hi\u1ec3u d\u00e3y s\u1ed1 b\u1eaft \u0111\u1ea7u b\u1eb1ng <\/span>0<\/span> l\u00e0 \u0111\u1ecbnh d\u1ea1ng Number v\u00e0 t\u1ef1 \u0111\u1ed9ng x\u00f3a b\u1ecf s\u1ed1 0 (V\u00ed d\u1ee5: <\/span>0981234567<\/span> tr\u1edf th\u00e0nh <\/span>981234567<\/span>), d\u1eabn \u0111\u1ebfn vi\u1ec7c CRM t\u1eeb ch\u1ed1i nh\u1eadn data v\u00ec sai \u0111\u1ecbnh d\u1ea1ng S\u0110T.<\/span><\/p>\n

            C\u00e1ch x\u1eed l\u00fd:<\/b><\/p>\n

              \n
            • \u0110\u1ecbnh d\u1ea1ng to\u00e0n b\u1ed9 c\u1ed9t S\u1ed1 \u0111i\u1ec7n tho\u1ea1i th\u00e0nh <\/span>Plain Text (V\u0103n b\u1ea3n thu\u1ea7n t\u00fay)<\/b>.<\/span><\/li>\n
            • Ho\u1eb7c s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m t\u1ea1i c\u1ed9t ph\u1ee5: <\/span>=TEXT(A2, “0000000000”)<\/span> \u0111\u1ec3 \u00e9p d\u1eef li\u1ec7u v\u1ec1 \u0111\u00fang 10 ch\u1eef s\u1ed1 tr\u01b0\u1edbc khi \u0111\u1ea9y sang CRM.<\/span><\/li>\n<\/ul>\n

              Ph\u00e2n lo\u1ea1i Ngu\u1ed3n Lead r\u00f5 r\u00e0ng<\/b><\/h3>\n

              \u0110\u1eebng gom chung t\u1ea5t c\u1ea3 data v\u00e0o m\u1ed9t ngu\u1ed3n duy nh\u1ea5t. H\u00e3y g\u1eafn gi\u00e1 tr\u1ecb ngu\u1ed3n c\u1ee5 th\u1ec3 tr\u00ean Sheet (v\u00ed d\u1ee5: <\/span>FB_Ads_Duan_Vinhomes<\/span>, <\/span>GG_Search_DatNen_LongAn<\/span>). Nh\u1edd \u0111\u00f3, khi data sang CRM, b\u1ed9 ph\u1eadn Marketing c\u00f3 th\u1ec3 \u0111o l\u01b0\u1eddng ch\u00ednh x\u00e1c chi ph\u00ed tr\u00ean t\u1eebng h\u1ee3p \u0111\u1ed3ng B\u0110S ch\u1ed1t th\u00e0nh c\u00f4ng t\u1eeb t\u1eebng k\u00eanh.<\/span><\/p>\n

              G\u00e1n Tag d\u1ef1 \u00e1n B\u0110S t\u1ef1 \u0111\u1ed9ng<\/b><\/h3>\n

              \u0110\u1ed1i v\u1edbi c\u00e1c s\u00e0n B\u0110S ph\u00e2n ph\u1ed1i nhi\u1ec1u d\u1ef1 \u00e1n c\u00f9ng l\u00fac, vi\u1ec7c g\u1eafn Tag t\u1ef1 \u0111\u1ed9ng (nh\u01b0 <\/span>#CanHoCaoCap<\/span>, <\/span>#BiethuBien<\/span>, <\/span>#PhanKhuc2To5Ty<\/span>) ngay t\u1eeb Google Sheet s\u1ebd gi\u00fap h\u1ec7 th\u1ed1ng CRM t\u1ef1 \u0111\u1ed9ng g\u00e1n d\u1eef li\u1ec7u cho \u0111\u00fang nh\u00f3m Sale chuy\u00ean tr\u00e1ch d\u1ef1 \u00e1n \u0111\u00f3.<\/span><\/p>\n

              5. X\u1eed L\u00fd C\u00e1c S\u1ef1 C\u1ed1 Th\u01b0\u1eddng G\u1eb7p Khi \u0110\u1ed3ng B\u1ed9 D\u1eef Li\u1ec7u B\u0110S<\/b><\/h2>\n
                \n
              • Lead v\u1ec1 CRM b\u1ecb ch\u1eadm ho\u1eb7c s\u00f3t b\u1ea3n ghi:<\/b> Nguy\u00ean nh\u00e2n th\u01b0\u1eddng do v\u01b0\u1ee3t qu\u00e1 h\u1ea1n ng\u1ea1ch (Quota API) c\u1ee7a Google ho\u1eb7c g\u00f3i Zapier\/Make b\u1ecb h\u1ebft l\u01b0\u1ee3t ch\u1ea1y (Tasks). H\u00e3y ki\u1ec3m tra l\u1ea1i nh\u1eadt k\u00fd l\u1ecbch s\u1eed (Log) c\u1ee7a c\u00f4ng c\u1ee5 k\u1ebft n\u1ed1i.<\/span><\/li>\n
              • Xung \u0111\u1ed9t d\u1eef li\u1ec7u khi nhi\u1ec1u Sale c\u00f9ng c\u1eadp nh\u1eadt:<\/b> N\u1ebfu 2 nh\u00e2n vi\u00ean c\u00f9ng ch\u0103m s\u00f3c 1 lead t\u1eeb 2 ngu\u1ed3n kh\u00e1c nhau \u0111\u1ed5 v\u1ec1, h\u00e3y c\u00e0i \u0111\u1eb7t quy\u1ec1n \u01b0u ti\u00ean tr\u00ean CRM: Lead thu\u1ed9c v\u1ec1 ng\u01b0\u1eddi \u0111\u1ea7u ti\u00ean li\u00ean h\u1ec7 th\u00e0nh c\u00f4ng.<\/span><\/li>\n
              • L\u1ed7i m\u1ea5t k\u1ebft n\u1ed1i Token Google Account:<\/b> Sau m\u1ed9t th\u1eddi gian, quy\u1ec1n OAuth 2.0 gi\u1eefa Google Sheet v\u00e0 c\u00f4ng c\u1ee5 CRM c\u00f3 th\u1ec3 b\u1ecb h\u1ebft h\u1ea1n. C\u1ea7n ti\u1ebfn h\u00e0nh Re-connect (k\u1ebft n\u1ed1i l\u1ea1i t\u00e0i kho\u1ea3n) \u0111\u1ec3 lu\u1ed3ng t\u1ef1 \u0111\u1ed9ng ti\u1ebfp t\u1ee5c ho\u1ea1t \u0111\u1ed9ng.<\/span><\/li>\n<\/ul>\n

                FAQ \u2013 C\u00e2u H\u1ecfi Th\u01b0\u1eddng G\u1eb7p<\/b><\/h2>\n
                  \n
                1. \u0110\u1ed3ng b\u1ed9 Data t\u1eeb Google Sheet v\u00e0o CRM B\u0110S c\u00f3 m\u1ea5t ph\u00ed kh\u00f4ng?<\/b><\/li>\n<\/ol>\n

                  B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n <\/span>ho\u00e0n to\u00e0n mi\u1ec5n ph\u00ed<\/b> n\u1ebfu \u00e1p d\u1ee5ng c\u00e1ch vi\u1ebft m\u00e3 Google Apps Script k\u1ebft n\u1ed1i Webhook API c\u1ee7a CRM, ho\u1eb7c s\u1eed d\u1ee5ng c\u00e1c CRM B\u0110S c\u00f3 t\u00edch h\u1ee3p s\u1eb5n t\u00ednh n\u0103ng k\u1ebft n\u1ed1i Google Sheets. Chi ph\u00ed ch\u1ec9 ph\u00e1t sinh khi b\u1ea1n d\u00f9ng c\u00e1c n\u1ec1n t\u1ea3ng trung gian b\u00ean th\u1ee9 3 (nh\u01b0 Zapier\/Make) \u1edf m\u1ee9c dung l\u01b0\u1ee3ng l\u1edbn.<\/span><\/p>\n

                    \n
                  1. C\u00f3 th\u1ec3 \u0111\u1ed3ng b\u1ed9 ng\u01b0\u1ee3c d\u1eef li\u1ec7u t\u1eeb CRM B\u0110S v\u1ec1 l\u1ea1i Google Sheet kh\u00f4ng?<\/b><\/li>\n<\/ol>\n

                    C\u00f3.<\/b> Quy tr\u00ecnh \u0111\u1ed3ng b\u1ed9 2 chi\u1ec1u (Bi-directional sync) cho ph\u00e9p d\u1eef li\u1ec7u c\u1eadp nh\u1eadt tr\u1ea1ng th\u00e1i tr\u00ean CRM (\u0110\u00e3 nghe m\u00e1y, \u0110\u00e3 \u0111i xem nh\u00e0, \u0110\u00e3 \u0111\u1eb7t c\u1ecdc) t\u1ef1 \u0111\u1ed9ng \u0111\u1ea9y ng\u01b0\u1ee3c v\u1ec1 Google Sheet \u0111\u1ec3 ph\u1ee5c v\u1ee5 l\u00e0m b\u00e1o c\u00e1o dashboard tr\u1ef1c quan.<\/span><\/p>\n

                      \n
                    1. CRM B\u0110S n\u00e0o h\u1ed7 tr\u1ee3 k\u1ebft n\u1ed1i Google Sheet t\u1ed1t nh\u1ea5t hi\u1ec7n nay?<\/b><\/li>\n<\/ol>\n

                      H\u1ea7u h\u1ebft c\u00e1c ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd B\u0110S l\u1edbn t\u1ea1i Vi\u1ec7t Nam nh\u01b0 Getfly CRM, Pancake CRM, MISA AMIS, SlimCRM hay Salesforce\/HubSpot \u0111\u1ec1u h\u1ed7 tr\u1ee3 c\u1ed5ng API m\u1edf v\u00e0 t\u00edch h\u1ee3p s\u1eb5n t\u00ednh n\u0103ng \u0111\u1ed3ng b\u1ed9 v\u1edbi Google Sheets.<\/span><\/p>\n

                       <\/p>\n","protected":false},"excerpt":{"rendered":"

                      Trong ng\u00e0nh b\u1ea5t \u0111\u1ed9ng s\u1ea3n (B\u0110S), t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd data kh\u00e1ch h\u00e0ng quy\u1ebft \u0111\u1ecbnh \u0111\u1ebfn 80% t\u1ef7 l\u1ec7 ch\u1ed1t h\u1eb9n th\u00e0nh c\u00f4ng. Tuy nhi\u00ean, nhi\u1ec1u doanh nghi\u1ec7p… <\/p>\n","protected":false},"author":1,"featured_media":40512,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-40493","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\/40493","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=40493"}],"version-history":[{"count":3,"href":"https:\/\/meeycrm.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/40493\/revisions"}],"predecessor-version":[{"id":40514,"href":"https:\/\/meeycrm.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/40493\/revisions\/40514"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/meeycrm.com\/tin-tuc\/wp-json\/wp\/v2\/media\/40512"}],"wp:attachment":[{"href":"https:\/\/meeycrm.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=40493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meeycrm.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=40493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meeycrm.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=40493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}