{"id":686,"date":"2026-05-18T21:05:59","date_gmt":"2026-05-18T13:05:59","guid":{"rendered":"https:\/\/junai.ai\/blog\/n8n-sheets-8\/"},"modified":"2026-05-18T21:36:47","modified_gmt":"2026-05-18T13:36:47","slug":"n8n-sheets-8","status":"publish","type":"post","link":"https:\/\/junai.ai\/blog\/n8n-sheets-8\/","title":{"rendered":"n8n Google Sheets \uc5f0\ub3d9 \u2014 \uc77d\uae30\u00b7\uc4f0\uae30 (Ch.8)"},"content":{"rendered":"\n<!-- WordPress REST API \ubc1c\ud589\uc6a9 HTML (\uc790\ub3d9 \uc0dd\uc131) -->\n<!-- WP-FEATURED-MEDIA-ID: 703 -->\n<div style=\"max-width:800px;margin:0 auto;\">\n<style>\n:root { --color-primary: #1e40af; --color-accent: #3b82f6; --color-bg: #fafafa; --color-bg-card: #fff; --color-text: #1e293b; --color-text-muted: #64748b; --hero-start: #0f172a; --hero-end: #1e40af; }\n* { box-sizing: border-box; }\n.container { max-width: 760px; margin: 0 auto; padding: 0 24px 80px; }\n.hero { background: linear-gradient(135deg, var(--hero-start) 0%, var(--hero-end) 100%); color: #fff; padding: 80px 24px 60px; text-align: center; }\n.hero .eyebrow { display: inline-block; font-size: 14px; color: #60a5fa; font-weight: 700; letter-spacing: 0.1em; text-transform: uppercase; margin-bottom: 14px; }\n.hero h1 { font-size: 36px; margin: 0 0 16px; line-height: 1.3; font-weight: 800; }\n.hero p { color: #cbd5e1; font-size: 18px; max-width: 640px; margin: 0 auto; line-height: 1.6; }\n.hero img { width: 100%; max-width: 640px; height: auto; margin: 32px auto 0; border-radius: 10px; display: block; }\narticle { padding-top: 48px; }\narticle h2 { font-size: 26px; margin: 56px 0 20px; padding-left: 14px; border-left: 5px solid var(--color-accent); line-height: 1.4; }\narticle p { margin: 16px 0; }\narticle strong { color: var(--color-primary); font-weight: 700; }\narticle code { background: #f1f5f9; padding: 2px 8px; border-radius: 4px; font-family: 'SF Mono', Menlo, monospace; font-size: 14px; color: #4338ca; }\n.databox { background: #eff6ff; border-left: 4px solid var(--color-accent); padding: 16px 20px; margin: 24px 0; border-radius: 0 8px 8px 0; font-size: 15.5px; }\n.databox strong { color: var(--color-primary); }\n.warnbox { background: linear-gradient(135deg, #fef3c7 0%, #fde68a 100%); padding: 16px 20px; margin: 24px 0; border-radius: 8px; font-size: 15.5px; }\n.warnbox strong { color: #b45309; }\n.step { margin: 22px 0; padding: 20px 22px; background: var(--color-bg-card); border: 1px solid #e2e8f0; border-radius: 12px; }\n.step-header { display: flex; align-items: center; gap: 14px; margin-bottom: 10px; }\n.step-num { display: inline-flex; align-items: center; justify-content: center; width: 36px; height: 36px; border-radius: 50%; background: var(--color-primary); color: #fff; font-weight: 800; font-size: 16px; flex-shrink: 0; }\n.step .step-title { margin: 0; font-size: 18px; font-weight: 700; color: var(--color-text); }\n.step p { margin: 10px 0; }\n.step p:first-of-type { margin-top: 0; }\n.cmd { background: #0f172a; color: #e2e8f0; padding: 14px 18px; border-radius: 8px; font-family: 'SF Mono', Menlo, monospace; font-size: 14px; overflow-x: auto; margin: 14px 0; line-height: 1.55; white-space: pre; }\n.cmd .p { color: #64748b; }\n.cmd .o { color: #94a3b8; display: block; }\n.cmd .c { color: #fbbf24; }\n.screenshot { margin: 24px 0; }\n.screenshot img { width: 100%; height: auto; border: 1px solid #e2e8f0; border-radius: 8px; display: block; box-shadow: 0 1px 4px rgba(0,0,0,0.06); }\n.screenshot figcaption { margin-top: 10px; font-size: 14.5px; color: var(--color-text-muted); text-align: center; }\n.cta { background: #0f172a; color: #fff; padding: 32px; border-radius: 12px; margin: 48px 0 0; text-align: center; }\n.cta h3 { color: #fff; margin: 0 0 10px; font-size: 20px; border: none; padding: 0; }\n.cta p { color: #cbd5e1; margin: 0 0 18px; }\n.cta a { display: inline-block; background: var(--color-accent); color: #fff; padding: 12px 26px; border-radius: 8px; text-decoration: none; font-weight: 700; }\n.tablewrap { overflow-x: auto; margin: 22px 0; }\ntable { width: 100%; border-collapse: collapse; font-size: 15px; background: var(--color-bg-card); }\nth, td { padding: 11px 12px; text-align: left; border-bottom: 1px solid #e2e8f0; vertical-align: top; }\nth { background: #f1f5f9; font-weight: 700; color: #0f172a; }\ntd:first-child, th:first-child { font-weight: 700; }\n@media (max-width: 560px) {\n  .tablewrap table, .tablewrap thead, .tablewrap tbody, .tablewrap tr, .tablewrap th, .tablewrap td { display: block; width: auto; }\n  .tablewrap thead { display: none; }\n  .tablewrap tr { margin: 0 0 14px; border: 1px solid #e2e8f0; border-radius: 10px; overflow: hidden; }\n  .tablewrap td { border: none; border-bottom: 1px solid #f1f5f9; padding: 9px 14px; }\n  .tablewrap td:first-child { background: #f1f5f9; font-weight: 800; }\n  .tablewrap td:last-child { border-bottom: none; }\n  .tablewrap td[data-label]::before { content: attr(data-label) \" \u2014 \"; font-weight: 700; color: var(--color-primary); }\n}\n@media (max-width: 480px) { .hero { padding: 56px 20px 40px; } .hero h1 { font-size: 26px; } .hero p { font-size: 16px; } article h2 { font-size: 22px; } body { font-size: 16px; } .container { padding: 0 18px 60px; } .step { padding: 16px 18px; } .cmd { font-size: 13px; } }\n<\/style>\n<header class=\"hero\">\n  <span class=\"eyebrow\">n8n \ud55c\uad6d\uc5b4 \uad50\uc7ac \u00b7 Ch.8<\/span>\n  <h1>Google Sheets \uc5f0\ub3d9 \u2014 \uc77d\uae30\u00b7\uc4f0\uae30<\/h1>\n  <p>\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8\ub294 \ube44\uacf5\uc2dd \ub370\uc774\ud130\ubca0\uc774\uc2a4. n8n \uc73c\ub85c \uc2dc\ud2b8\uc5d0 \uc790\ub3d9 \ud589 \ucd94\uac00, \ub610\ub294 \uc2dc\ud2b8\uc758 \ub370\uc774\ud130\ub97c \uc77d\uc5b4 \ub2e4\ub978 \ud750\ub984\uc73c\ub85c \u2014 OAuth \ud55c \ubc88 \uc124\uc815\ud558\uba74 \ud3c9\uc0dd \uc791\ub3d9.<\/p>\n  <img decoding=\"async\" src=\"https:\/\/junai.ai\/blog\/wp-content\/uploads\/2026\/05\/hero-5-8.jpg\" alt=\"Google Sheets \uc2dc\ud2b8\uc758 \ud589 \ub370\uc774\ud130 \uc2dc\uac01\ud654 \u2014 \uc774\ub984\u00b7\uc774\uba54\uc77c\u00b7\uae08\uc561 \uc5f4\">\n<\/header>\n\n<div class=\"container\">\n<article>\n\n<p>n8n \ud1b5\ud569 \ub178\ub4dc \uc911 \uac00\uc7a5 \uc790\uc8fc \uc4f0\uc774\ub294 \uac8c Google Sheets. \uc774\uc720\ub294 \uac04\ub2e8 \u2014 \ub204\uad6c\ub098 \uc2dc\ud2b8\ub97c \uc4f0\uace0, \ub370\uc774\ud130 \uc7a0\uc2dc \ubaa8\uc544\ub450\uae30\uc5d0 \uc2dc\ud2b8\ub9cc\ud07c \ud3b8\ud55c \uac8c \uc5c6\uc2b5\ub2c8\ub2e4. Webhook \uc73c\ub85c \ub4e4\uc5b4\uc628 \ub370\uc774\ud130\ub97c \uc2dc\ud2b8\uc5d0 \uc790\ub3d9 \ub204\uc801\ud558\uac70\ub098, \ub9e4\uc77c 9\uc2dc \uc2dc\ud2b8 \uac80\ud1a0 \ud6c4 \uc0c8 \ud589\ub9cc Slack \uc73c\ub85c \u2014 \uc774 \ub450 \ud328\ud134\uc774 95%.<\/p>\n\n<h2>Google Sheets \ub178\ub4dc\uc758 \ub450 \uc791\uc5c5 \u2014 \uc4f0\uae30 \/ \uc77d\uae30<\/h2>\n\n<div class=\"tablewrap\">\n<table>\n<thead><tr><th>\uc791\uc5c5<\/th><th>n8n \ub178\ub4dc Operation<\/th><th>\uc608\uc2dc<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>\ud589 \ucd94\uac00<\/td><td data-label=\"Operation\">Append Row<\/td><td data-label=\"\uc608\uc2dc\">Webhook \uc73c\ub85c \ub4e4\uc5b4\uc628 \uacb0\uc81c \uc815\ubcf4 \ub204\uc801<\/td><\/tr>\n<tr><td>\uc5ec\ub7ec \ud589 \ucd94\uac00<\/td><td data-label=\"Operation\">Append or Update Rows<\/td><td data-label=\"\uc608\uc2dc\">100\uac74 batch \uc5c5\ub85c\ub4dc<\/td><\/tr>\n<tr><td>\uc804\uccb4 \uc77d\uae30<\/td><td data-label=\"Operation\">Get Rows<\/td><td data-label=\"\uc608\uc2dc\">\ub9e4\uc77c 9\uc2dc \uc2dc\ud2b8 \uc804\uccb4 \uac80\ud1a0<\/td><\/tr>\n<tr><td>\ud2b9\uc815 \ud589 \uac80\uc0c9<\/td><td data-label=\"Operation\">Lookup<\/td><td data-label=\"\uc608\uc2dc\">\uc774\uba54\uc77c\ub85c \uc0ac\uc6a9\uc790 \uc815\ubcf4 \ucc3e\uae30<\/td><\/tr>\n<tr><td>\ud589 \uc5c5\ub370\uc774\ud2b8<\/td><td data-label=\"Operation\">Update Row<\/td><td data-label=\"\uc608\uc2dc\">\uc0c1\ud0dc \uceec\ub7fc\ub9cc &#8220;\ucc98\ub9ac\uc644\ub8cc&#8221; \ub85c<\/td><\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n\n<p>\uac00\uc7a5 \ud754\ud55c \ud328\ud134\uc740 <strong>Append Row<\/strong> (\ub204\uc801) \uc640 <strong>Get Rows<\/strong> (\uc804\uccb4 \uc77d\uae30). \uc774 \ub450 \uac1c\ub9cc \uc775\ud600\ub450\uba74 \uac70\uc758 \ubaa8\ub4e0 \uc2dc\ub098\ub9ac\uc624 \ucc98\ub9ac.<\/p>\n\n<h2>1\ub2e8\uacc4 \u2014 Google Sheets \ub178\ub4dc \ucd94\uac00<\/h2>\n\n<figure class=\"screenshot\">\n<img decoding=\"async\" src=\"https:\/\/junai.ai\/blog\/wp-content\/uploads\/2026\/05\/01-sheets-node-settings.png\" alt=\"\uaca9\ub9ac \uc778\uc2a4\ud134\uc2a4\uc5d0\uc11c 'What happens next?' \ud328\ub110\uc758 google sheets \uac80\uc0c9 \uacb0\uacfc \u2014 \uccab \ud56d\ubaa9 Google Sheets \ub178\ub4dc\">\n<figcaption>\uc774\uc804 \ub178\ub4dc\uc758 + \ud074\ub9ad \u2192 &#8220;google sheets&#8221; \uac80\uc0c9 \u2192 \uccab \uacb0\uacfc \ud074\ub9ad. \uc88c\uce21 \uce94\ubc84\uc2a4\uc5d0 Manual Trigger \uac00 \uc774\ubbf8 \uc788\ub294 \uc0c1\ud0dc.<\/figcaption>\n<\/figure>\n\n<div class=\"step\">\n<div class=\"step-header\"><span class=\"step-num\">1<\/span><div class=\"step-title\">\ud2b8\ub9ac\uac70 \ub2e4\uc74c \ub2e8\uacc4\ub85c \uac80\uc0c9<\/div><\/div>\n<p>Manual Trigger\u00b7Schedule\u00b7Webhook \uc5b4\ub290 \ud2b8\ub9ac\uac70 \ub2e4\uc74c\uc5d0\ub4e0 OK. \ud2b8\ub9ac\uac70 \ub178\ub4dc \uc6b0\uce21\uc758 + \ud45c\uc2dc \u2192 \uac80\uc0c9\ucc3d\uc5d0 <code>google sheets<\/code> \u2192 \uacb0\uacfc \ud074\ub9ad.<\/p>\n<\/div>\n\n<div class=\"step\">\n<div class=\"step-header\"><span class=\"step-num\">2<\/span><div class=\"step-title\">Operation \uc120\ud0dd \u2014 Append \ub610\ub294 Get<\/div><\/div>\n<p>\ub178\ub4dc \ucd94\uac00\ud558\uba74 \uc5b4\ub5a4 \uc791\uc5c5\uc744 \ud560\uc9c0 \ubb3c\uc5b4\uc694. \ucc98\uc74c \uc775\ud790 \ub550:<\/p>\n<ul>\n<li><strong>Append Row in Sheet<\/strong> \u2014 \uc0c8 \ud589 \ucd94\uac00<\/li>\n<li><strong>Get Row(s) in Sheet<\/strong> \u2014 \ud589 \uc77d\uae30<\/li>\n<\/ul>\n<p>\uac01\uac01 \ud558\ub098\uc529 \ub9cc\ub4e4\uc5b4\ubcf4\ub294 \uac8c \ud559\uc2b5 \uc21c\uc11c.<\/p>\n<\/div>\n\n<h2>2\ub2e8\uacc4 \u2014 OAuth credentials \uc124\uc815 (\ud55c \ubc88\ub9cc)<\/h2>\n\n<p>Google Sheets \ub294 Google \uacc4\uc815 \uad8c\ud55c\uc774 \ud544\uc694\ud574\uc11c OAuth \uc778\uc99d\uc744 \uac70\uce69\ub2c8\ub2e4. n8n \uc774 \ub3c4\uc640\uc8fc\uae34 \ud558\ub294\ub370, \uccab \ud55c \ubc88\uc740 \uc808\ucc28\uac00 \uc788\uc5b4\uc694.<\/p>\n\n<div class=\"step\">\n<div class=\"step-header\"><span class=\"step-num\">1<\/span><div class=\"step-title\">\ub178\ub4dc \ud328\ub110\uc5d0\uc11c Credential to connect with<\/div><\/div>\n<p><strong>&#8211; Create new credential<\/strong> \ud074\ub9ad. \ub450 \uc778\uc99d \ubc29\uc2dd \uc911 \uc120\ud0dd:<\/p>\n<ul>\n<li><strong>Google Sheets OAuth2 API<\/strong> \u2014 \uc77c\ubc18 \uc0ac\uc6a9\uc790\uc5d0\uac8c \uad8c\uc7a5. \ube0c\ub77c\uc6b0\uc800\ub85c Google \ub85c\uadf8\uc778 \ud55c \ubc88.<\/li>\n<li><strong>Service Account<\/strong> \u2014 \uc11c\ubc84\uc6a9. Google Cloud Console \uc5d0\uc11c \ud0a4 \ud30c\uc77c \ubc1b\uc544 \ub4f1\ub85d.<\/li>\n<\/ul>\n<\/div>\n\n<div class=\"step\">\n<div class=\"step-header\"><span class=\"step-num\">2<\/span><div class=\"step-title\">\uc140\ud504\ud638\uc2a4\ud305\uc778 \uacbd\uc6b0 \u2014 Redirect URI \ub4f1\ub85d<\/div><\/div>\n<p>\uc140\ud504\ud638\uc2a4\ud305 n8n \uc740 Google Cloud Console \uc5d0\uc11c OAuth client \uc9c1\uc811 \ub9cc\ub4e4\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<div class=\"cmd\"><span class=\"p\"># Google Cloud Console \u2192 APIs &#038; Services \u2192 Credentials<\/span>\n1. Create Credentials \u2192 <span class=\"c\">OAuth client ID<\/span>\n2. Application type: <span class=\"c\">Web application<\/span>\n3. Authorized redirect URIs \uc5d0 n8n \uc758 URL \ucd94\uac00:\n   <span class=\"c\">https:\/\/your-n8n-domain.com\/rest\/oauth2-credential\/callback<\/span>\n4. Client ID \uc640 Client Secret \ubc1b\uae30 \u2192 n8n \uc5d0 \ubd99\uc5ec\ub123\uae30<\/div>\n<p>n8n Cloud \uc0ac\uc6a9\uc790\ub294 \uc774 \uc808\ucc28 \uc0dd\ub7b5 \u2014 Cloud \uac00 \uc790\uccb4 OAuth client \uac00 \uc788\uc5b4\uc11c \uadf8\ub0e5 &#8220;Connect my account&#8221; \ud55c \ubc88.<\/p>\n<\/div>\n\n<div class=\"step\">\n<div class=\"step-header\"><span class=\"step-num\">3<\/span><div class=\"step-title\">Sign in with Google \u2192 \uad8c\ud55c \ud5c8\uc6a9<\/div><\/div>\n<p>\ube0c\ub77c\uc6b0\uc800 \ud31d\uc5c5 \u2192 \uc790\uc2e0\uc758 Google \uacc4\uc815\uc73c\ub85c \ub85c\uadf8\uc778 \u2192 &#8220;n8n\uc774 Sheets \uc5d0 \uc811\uadfc\ud558\ub824 \ud569\ub2c8\ub2e4&#8221; \ub3d9\uc758. \ud55c \ubc88\ub9cc \ud558\uba74 credentials \uc800\uc7a5\ub3fc\uc11c \ub2e4\ub978 \uc6cc\ud06c\ud50c\ub85c\uc5d0\uc11c\ub3c4 \uc7ac\uc0ac\uc6a9.<\/p>\n<\/div>\n\n<h2>3\ub2e8\uacc4 \u2014 Append Row \uc2e4\uc804 \uc608\uc81c<\/h2>\n\n<p>Webhook \uc73c\ub85c \ub4e4\uc5b4\uc628 \uacb0\uc81c \uc815\ubcf4\ub97c \uc2dc\ud2b8\uc5d0 \uc790\ub3d9 \ub204\uc801\ud558\ub294 \uc6cc\ud06c\ud50c\ub85c:<\/p>\n\n<div class=\"cmd\"><span class=\"c\">Webhook<\/span> (POST \/payment)\n   \u2193 body: { name: &#8220;\ubc15\uc900\uc131&#8221;, amount: 50000, plan: &#8220;Pro&#8221; }\n<span class=\"c\">Google Sheets<\/span> (Append Row)\n   &#8211; Document: \uacb0\uc81c\ub85c\uadf8.xlsx\n   &#8211; Sheet: Sheet1\n   &#8211; Columns:\n       \uc774\ub984:   <span class=\"c\">={{ $json.body.name }}<\/span>\n       \uae08\uc561:   <span class=\"c\">={{ $json.body.amount }}<\/span>\n       \ud50c\ub79c:   <span class=\"c\">={{ $json.body.plan }}<\/span>\n       \uc2dc\uac01:   <span class=\"c\">={{ $now.toFormat(&#8220;yyyy-MM-dd HH:mm&#8221;) }}<\/span><\/div>\n\n<p>\uc2e4\ud589\ud558\uba74 \uc2dc\ud2b8\uc758 \ub9c8\uc9c0\ub9c9 \ud589 \uc544\ub798\ub85c \uc790\ub3d9 \ucd94\uac00. <strong>Columns \ub9e4\ud551\uc774 \uc790\ub3d9<\/strong> \u2014 \uc2dc\ud2b8 \uccab \ud589\uc758 \ud5e4\ub354\uc640 \uac19\uc740 \uc774\ub984\uc758 \ud544\ub4dc\ub9cc \uc790\ub3d9 \ubc30\uc815. \ub354 \uc815\ud655\ud788 \ud558\ub824\uba74 \ub9e4\ud551 \ubaa8\ub4dc <code>Map Each Column Manually<\/code> \uc120\ud0dd.<\/p>\n\n<div class=\"warnbox\"><strong>\ud754\ud55c \uc2e4\uc218 \u2014 Document \uc120\ud0dd \uc2dc<\/strong><br>\uc2dc\ud2b8 URL \uc744 \uadf8\ub300\ub85c \ubd99\uc5ec\ub123\uc9c0 \ub9d0\uace0, \ub178\ub4dc\uc758 <strong>Document<\/strong> \ub4dc\ub86d\ub2e4\uc6b4\uc5d0\uc11c \ubcf8\uc778 \uacc4\uc815\uc758 \uc2dc\ud2b8 \ubaa9\ub85d\uc744 \uace8\ub77c\uc57c \ud569\ub2c8\ub2e4. URL \ubd99\uc5ec\ub123\uae30\ub294 \uc77c\ubd80 \ucf00\uc774\uc2a4\uc5d0\uc11c \uc2e4\ud328. \ub610 \uc2dc\ud2b8 \uc774\ub984 \ud55c\uad6d\uc5b4\uac00 \ub4e4\uc5b4\uac00\uba74 \uc2dc\ud2b8 ID \ubaa8\ub4dc\ub85c \ubc14\uafd4\uc11c \uc785\ub825 \uad8c\uc7a5.<\/div>\n\n<h2>4\ub2e8\uacc4 \u2014 Get Rows \ub85c \uc2dc\ud2b8 \uc77d\uae30 + \ud544\ud130\ub9c1<\/h2>\n\n<p>\ubc18\ub300 \ubc29\ud5a5 \u2014 \uc2dc\ud2b8\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc640 \ub2e4\ub978 \uacf3\uc73c\ub85c:<\/p>\n\n<div class=\"cmd\"><span class=\"c\">Schedule<\/span> (\ub9e4\uc77c 9\uc2dc)\n   \u2193\n<span class=\"c\">Google Sheets<\/span> (Get Rows)\n   &#8211; Operation: Get Row(s) in Sheet\n   &#8211; Filters: <span class=\"c\">\uc0c1\ud0dc = &#8220;\ubbf8\ubc1c\uc1a1&#8221;<\/span>\n   \u2193 \ubbf8\ubc1c\uc1a1 \ud589\ub4e4\uc774 items \ub85c \ubcc0\ud658\n<span class=\"c\">Send Email<\/span> (Run Once For Each Item)\n   &#8211; To:      <span class=\"c\">={{ $json.\uc774\uba54\uc77c }}<\/span>\n   &#8211; Subject: <span class=\"c\">={{ &#8220;\uc548\ub155 &#8221; + $json.\uc774\ub984 + &#8220;\ub2d8&#8221; }}<\/span><\/div>\n\n<p>Get Rows \uc758 <strong>Filters<\/strong> \uc635\uc158\uc774 \ud575\uc2ec. \uc804\uccb4 \ub2e4 \ubc1b\uc9c0 \ub9d0\uace0 \ubbf8\ubc1c\uc1a1 \ud589\ub9cc \uac00\uc838\uc624\uba74 \ud6a8\uc728 \u2191. n8n \uc774 \uc2dc\ud2b8 \uceec\ub7fc \uc774\ub984 \uc790\ub3d9 \uac10\uc9c0\ud574\uc11c \ub4dc\ub86d\ub2e4\uc6b4\uc73c\ub85c \uceec\ub7fc \uc120\ud0dd \uac00\ub2a5.<\/p>\n\n<div class=\"databox\"><strong>\uc2e4\ubb34 \ud301 \u2014<\/strong> Send Email \ud6c4 \uac19\uc740 \ud589\uc758 &#8220;\uc0c1\ud0dc&#8221; \uceec\ub7fc\uc744 &#8220;\ubc1c\uc1a1\uc644\ub8cc&#8221; \ub85c \uc5c5\ub370\uc774\ud2b8\ud558\ub294 \ub178\ub4dc\ub97c \ub9c8\uc9c0\ub9c9\uc5d0 \ub450\uba74 \ub2e4\uc74c \ub0a0 9\uc2dc \uc2e4\ud589 \ub54c \uc911\ubcf5 \ubc1c\uc1a1 \ubc29\uc9c0. <code>Update Row<\/code> \ub178\ub4dc + Row Number \ub9e4\uce6d\uc73c\ub85c \uad6c\ud604.<\/div>\n\n<p>\ub2e4\uc74c Ch.9 \uc5d0\uc11c\ub294 \uba54\uc77c \uc790\ub3d9 \ubc1c\uc1a1 \u2014 Gmail (OAuth) \uc640 SMTP (\uc11c\ube44\uc2a4 \uba54\uc77c) \ub450 \uae38\uc758 \ucc28\uc774, \ucca8\ubd80\ud30c\uc77c \ucc98\ub9ac, HTML \uba54\uc77c \ud15c\ud50c\ub9bf\uae4c\uc9c0 \ub2e4\ub8f9\ub2c8\ub2e4.<\/p>\n\n<div class=\"cta\">\n<h3>n8n \ud55c\uad6d\uc5b4 \uad50\uc7ac \u00b7 Ch.8 \uc644\ub8cc<\/h3>\n<p>\ub2e4\uc74c \ud3b8 \u2192 Ch.9 Gmail \u00b7 SMTP \uc790\ub3d9 \ubc1c\uc1a1<\/p>\n<a href=\"https:\/\/junai.ai\/blog\/category\/n8n\/\">\uc804\uccb4 \uc2dc\ub9ac\uc988 \ubcf4\uae30<\/a>\n<\/div>\n\n<\/article>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>n8n Google Sheets \ub178\ub4dc\ub85c \uc2dc\ud2b8 \uc790\ub3d9 \uc77d\uae30\u00b7\uc4f0\uae30. OAuth + Append + Get Rows \uc2e4\uc804 \ud328\ud134. \uae30\ucd08 Ch.8.<\/p>\n","protected":false},"author":1,"featured_media":703,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[],"class_list":["post-686","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-n8n"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/posts\/686","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/comments?post=686"}],"version-history":[{"count":2,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/posts\/686\/revisions"}],"predecessor-version":[{"id":717,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/posts\/686\/revisions\/717"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/media\/703"}],"wp:attachment":[{"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/media?parent=686"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/categories?post=686"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/junai.ai\/blog\/wp-json\/wp\/v2\/tags?post=686"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}