{"id":6050,"date":"2025-03-27T09:17:21","date_gmt":"2025-03-27T00:17:21","guid":{"rendered":"https:\/\/cooss.net\/tu-dong-hoa-tung-dong-google-sheets-tren-make-com-vi\/"},"modified":"2025-03-27T12:40:49","modified_gmt":"2025-03-27T03:40:49","slug":"tu-dong-hoa-tung-dong-google-sheets-tren-make-com-vi","status":"publish","type":"post","link":"https:\/\/cooss.net\/vi\/tu-dong-hoa-tung-dong-google-sheets-tren-make-com-vi\/","title":{"rendered":"T\u1ef1 \u0111\u1ed9ng h\u00f3a Google Sheets t\u1eebng d\u00f2ng tr\u00ean Make.com"},"content":{"rendered":"\n<p>B\u1ea1n c\u00f3 k\u1ebf ho\u1ea1ch t\u1ef1 \u0111\u1ed9ng h\u00f3a d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Google Sheets v\u00e0 <a href=\"https:\/\/www.make.com\/en\/register?pc=cooss\" target=\"_blank\" rel=\"noopener\">Make.com<\/a> kh\u00f4ng?<\/p>\n\n\n\n<p>N\u1ebfu b\u1ea1n ch\u1ec9 \u0111\u1ecdc v\u00e0 x\u1eed l\u00fd m\u1ed9t d\u00f2ng m\u1ed7i l\u1ea7n th\u1ef1c hi\u1ec7n, b\u1ea1n c\u00f3 th\u1ec3 gi\u1ea3m thi\u1ec3u sai s\u00f3t trong c\u00f4ng vi\u1ec7c t\u1ef1 \u0111\u1ed9ng h\u00f3a v\u00e0 n\u00e2ng cao hi\u1ec7u qu\u1ea3. T\u00f4i s\u1ebd cho b\u1ea1n bi\u1ebft v\u1ec1 ph\u01b0\u01a1ng ph\u00e1p n\u00e0y.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">X\u1eed l\u00fd ch\u1ec9 m\u1ed9t d\u00f2ng c\u1ee7a Google Sheets tr\u00ean Make.com<\/h2>\n\n\n\n<p>C\u00f3 nhi\u1ec1u c\u00e1ch \u0111\u1ec3 l\u1ea5y m\u1ed9t h\u00e0ng c\u1ee5 th\u1ec3 t\u1eeb Google Sheets tr\u00ean <a href=\"https:\/\/www.make.com\/en\/register?pc=cooss\" target=\"_blank\" rel=\"noopener\">Make.com<\/a>, nh\u01b0ng b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng thi\u1ebft l\u1eadp theo c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Chu\u1ea9n b\u1ecb Google Sheets<\/h3>\n\n\n\n<p>Tr\u01b0\u1edbc ti\u00ean, b\u1ea1n c\u1ea7n t\u1ea1o m\u1ed9t Google Sheets.<\/p>\n\n\n\n<p>Trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a t\u00f4i, t\u00f4i \u0111\u00e3 s\u1eafp x\u1ebfp nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y v\u1edbi c\u00e1c c\u1ed9t bao g\u1ed3m ch\u1ee7 \u0111\u1ec1, \u0111\u1ecba ch\u1ec9 b\u00e0i vi\u1ebft Google Doc, v\u00e0 c\u1ed9t cho bi\u1ebft li\u1ec7u c\u00f4ng vi\u1ec7c vi\u1ebft \u0111\u00e3 ho\u00e0n t\u1ea5t hay ch\u01b0a. T\u00f4i \u0111\u00e3 t\u1ed5 ch\u1ee9c n\u1ed9i dung b\u00e0i vi\u1ebft trong Google Doc v\u00e0 d\u1ef1 \u0111\u1ecbnh t\u00f3m t\u1eaft n\u1ed9i dung \u0111\u00f3 \u0111\u1ec3 t\u1ea1o m\u1ed9t b\u1ea3n nh\u00e1p b\u00e0i vi\u1ebft tr\u00ean blog. Khi vi\u1ec7c vi\u1ebft ho\u00e0n t\u1ea5t, t\u00f4i s\u1ebd ghi l\u1ea1i \u0111\u1ecba ch\u1ec9 c\u1ee7a b\u00e0i vi\u1ebft, ghi ng\u00e0y \u0111\u0103ng b\u00e0i, v\u00e0 \u0111\u00e1nh d\u1ea5u &#8216;Y&#8217; \u0111\u1ec3 ph\u00e2n bi\u1ec7t vi\u1ec7c \u0111\u00e3 ho\u00e0n t\u1ea5t \u0111\u0103ng b\u00e0i.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"156\" src=\"https:\/\/cooss.net\/wp-content\/uploads\/2025\/03\/image-9-1024x156.png\" alt=\"\" class=\"wp-image-6004\" title=\"\" srcset=\"https:\/\/cooss.net\/wp-content\/uploads\/2025\/03\/image-9-1024x156.png 1024w, https:\/\/cooss.net\/wp-content\/uploads\/2025\/03\/image-9-300x46.png 300w, https:\/\/cooss.net\/wp-content\/uploads\/2025\/03\/image-9-768x117.png 768w, https:\/\/cooss.net\/wp-content\/uploads\/2025\/03\/image-9-600x91.png 600w, https:\/\/cooss.net\/wp-content\/uploads\/2025\/03\/image-9.png 1456w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Ph\u01b0\u01a1ng ph\u00e1p 1: C\u00e0i \u0111\u1eb7t &#8220;Search Rows&#8221; v\u00e0 &#8220;Limit&#8221;<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">1. **Th\u00eam m\u00f4-\u0111un Google Sheets**<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ch\u1ecdn m\u00f4-\u0111un &#8220;Search Rows&#8221; t\u1eeb &#8220;Google Sheets&#8221;.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Trong Filter, t\u00ecm ki\u1ebfm c\u00e1c h\u00e0ng m\u00e0 c\u1ed9t &#8216;\u0110\u00e3 ho\u00e0n t\u1ea5t \u0111\u0103ng b\u00e0i&#8217; kh\u00f4ng ph\u1ea3i l\u00e0 &#8216;Y&#8217;.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0110\u1eb7t gi\u00e1 tr\u1ecb &#8216;Limit&#8217; l\u00e0 1. \u0110i\u1ec1u n\u00e0y s\u1ebd l\u1ea5y m\u1ed9t d\u00f2ng m\u1ed7i l\u1ea7n th\u1ef1c hi\u1ec7n.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"403\" height=\"560\" src=\"https:\/\/cooss.net\/wp-content\/uploads\/2025\/03\/image-10.png\" alt=\"\" class=\"wp-image-6010\" title=\"\" srcset=\"https:\/\/cooss.net\/wp-content\/uploads\/2025\/03\/image-10.png 403w, https:\/\/cooss.net\/wp-content\/uploads\/2025\/03\/image-10-216x300.png 216w\" sizes=\"(max-width: 403px) 100vw, 403px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"397\" height=\"650\" src=\"https:\/\/cooss.net\/wp-content\/uploads\/2025\/03\/image-11.png\" alt=\"\" class=\"wp-image-6016\" title=\"\" srcset=\"https:\/\/cooss.net\/wp-content\/uploads\/2025\/03\/image-11.png 397w, https:\/\/cooss.net\/wp-content\/uploads\/2025\/03\/image-11-183x300.png 183w\" sizes=\"(max-width: 397px) 100vw, 397px\" \/><\/figure>\n<\/div>\n<\/div>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">2. **K\u1ebft n\u1ed1i m\u00f4-\u0111un x\u1eed l\u00fd ti\u1ebfp theo**<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>K\u1ebft n\u1ed1i v\u1edbi m\u00f4-\u0111un kh\u00e1c \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u \u0111\u00e3 l\u1ea5y (v\u00ed d\u1ee5: g\u1eedi email, nh\u1eadp v\u00e0o c\u01a1 s\u1edf d\u1eef li\u1ec7u, v.v.).<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a t\u00f4i, \u0111\u1ec3 tr\u00e1nh l\u1eb7p l\u1ea1i b\u00e0i vi\u1ebft gi\u1ed1ng nhau khi c\u00f3 l\u1ed7i x\u1ea3y ra trong qu\u00e1 tr\u00ecnh ho\u1ea1t \u0111\u1ed9ng, t\u00f4i \u0111\u00e3 ch\u1ecdn m\u00f4-\u0111un &#8216;Update Row&#8217; trong Google Sheets \u0111\u1ec3 ghi gi\u00e1 tr\u1ecb &#8216;\u0110\u00e3 ho\u00e0n t\u1ea5t \u0111\u0103ng b\u00e0i&#8217; l\u00e0 &#8216;Y&#8217;.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"977\" height=\"658\" src=\"https:\/\/cooss.net\/wp-content\/uploads\/2025\/03\/image-13.png\" alt=\"\" class=\"wp-image-6028\" title=\"\" srcset=\"https:\/\/cooss.net\/wp-content\/uploads\/2025\/03\/image-13.png 977w, https:\/\/cooss.net\/wp-content\/uploads\/2025\/03\/image-13-300x202.png 300w, https:\/\/cooss.net\/wp-content\/uploads\/2025\/03\/image-13-768x517.png 768w, https:\/\/cooss.net\/wp-content\/uploads\/2025\/03\/image-13-600x404.png 600w\" sizes=\"(max-width: 977px) 100vw, 977px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Nh\u01b0 b\u1ea1n th\u1ea5y trong h\u00ecnh, khi b\u1ea1n nh\u1ea5p chu\u1ed9t v\u00e0o tr\u01b0\u1eddng \u0111\u1ea7u v\u00e0o c\u1ee7a b\u01b0\u1edbc ti\u1ebfp theo, m\u1ed9t h\u1ed9p pop-up s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n ch\u1ecdn gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t n\u00e0o trong Google Sheets m\u00e0 b\u1ea1n \u0111\u00e3 ch\u1ec9 \u0111\u1ecbnh \u1edf b\u01b0\u1edbc tr\u01b0\u1edbc.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0110\u1eb7t s\u1ed1 h\u00e0ng v\u00e0o &#8216;Row Number&#8217; m\u00e0 b\u1ea1n \u0111\u00e3 ch\u1ecdn \u1edf b\u01b0\u1edbc tr\u01b0\u1edbc.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>B\u1eb1ng c\u00e1ch ghi gi\u00e1 tr\u1ecb &#8216;Y&#8217; v\u00e0o &#8216;Values&#8217;, l\u1ea7n th\u1ef1c hi\u1ec7n ti\u1ebfp theo s\u1ebd ch\u1ecdn h\u00e0ng ti\u1ebfp theo.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Ph\u01b0\u01a1ng ph\u00e1p 2: S\u1eed d\u1ee5ng &#8220;Get a Cell&#8221; \u0111\u1ec3 \u0111\u1ecdc d\u00f2ng c\u1ee5 th\u1ec3<\/h3>\n\n\n\n<p>T\u00f4i th\u00edch &#8216;Ph\u01b0\u01a1ng ph\u00e1p 1&#8217;, nh\u01b0ng c\u0169ng c\u00f3 ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c m\u00e0 t\u00f4i s\u1ebd gi\u1edbi thi\u1ec7u ng\u1eafn g\u1ecdn.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">1. **Th\u00eam m\u00f4-\u0111un Google Sheets**<\/h4>\n\n\n\n<p>&#8211; S\u1eed d\u1ee5ng m\u00f4-\u0111un &#8220;Get a Cell&#8221; t\u1eeb &#8220;Google Sheets&#8221;.<br>&#8211; Ch\u1ec9 \u0111\u1ecbnh tr\u1ef1c ti\u1ebfp h\u00e0ng (Row) v\u00e0 c\u1ed9t (Column) m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">2. **Th\u00eam logic t\u0103ng s\u1ed1 h\u00e0ng**<\/h4>\n\n\n\n<p>&#8211; \u0110\u1ec3 \u0111\u1ecdc d\u00f2ng m\u1edbi trong l\u1ea7n th\u1ef1c hi\u1ec7n ti\u1ebfp theo, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng &#8216;Helper Sheet&#8217; trong Google Sheets.<br>&#8211; Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng bi\u1ebfn l\u01b0u tr\u1eef (Variable) b\u00ean trong <a href=\"https:\/\/www.make.com\/en\/register?pc=cooss\" target=\"_blank\" rel=\"noopener\">Make<\/a> \u0111\u1ec3 t\u0103ng s\u1ed1 h\u00e0ng c\u1ea7n \u0111\u1ecdc b\u1eb1ng m\u00f4-\u0111un &#8220;Update a Cell&#8221;.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Ph\u01b0\u01a1ng ph\u00e1p 3: S\u1eed d\u1ee5ng m\u00f4-\u0111un &#8220;Watch Rows&#8221;<\/h3>\n\n\n\n<p>&#8211; M\u00f4-\u0111un n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t khi c\u00f3 h\u00e0ng m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o, v\u00ec v\u1eady n\u00f3 kh\u00f4ng ph\u00f9 h\u1ee3p cho vi\u1ec7c x\u1eed l\u00fd t\u1eebng d\u1eef li\u1ec7u hi\u1ec7n c\u00f3. Tuy nhi\u00ean, n\u00f3 r\u1ea5t h\u1eefu \u00edch khi c\u1ea7n c\u1eadp nh\u1eadt theo th\u1eddi gian th\u1ef1c.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>B\u1ea1n c\u00f3 k\u1ebf ho\u1ea1ch t\u1ef1 \u0111\u1ed9ng h\u00f3a d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Google Sheets v\u00e0 Make.com kh\u00f4ng? N\u1ebfu b\u1ea1n ch\u1ec9 \u0111\u1ecdc v\u00e0 x\u1eed l\u00fd m\u1ed9t d\u00f2ng m\u1ed7i l\u1ea7n th\u1ef1c hi\u1ec7n, b\u1ea1n c\u00f3 th\u1ec3 gi\u1ea3m thi\u1ec3u sai s\u00f3t trong c\u00f4ng vi\u1ec7c t\u1ef1 \u0111\u1ed9ng h\u00f3a v\u00e0 n\u00e2ng cao hi\u1ec7u qu\u1ea3. T\u00f4i s\u1ebd cho b\u1ea1n bi\u1ebft v\u1ec1 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[162],"tags":[],"class_list":["post-6050","post","type-post","status-publish","format-standard","hentry","category-marketing-automation-vi"],"_links":{"self":[{"href":"https:\/\/cooss.net\/vi\/wp-json\/wp\/v2\/posts\/6050","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cooss.net\/vi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cooss.net\/vi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cooss.net\/vi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cooss.net\/vi\/wp-json\/wp\/v2\/comments?post=6050"}],"version-history":[{"count":1,"href":"https:\/\/cooss.net\/vi\/wp-json\/wp\/v2\/posts\/6050\/revisions"}],"predecessor-version":[{"id":6113,"href":"https:\/\/cooss.net\/vi\/wp-json\/wp\/v2\/posts\/6050\/revisions\/6113"}],"wp:attachment":[{"href":"https:\/\/cooss.net\/vi\/wp-json\/wp\/v2\/media?parent=6050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cooss.net\/vi\/wp-json\/wp\/v2\/categories?post=6050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cooss.net\/vi\/wp-json\/wp\/v2\/tags?post=6050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}