{"id":119270,"date":"2025-09-18T16:25:40","date_gmt":"2025-09-18T09:25:40","guid":{"rendered":"https:\/\/tino.vn\/blog\/?p=119270"},"modified":"2025-09-22T18:40:55","modified_gmt":"2025-09-22T11:40:55","slug":"sua-loi-tich-hop-google-sheet-drive-voi-n8n","status":"publish","type":"post","link":"https:\/\/tino.vn\/blog\/sua-loi-tich-hop-google-sheet-drive-voi-n8n\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eeda l\u1ed7i t\u00edch h\u1ee3p Google Sheet\/Drive v\u1edbi n8n hi\u1ec7u qu\u1ea3"},"content":{"rendered":"\n<p><strong>Trong th\u1eddi \u0111\u1ea1i t\u1ef1 \u0111\u1ed9ng h\u00f3a, Google Sheet v\u00e0 Google Drive g\u1ea7n nh\u01b0 l\u00e0 \u201cx\u01b0\u01a1ng s\u1ed1ng\u201d trong vi\u1ec7c l\u01b0u tr\u1eef v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u. Khi k\u1ebft h\u1ee3p c\u00f9ng n8n, ch\u00fang tr\u1edf th\u00e0nh c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 x\u00e2y d\u1ef1ng quy tr\u00ecnh l\u00e0m vi\u1ec7c th\u00f4ng minh, ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 h\u1ea1n ch\u1ebf sai s\u00f3t. Tuy nhi\u00ean, kh\u00f4ng \u00edt ng\u01b0\u1eddi d\u00f9ng g\u1eb7p l\u1ed7i khi t\u00edch h\u1ee3p Google Sheet\/Drive v\u1edbi n\u1ec1n t\u1ea3ng n\u00e0y. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eeda l\u1ed7i t\u00edch h\u1ee3p Google Sheet\/Drive v\u1edbi n8n<\/strong> <strong>hi\u1ec7u qu\u1ea3<\/strong><\/p>\n\n\n\n<h2 id=\"C\u00e1c_t\u00ecnh_hu\u1ed1ng_\u1ee9ng_d\u1ee5ng_Google_Sheet\/Drive_ph\u1ed5_bi\u1ebfn_trong_n8n\"><a id=\"post-119270-_bbfvu75dawx1\"><\/a>C\u00e1c t\u00ecnh hu\u1ed1ng \u1ee9ng d\u1ee5ng Google Sheet\/Drive ph\u1ed5 bi\u1ebfn trong n8n<\/h2>\n\n\n\n<h3 id=\"\u1ee8ng_d\u1ee5ng_c\u1ee7a_Google_Sheets_trong_n8n\"><a id=\"post-119270-_zacoukwsyahn\"><\/a><strong>\u1ee8ng d\u1ee5ng c\u1ee7a Google Sheets trong n8n<\/strong><\/h3>\n\n\n\n<h4 id=\"L\u01b0u_tr\u1eef_d\u1eef_li\u1ec7u_t\u1eeb_c\u00e1c_ngu\u1ed3n_kh\u00e1c_nhau_(data_logging)\"><a id=\"post-119270-_w9horc9zwcx0\"><\/a>L\u01b0u tr\u1eef d\u1eef li\u1ec7u t\u1eeb c\u00e1c ngu\u1ed3n kh\u00e1c nhau (data logging)<\/h4>\n\n\n\n<p>n8n ho\u1ea1t \u0111\u1ed9ng nh\u01b0 m\u1ed9t c\u1ea7u n\u1ed1i, thu th\u1eadp d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u n\u01a1i v\u00e0 ghi v\u00e0o Google Sheets.<\/p>\n\n\n\n<p>V\u00ed d\u1ee5:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Thu th\u1eadp lead t\u1eeb Form: <\/strong>T\u1ef1 \u0111\u1ed9ng l\u01b0u th\u00f4ng tin kh\u00e1ch h\u00e0ng ti\u1ec1m n\u0103ng t\u1eeb Facebook Lead Ads, Google Forms, Typeform, ho\u1eb7c website form v\u00e0o m\u1ed9t trang t\u00ednh Google Sheets.<\/li>\n\n\n\n<li><strong>Theo d\u00f5i \u0111\u01a1n h\u00e0ng:<\/strong> M\u1ed7i khi c\u00f3 \u0111\u01a1n h\u00e0ng m\u1edbi tr\u00ean Shopify, WooCommerce, ho\u1eb7c c\u00e1c s\u00e0n th\u01b0\u01a1ng m\u1ea1i \u0111i\u1ec7n t\u1eed, t\u1ef1 \u0111\u1ed9ng th\u00eam m\u1ed9t d\u00f2ng m\u1edbi v\u00e0o Google Sheets v\u1edbi th\u00f4ng tin chi ti\u1ebft (m\u00e3 \u0111\u01a1n, s\u1ea3n ph\u1ea9m, kh\u00e1ch h\u00e0ng, gi\u00e1 ti\u1ec1n).<\/li>\n\n\n\n<li><strong>L\u01b0u tr\u1eef d\u1eef li\u1ec7u t\u1eeb m\u1ea1ng x\u00e3 h\u1ed9i: <\/strong>T\u1ef1 \u0111\u1ed9ng l\u01b0u l\u1ea1i c\u00e1c b\u00e0i \u0111\u0103ng c\u00f3 ch\u1ee9a hashtag nh\u1ea5t \u0111\u1ecbnh t\u1eeb Twitter, ho\u1eb7c c\u00e1c b\u00ecnh lu\u1eadn m\u1edbi tr\u00ean m\u1ed9t b\u00e0i post Facebook v\u00e0o Google Sheets \u0111\u1ec3 ph\u00e2n t\u00edch.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"700\" height=\"375\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/loi-tich-hop-google-sheet-drive-voi-n8n-1.png\" alt=\"\u1ee8ng d\u1ee5ng Google Sheets trong n8n\" class=\"wp-image-119280\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/loi-tich-hop-google-sheet-drive-voi-n8n-1.png 700w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/loi-tich-hop-google-sheet-drive-voi-n8n-1-300x161.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><figcaption class=\"wp-element-caption\"><strong>\u1ee8ng d\u1ee5ng Google Sheets trong n8n<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<h4 id=\"L\u00e0m_ngu\u1ed3n_d\u1eef_li\u1ec7u_\u0111\u1ea7u_v\u00e0o_(data_source)\"><a id=\"post-119270-_j4wxwcmbf4n5\"><\/a>L\u00e0m ngu\u1ed3n d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o (data source)<\/h4>\n\n\n\n<p>n8n c\u00f3 th\u1ec3 \u0111\u1ecdc d\u1eef li\u1ec7u t\u1eeb m\u1ed9t trang t\u00ednh Google Sheets \u0111\u1ec3 k\u00edch ho\u1ea1t ho\u1eb7c cung c\u1ea5p th\u00f4ng tin cho c\u00e1c b\u01b0\u1edbc ti\u1ebfp theo trong workflow.<\/p>\n\n\n\n<p>V\u00ed d\u1ee5:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>G\u1eedi email h\u00e0ng lo\u1ea1t: <\/strong>\u0110\u1ecdc danh s\u00e1ch email v\u00e0 t\u00ean kh\u00e1ch h\u00e0ng t\u1eeb m\u1ed9t file Google Sheets, sau \u0111\u00f3 s\u1eed d\u1ee5ng Node Send Email ho\u1eb7c Gmail \u0111\u1ec3 g\u1eedi email marketing c\u00e1 nh\u00e2n h\u00f3a.<\/li>\n\n\n\n<li><strong>T\u1ea1o b\u00e1o gi\u00e1 t\u1ef1 \u0111\u1ed9ng: <\/strong>L\u1ea5y th\u00f4ng tin s\u1ea3n ph\u1ea9m (t\u00ean, gi\u00e1, s\u1ed1 l\u01b0\u1ee3ng) t\u1eeb m\u1ed9t trang t\u00ednh, sau \u0111\u00f3 d\u00f9ng d\u1eef li\u1ec7u n\u00e0y \u0111\u1ec3 \u0111i\u1ec1n v\u00e0o m\u1ed9t m\u1eabu b\u00e1o gi\u00e1 v\u00e0 g\u1eedi cho kh\u00e1ch h\u00e0ng.<\/li>\n\n\n\n<li><strong>\u0110\u1ed3ng b\u1ed9 h\u00f3a danh b\u1ea1: <\/strong>\u0110\u1ecdc danh s\u00e1ch li\u00ean h\u1ec7 t\u1eeb Google Sheets v\u00e0 t\u1ef1 \u0111\u1ed9ng th\u00eam ho\u1eb7c c\u1eadp nh\u1eadt v\u00e0o h\u1ec7 th\u1ed1ng CRM (nh\u01b0 HubSpot, Salesforce).<\/li>\n<\/ul>\n\n\n\n<h4 id=\"C\u1eadp_nh\u1eadt_tr\u1ea1ng_th\u00e1i_c\u00f4ng_vi\u1ec7c_(status_tracking)\"><a id=\"post-119270-_kkujuwowzjxj\"><\/a>C\u1eadp nh\u1eadt tr\u1ea1ng th\u00e1i c\u00f4ng vi\u1ec7c (status tracking)<\/h4>\n\n\n\n<p>S\u1eed d\u1ee5ng Google Sheets nh\u01b0 m\u1ed9t b\u1ea3ng theo d\u00f5i tr\u1ea1ng th\u00e1i v\u00e0 n8n s\u1ebd c\u1eadp nh\u1eadt th\u00f4ng tin theo th\u1eddi gian th\u1ef1c.<\/p>\n\n\n\n<p>V\u00ed d\u1ee5:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Qu\u1ea3n l\u00fd quy tr\u00ecnh tuy\u1ec3n d\u1ee5ng: <\/strong>Khi m\u1ed9t \u1ee9ng vi\u00ean \u0111\u01b0\u1ee3c chuy\u1ec3n sang v\u00f2ng ph\u1ecfng v\u1ea5n tr\u00ean h\u1ec7 th\u1ed1ng (v\u00ed d\u1ee5: Notion, Trello), n8n s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00ecm \u0111\u1ebfn d\u00f2ng ch\u1ee9a th\u00f4ng tin \u1ee9ng vi\u00ean \u0111\u00f3 trong Google Sheets v\u00e0 c\u1eadp nh\u1eadt c\u1ed9t &#8220;Tr\u1ea1ng th\u00e1i&#8221; th\u00e0nh &#8220;\u0110\u00e3 ph\u1ecfng v\u1ea5n&#8221;.<\/li>\n\n\n\n<li><strong>Theo d\u00f5i x\u1eed l\u00fd y\u00eau c\u1ea7u kh\u00e1ch h\u00e0ng: <\/strong>Khi m\u1ed9t ticket h\u1ed7 tr\u1ee3 tr\u00ean <a href=\"https:\/\/www.zendesk.com\/\" target=\"_blank\" data-type=\"link\" data-id=\"https:\/\/www.zendesk.com\/\" rel=\"noreferrer noopener nofollow\">Zendesk<\/a> ho\u1eb7c Freshdesk \u0111\u01b0\u1ee3c \u0111\u00f3ng, n8n s\u1ebd c\u1eadp nh\u1eadt tr\u1ea1ng th\u00e1i c\u1ee7a ticket t\u01b0\u01a1ng \u1ee9ng trong Google Sheets.<\/li>\n<\/ul>\n\n\n\n<h4 id=\"X\u00e2y_d\u1ef1ng_b\u00e1o_c\u00e1o_\u0111\u01a1n_gi\u1ea3n_(simple_reporting)\"><a id=\"post-119270-_b5quo2wydr8v\"><\/a>X\u00e2y d\u1ef1ng b\u00e1o c\u00e1o \u0111\u01a1n gi\u1ea3n (simple reporting)<\/h4>\n\n\n\n<p>T\u1ef1 \u0111\u1ed9ng t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u v\u00e0 t\u1ea1o ra c\u00e1c b\u00e1o c\u00e1o c\u01a1 b\u1ea3n ngay tr\u00ean Google Sheets.<\/p>\n\n\n\n<p>V\u00ed d\u1ee5:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>B\u00e1o c\u00e1o kinh doanh h\u00e0ng ng\u00e0y:<\/strong> M\u1ed7i cu\u1ed1i ng\u00e0y, n8n t\u1ef1 \u0111\u1ed9ng l\u1ea5y d\u1eef li\u1ec7u b\u00e1n h\u00e0ng t\u1eeb h\u1ec7 th\u1ed1ng, t\u00ednh t\u1ed5ng doanh thu, s\u1ed1 \u0111\u01a1n h\u00e0ng, sau \u0111\u00f3 ghi k\u1ebft qu\u1ea3 v\u00e0o m\u1ed9t trang t\u00ednh b\u00e1o c\u00e1o t\u1ed5ng h\u1ee3p.<\/li>\n\n\n\n<li><strong>T\u1ed5ng h\u1ee3p hi\u1ec7u su\u1ea5t qu\u1ea3ng c\u00e1o:<\/strong> T\u1ef1 \u0111\u1ed9ng k\u00e9o d\u1eef li\u1ec7u t\u1eeb Facebook Ads, <a href=\"https:\/\/tino.vn\/blog\/google-ads-la-gi\/\" target=\"_blank\" data-type=\"post\" data-id=\"58625\" rel=\"noreferrer noopener\">Google Ads<\/a> v\u00e0o Google Sheets m\u1ed7i s\u00e1ng \u0111\u1ec3 \u0111\u1ed9i ng\u0169 marketing c\u00f3 c\u00e1i nh\u00ecn t\u1ed5ng quan nhanh ch\u00f3ng.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"\u1ee8ng_d\u1ee5ng_c\u1ee7a_Google_Drive_trong_n8n\"><a id=\"post-119270-_mi7da8qsticv\"><\/a><strong>\u1ee8ng d\u1ee5ng c\u1ee7a Google Drive trong n8n<\/strong><\/h3>\n\n\n\n<p>Google Drive \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 m\u1ed9t kho l\u01b0u tr\u1eef v\u00e0 qu\u1ea3n l\u00fd t\u1ec7p tin trung t\u00e2m, gi\u00fap t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c c\u00f4ng vi\u1ec7c li\u00ean quan \u0111\u1ebfn t\u00e0i li\u1ec7u.<\/p>\n\n\n\n<h4 id=\"L\u01b0u_tr\u1eef_v\u00e0_t\u1ed5_ch\u1ee9c_t\u1ec7p_tin_t\u1ef1_\u0111\u1ed9ng\"><a id=\"post-119270-_1oy2udxt7ffp\"><\/a>L\u01b0u tr\u1eef v\u00e0 t\u1ed5 ch\u1ee9c t\u1ec7p tin t\u1ef1 \u0111\u1ed9ng<\/h4>\n\n\n\n<p>\u0110\u00e2y l\u00e0 \u1ee9ng d\u1ee5ng c\u1ed1t l\u00f5i, gi\u00fap \u0111\u1ea3m b\u1ea3o c\u00e1c t\u1ec7p tin quan tr\u1ecdng \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef \u0111\u00fang n\u01a1i, \u0111\u00fang c\u1ea5u tr\u00fac.<\/p>\n\n\n\n<p>V\u00ed d\u1ee5:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>L\u01b0u tr\u1eef h\u00f3a \u0111\u01a1n, h\u1ee3p \u0111\u1ed3ng: <\/strong>Khi c\u00f3 m\u1ed9t email ch\u1ee9a h\u00f3a \u0111\u01a1n t\u1eeb nh\u00e0 cung c\u1ea5p, n8n c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng t\u1ea3i t\u1ec7p \u0111\u00ednh k\u00e8m, \u0111\u1ed5i t\u00ean theo c\u1ea5u tr\u00fac (v\u00ed d\u1ee5: [T\u00ean NCC]_[M\u00e3 H\u0110]_[Ng\u00e0y]) v\u00e0 l\u01b0u v\u00e0o th\u01b0 m\u1ee5c H\u00f3a \u0111\u01a1n tr\u00ean Google Drive.<\/li>\n\n\n\n<li><strong>T\u1ea1o th\u01b0 m\u1ee5c cho d\u1ef1 \u00e1n\/kh\u00e1ch h\u00e0ng m\u1edbi: <\/strong>Khi m\u1ed9t d\u1ef1 \u00e1n m\u1edbi \u0111\u01b0\u1ee3c t\u1ea1o tr\u00ean Trello ho\u1eb7c Asana, n8n s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u1ea1o m\u1ed9t b\u1ed9 th\u01b0 m\u1ee5c chu\u1ea9n (v\u00ed d\u1ee5: T\u00e0i li\u1ec7u, Thi\u1ebft k\u1ebf, B\u00e1o c\u00e1o) tr\u00ean Google Drive cho d\u1ef1 \u00e1n \u0111\u00f3.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"700\" height=\"375\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/loi-tich-hop-google-sheet-drive-voi-n8n-2.png\" alt=\"\u1ee8ng d\u1ee5ng Google Drive trong n8n\" class=\"wp-image-119281\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/loi-tich-hop-google-sheet-drive-voi-n8n-2.png 700w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/loi-tich-hop-google-sheet-drive-voi-n8n-2-300x161.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><figcaption class=\"wp-element-caption\"><strong>\u1ee8ng d\u1ee5ng Google Drive trong n8n<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<h4 id=\"T\u1ef1_\u0111\u1ed9ng_t\u1ea1o_t\u00e0i_li\u1ec7u_(document_generation)\"><a id=\"post-119270-_d79nh1n0qxn8\"><\/a>T\u1ef1 \u0111\u1ed9ng t\u1ea1o t\u00e0i li\u1ec7u (document generation)<\/h4>\n\n\n\n<p>K\u1ebft h\u1ee3p n8n v\u1edbi Google Docs (th\u00f4ng qua Google Drive) \u0111\u1ec3 t\u1ea1o ra c\u00e1c t\u00e0i li\u1ec7u theo m\u1eabu c\u00f3 s\u1eb5n.<\/p>\n\n\n\n<p>V\u00ed d\u1ee5:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>T\u1ea1o h\u1ee3p \u0111\u1ed3ng ho\u1eb7c b\u00e1o gi\u00e1: <\/strong>n8n l\u1ea5y th\u00f4ng tin kh\u00e1ch h\u00e0ng t\u1eeb CRM ho\u1eb7c Google Sheets, sau \u0111\u00f3 \u0111i\u1ec1n v\u00e0o m\u1ed9t m\u1eabu h\u1ee3p \u0111\u1ed3ng (template) tr\u00ean Google Docs, t\u1ea1o ra m\u1ed9t file m\u1edbi v\u00e0 l\u01b0u v\u00e0o th\u01b0 m\u1ee5c c\u1ee7a kh\u00e1ch h\u00e0ng \u0111\u00f3 tr\u00ean Google Drive.<\/li>\n\n\n\n<li><strong>T\u1ea1o ch\u1ee9ng ch\u1ec9 ho\u00e0n th\u00e0nh kh\u00f3a h\u1ecdc<\/strong>: Khi m\u1ed9t h\u1ecdc vi\u00ean ho\u00e0n th\u00e0nh kh\u00f3a h\u1ecdc tr\u00ean h\u1ec7 th\u1ed1ng LMS, n8n s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u1ea1o m\u1ed9t file ch\u1ee9ng ch\u1ec9 (t\u1eeb template) v\u1edbi t\u00ean c\u1ee7a h\u1ecdc vi\u00ean v\u00e0 g\u1eedi cho h\u1ecd.<\/li>\n<\/ul>\n\n\n\n<h4 id=\"Sao_l\u01b0u_d\u1eef_li\u1ec7u_(data_backup)\"><a id=\"post-119270-_z13u7nmswrhf\"><\/a>Sao l\u01b0u d\u1eef li\u1ec7u (data backup)<\/h4>\n\n\n\n<p>S\u1eed d\u1ee5ng Google Drive nh\u01b0 m\u1ed9t n\u01a1i an to\u00e0n \u0111\u1ec3 sao l\u01b0u c\u00e1c d\u1eef li\u1ec7u quan tr\u1ecdng t\u1eeb c\u00e1c h\u1ec7 th\u1ed1ng kh\u00e1c.<\/p>\n\n\n\n<p>V\u00ed d\u1ee5:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Backup website:<\/strong> T\u1ef1 \u0111\u1ed9ng sao l\u01b0u c\u01a1 s\u1edf d\u1eef li\u1ec7u ho\u1eb7c c\u00e1c t\u1ec7p tin c\u1ee7a website theo l\u1ecbch (v\u00ed d\u1ee5: h\u00e0ng tu\u1ea7n) v\u00e0 t\u1ea3i file backup l\u00ean m\u1ed9t th\u01b0 m\u1ee5c ri\u00eang tr\u00ean Google Drive.<\/li>\n\n\n\n<li><strong>L\u01b0u tr\u1eef b\u00e1o c\u00e1o t\u1eeb c\u00e1c n\u1ec1n t\u1ea3ng kh\u00e1c: <\/strong>T\u1ef1 \u0111\u1ed9ng xu\u1ea5t b\u00e1o c\u00e1o t\u1eeb c\u00e1c c\u00f4ng c\u1ee5 marketing, t\u00e0i ch\u00ednh d\u01b0\u1edbi d\u1ea1ng file (PDF, CSV) v\u00e0 l\u01b0u tr\u1eef ch\u00fang tr\u00ean Google Drive \u0111\u1ec3 tham chi\u1ebfu sau n\u00e0y.<\/li>\n<\/ul>\n\n\n\n<h4 id=\"Chia_s\u1ebb_v\u00e0_c\u1ea5p_quy\u1ec1n_truy_c\u1eadp_t\u1ec7p_tin\"><a id=\"post-119270-_gjdlsqnnc2p3\"><\/a>Chia s\u1ebb v\u00e0 c\u1ea5p quy\u1ec1n truy c\u1eadp t\u1ec7p tin<\/h4>\n\n\n\n<p>T\u1ef1 \u0111\u1ed9ng h\u00f3a vi\u1ec7c chia s\u1ebb t\u00e0i li\u1ec7u v\u00e0 qu\u1ea3n l\u00fd quy\u1ec1n truy c\u1eadp.<\/p>\n\n\n\n<p>V\u00ed d\u1ee5:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Chia s\u1ebb t\u00e0i li\u1ec7u cho kh\u00e1ch h\u00e0ng:<\/strong> Sau khi t\u1ef1 \u0111\u1ed9ng t\u1ea1o m\u1ed9t b\u1ea3n b\u00e1o gi\u00e1, n8n c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng chia s\u1ebb file \u0111\u00f3 v\u1edbi email c\u1ee7a kh\u00e1ch h\u00e0ng v\u1edbi quy\u1ec1n &#8220;ch\u1ec9 xem&#8221; v\u00e0 g\u1eedi link qua email.<\/li>\n\n\n\n<li><strong>C\u1ea5p quy\u1ec1n truy c\u1eadp cho nh\u00e2n s\u1ef1 m\u1edbi: <\/strong>Khi c\u00f3 m\u1ed9t nh\u00e2n vi\u00ean m\u1edbi, n8n c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng c\u1ea5p cho h\u1ecd quy\u1ec1n truy c\u1eadp v\u00e0o c\u00e1c th\u01b0 m\u1ee5c d\u1ef1 \u00e1n li\u00ean quan tr\u00ean Google Drive.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"H\u01b0\u1edbng_d\u1eabn_s\u1eeda_l\u1ed7i_t\u00edch_h\u1ee3p_Google_Sheet\/Drive_v\u1edbi_n8n:_Nguy\u00ean_nh\u00e2n_v\u00e0_c\u00e1ch_gi\u1ea3i_quy\u1ebft\"><a id=\"post-119270-_c0md9w7dmotf\"><\/a>H\u01b0\u1edbng d\u1eabn s\u1eeda l\u1ed7i t\u00edch h\u1ee3p Google Sheet\/Drive v\u1edbi n8n: Nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch gi\u1ea3i quy\u1ebft<\/h2>\n\n\n\n<h3 id=\"L\u1ed7i_x\u00e1c_th\u1ef1c_OAuth_th\u1ea5t_b\u1ea1i_(403_Forbidden)\"><a id=\"post-119270-_4f97usbihjq8\"><\/a>L\u1ed7i x\u00e1c th\u1ef1c OAuth th\u1ea5t b\u1ea1i (403 Forbidden)<\/h3>\n\n\n\n<h4 id=\"M\u00f4_t\u1ea3_l\u1ed7i\"><a id=\"post-119270-_6asv22wcipy1\"><\/a>M\u00f4 t\u1ea3 l\u1ed7i<\/h4>\n\n\n\n<p>L\u1ed7i n\u00e0y x\u1ea3y ra khi n8n kh\u00f4ng th\u1ec3 x\u00e1c th\u1ef1c v\u1edbi t\u00e0i kho\u1ea3n Google, d\u1eabn \u0111\u1ebfn th\u00f4ng b\u00e1o &#8220;<strong>Forbidden &#8211; perhaps check your credentials?<\/strong>&#8221; ho\u1eb7c &#8220;<strong>403 Forbidden<\/strong>&#8220;.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"622\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/1-1-1024x622.png\" alt=\"L\u1ed7i x\u00e1c th\u1ef1c OAuth th\u1ea5t b\u1ea1i (403 Forbidden)\" class=\"wp-image-119273\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/1-1-1024x622.png 1024w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/1-1-300x182.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/1-1-768x467.png 768w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/1-1.png 1460w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><strong>L\u1ed7i x\u00e1c th\u1ef1c OAuth th\u1ea5t b\u1ea1i (403 Forbidden)<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>Nguy\u00ean nh\u00e2n: <\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Credentials OAuth kh\u00f4ng \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp \u0111\u00fang (v\u00ed d\u1ee5: ch\u01b0a enable API t\u01b0\u01a1ng \u1ee9ng nh\u01b0 Google Sheets API ho\u1eb7c Google Drive API),<\/li>\n\n\n\n<li>Redirect URI sai ho\u1eb7c kh\u00f4ng th\u00eam test users v\u00e0o OAuth consent screen (n\u1ebfu ch\u01b0a public).<\/li>\n\n\n\n<li>G\u1ea7n \u0111\u00e2y, l\u1ed7i n\u00e0y c\u00f2n ph\u1ed5 bi\u1ebfn h\u01a1n v\u1edbi n8n.cloud do y\u00eau c\u1ea7u verification process t\u1eeb Google.<\/li>\n<\/ul>\n\n\n\n<h4 id=\"C\u00e1ch_x\u1eed_l\u00fd\"><a id=\"post-119270-_cssf4eni3gqf\"><\/a>C\u00e1ch x\u1eed l\u00fd<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>V\u00e0o <a href=\"https:\/\/console.cloud.google.com\/\" data-type=\"link\" data-id=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Google Cloud Console<\/a>, enable API t\u01b0\u01a1ng \u1ee9ng (Google Sheets API cho Sheets, Google Drive API cho Drive). Xem chi ti\u1ebft t\u1ea1i b\u00e0i vi\u1ebft: <a href=\"https:\/\/tino.vn\/blog\/cach-xac-thuc-credential-cho-google-tren-n8n\/\" target=\"_blank\" rel=\"noreferrer noopener\">C\u00e1ch x\u00e1c th\u1ef1c Credential cho Google tr\u00ean n8n<\/a><\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"599\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/2-1-1024x599.png\" alt=\"L\u1ed7i x\u00e1c th\u1ef1c OAuth th\u1ea5t b\u1ea1i (403 Forbidden)\" class=\"wp-image-119275\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/2-1-1024x599.png 1024w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/2-1-300x176.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/2-1-768x449.png 768w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/2-1.png 1393w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><strong>L\u1ed7i x\u00e1c th\u1ef1c OAuth th\u1ea5t b\u1ea1i (403 Forbidden)<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Trong OAuth consent screen, ch\u1ecdn &#8220;<strong>External<\/strong>&#8221; user type v\u00e0 th\u00eam email c\u1ee7a b\u1ea1n l\u00e0m test user (n\u1ebfu ch\u01b0a public app).<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"580\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/6-1024x580.png\" alt=\"L\u1ed7i x\u00e1c th\u1ef1c OAuth th\u1ea5t b\u1ea1i (403 Forbidden)\" class=\"wp-image-119278\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/6-1024x580.png 1024w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/6-300x170.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/6-768x435.png 768w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/6-1536x869.png 1536w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/6.png 1592w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><strong>L\u1ed7i x\u00e1c th\u1ef1c OAuth th\u1ea5t b\u1ea1i (403 Forbidden)<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Ki\u1ec3m tra redirect URIs trong credentials (th\u01b0\u1eddng l\u00e0 <strong>https:\/\/your-n8n-instance\/oauth2\/callback<\/strong>).<\/li>\n\n\n\n<li>T\u1ea1o m\u1edbi credentials trong n8n v\u00e0 re-authenticate. N\u1ebfu d\u00f9ng n8n.cloud, ch\u1edd Google verification ho\u1eb7c d\u00f9ng service account thay th\u1ebf.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"L\u1ed7i_quy\u1ec1n_truy_c\u1eadp_b\u1ecb_t\u1eeb_ch\u1ed1i_(Permission_Denied_ho\u1eb7c_Access_Blocked)\"><a id=\"post-119270-_wbmvywi95cp8\"><\/a><strong>L\u1ed7i quy\u1ec1n truy c\u1eadp b\u1ecb t\u1eeb ch\u1ed1i (Permission Denied ho\u1eb7c Access Blocked)<\/strong><\/h3>\n\n\n\n<h4 id=\"M\u00f4_t\u1ea3_l\u1ed7i\"><a id=\"post-119270-_m8re5aa27jz2\"><\/a>M\u00f4 t\u1ea3 l\u1ed7i<\/h4>\n\n\n\n<p>Th\u00f4ng b\u00e1o l\u1ed7i nh\u01b0 &#8220;Access blocked: n8n.cloud has not completed the Google verification process&#8221; (Error 403: access_denied) ho\u1eb7c &#8220;Permission Denied&#8221;. X\u1ea3y ra khi n8n c\u1ed1 g\u1eafng th\u1ef1c hi\u1ec7n m\u1ed9t h\u00e0nh \u0111\u1ed9ng (v\u00ed d\u1ee5: ghi d\u1eef li\u1ec7u) m\u00e0 b\u1ea1n ch\u01b0a c\u1ea5p ph\u00e9p cho n\u00f3 trong qu\u00e1 tr\u00ecnh x\u00e1c th\u1ef1c.<\/p>\n\n\n\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ch\u1ec9 c\u1ea5p quy\u1ec1n \u0111\u1ecdc (Read-only) ho\u1eb7c c\u00e1c quy\u1ec1n kh\u00f4ng li\u00ean quan \u0111\u1ebfn vi\u1ec7c ch\u1ec9nh s\u1eeda b\u1ea3ng t\u00ednh.<\/li>\n\n\n\n<li>T\u00e0i kho\u1ea3n Google kh\u00e1c nhau gi\u1eefa n8n v\u00e0 Google Cloud Platform (GCP)<\/li>\n\n\n\n<li>App ch\u01b0a \u0111\u01b0\u1ee3c verified b\u1edfi Google<\/li>\n<\/ul>\n\n\n\n<p>\u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t x\u1ea3y ra v\u1edbi Google Drive khi copy ho\u1eb7c upload file.<\/p>\n\n\n\n<h4 id=\"C\u00e1ch_x\u1eed_l\u00fd\"><a id=\"post-119270-_aild2i5r9xgu\"><\/a>C\u00e1ch x\u1eed l\u00fd<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Reconnect t\u00e0i kho\u1ea3n<\/strong> v\u00e0 \u0111\u1ea3m b\u1ea3o b\u1ea1n tick v\u00e0o t\u1ea5t c\u1ea3 c\u00e1c \u00f4 li\u00ean quan \u0111\u1ebfn vi\u1ec7c &#8220;Xem, ch\u1ec9nh s\u1eeda, t\u1ea1o v\u00e0 x\u00f3a t\u1ea5t c\u1ea3 c\u00e1c t\u1ec7p Google Drive c\u1ee7a b\u1ea1n&#8221; ho\u1eb7c &#8220;Xem v\u00e0 qu\u1ea3n l\u00fd b\u1ea3ng t\u00ednh Google Sheets c\u1ee7a b\u1ea1n&#8221;.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"620\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/4-1-1024x620.png\" alt=\"L\u1ed7i quy\u1ec1n truy c\u1eadp b\u1ecb t\u1eeb ch\u1ed1i (Permission Denied ho\u1eb7c Access Blocked)\" class=\"wp-image-119277\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/4-1-1024x620.png 1024w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/4-1-300x182.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/4-1-768x465.png 768w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/4-1.png 1357w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><strong>L\u1ed7i quy\u1ec1n truy c\u1eadp b\u1ecb t\u1eeb ch\u1ed1i (Permission Denied ho\u1eb7c Access Blocked)<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>N\u1ebfu l\u1ed7i &#8220;access blocked&#8221;, h\u00e3y publish app trong OAuth screen ho\u1eb7c d\u00f9ng t\u00e0i kho\u1ea3n c\u00e1 nh\u00e2n thay v\u00ec n8n.cloud cho testing.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"529\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/3-2-1024x529.png\" alt=\"L\u1ed7i quy\u1ec1n truy c\u1eadp b\u1ecb t\u1eeb ch\u1ed1i (Permission Denied ho\u1eb7c Access Blocked)\" class=\"wp-image-119274\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/3-2-1024x529.png 1024w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/3-2-300x155.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/3-2-768x397.png 768w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/3-2.png 1479w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><strong>L\u1ed7i quy\u1ec1n truy c\u1eadp b\u1ecb t\u1eeb ch\u1ed1i (Permission Denied ho\u1eb7c Access Blocked)<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Ki\u1ec3m tra email account kh\u1edbp gi\u1eefa n8n v\u00e0 GCP.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"L\u1ed7i_404:_Not_Found_\"><a id=\"post-119270-_arjfnwicg2zy\"><\/a>L\u1ed7i 404: Not Found <\/h3>\n\n\n\n<h4 id=\"M\u00f4_t\u1ea3_l\u1ed7i\"><a id=\"post-119270-_gqgy2zhduclh\"><\/a>M\u00f4 t\u1ea3 l\u1ed7i<\/h4>\n\n\n\n<p>L\u1ed7i n\u00e0y c\u00f3 ngh\u0129a l\u00e0 n8n kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y t\u1ec7p ho\u1eb7c trang t\u00ednh b\u1ea1n \u0111\u00e3 ch\u1ec9 \u0111\u1ecbnh.<\/p>\n\n\n\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>ID trang t\u00ednh trong URL b\u1ecb sao ch\u00e9p thi\u1ebfu ho\u1eb7c th\u1eeba k\u00fd t\u1ef1.<\/li>\n\n\n\n<li>File \u0111\u00e3 b\u1ecb x\u00f3a ho\u1eb7c b\u1ea1n kh\u00f4ng c\u00f3 quy\u1ec1n truy c\u1eadp: File \u0111\u00e3 b\u1ecb chuy\u1ec3n v\u00e0o th\u00f9ng r\u00e1c, ho\u1eb7c t\u00e0i kho\u1ea3n Google b\u1ea1n d\u00f9ng \u0111\u1ec3 x\u00e1c th\u1ef1c trong n8n kh\u00f4ng \u0111\u01b0\u1ee3c chia s\u1ebb quy\u1ec1n xem (view) file n\u00e0y.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"619\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/5-2-1024x619.png\" alt=\"L\u1ed7i 404: Not Found \" class=\"wp-image-119279\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/5-2-1024x619.png 1024w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/5-2-300x181.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/5-2-768x464.png 768w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/5-2.png 1485w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><strong>L\u1ed7i 404: Not Found <\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<h4 id=\"C\u00e1ch_x\u1eed_l\u00fd\"><a id=\"post-119270-_d84fxf3v2c3f\"><\/a>C\u00e1ch x\u1eed l\u00fd<\/h4>\n\n\n\n<p>Ki\u1ec3m tra l\u1ea1i Spreadsheet ID (Ph\u1ea7n ID l\u00e0 chu\u1ed7i k\u00fd t\u1ef1 n\u1eb1m gi\u1eefa <em>&#8230;\/d\/ <\/em>v\u00e0 <em>\/edit&#8230;.<\/em>)<\/p>\n\n\n\n<p>M\u1edf file Google Sheets, nh\u1ea5n n\u00fat &#8220;<strong>Share<\/strong>&#8221; (Chia s\u1ebb) \u1edf g\u00f3c tr\u00ean b\u00ean ph\u1ea3i v\u00e0 ki\u1ec3m tra xem email m\u00e0 b\u1ea1n \u0111\u00e3 d\u00f9ng \u0111\u1ec3 t\u1ea1o Credential trong n8n c\u00f3 n\u1eb1m trong danh s\u00e1ch \u0111\u01b0\u1ee3c chia s\u1ebb kh\u00f4ng, v\u00e0 c\u00f3 \u00edt nh\u1ea5t l\u00e0 quy\u1ec1n &#8220;Viewer&#8221; (Ng\u01b0\u1eddi xem).<\/p>\n\n\n\n<h3 id=\"L\u1ed7i_d\u1eef_li\u1ec7u_kh\u00f4ng_\u0111\u1ed3ng_b\u1ed9_ho\u1eb7c_b\u1ecb_thi\u1ebfu\"><a id=\"post-119270-_7osrgm2fx4u\"><\/a><strong>L\u1ed7i d\u1eef li\u1ec7u kh\u00f4ng \u0111\u1ed3ng b\u1ed9 ho\u1eb7c b\u1ecb thi\u1ebfu<\/strong><\/h3>\n\n\n\n<h4 id=\"M\u00f4_t\u1ea3_l\u1ed7i\"><a id=\"post-119270-_wzuc9uksy6p\"><\/a>M\u00f4 t\u1ea3 l\u1ed7i<\/h4>\n\n\n\n<p>D\u1eef li\u1ec7u kh\u00f4ng \u0111\u01b0\u1ee3c append ho\u1eb7c update v\u00e0o sheet, d\u00f9 workflow ch\u1ea1y th\u00e0nh c\u00f4ng.<\/p>\n\n\n\n<p><strong>Nguy\u00ean nh\u00e2n: <\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Node Google Sheets kh\u00f4ng ph\u00e1t hi\u1ec7n thay \u0111\u1ed5i (kh\u00f4ng d\u00f9ng trigger \u0111\u00fang).<\/li>\n\n\n\n<li>V\u1ea5n \u0111\u1ec1 v\u1edbi webhook setup ho\u1eb7c kh\u00f4ng tracking changes qua Google Apps Script.<\/li>\n\n\n\n<li>D\u1eef li\u1ec7u b\u1ecb thi\u1ebfu do filter sai ho\u1eb7c kh\u00f4ng \u0111\u1ed3ng b\u1ed9 th\u1eddi gian th\u1ef1c.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"700\" height=\"375\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/loi-tich-hop-google-sheet-drive-voi-n8n-3.png\" alt=\"L\u1ed7i d\u1eef li\u1ec7u kh\u00f4ng \u0111\u1ed3ng b\u1ed9 ho\u1eb7c b\u1ecb thi\u1ebfu\" class=\"wp-image-119282\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/loi-tich-hop-google-sheet-drive-voi-n8n-3.png 700w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/loi-tich-hop-google-sheet-drive-voi-n8n-3-300x161.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><figcaption class=\"wp-element-caption\"><strong>L\u1ed7i d\u1eef li\u1ec7u kh\u00f4ng \u0111\u1ed3ng b\u1ed9 ho\u1eb7c b\u1ecb thi\u1ebfu<\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<h4 id=\"C\u00e1ch_x\u1eed_l\u00fd\"><a id=\"post-119270-_fk895bbkfy5a\"><\/a>C\u00e1ch x\u1eed l\u00fd<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>S\u1eed d\u1ee5ng trigger v\u00e0 node ph\u00f9 h\u1ee3p<\/li>\n\n\n\n<li>S\u1eed d\u1ee5ng Google Sheets Trigger node \u0111\u1ec3 listen changes th\u1eddi gian th\u1ef1c.<\/li>\n\n\n\n<li>N\u1ebfu c\u1ea7n tracking changes, th\u00eam Google Apps Script v\u00e0o sheet: T\u1ea1o script v\u1edbi onEdit() function g\u1eedi webhook \u0111\u1ebfn n8n.<\/li>\n\n\n\n<li>Th\u00eam Filter node trong n8n \u0111\u1ec3 ki\u1ec3m tra c\u1ed9t thay \u0111\u1ed5i (v\u00ed d\u1ee5: if column A == &#8216;true&#8217;).<\/li>\n\n\n\n<li>Debug b\u1eb1ng c\u00e1ch ch\u1ea1y manual v\u00e0 ki\u1ec3m tra output c\u1ee7a node.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"L\u1ed7i_v\u01b0\u1ee3t_qu\u00e1_gi\u1edbi_h\u1ea1n_API_\"><a id=\"post-119270-_8w40mqctrmgp\"><\/a><strong>L\u1ed7i v\u01b0\u1ee3t qu\u00e1 gi\u1edbi h\u1ea1n API <\/strong><\/h3>\n\n\n\n<h4 id=\"M\u00f4_t\u1ea3_l\u1ed7i\"><a id=\"post-119270-_o6xvsfyh1g9x\"><\/a>M\u00f4 t\u1ea3 l\u1ed7i<\/h4>\n\n\n\n<p>L\u1ed7i nh\u01b0 &#8220;429 Too Many Requests&#8221; x\u1ea3y ra khi workflow g\u1ecdi API Google qu\u00e1 nhi\u1ec1u l\u1ea7n trong th\u1eddi gian ng\u1eafn.<\/p>\n\n\n\n<p><strong>Nguy\u00ean nh\u00e2n: <\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Workflow kh\u00f4ng t\u1ed1i \u01b0u (v\u00ed d\u1ee5: loop kh\u00f4ng c\u00f3 delay)<\/li>\n\n\n\n<li>Ch\u1ea1y song song nhi\u1ec1u instances v\u01b0\u1ee3t quota mi\u1ec5n ph\u00ed c\u1ee7a Google (100 requests\/ph\u00fat cho Sheets, 750 requests\/ph\u00fat cho Drive).<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"700\" height=\"375\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/loi-tich-hop-google-sheet-drive-voi-n8n-4.png\" alt=\"L\u1ed7i v\u01b0\u1ee3t qu\u00e1 gi\u1edbi h\u1ea1n API \" class=\"wp-image-119283\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/loi-tich-hop-google-sheet-drive-voi-n8n-4.png 700w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2025\/09\/loi-tich-hop-google-sheet-drive-voi-n8n-4-300x161.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><figcaption class=\"wp-element-caption\"><strong>L\u1ed7i v\u01b0\u1ee3t qu\u00e1 gi\u1edbi h\u1ea1n API <\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<h4 id=\"C\u00e1ch_x\u1eed_l\u00fd\"><a id=\"post-119270-_csxszqh3hp8w\"><\/a>C\u00e1ch x\u1eed l\u00fd<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Th\u00eam Wait node (delay 1-5 gi\u00e2y) gi\u1eefa c\u00e1c calls API.<\/li>\n\n\n\n<li>S\u1eed d\u1ee5ng Batch processing: Gom nhi\u1ec1u requests v\u00e0o m\u1ed9t (v\u00ed d\u1ee5: append multiple rows c\u00f9ng l\u00fac).<\/li>\n\n\n\n<li>Ki\u1ec3m tra quota trong Google Cloud Console v\u00e0 n\u00e2ng c\u1ea5p n\u1ebfu c\u1ea7n (paid tier cho gi\u1edbi h\u1ea1n cao h\u01a1n).<\/li>\n\n\n\n<li>Ch\u1ea1y workflow v\u1edbi schedule h\u1ee3p l\u00fd (v\u00ed d\u1ee5: h\u00e0ng gi\u1edd thay v\u00ec h\u00e0ng ph\u00fat).<\/li>\n<\/ul>\n\n\n\n<h3 id=\"L\u1ed7i_v\u1ea5n_\u0111\u1ec1_v\u1ec1_\u0111\u1ecbnh_d\u1ea1ng_file_ho\u1eb7c_d\u1eef_li\u1ec7u_kh\u00f4ng_t\u01b0\u01a1ng_th\u00edch_(JSON_Type_Mismatch)\"><a id=\"post-119270-_fgj8t346eb7c\"><\/a><strong>L\u1ed7i v\u1ea5n \u0111\u1ec1 v\u1ec1 \u0111\u1ecbnh d\u1ea1ng file ho\u1eb7c d\u1eef li\u1ec7u kh\u00f4ng t\u01b0\u01a1ng th\u00edch (JSON Type Mismatch)<\/strong><\/h3>\n\n\n\n<h4 id=\"M\u00f4_t\u1ea3_l\u1ed7i\"><a id=\"post-119270-_kwec755d5v9\"><\/a>M\u00f4 t\u1ea3 l\u1ed7i<\/h4>\n\n\n\n<p>D\u1eef li\u1ec7u kh\u00f4ng \u0111\u01b0\u1ee3c x\u1eed l\u00fd \u0111\u00fang do mismatch type (v\u00ed d\u1ee5: text &#8220;true&#8221; thay v\u00ec boolean true), d\u1eabn \u0111\u1ebfn workflow th\u1ea5t b\u1ea1i ho\u1eb7c d\u1eef li\u1ec7u sai trong sheet\/drive.<\/p>\n\n\n\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Kh\u00f4ng convert types trong node.<\/li>\n\n\n\n<li>D\u1eef li\u1ec7u t\u1eeb ngu\u1ed3n ngo\u00e0i kh\u00f4ng kh\u1edbp \u0111\u1ecbnh d\u1ea1ng mong \u0111\u1ee3i c\u1ee7a Google API.<\/li>\n<\/ul>\n\n\n\n<p>C\u00e1ch x\u1eed l\u00fd<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ki\u1ec3m tra data types trong n8n (icon b\u00ean c\u1ea1nh field: &#8220;A&#8221; cho string, switch cho boolean).<\/li>\n\n\n\n<li>S\u1eed d\u1ee5ng &#8220;<strong>Convert Types<\/strong>&#8221; option trong Filter ho\u1eb7c node Code \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng chuy\u1ec3n \u0111\u1ed5i.<\/li>\n\n\n\n<li>Trong node Code, d\u00f9ng code JS nh\u01b0 item.value = Boolean(item.value) \u0111\u1ec3 fix mismatch.<\/li>\n\n\n\n<li>Test v\u1edbi d\u1eef li\u1ec7u m\u1eabu tr\u01b0\u1edbc khi ch\u1ea1y full workflow.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"K\u1ebft_lu\u1eadn\"><a id=\"post-119270-_uplq3lpojpit\"><\/a><strong>K\u1ebft lu\u1eadn<\/strong><\/h3>\n\n\n\n<p>B\u1eb1ng c\u00e1ch hi\u1ec3u r\u00f5 nguy\u00ean nh\u00e2n g\u1ed1c r\u1ec5 t\u1eeb vi\u1ec7c x\u00e1c th\u1ef1c, quy\u1ec1n truy c\u1eadp cho \u0111\u1ebfn c\u1ea5u tr\u00fac d\u1eef li\u1ec7u, b\u1ea1n kh\u00f4ng ch\u1ec9 c\u00f3 th\u1ec3 kh\u1eafc ph\u1ee5c c\u00e1c l\u1ed7i hi\u1ec7n t\u1ea1i m\u00e0 c\u00f2n t\u1ef1 tin x\u00e2y d\u1ef1ng nh\u1eefng quy tr\u00ecnh l\u00e0m vi\u1ec7c b\u1ec1n v\u1eefng v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n trong t\u01b0\u01a1ng lai. \u0110\u1eebng ng\u1ea7n ng\u1ea1i th\u1eed nghi\u1ec7m, g\u1ee1 l\u1ed7i v\u00e0 t\u1ed1i \u01b0u. Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng tr\u00ean con \u0111\u01b0\u1eddng t\u1ef1 \u0111\u1ed9ng h\u00f3a v\u00e0 khai th\u00e1c t\u1ed1i \u0111a ti\u1ec1m n\u0103ng m\u00e0 n8n v\u00e0 Google mang l\u1ea1i!<\/p>\n\n\n\n<h2 id=\"Nh\u1eefng_c\u00e2u_h\u1ecfi_th\u01b0\u1eddng_g\u1eb7p\"><a id=\"post-119270-_m2i5jcbkdsw2\"><\/a>Nh\u1eefng c\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p<\/h2>\n\n\n\t\t<section\t\thelp class=\"sc_fs_faq sc_card    \"\n\t\t\t\t>\n\t\t\t\t<h2 id=\"T\u00f4i_c\u00f3_c\u1ea7n_ph\u1ea3i_t\u1ea1o_m\u1ed9t_Credential_ri\u00eang_cho_Google_Sheets_v\u00e0_m\u1ed9t_c\u00e1i_ri\u00eang_cho_Google_Drive_kh\u00f4ng?\">T\u00f4i c\u00f3 c\u1ea7n ph\u1ea3i t\u1ea1o m\u1ed9t Credential ri\u00eang cho Google Sheets v\u00e0 m\u1ed9t c\u00e1i ri\u00eang cho Google Drive kh\u00f4ng?<\/h2>\t\t\t\t<div>\n\t\t\t\t\t\t<div class=\"sc_fs_faq__content\">\n\t\t\t\t\n\n<p>Kh\u00f4ng c\u1ea7n. Khi b\u1ea1n x\u00e1c th\u1ef1c t\u00e0i kho\u1ea3n Google v\u1edbi n8n v\u00e0 c\u1ea5p \u0111\u1ee7 quy\u1ec1n (scope) cho Google Drive, Credential \u0111\u00f3 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho c\u1ea3 hai node Google Sheets v\u00e0 Google Drive. Ch\u00fang d\u00f9ng chung m\u1ed9t h\u1ec7 th\u1ed1ng x\u00e1c th\u1ef1c.<\/p>\n\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section\t\thelp class=\"sc_fs_faq sc_card    \"\n\t\t\t\t>\n\t\t\t\t<h2 id=\"T\u1ea1i_sao_workflow_c\u1ee7a_t\u00f4i_ch\u1ea1y_th\u00e0nh_c\u00f4ng_nh\u01b0ng_kh\u00f4ng_c\u00f3_d\u1eef_li\u1ec7u_n\u00e0o_\u0111\u01b0\u1ee3c_ghi_v\u00e0o_Google_Sheets?\">T\u1ea1i sao workflow c\u1ee7a t\u00f4i ch\u1ea1y th\u00e0nh c\u00f4ng nh\u01b0ng kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u n\u00e0o \u0111\u01b0\u1ee3c ghi v\u00e0o Google Sheets?<\/h2>\t\t\t\t<div>\n\t\t\t\t\t\t<div class=\"sc_fs_faq__content\">\n\t\t\t\t\n\n<p>C\u00f3 hai nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn nh\u1ea5t:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Sai c\u1ea5u tr\u00fac d\u1eef li\u1ec7u:<\/strong> Node Google Sheets mong \u0111\u1ee3i m\u1ed9t m\u1ea3ng c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng (Array of Objects). N\u1ebfu d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o kh\u00f4ng \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng n\u00e0y, n\u00f3 c\u00f3 th\u1ec3 ch\u1ea1y &#8220;th\u00e0nh c\u00f4ng&#8221; nh\u01b0ng kh\u00f4ng th\u1ef1c hi\u1ec7n h\u00e0nh \u0111\u1ed9ng ghi. H\u00e3y d\u00f9ng node Set ho\u1eb7c Code \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng l\u1ea1i d\u1eef li\u1ec7u cho \u0111\u00fang.<\/li>\n\n\n\n<li><strong>D\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o r\u1ed7ng:<\/strong> H\u00e3y ki\u1ec3m tra output c\u1ee7a node ngay tr\u01b0\u1edbc node Google Sheets. R\u1ea5t c\u00f3 th\u1ec3 node \u0111\u00f3 kh\u00f4ng tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u n\u00e0o, n\u00ean kh\u00f4ng c\u00f3 g\u00ec \u0111\u1ec3 ghi.<\/li>\n<\/ul>\n\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section\t\thelp class=\"sc_fs_faq sc_card    \"\n\t\t\t\t>\n\t\t\t\t<h2 id=\"Gi\u1edbi_h\u1ea1n_API_c\u1ee7a_Google_Sheets_l\u00e0_bao_nhi\u00eau_v\u00e0_l\u00e0m_sao_\u0111\u1ec3_kh\u00f4ng_b\u1ecb_v\u01b0\u1ee3t?\">Gi\u1edbi h\u1ea1n API c\u1ee7a Google Sheets l\u00e0 bao nhi\u00eau v\u00e0 l\u00e0m sao \u0111\u1ec3 kh\u00f4ng b\u1ecb v\u01b0\u1ee3t?<\/h2>\t\t\t\t<div>\n\t\t\t\t\t\t<div class=\"sc_fs_faq__content\">\n\t\t\t\t\n\n<p>Gi\u1edbi h\u1ea1n ph\u1ed5 bi\u1ebfn l\u00e0 60 y\u00eau c\u1ea7u ghi m\u1ed7i ph\u00fat cho m\u1ed7i ng\u01b0\u1eddi d\u00f9ng. \u0110\u1ec3 tr\u00e1nh v\u01b0\u1ee3t gi\u1edbi h\u1ea1n khi x\u1eed l\u00fd nhi\u1ec1u d\u1eef li\u1ec7u, h\u00e3y g\u1ed9p c\u00e1c thao t\u00e1c. Thay v\u00ec d\u00f9ng v\u00f2ng l\u1eb7p \u0111\u1ec3 th\u00eam 100 d\u00f2ng (g\u1eedi 100 y\u00eau c\u1ea7u), h\u00e3y chu\u1ea9n b\u1ecb m\u1ed9t m\u1ea3ng ch\u1ee9a 100 d\u00f2ng \u0111\u00f3 v\u00e0 \u0111\u01b0a v\u00e0o node Google Sheets m\u1ed9t l\u1ea7n duy nh\u1ea5t. Node s\u1ebd t\u1ef1 \u0111\u1ed9ng g\u1eedi ch\u00fang trong m\u1ed9t y\u00eau c\u1ea7u h\u00e0ng lo\u1ea1t (batch request).<\/p>\n\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section\t\thelp class=\"sc_fs_faq sc_card    \"\n\t\t\t\t>\n\t\t\t\t<h2 id=\"L\u00e0m_c\u00e1ch_n\u00e0o_\u0111\u1ec3_workflow_t\u1ef1_\u0111\u1ed9ng_ch\u1ea1y_m\u1ed7i_khi_c\u00f3_m\u1ed9t_d\u00f2ng_m\u1edbi_\u0111\u01b0\u1ee3c_th\u00eam_v\u00e0o_Google_Sheets?\">L\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 workflow t\u1ef1 \u0111\u1ed9ng ch\u1ea1y m\u1ed7i khi c\u00f3 m\u1ed9t d\u00f2ng m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o Google Sheets?<\/h2>\t\t\t\t<div>\n\t\t\t\t\t\t<div class=\"sc_fs_faq__content\">\n\t\t\t\t\n\n<p>H\u00e3y s\u1eed d\u1ee5ng node Google Sheet Trigger. Node n\u00e0y s\u1ebd l\u1eafng nghe c\u00e1c thay \u0111\u1ed5i tr\u00ean trang t\u00ednh b\u1ea1n ch\u1ec9 \u0111\u1ecbnh. M\u1ed7i khi c\u00f3 m\u1ed9t d\u00f2ng m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o (ho\u1eb7c c\u1eadp nh\u1eadt), n\u00f3 s\u1ebd t\u1ef1 \u0111\u1ed9ng k\u00edch ho\u1ea1t workflow c\u1ee7a b\u1ea1n v\u00e0 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb d\u00f2ng \u0111\u00f3 l\u00e0m \u0111\u1ea7u v\u00e0o.<\/p>\n\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section\t\thelp class=\"sc_fs_faq sc_card    \"\n\t\t\t\t>\n\t\t\t\t<h2 id=\"L\u00e0m_th\u1ebf_n\u00e0o_\u0111\u1ec3_x\u1eed_l\u00fd_l\u1ed7i_m\u1ed9t_c\u00e1ch_t\u1ef1_\u0111\u1ed9ng_khi_t\u00edch_h\u1ee3p_v\u1edbi_Google_Sheets_(v\u00ed_d\u1ee5:_l\u1ed7i_h\u1ebft_h\u1ea1n_x\u00e1c_th\u1ef1c)?\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 x\u1eed l\u00fd l\u1ed7i m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng khi t\u00edch h\u1ee3p v\u1edbi Google Sheets (v\u00ed d\u1ee5: l\u1ed7i h\u1ebft h\u1ea1n x\u00e1c th\u1ef1c)?<\/h2>\t\t\t\t<div>\n\t\t\t\t\t\t<div class=\"sc_fs_faq__content\">\n\t\t\t\t\n\n<p>H\u00e3y t\u1eadn d\u1ee5ng t\u00ednh n\u0103ng &#8220;Error Workflow&#8221; (Quy tr\u00ecnh x\u1eed l\u00fd l\u1ed7i) c\u1ee7a n8n. B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t workflow ri\u00eang chuy\u00ean \u0111\u1ec3 x\u1eed l\u00fd l\u1ed7i. Trong workflow ch\u00ednh, v\u00e0o m\u1ee5c Settings v\u00e0 ch\u1ec9 \u0111\u1ecbnh &#8220;Error Workflow&#8221;. N\u1ebfu workflow ch\u00ednh g\u1eb7p l\u1ed7i (v\u00ed d\u1ee5: l\u1ed7i 403 do h\u1ebft h\u1ea1n token), n\u00f3 s\u1ebd t\u1ef1 \u0111\u1ed9ng k\u00edch ho\u1ea1t Error Workflow, cho ph\u00e9p b\u1ea1n g\u1eedi th\u00f4ng b\u00e1o qua Slack, email \u0111\u1ec3 c\u1ea3nh b\u00e1o v\u00e0 x\u1eed l\u00fd k\u1ecbp th\u1eddi.<\/p>\n\n\t\t\t<\/div>\n\t\t<\/div>\n\t\t<\/section>\n\t\t\n<script type=\"application\/ld+json\">\n\t{\n\t\t\"@context\": \"https:\/\/schema.org\",\n\t\t\"@type\": \"FAQPage\",\n\t\t\"mainEntity\": [\n\t\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"T\u00f4i c\u00f3 c\u1ea7n ph\u1ea3i t\u1ea1o m\u1ed9t Credential ri\u00eang cho Google Sheets v\u00e0 m\u1ed9t c\u00e1i ri\u00eang cho Google Drive kh\u00f4ng?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"<p>Kh\u00f4ng c\u1ea7n. Khi b\u1ea1n x\u00e1c th\u1ef1c t\u00e0i kho\u1ea3n Google v\u1edbi n8n v\u00e0 c\u1ea5p \u0111\u1ee7 quy\u1ec1n (scope) cho Google Drive, Credential \u0111\u00f3 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho c\u1ea3 hai node Google Sheets v\u00e0 Google Drive. Ch\u00fang d\u00f9ng chung m\u1ed9t h\u1ec7 th\u1ed1ng x\u00e1c th\u1ef1c.<\/p>\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"T\u1ea1i sao workflow c\u1ee7a t\u00f4i ch\u1ea1y th\u00e0nh c\u00f4ng nh\u01b0ng kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u n\u00e0o \u0111\u01b0\u1ee3c ghi v\u00e0o Google Sheets?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"<p>C\u00f3 hai nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn nh\u1ea5t:<\/p><ul><li><strong>Sai c\u1ea5u tr\u00fac d\u1eef li\u1ec7u:<\/strong> Node Google Sheets mong \u0111\u1ee3i m\u1ed9t m\u1ea3ng c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng (Array of Objects). N\u1ebfu d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o kh\u00f4ng \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng n\u00e0y, n\u00f3 c\u00f3 th\u1ec3 ch\u1ea1y \\\"th\u00e0nh c\u00f4ng\\\" nh\u01b0ng kh\u00f4ng th\u1ef1c hi\u1ec7n h\u00e0nh \u0111\u1ed9ng ghi. H\u00e3y d\u00f9ng node Set ho\u1eb7c Code \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng l\u1ea1i d\u1eef li\u1ec7u cho \u0111\u00fang.<\/li><li><strong>D\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o r\u1ed7ng:<\/strong> H\u00e3y ki\u1ec3m tra output c\u1ee7a node ngay tr\u01b0\u1edbc node Google Sheets. R\u1ea5t c\u00f3 th\u1ec3 node \u0111\u00f3 kh\u00f4ng tr\u1ea3 v\u1ec1 d\u1eef li\u1ec7u n\u00e0o, n\u00ean kh\u00f4ng c\u00f3 g\u00ec \u0111\u1ec3 ghi.<\/li><\/ul>\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Gi\u1edbi h\u1ea1n API c\u1ee7a Google Sheets l\u00e0 bao nhi\u00eau v\u00e0 l\u00e0m sao \u0111\u1ec3 kh\u00f4ng b\u1ecb v\u01b0\u1ee3t?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"<p>Gi\u1edbi h\u1ea1n ph\u1ed5 bi\u1ebfn l\u00e0 60 y\u00eau c\u1ea7u ghi m\u1ed7i ph\u00fat cho m\u1ed7i ng\u01b0\u1eddi d\u00f9ng. \u0110\u1ec3 tr\u00e1nh v\u01b0\u1ee3t gi\u1edbi h\u1ea1n khi x\u1eed l\u00fd nhi\u1ec1u d\u1eef li\u1ec7u, h\u00e3y g\u1ed9p c\u00e1c thao t\u00e1c. Thay v\u00ec d\u00f9ng v\u00f2ng l\u1eb7p \u0111\u1ec3 th\u00eam 100 d\u00f2ng (g\u1eedi 100 y\u00eau c\u1ea7u), h\u00e3y chu\u1ea9n b\u1ecb m\u1ed9t m\u1ea3ng ch\u1ee9a 100 d\u00f2ng \u0111\u00f3 v\u00e0 \u0111\u01b0a v\u00e0o node Google Sheets m\u1ed9t l\u1ea7n duy nh\u1ea5t. Node s\u1ebd t\u1ef1 \u0111\u1ed9ng g\u1eedi ch\u00fang trong m\u1ed9t y\u00eau c\u1ea7u h\u00e0ng lo\u1ea1t (batch request).<\/p>\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"L\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 workflow t\u1ef1 \u0111\u1ed9ng ch\u1ea1y m\u1ed7i khi c\u00f3 m\u1ed9t d\u00f2ng m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o Google Sheets?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"<p>H\u00e3y s\u1eed d\u1ee5ng node Google Sheet Trigger. Node n\u00e0y s\u1ebd l\u1eafng nghe c\u00e1c thay \u0111\u1ed5i tr\u00ean trang t\u00ednh b\u1ea1n ch\u1ec9 \u0111\u1ecbnh. M\u1ed7i khi c\u00f3 m\u1ed9t d\u00f2ng m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o (ho\u1eb7c c\u1eadp nh\u1eadt), n\u00f3 s\u1ebd t\u1ef1 \u0111\u1ed9ng k\u00edch ho\u1ea1t workflow c\u1ee7a b\u1ea1n v\u00e0 l\u1ea5y d\u1eef li\u1ec7u t\u1eeb d\u00f2ng \u0111\u00f3 l\u00e0m \u0111\u1ea7u v\u00e0o.<\/p>\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 x\u1eed l\u00fd l\u1ed7i m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng khi t\u00edch h\u1ee3p v\u1edbi Google Sheets (v\u00ed d\u1ee5: l\u1ed7i h\u1ebft h\u1ea1n x\u00e1c th\u1ef1c)?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"<p>H\u00e3y t\u1eadn d\u1ee5ng t\u00ednh n\u0103ng \\\"Error Workflow\\\" (Quy tr\u00ecnh x\u1eed l\u00fd l\u1ed7i) c\u1ee7a n8n. B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t workflow ri\u00eang chuy\u00ean \u0111\u1ec3 x\u1eed l\u00fd l\u1ed7i. Trong workflow ch\u00ednh, v\u00e0o m\u1ee5c Settings v\u00e0 ch\u1ec9 \u0111\u1ecbnh \\\"Error Workflow\\\". N\u1ebfu workflow ch\u00ednh g\u1eb7p l\u1ed7i (v\u00ed d\u1ee5: l\u1ed7i 403 do h\u1ebft h\u1ea1n token), n\u00f3 s\u1ebd t\u1ef1 \u0111\u1ed9ng k\u00edch ho\u1ea1t Error Workflow, cho ph\u00e9p b\u1ea1n g\u1eedi th\u00f4ng b\u00e1o qua Slack, email \u0111\u1ec3 c\u1ea3nh b\u00e1o v\u00e0 x\u1eed l\u00fd k\u1ecbp th\u1eddi.<\/p>\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t\t\t\t]\n\t}\n<\/script>\n","protected":false},"excerpt":{"rendered":"<p>Trong th\u1eddi \u0111\u1ea1i t\u1ef1 \u0111\u1ed9ng h\u00f3a, Google Sheet v\u00e0 Google Drive g\u1ea7n nh\u01b0 l\u00e0 \u201cx\u01b0\u01a1ng s\u1ed1ng\u201d trong vi\u1ec7c l\u01b0u tr\u1eef v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u. Khi k\u1ebft h\u1ee3p c\u00f9ng n8n, ch\u00fang tr\u1edf th\u00e0nh c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 x\u00e2y d\u1ef1ng quy tr\u00ecnh l\u00e0m vi\u1ec7c th\u00f4ng minh, ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 h\u1ea1n ch\u1ebf sai s\u00f3t. [&hellip;]<\/p>\n","protected":false},"author":23,"featured_media":119285,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7397],"tags":[7343],"class_list":["post-119270","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-n8n","tag-n8n"],"_links":{"self":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/posts\/119270","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/comments?post=119270"}],"version-history":[{"count":4,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/posts\/119270\/revisions"}],"predecessor-version":[{"id":119397,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/posts\/119270\/revisions\/119397"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/media\/119285"}],"wp:attachment":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/media?parent=119270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/categories?post=119270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/tags?post=119270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}