MCP 무제한 크롤링

✔️ n8n + MCP + Claude로 “웹 데이터 크롤링 자동화”를 완성하는 실전 튜토리얼! 코딩 부담 없이 20 분 만에 나만의 웹 데이터 수집 에이전트를 구축해 보세요! 이번 영상에서는, n8n 워크플로로 사이트별 크롤링‧파싱을 자동화하고 MCP으로 크롤링 결과를 에이전트에 전달, Claude가 데이터를 요약‧분석해 기획·마케팅 인사이트까지 제공하는 전 과정을 공개합니다.

Dec 18, 2022

웹 데이터 크롤링 자동화

 
notion image
 
  • 왜 웹 데이터 크롤링을 자동화해야 할까요?
 
단 20분 만에, 코딩 부담 없이 자신만의 웹 데이터 수집 에이전트를 구축하는 방법을 알아보세요! 이 실전 튜토리얼에서는 n8n, MCP, 그리고 Claude의 강력한 조합을 사용하여 웹 데이터 크롤링 자동화를 완벽하게 완성하는 방법을 공개합니다. 이 과정을 자동화하면 시간과 노력을 절약하고 데이터를 수동으로 수집하는 대신 활용하는 데 집중할 수 있습니다.
 
  • 자동화 워크플로 전체 과정
 
이 가이드는 전체 자동화 과정을 안내합니다. 먼저, n8n 워크플로를 사용하여 웹 데이터의 초기 수집 단계인 웹사이트 크롤링과 필요한 정보 파싱을 자동화하는 방법을 배우게 됩니다. n8n은 다양한 웹사이트에서 필요한 정보를 추출하기 위한 시각적이고 유연한 방법을 제공합니다.
다음으로, MCP는 크롤링된 결과를 분석 에이전트로 원활하게 전송하는 역할을 하여 데이터 분석 다음 단계를 준비합니다.
마지막으로, AI 모델인 Claude가 나섭니다. MCP를 통해 전달된 데이터가 요약되고 분석됩니다. Claude는 가공되지 않은 데이터를 실행 가능한 인사이트로 변환하여 전략 기획 및 마케팅 노력에 유용한 정보를 제공하는 데 핵심적인 역할을 합니다.
 
  • 이 자동화 시스템의 주요 이점
 
n8n, MCP, Claude를 통합함으로써 강력하고 효율적인 데이터 수집 및 분석 파이프라인을 구축할 수 있습니다. 주요 이점으로는 복잡한 코딩의 필요성 제거, 데이터 수집 설정에 필요한 시간 대폭 단축, 그리고 분석된 웹 데이터로부터 직접적으로 가치 있는 비즈니스 인사이트 확보가 포함됩니다. 이 시스템은 기술적 배경이 없는 사람들도 웹 데이터의 힘을 활용할 수 있도록 지원합니다.
 
  • Conclusion
n8n, MCP, Claude를 활용한 웹 데이터 크롤링 자동화를 완성함으로써, 데이터 수집 과정을 간소화하고 전례 없는 편리함으로 전략적 인사이트를 확보할 수 있습니다. 이러한 노코드(no-code) 접근 방식은 강력한 데이터 도구에 대한 접근성을 높여, 견고한 데이터 분석 기반의 기획 및 마케팅에 있어 경쟁 우위를 제공합니다.


 

참고 자료

1. 리뷰데이터 크롤링 서브 워크플로

코드보기
{ "name": "상품 리뷰데이터 스크랩", "nodes": [ { "parameters": { "command": "=curl 'https://www.coupang.com/vp/product/reviews?productId={{ $json.productNo }}&page=1&size=5&sortBy=ORDER_SCORE_ASC&ratings=&q=&viRoleCode=3&ratingSummary=true' \\\n -H 'accept: */*' \\\n -H 'accept-language: ko-KR,ko;q=0.9,en-US;q=0.8,en;q=0.7' \\\n -H 'cache-control: no-cache' \\\n -b 'PCID=17134864285659092236847; MARKETID=17134864285659092236847; _fbp=fb.1.1713486429371.779150919; gd1=Y; delivery_toggle=false; cf_clearance=fy0d7gC.LwnSWWKi3u8AqtjjuYGJFRBcn1dDXm0jbic-1726618118-1.2.1.1-XG4FN2rOhgk_DItwEd7KkKTn874ZbKzdpavkO9uEk4xX8TTwse7DX8f6TSJV_adVFWvKFzhsA.mglW0Om0P6JbsXrLClwunSvhrr8kiRTkUddX0i4WtQzbWY4HYMTldEWdo.oSudlCRavaXcyrV5XUFDEpHfkUPbcOccki_d6c47T6FKu5gPekeU6dgFsrk.QfNEutCe3gPUyj2rQovb0gIJ.NFIZGOik0TbP5niC3l0SPe_altcEhGckSACEEmuyVvjDIf3u3hXqcJG_FrbACFlzaQDLUw_GxLwrV.UejoSgBVJDSggFIKZYTq.HTnIcpNdqzh1cEzTeqWSNVSkRd1JmXNXy54whwrKDRYYUn1cXC7JCq13SnIDHxxFnTgLdLd6GGC0QocRPY5l_A9gfg; rememberme=true; x-coupang-accept-language=ko-KR; x-coupang-target-market=KR; CPUSR_RL=JktEyDAxYdu0EFDRJhJff9VbZMnq000Sc%2FNei%2Fwwn%2Bm%2FETlHt0Z2s6%2FDkbZnXybRIOyWBYoJPBtjid3d2t6HLluNK5BSCDCFSIAfMXNQdFt%2FKwx7FWcAK5odfwllwKJwuqJSYVJIVxOimIkhBJ1%2FKrDX844ofNV%2BVJEU6f3%2B2kuNeLd%2Fu3IHRt0twYxTiogmc8a97XkY2QT09JjTUnB45YnG8IP5iIzoa%2Bt7DO9d0RsYfMpXySFRBQ%3D%3D; CSID=DUM_eNx520chtJPCNtm3eJp.0hf0gpmf; CUPT=DUM__NQ4Mugz38Xb5Gxv70iC-HnkCmZVfGSaSkIQpuxE4Ak; CT_LSID=be4c270062e2628b8748f56375be60c89a1df7bd63c601e426046e07a0263ec0; member_srl=35234972; CT_AT=eyJraWQiOiJjMjM3NDM1OC1lYzZlLTRkNjgtOTFlNS0zMjVkM2I4YjVkMmMiLCJ0eXAiOiJKV1QiLCJhbGciOiJFUzI1NiJ9.eyJleHQiOnsiTFNJRCI6ImFkZjRhZTdjLTViMzItNGY5OC1hNTcwLWYxMWQxYmYzNzE4MiIsIk5PTkNFIjoiMWUwNjgyYmI0MWQwNGNkYTljYWNkOTZlZmI1NTYzMmQiLCJmaWF0IjoxLjc0Mzk3MjQ5NEU5LCJGQUdFIjoiNyJ9LCJzdWIiOiIzNTIzNDk3MiIsImF1ZCI6WyJodHRwczovL3d3dy5jb3VwYW5nLmNvbSIsIi0iXSwic2NwIjpbIm9wZW5pZCIsIm9mZmxpbmUiLCJjb3JlIiwiY29yZS1zaGFyZWQiLCJwYXkiXSwibmJmIjoxNzQ2MDE4MDIxLCJpc3MiOiJodHRwczovL21hdXRoLmNvdXBhbmcuY29tLyIsImV4cCI6MTc0NjAzMjQyMSwiaWF0IjoxNzQ2MDE4MDIxLCJqdGkiOiJjOTUzYjQ0OS1hZWNkLTQ0OWEtYjk2NC0xNDI3Mjc0YjEzNGEiLCJjbGllbnRfaWQiOiI0ZTJlMDJjOC03NDU2LTRiZDQtOWM3NS01Yjk4ZjIwNTgzODIifQ.Pk7Z8D1LEfn5OwqiL1UUTs3vTJM2yC4i_DTWxF0tfVmI7h5cuApFyXreOwVoniNfNZAWhrGKFEGNeVlQ7f3i0A; ILOGIN=Y; sid=9911e06e465540149365674665b6ad206336366c; searchKeyword=%EB%B0%B1%ED%8C%A9%7C%EB%82%A8%EC%84%B1%20%EC%8A%A4%ED%82%A8; searchKeywordType=%7B%22%EB%B0%B1%ED%8C%A9%22%3A0%7D%7C%7B%22%EB%82%A8%EC%84%B1%20%EC%8A%A4%ED%82%A8%22%3A0%7D; trac_src=0; trac_spec=0; trac_addtag=0; trac_ctag=\"\"; trac_lptag=\"\"; trac_itime=\"\"; trac_sid=\"\"; trac_appver=\"\"; _abck=944E3A428719982F5654F0EAD520FBC9~0~YAAQx+Q1F8ElKYaWAQAAP//5hg32UUWft+4VJpfoCqEvYMzh8XF9E87GNqfN7nfOXjZDknJQs4f22MJWlnTfPo+7VwXFwaU2eNb2IxDN9xFkbs36w0cWv5ga7azFygd4vB8y2giFDcVRIpLljH37jucWPyUVCF0/ht4XirzmQAdRotuiucgegBRogZyKDEpitpWbRX6oze51Vs3xVR8hDJBrkwPa6V4001lGaVg+BeE+1bJPGI1+9oTJAuj0MTKcQgWARcPPPFTRilIM4Ed7Tf8WjQV9VLQUm7rr5jsYLgG5o1zgVhSBpaA8GMPA3XUIxqmyh9knTo2Cq6PwtZqnmH7g22wp7CytkEGsU/VUmnp6+5nfq9lnHnYtOzEIYwqzENh71KTHfl45w8T8SMVE2VNVw1km/cVR4SHv5QBcCG8k7xJTciFj2gI1AbtXSgbJ+WEVW1GRkTkDwRwieF4qlgc+dpragvALZiaaUiEpsPzwwNAGNs/SxCDPdWmv8lGO59KfJ02uHphgT6QfHVns+NxD8vilpI16NRkIUA8kqLI2k1HBC8o2/iwDdpc2lgh8fQ4PNTHXE/Fb6H2VEBlKW/epY49WocUstrrQYJagcfeGK0a7DJ8RIh20dQmiVXPM+sUUymolB4BJAX89NpfKtLsMDSwqs/wmJEMsiPcZ7uKbkHTSEJDlBZHueAtKWpkDLgW748OXZw+aqpzz57SHz5nsCLjzJ0ru+hmmImmlsoBe4wmfN1dVdOvnz9pZyec=~-1~-1~-1; bm_sz=DCBA45E24BB9AE509E53E1D8D6E7730E~YAAQV+Q1F/oIJYaWAQAAPzH9hhsE6SRfmO9aJ7UZpo23WM84ppHzkklfxsOmlCby0nfFuqQfF1TJwJGagEAx5Zr3PSQdW78h91vgHeSap7WXxRBob4/vxRJAJn5Dd32Agld/zxkxf+uP3tHsMhBpvtSSJ76VbiSWZIac27kbQHAZk2A6CopqnTyI91g7oJZ8c9iyPfx8zFfYAE0zT+O1pK9hhJcCCY7XWOvwC/bxb+vw/sTT5/t51tsTZ4lVnplRz4M747GSMxOcMo5Q/lZXevCqPTXflZsGc7oMBS3ukgS7QsNydz9Nf7VSMn9CVUyeOv5+PTww0Xm9IZDfKcdcKqqSHlqNA3+QwrQd4uiUdlB+XbJPy0hLqnnhV6B6hQjji2/Mqfo2+aPLCvYQEUzCoCOBRGuf6LvAymY41+EdLnq+27iQtqxDT4W9cqt79NOn5WekWkNK8MfJZXptd2vkDp1+jQ==~4535600~3487539; cto_bundle=GqKP5F9tVm9UbTdrN25ZWiUyQjREWTUwRHNNcElEUW5GRTNTRFREZEk2WkF4TFB5bW1sRHVIbUU0WHR5dG4lMkYlMkJiN1d5WCUyQm5tdVJHWndRU25MdGhLT1FsRUVJeXpXRUt4M0xqdmJTblpNcXN4JTJGRDB1M0c2YVVBQyUyRmpxc09ZUk5QbFFxRDMlMkYyMXpGaWN2NjhlQzNPWXluNzhGcjZhZnJWc3c3OTFKRyUyRlNvYkpCemhFV3pGbjZmQm1sWnZkZWp4YmpySHpSJTJGWHJkREtQRXhocCUyRk5Qd1VuYnlYbFF3aEElM0QlM0Q; bm_lso=CFB7E7E89D2C71E50F45ADB3368826391AA5DDDFDDB8D26C10E214FCC04DDF68~YAAQV+Q1F0sKJYaWAQAAdzb9hgPkv2mXr8d3wYDM2hWLTKL0VG8yzRDopjAETqx1SJaGohOjP/nsGGHAfq+HsIAIdWgtaRQfNVrBpNKGBGxefFBejXZxopUoR5LQb6FmwnNcNW1gPcVvw7CQopMuxeuuqKzILsSiGpY2ojnk+yqe0apCq6b9g6T0ybnxNuguKSw8jo3RQyO2rKQ7fliOwwlnGiJngc76GgEEhBl+Zvbrlc/xZft7uZh60pAPsBp2KoeVwkw2Ib7hb6b0zDmU9lRzxMIzbJ9mIouLuFS+T81ZwzSD9hLV9JfMTsRnqdPXBwkxD9C4CQVNm13BSXz8Ovg/shdyE7bH6sgy0OG37LW/k0bHNBg8uvEBqdlSPjZwJ8sdKqG41bz7TPRrDnMZWEa84XbYpfolOzXM7LW03g3pfI5R8tuPfmiabDHZsk3ZXsLCSXb60rKlfMb+Fns=^1746021463896; bm_s=YAAQf9ojFxUuEXGWAQAAegn/hgOv5AbHprJTtddv+jdlJ4cVFDMURt2QFkO2UKNRdIgOTK7SCdi+uZ6CWi36uqKE62hzcOwdvNh6zvwHVbns1DqXqYwQiP7V1FsFRSXtslegpRjM2cCyRpfvnVaTdoEvhYxPL8vJkLBYQd0gANIFtsVBuOECPnbBsBLlTDC1YtC3DpRFA8dGyjpZxRC4ypaUqs7DIcwP0lwAisGXIXauzXaVxTDYRsXrnSSxrJ5swEkcmcbbOIodNu4la28iJsXDgWkxmNHgIPr2yEdxDZMuODIqgUsz7CWPBPwlKyizz3Mdj0R5L1P3eIBRVpIeVDkBZ+q5008jlFgHjdyEbnZswveB3OZ49zz/k/rTQcGIcOSxYXYNu2lPrTUcZE6KCiRTvYKudWelMElA5g9t1N5pCE09T29JD+LZ4Ar+Nvv9FghMRxdeAz+6Y7clKU2xpJei2/ay9vn8; bm_so=9A4855DB872EECC0FE459351F92B12BA07F7F8C829D23CF7CBF7D533D437304E~YAAQf9ojFxYuEXGWAQAAegn/hgM4UTSTmRf+tMofGUUda4keSuO3zsK2RNafEcjoAaXt5pR57cISVQIU3qZN4+PzrBKWjSUjEAFes+BA/g/jmkS0UavWJwim8x6ufVYiXGbV2EV2Y6sI08S1xLIz2EBmAG7GO7/pAhd9oDyD9xu2ZxSFfOA5ALuWFRVGillrbFMvuV/9MY3OHTKrVp8obGpsU20ILqCwF4GJdcDZ/k9BNeETZKLYmy62IZqOszcz8oyyRB4nXh9t2unxUY3B2qSKSo4h2wV3rpFlcq+Nf6VJDJoOow9e/a/lvaCqnrCHojOaXvdnskRA0ArJhCXt7f4DrcVB89VuxHxkJv4Eh/XK6VRD3VLVADMUAXbB/S4QKGFAe6oC2k5c5OA4oHFjkU5/RQVrvk7DV8yPyijaeMCemkeQavJSZESeigv1upvkYsxG5oJpyWdmnAtomcs=; baby-isWide=wide; web-session-id=dc3db872-6985-4fca-b391-bf308692fa54' \\\n -H 'pragma: no-cache' \\\n -H 'priority: u=1, i' \\\n -H 'referer: https://www.coupang.com/vp/products/7856132617?itemId=21426210870&vendorItemId=88316309236&sourceType=srp_product_ads&clickEventId=096ca7f0-25cb-11f0-8f4f-95d41a1ed88b&korePlacement=15&koreSubPlacement=1&q=%EB%82%A8%EC%84%B1+%EC%8A%A4%ED%82%A8&itemsCount=36&searchId=51a6d0d92058873&rank=0&searchRank=0&isAddedCart=' \\\n -H 'sec-ch-ua: \"Google Chrome\";v=\"135\", \"Not-A.Brand\";v=\"8\", \"Chromium\";v=\"135\"' \\\n -H 'sec-ch-ua-mobile: ?0' \\\n -H 'sec-ch-ua-platform: \"macOS\"' \\\n -H 'sec-fetch-dest: empty' \\\n -H 'sec-fetch-mode: cors' \\\n -H 'sec-fetch-site: same-origin' \\\n -H 'user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36' \\\n -H 'x-requested-with;'" }, "type": "n8n-nodes-base.executeCommand", "typeVersion": 1, "position": [ 220, 20 ], "id": "74b71fc4-3bc3-42a8-8dd3-1a47b091a7df", "name": "Execute Command" }, { "parameters": { "operation": "extractHtmlContent", "dataPropertyName": "stdout", "extractionValues": { "values": [ { "key": "review", "cssSelector": ".sdp-review__article__list", "returnValue": "html", "returnArray": true } ] }, "options": {} }, "type": "n8n-nodes-base.html", "typeVersion": 1.2, "position": [ 1640, 20 ], "id": "e65a5022-2258-41c1-ac65-cd9e45dfd509", "name": "1차 파싱" }, { "parameters": { "fieldToSplitOut": "review", "options": {} }, "type": "n8n-nodes-base.splitOut", "typeVersion": 1, "position": [ 1860, 20 ], "id": "5847ad1e-37d0-4f8a-a0c1-6d935c9d571d", "name": "Split Out" }, { "parameters": { "operation": "extractHtmlContent", "dataPropertyName": "review", "extractionValues": { "values": [ { "key": "username", "cssSelector": ".sdp-review__article__list__info__user__name" }, { "key": "productName", "cssSelector": ".sdp-review__article__list__info__product-info__name" }, { "key": "rating", "cssSelector": ".sdp-review__article__list__info__product-info__star-orange", "returnValue": "attribute", "attribute": "data-rating" }, { "key": "review", "cssSelector": ".sdp-review__article__list__review__content" }, { "key": "survey", "cssSelector": ".sdp-review__article__list__survey" }, { "key": "date", "cssSelector": ".sdp-review__article__list__info__product-info__reg-date" } ] }, "options": {} }, "type": "n8n-nodes-base.html", "typeVersion": 1.2, "position": [ 2080, 20 ], "id": "7dcf6f56-1462-42a2-ba95-73474e6b4eaa", "name": "2차 파싱" }, { "parameters": { "jsCode": "return {\n data : $input.all().map(e => Object.values(e.json)),\n productNo: $('Loop Over Items').first().json.productNo\n}" }, "type": "n8n-nodes-base.code", "typeVersion": 2, "position": [ 2300, 20 ], "id": "09cdfdaf-3fa8-49ab-8665-e98e0d88573f", "name": "전처리" }, { "parameters": { "method": "POST", "url": "=https://sheets.googleapis.com/v4/spreadsheets/1EAm3rTmvNl4ZRQkdYovUdfIYrrtseUr2dJlEihCISfI/values/{{ $json.productNo }}!A2:F2:append?valueInputOption=USER_ENTERED", "authentication": "predefinedCredentialType", "nodeCredentialType": "googleSheetsOAuth2Api", "sendHeaders": true, "headerParameters": { "parameters": [ { "name": "Content-Type", "value": "application/x-www-form-urlencoded" } ] }, "sendBody": true, "contentType": "raw", "rawContentType": "application/json", "body": "={{ {\"values\" : $json.data } }}", "options": {} }, "type": "n8n-nodes-base.httpRequest", "typeVersion": 4.2, "position": [ 2520, 20 ], "id": "1aa68cdd-7fc0-4e3a-8efe-cb8b577ab495", "name": "리뷰 데이터 입력", "credentials": { "googleSheetsOAuth2Api": { "id": "RPDt3rL1xfWaPW5s", "name": "Google Sheets account" } } }, { "parameters": { "method": "POST", "url": "=https://sheets.googleapis.com/v4/spreadsheets/1EAm3rTmvNl4ZRQkdYovUdfIYrrtseUr2dJlEihCISfI/values/{{ $json.title }}!A1:F1:append?valueInputOption=USER_ENTERED", "authentication": "predefinedCredentialType", "nodeCredentialType": "googleSheetsOAuth2Api", "sendHeaders": true, "headerParameters": { "parameters": [ { "name": "Content-Type", "value": "application/x-www-form-urlencoded" } ] }, "sendBody": true, "contentType": "raw", "rawContentType": "application/json", "body": "={{ {\"values\" : [[\"username\", \"productName\",\t\"rating\",\t\"review\",\t\"survey\",\t\"date\"]] } }}", "options": {} }, "type": "n8n-nodes-base.httpRequest", "typeVersion": 4.2, "position": [ 440, -180 ], "id": "efff43db-c213-4ef7-8b7c-d4bc41bc319d", "name": "리뷰 데이터 헤더 입력", "credentials": { "googleSheetsOAuth2Api": { "id": "RPDt3rL1xfWaPW5s", "name": "Google Sheets account" } } }, { "parameters": { "operation": "extractHtmlContent", "dataPropertyName": "stdout", "extractionValues": { "values": [ { "key": "reviewCount", "cssSelector": ".sdp-review__article__list__hidden-rating", "returnValue": "html" } ] }, "options": {} }, "type": "n8n-nodes-base.html", "typeVersion": 1.2, "position": [ 440, 20 ], "id": "b23a0a56-05df-4658-a8b5-1bbdf5ea6b92", "name": "HTML" }, { "parameters": { "jsCode": "const numbers = $input.first().json.reviewCount.match(/\\d+/g);\n\nconst sum = numbers.map(Number).reduce((a, b) => a+ b , 0);\n\nconst pageCount = parseInt(sum / 30) + 1;\n\nreturn {\n pageNo : Array(pageCount).fill(1).map((_, i) => i + 1),\n productNo : $('상품 번호 입력').first().json.productNo\n}" }, "type": "n8n-nodes-base.code", "typeVersion": 2, "position": [ 660, 20 ], "id": "203e5573-8631-4c7a-afd0-adbf5397e416", "name": "페이지수 계산" }, { "parameters": { "executeOnce": false, "command": "=curl 'https://www.coupang.com/vp/product/reviews?productId={{ $json.productNo }}&page=&size=30&size=5&sortBy=ORDER_SCORE_ASC&ratings=&q=&viRoleCode=3&ratingSummary=true' \\\n -H 'accept: */*' \\\n -H 'accept-language: ko-KR,ko;q=0.9,en-US;q=0.8,en;q=0.7' \\\n -H 'cache-control: no-cache' \\\n -b 'PCID=17134864285659092236847; MARKETID=17134864285659092236847; _fbp=fb.1.1713486429371.779150919; gd1=Y; delivery_toggle=false; cf_clearance=fy0d7gC.LwnSWWKi3u8AqtjjuYGJFRBcn1dDXm0jbic-1726618118-1.2.1.1-XG4FN2rOhgk_DItwEd7KkKTn874ZbKzdpavkO9uEk4xX8TTwse7DX8f6TSJV_adVFWvKFzhsA.mglW0Om0P6JbsXrLClwunSvhrr8kiRTkUddX0i4WtQzbWY4HYMTldEWdo.oSudlCRavaXcyrV5XUFDEpHfkUPbcOccki_d6c47T6FKu5gPekeU6dgFsrk.QfNEutCe3gPUyj2rQovb0gIJ.NFIZGOik0TbP5niC3l0SPe_altcEhGckSACEEmuyVvjDIf3u3hXqcJG_FrbACFlzaQDLUw_GxLwrV.UejoSgBVJDSggFIKZYTq.HTnIcpNdqzh1cEzTeqWSNVSkRd1JmXNXy54whwrKDRYYUn1cXC7JCq13SnIDHxxFnTgLdLd6GGC0QocRPY5l_A9gfg; rememberme=true; x-coupang-accept-language=ko-KR; x-coupang-target-market=KR; CPUSR_RL=JktEyDAxYdu0EFDRJhJff9VbZMnq000Sc%2FNei%2Fwwn%2Bm%2FETlHt0Z2s6%2FDkbZnXybRIOyWBYoJPBtjid3d2t6HLluNK5BSCDCFSIAfMXNQdFt%2FKwx7FWcAK5odfwllwKJwuqJSYVJIVxOimIkhBJ1%2FKrDX844ofNV%2BVJEU6f3%2B2kuNeLd%2Fu3IHRt0twYxTiogmc8a97XkY2QT09JjTUnB45YnG8IP5iIzoa%2Bt7DO9d0RsYfMpXySFRBQ%3D%3D; CSID=DUM_eNx520chtJPCNtm3eJp.0hf0gpmf; CUPT=DUM__NQ4Mugz38Xb5Gxv70iC-HnkCmZVfGSaSkIQpuxE4Ak; CT_LSID=be4c270062e2628b8748f56375be60c89a1df7bd63c601e426046e07a0263ec0; member_srl=35234972; CT_AT=eyJraWQiOiJjMjM3NDM1OC1lYzZlLTRkNjgtOTFlNS0zMjVkM2I4YjVkMmMiLCJ0eXAiOiJKV1QiLCJhbGciOiJFUzI1NiJ9.eyJleHQiOnsiTFNJRCI6ImFkZjRhZTdjLTViMzItNGY5OC1hNTcwLWYxMWQxYmYzNzE4MiIsIk5PTkNFIjoiMWUwNjgyYmI0MWQwNGNkYTljYWNkOTZlZmI1NTYzMmQiLCJmaWF0IjoxLjc0Mzk3MjQ5NEU5LCJGQUdFIjoiNyJ9LCJzdWIiOiIzNTIzNDk3MiIsImF1ZCI6WyJodHRwczovL3d3dy5jb3VwYW5nLmNvbSIsIi0iXSwic2NwIjpbIm9wZW5pZCIsIm9mZmxpbmUiLCJjb3JlIiwiY29yZS1zaGFyZWQiLCJwYXkiXSwibmJmIjoxNzQ2MDE4MDIxLCJpc3MiOiJodHRwczovL21hdXRoLmNvdXBhbmcuY29tLyIsImV4cCI6MTc0NjAzMjQyMSwiaWF0IjoxNzQ2MDE4MDIxLCJqdGkiOiJjOTUzYjQ0OS1hZWNkLTQ0OWEtYjk2NC0xNDI3Mjc0YjEzNGEiLCJjbGllbnRfaWQiOiI0ZTJlMDJjOC03NDU2LTRiZDQtOWM3NS01Yjk4ZjIwNTgzODIifQ.Pk7Z8D1LEfn5OwqiL1UUTs3vTJM2yC4i_DTWxF0tfVmI7h5cuApFyXreOwVoniNfNZAWhrGKFEGNeVlQ7f3i0A; ILOGIN=Y; sid=9911e06e465540149365674665b6ad206336366c; searchKeyword=%EB%B0%B1%ED%8C%A9%7C%EB%82%A8%EC%84%B1%20%EC%8A%A4%ED%82%A8; searchKeywordType=%7B%22%EB%B0%B1%ED%8C%A9%22%3A0%7D%7C%7B%22%EB%82%A8%EC%84%B1%20%EC%8A%A4%ED%82%A8%22%3A0%7D; trac_src=0; trac_spec=0; trac_addtag=0; trac_ctag=\"\"; trac_lptag=\"\"; trac_itime=\"\"; trac_sid=\"\"; trac_appver=\"\"; _abck=944E3A428719982F5654F0EAD520FBC9~0~YAAQx+Q1F8ElKYaWAQAAP//5hg32UUWft+4VJpfoCqEvYMzh8XF9E87GNqfN7nfOXjZDknJQs4f22MJWlnTfPo+7VwXFwaU2eNb2IxDN9xFkbs36w0cWv5ga7azFygd4vB8y2giFDcVRIpLljH37jucWPyUVCF0/ht4XirzmQAdRotuiucgegBRogZyKDEpitpWbRX6oze51Vs3xVR8hDJBrkwPa6V4001lGaVg+BeE+1bJPGI1+9oTJAuj0MTKcQgWARcPPPFTRilIM4Ed7Tf8WjQV9VLQUm7rr5jsYLgG5o1zgVhSBpaA8GMPA3XUIxqmyh9knTo2Cq6PwtZqnmH7g22wp7CytkEGsU/VUmnp6+5nfq9lnHnYtOzEIYwqzENh71KTHfl45w8T8SMVE2VNVw1km/cVR4SHv5QBcCG8k7xJTciFj2gI1AbtXSgbJ+WEVW1GRkTkDwRwieF4qlgc+dpragvALZiaaUiEpsPzwwNAGNs/SxCDPdWmv8lGO59KfJ02uHphgT6QfHVns+NxD8vilpI16NRkIUA8kqLI2k1HBC8o2/iwDdpc2lgh8fQ4PNTHXE/Fb6H2VEBlKW/epY49WocUstrrQYJagcfeGK0a7DJ8RIh20dQmiVXPM+sUUymolB4BJAX89NpfKtLsMDSwqs/wmJEMsiPcZ7uKbkHTSEJDlBZHueAtKWpkDLgW748OXZw+aqpzz57SHz5nsCLjzJ0ru+hmmImmlsoBe4wmfN1dVdOvnz9pZyec=~-1~-1~-1; bm_sz=DCBA45E24BB9AE509E53E1D8D6E7730E~YAAQV+Q1F/oIJYaWAQAAPzH9hhsE6SRfmO9aJ7UZpo23WM84ppHzkklfxsOmlCby0nfFuqQfF1TJwJGagEAx5Zr3PSQdW78h91vgHeSap7WXxRBob4/vxRJAJn5Dd32Agld/zxkxf+uP3tHsMhBpvtSSJ76VbiSWZIac27kbQHAZk2A6CopqnTyI91g7oJZ8c9iyPfx8zFfYAE0zT+O1pK9hhJcCCY7XWOvwC/bxb+vw/sTT5/t51tsTZ4lVnplRz4M747GSMxOcMo5Q/lZXevCqPTXflZsGc7oMBS3ukgS7QsNydz9Nf7VSMn9CVUyeOv5+PTww0Xm9IZDfKcdcKqqSHlqNA3+QwrQd4uiUdlB+XbJPy0hLqnnhV6B6hQjji2/Mqfo2+aPLCvYQEUzCoCOBRGuf6LvAymY41+EdLnq+27iQtqxDT4W9cqt79NOn5WekWkNK8MfJZXptd2vkDp1+jQ==~4535600~3487539; cto_bundle=GqKP5F9tVm9UbTdrN25ZWiUyQjREWTUwRHNNcElEUW5GRTNTRFREZEk2WkF4TFB5bW1sRHVIbUU0WHR5dG4lMkYlMkJiN1d5WCUyQm5tdVJHWndRU25MdGhLT1FsRUVJeXpXRUt4M0xqdmJTblpNcXN4JTJGRDB1M0c2YVVBQyUyRmpxc09ZUk5QbFFxRDMlMkYyMXpGaWN2NjhlQzNPWXluNzhGcjZhZnJWc3c3OTFKRyUyRlNvYkpCemhFV3pGbjZmQm1sWnZkZWp4YmpySHpSJTJGWHJkREtQRXhocCUyRk5Qd1VuYnlYbFF3aEElM0QlM0Q; bm_lso=CFB7E7E89D2C71E50F45ADB3368826391AA5DDDFDDB8D26C10E214FCC04DDF68~YAAQV+Q1F0sKJYaWAQAAdzb9hgPkv2mXr8d3wYDM2hWLTKL0VG8yzRDopjAETqx1SJaGohOjP/nsGGHAfq+HsIAIdWgtaRQfNVrBpNKGBGxefFBejXZxopUoR5LQb6FmwnNcNW1gPcVvw7CQopMuxeuuqKzILsSiGpY2ojnk+yqe0apCq6b9g6T0ybnxNuguKSw8jo3RQyO2rKQ7fliOwwlnGiJngc76GgEEhBl+Zvbrlc/xZft7uZh60pAPsBp2KoeVwkw2Ib7hb6b0zDmU9lRzxMIzbJ9mIouLuFS+T81ZwzSD9hLV9JfMTsRnqdPXBwkxD9C4CQVNm13BSXz8Ovg/shdyE7bH6sgy0OG37LW/k0bHNBg8uvEBqdlSPjZwJ8sdKqG41bz7TPRrDnMZWEa84XbYpfolOzXM7LW03g3pfI5R8tuPfmiabDHZsk3ZXsLCSXb60rKlfMb+Fns=^1746021463896; bm_s=YAAQf9ojFxUuEXGWAQAAegn/hgOv5AbHprJTtddv+jdlJ4cVFDMURt2QFkO2UKNRdIgOTK7SCdi+uZ6CWi36uqKE62hzcOwdvNh6zvwHVbns1DqXqYwQiP7V1FsFRSXtslegpRjM2cCyRpfvnVaTdoEvhYxPL8vJkLBYQd0gANIFtsVBuOECPnbBsBLlTDC1YtC3DpRFA8dGyjpZxRC4ypaUqs7DIcwP0lwAisGXIXauzXaVxTDYRsXrnSSxrJ5swEkcmcbbOIodNu4la28iJsXDgWkxmNHgIPr2yEdxDZMuODIqgUsz7CWPBPwlKyizz3Mdj0R5L1P3eIBRVpIeVDkBZ+q5008jlFgHjdyEbnZswveB3OZ49zz/k/rTQcGIcOSxYXYNu2lPrTUcZE6KCiRTvYKudWelMElA5g9t1N5pCE09T29JD+LZ4Ar+Nvv9FghMRxdeAz+6Y7clKU2xpJei2/ay9vn8; bm_so=9A4855DB872EECC0FE459351F92B12BA07F7F8C829D23CF7CBF7D533D437304E~YAAQf9ojFxYuEXGWAQAAegn/hgM4UTSTmRf+tMofGUUda4keSuO3zsK2RNafEcjoAaXt5pR57cISVQIU3qZN4+PzrBKWjSUjEAFes+BA/g/jmkS0UavWJwim8x6ufVYiXGbV2EV2Y6sI08S1xLIz2EBmAG7GO7/pAhd9oDyD9xu2ZxSFfOA5ALuWFRVGillrbFMvuV/9MY3OHTKrVp8obGpsU20ILqCwF4GJdcDZ/k9BNeETZKLYmy62IZqOszcz8oyyRB4nXh9t2unxUY3B2qSKSo4h2wV3rpFlcq+Nf6VJDJoOow9e/a/lvaCqnrCHojOaXvdnskRA0ArJhCXt7f4DrcVB89VuxHxkJv4Eh/XK6VRD3VLVADMUAXbB/S4QKGFAe6oC2k5c5OA4oHFjkU5/RQVrvk7DV8yPyijaeMCemkeQavJSZESeigv1upvkYsxG5oJpyWdmnAtomcs=; baby-isWide=wide; web-session-id=dc3db872-6985-4fca-b391-bf308692fa54' \\\n -H 'pragma: no-cache' \\\n -H 'priority: u=1, i' \\\n -H 'referer: https://www.coupang.com/vp/products/7856132617?itemId=21426210870&vendorItemId=88316309236&sourceType=srp_product_ads&clickEventId=096ca7f0-25cb-11f0-8f4f-95d41a1ed88b&korePlacement=15&koreSubPlacement=1&q=%EB%82%A8%EC%84%B1+%EC%8A%A4%ED%82%A8&itemsCount=36&searchId=51a6d0d92058873&rank=0&searchRank=0&isAddedCart=' \\\n -H 'sec-ch-ua: \"Google Chrome\";v=\"135\", \"Not-A.Brand\";v=\"8\", \"Chromium\";v=\"135\"' \\\n -H 'sec-ch-ua-mobile: ?0' \\\n -H 'sec-ch-ua-platform: \"macOS\"' \\\n -H 'sec-fetch-dest: empty' \\\n -H 'sec-fetch-mode: cors' \\\n -H 'sec-fetch-site: same-origin' \\\n -H 'user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36' \\\n -H 'x-requested-with;'" }, "type": "n8n-nodes-base.executeCommand", "typeVersion": 1, "position": [ 1420, 20 ], "id": "f9011e27-339a-403d-8ab0-5cd351a1b3d5", "name": "Execute Command1" }, { "parameters": { "fieldToSplitOut": "pageNo", "include": "selectedOtherFields", "fieldsToInclude": "productNo", "options": {} }, "type": "n8n-nodes-base.splitOut", "typeVersion": 1, "position": [ 880, 20 ], "id": "7878403f-540c-4217-b9c0-068206745dd0", "name": "Split Out1" }, { "parameters": { "operation": "create", "documentId": { "__rl": true, "value": "1EAm3rTmvNl4ZRQkdYovUdfIYrrtseUr2dJlEihCISfI", "mode": "list", "cachedResultName": "상품 리뷰 DB", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAm3rTmvNl4ZRQkdYovUdfIYrrtseUr2dJlEihCISfI/edit?usp=drivesdk" }, "title": "={{ $json.productNo }}", "options": { "index": 0 } }, "type": "n8n-nodes-base.googleSheets", "typeVersion": 4.5, "position": [ 220, -180 ], "id": "b1e85105-b3f3-4fc2-9d5f-f3aeda64126e", "name": "시트 생성", "credentials": { "googleSheetsOAuth2Api": { "id": "RPDt3rL1xfWaPW5s", "name": "Google Sheets account" } } }, { "parameters": { "options": {} }, "type": "n8n-nodes-base.splitInBatches", "typeVersion": 3, "position": [ 1140, 20 ], "id": "14e5bf9d-fe7d-4457-ad5b-c0da4d858803", "name": "Loop Over Items" }, { "parameters": { "workflowInputs": { "values": [ { "name": "productNo" } ] } }, "type": "n8n-nodes-base.executeWorkflowTrigger", "typeVersion": 1.1, "position": [ -400, -80 ], "id": "9e2bf5f6-050a-4eba-948f-07a9a4f86184", "name": "When Executed by Another Workflow" }, { "parameters": { "assignments": { "assignments": [ { "id": "e0498870-2210-4968-b11f-4cc1cd9ef0cb", "name": "googleSheetUrl", "value": "=https://docs.google.com/spreadsheets/d/1EAm3rTmvNl4ZRQkdYovUdfIYrrtseUr2dJlEihCISfI", "type": "string" } ] }, "options": {} }, "type": "n8n-nodes-base.set", "typeVersion": 3.4, "position": [ 220, 240 ], "id": "c3e8d2a0-8baf-47a7-a500-715cc1019e6e", "name": "Edit Fields" }, { "parameters": { "assignments": { "assignments": [ { "id": "6ffa27c8-c2ec-4189-b140-1f181b2f1473", "name": "productNo", "value": "={{ $json.productNo }}", "type": "string" } ] }, "options": {} }, "type": "n8n-nodes-base.set", "typeVersion": 3.4, "position": [ -120, -80 ], "id": "19800dbd-e144-4803-9446-ac238a16fdd5", "name": "상품 번호 입력" } ], "pinData": { "When Executed by Another Workflow": [ { "json": { "productNo": "7856132617" } } ] }, "connections": { "Execute Command": { "main": [ [ { "node": "HTML", "type": "main", "index": 0 } ] ] }, "1차 파싱": { "main": [ [ { "node": "Split Out", "type": "main", "index": 0 } ] ] }, "Split Out": { "main": [ [ { "node": "2차 파싱", "type": "main", "index": 0 } ] ] }, "2차 파싱": { "main": [ [ { "node": "전처리", "type": "main", "index": 0 } ] ] }, "전처리": { "main": [ [ { "node": "리뷰 데이터 입력", "type": "main", "index": 0 } ] ] }, "HTML": { "main": [ [ { "node": "페이지수 계산", "type": "main", "index": 0 } ] ] }, "페이지수 계산": { "main": [ [ { "node": "Split Out1", "type": "main", "index": 0 } ] ] }, "Split Out1": { "main": [ [ { "node": "Loop Over Items", "type": "main", "index": 0 } ] ] }, "Execute Command1": { "main": [ [ { "node": "1차 파싱", "type": "main", "index": 0 } ] ] }, "시트 생성": { "main": [ [ { "node": "리뷰 데이터 헤더 입력", "type": "main", "index": 0 } ] ] }, "리뷰 데이터 입력": { "main": [ [ { "node": "Loop Over Items", "type": "main", "index": 0 } ] ] }, "Loop Over Items": { "main": [ [], [ { "node": "Execute Command1", "type": "main", "index": 0 } ] ] }, "When Executed by Another Workflow": { "main": [ [ { "node": "상품 번호 입력", "type": "main", "index": 0 } ] ] }, "리뷰 데이터 헤더 입력": { "main": [ [] ] }, "상품 번호 입력": { "main": [ [ { "node": "시트 생성", "type": "main", "index": 0 }, { "node": "Execute Command", "type": "main", "index": 0 }, { "node": "Edit Fields", "type": "main", "index": 0 } ] ] }, "Edit Fields": { "main": [ [] ] } }, "active": false, "settings": { "executionOrder": "v1" }, "versionId": "9632ee94-ce16-477d-93a0-fdd5a3a32307", "meta": { "templateCredsSetupCompleted": true, "instanceId": "b7fa3a3917b9829d954f3c12bc6521c63cd47a0eeab0efcb35b6d409fe14841d" }, "id": "yY5FyRmo19CbX4a8", "tags": [] }

2. MCP 서버 워크플로

코드보기
{ "name": "상품 리뷰 분석 MCP", "nodes": [ { "parameters": { "path": "e607359c-b9a3-4024-8377-e273b7d149b9" }, "type": "@n8n/n8n-nodes-langchain.mcpTrigger", "typeVersion": 1, "position": [ -40, -60 ], "id": "e8e108c9-f0c3-4424-ac86-f60260e094ab", "name": "MCP Server Trigger", "webhookId": "e607359c-b9a3-4024-8377-e273b7d149b9" }, { "parameters": { "name": "Coupang_Product_Scraper", "description": "쿠팡의 상품의 리뷰 데이터를 스크랩해주는 도구", "workflowId": { "__rl": true, "value": "yY5FyRmo19CbX4a8", "mode": "list", "cachedResultName": "상품 리뷰데이터 스크랩" }, "workflowInputs": { "mappingMode": "defineBelow", "value": { "productNo": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('productNo', `쿠팡 상품번호`, 'string') }}" }, "matchingColumns": [ "productNo" ], "schema": [ { "id": "productNo", "displayName": "productNo", "required": false, "defaultMatch": false, "display": true, "canBeUsedToMatch": true, "type": "string", "removed": false } ], "attemptToConvertTypes": false, "convertFieldsToString": false } }, "type": "@n8n/n8n-nodes-langchain.toolWorkflow", "typeVersion": 2.1, "position": [ 160, 180 ], "id": "bd5f070d-40f2-4cf9-8b49-59d3acc30568", "name": "Call n8n Workflow Tool" } ], "pinData": {}, "connections": { "Call n8n Workflow Tool": { "ai_tool": [ [ { "node": "MCP Server Trigger", "type": "ai_tool", "index": 0 } ] ] } }, "active": true, "settings": { "executionOrder": "v1" }, "versionId": "3e5a2ebb-6639-4948-9a4c-800e041b5a00", "meta": { "instanceId": "b7fa3a3917b9829d954f3c12bc6521c63cd47a0eeab0efcb35b6d409fe14841d" }, "id": "CtK72sCdZlLijSdf", "tags": [] }

3. Claude 설정 메뉴얼

1. Google Sheets MCP 설정

Google Sheets MCP 설정 방법
  1. 먼저 Google Sheets MCP 패키지를 설치합니다:
npm install @mkummer225/google-sheets-mcp
  1. Google Cloud Console에서 프로젝트를 생성하고 Google Sheets API를 활성화합니다:
      • 새 프로젝트 생성
      • API 및 서비스 > 라이브러리에서 "Google Sheets API" 검색 후 활성화
      • 사용자 인증 정보 만들기 > OAuth 클라이언트 ID 선택
      • 애플리케이션 유형: 데스크톱 앱
      • 인증 정보 다운로드 (credentials.json)
  1. claude_desktop_config.json 파일에 Google Sheets MCP 설정을 추가합니다:
{ "mcpServers": { "google-sheets-mcp": { "command": "node", "args": [ "/path/to/google-sheets-mcp/dist/index.js" ] }, ... } }
  1. 처음 실행 시 OAuth 인증 과정을 완료해야 합니다:
      • MCP 서버가 시작되면 브라우저가 열리고 Google 계정으로 로그인
      • 권한 요청에 동의하면 토큰이 저장되어 이후 자동으로 인증됨
  1. n8n 워크플로우에서 Google Sheets MCP 도구를 사용하여 스프레드시트 데이터를 읽고 쓸 수 있습니다.

2. 쿠팡 리뷰 데이터 스크랩 MCP 설정

notion image
  • n8n 노드에서 MCP 서버 ID를 확인해서 claude mcp 설정 파일에 삽입합니다.
{ ... "coupang-review-data-scraper": { "command": "npx", "args" : [ "-y", "supergateway", "--sse", "http://localhost:5678/mcp/[YOUR_MCP_SERVER_ID]/sse" ] } }