๐Ÿ“‹ ์ƒˆ OAuth ํด๋ผ์ด์–ธํŠธ ID ์ƒ์„ฑ - ์ƒ์„ธ ๊ฐ€์ด๋“œ

 ๐Ÿ“‹ ์ƒˆ OAuth ํด๋ผ์ด์–ธํŠธ ID ์ƒ์„ฑ - ์ƒ์„ธ ๊ฐ€์ด๋“œ


๐ŸŽฏ Step 1: ์ƒˆ ํ”„๋กœ์ ํŠธ ์ƒ์„ฑ

1-1. Google Cloud Console ์ ‘์†

https://console.cloud.google.com


1-2. ํ”„๋กœ์ ํŠธ ์„ ํƒ ๋“œ๋กญ๋‹ค์šด ํด๋ฆญ

ํ™”๋ฉด ์ƒ๋‹จ์˜ ํ”„๋กœ์ ํŠธ ์ด๋ฆ„ ํด๋ฆญ

1-3. ์ƒˆ ํ”„๋กœ์ ํŠธ

ใ…œ81. "์ƒˆ ํ”„๋กœ์ ํŠธ" ๋ฒ„ํŠผ ํด๋ฆญ

2. ํ”„๋กœ์ ํŠธ ์ด๋ฆ„: n8n-blog-2
3. "๋งŒ๋“ค๊ธฐ" ํด๋ฆญ
4. ํ”„๋กœ์ ํŠธ ์ƒ์„ฑ ์™„๋ฃŒ๊นŒ์ง€ ๋Œ€๊ธฐ (10์ดˆ)

1-4. ํ”„๋กœ์ ํŠธ ์„ ํƒ

์ƒ์„ฑ๋œ "n8n-blog-2" ํ”„๋กœ์ ํŠธ ์„ ํƒ


๐Ÿ”ง Step 2: API ํ™œ์„ฑํ™”

2-1. API ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์ด๋™

์ขŒ์ธก ๋ฉ”๋‰ด → "API ๋ฐ ์„œ๋น„์Šค" → "๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ"

2-2. Google Sheets API ํ™œ์„ฑํ™”

1. ๊ฒ€์ƒ‰์ฐฝ์— "Google Sheets API" ์ž…๋ ฅ

2. ๊ฒ€์ƒ‰ ๊ฒฐ๊ณผ ํด๋ฆญ
3. "์‚ฌ์šฉ ์„ค์ •" ๋ฒ„ํŠผ ํด๋ฆญ


๐Ÿ” Step 3: OAuth ๋™์˜ ํ™”๋ฉด ๊ตฌ์„ฑ

3-1. OAuth ๋™์˜ ํ™”๋ฉด ์ด๋™

์ขŒ์ธก ๋ฉ”๋‰ด → "API ๋ฐ ์„œ๋น„์Šค" → "OAuth ๋™์˜ ํ™”๋ฉด"

3-2. ์‚ฌ์šฉ์ž ์œ ํ˜• ์„ ํƒ

1. "์™ธ๋ถ€" ์„ ํƒ
2. "๋งŒ๋“ค๊ธฐ" ํด๋ฆญ

3-3. ์•ฑ ์ •๋ณด ์ž…๋ ฅ

์•ฑ ์ด๋ฆ„: n8n Blog Automation
์‚ฌ์šฉ์ž ์ง€์› ์ด๋ฉ”์ผ: (๋ณธ์ธ ์ด๋ฉ”์ผ ์„ ํƒ)
๊ฐœ๋ฐœ์ž ์—ฐ๋ฝ์ฒ˜ ์ •๋ณด: (๋ณธ์ธ ์ด๋ฉ”์ผ ์ž…๋ ฅ)

"์ €์žฅ ํ›„ ๊ณ„์†" ํด๋ฆญ

3-4. ๋ฒ”์œ„ (์ƒ๋žต ๊ฐ€๋Šฅ)

"์ €์žฅ ํ›„ ๊ณ„์†" ํด๋ฆญ (๋ฒ”์œ„ ์ถ”๊ฐ€ ์•ˆ ํ•จ)

3-5. ํ…Œ์ŠคํŠธ ์‚ฌ์šฉ์ž ์ถ”๊ฐ€

1. "+ ADD USERS" ํด๋ฆญ
2. prfparkst@gmail.com ์ž…๋ ฅ
3. "์ถ”๊ฐ€" ํด๋ฆญ
4. "์ €์žฅ ํ›„ ๊ณ„์†" ํด๋ฆญ

๐Ÿ”‘ Step 4: OAuth ํด๋ผ์ด์–ธํŠธ ID ์ƒ์„ฑ

4-1. ์‚ฌ์šฉ์ž ์ธ์ฆ ์ •๋ณด ์ด๋™

์ขŒ์ธก ๋ฉ”๋‰ด → "API ๋ฐ ์„œ๋น„์Šค" → "์‚ฌ์šฉ์ž ์ธ์ฆ ์ •๋ณด"

4-2. ์ธ์ฆ ์ •๋ณด ๋งŒ๋“ค๊ธฐ

์ƒ๋‹จ "+ ์‚ฌ์šฉ์ž ์ธ์ฆ ์ •๋ณด ๋งŒ๋“ค๊ธฐ" ํด๋ฆญ
→ "OAuth ํด๋ผ์ด์–ธํŠธ ID" ์„ ํƒ

4-3. ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ์œ ํ˜• ์„ ํƒ

์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ์œ ํ˜•: ์›น ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜
์ด๋ฆ„: n8n-sheets-integration

4-4. ์Šน์ธ๋œ ๋ฆฌ๋””๋ ‰์…˜ URI ์ถ”๊ฐ€

์ค‘์š”! ์ด ๋ถ€๋ถ„์ด ํ•ต์‹ฌ์ž…๋‹ˆ๋‹ค:

"์Šน์ธ๋œ ๋ฆฌ๋””๋ ‰์…˜ URI" ์„น์…˜
→ "+ URI ์ถ”๊ฐ€" ํด๋ฆญ
→ ์ •ํ™•ํžˆ ์ž…๋ ฅ:

http://localhost:5678/rest/oauth2-credential/callback

(https ์•„๋‹˜, http์ž„์— ์ฃผ์˜!)

4-5. ์ƒ์„ฑ

"๋งŒ๋“ค๊ธฐ" ํด๋ฆญ

4-6. ์ •๋ณด ๋ณต์‚ฌ

ํŒ์—…์— ๋‚˜ํƒ€๋‚˜๋Š”:

ํด๋ผ์ด์–ธํŠธ ID: (๋ณต์‚ฌ)
ํด๋ผ์ด์–ธํŠธ ๋ณด์•ˆ ๋น„๋ฐ€๋ฒˆํ˜ธ: (๋ณต์‚ฌ)

์•ˆ์ „ํ•œ ๊ณณ์— ์ €์žฅํ•˜์„ธ์š”!


๐Ÿ”— Step 5: n8n์— ์—ฐ๊ฒฐ

5-1. n8n ์›Œํฌํ”Œ๋กœ์šฐ๋กœ ๋Œ์•„๊ฐ€๊ธฐ

5-2. Append row in sheet ๋…ธ๋“œ ํด๋ฆญ

5-3. Credential ์„ค์ •

1. "Credential to connect with" ๋“œ๋กญ๋‹ค์šด
2. "Create New" ํด๋ฆญ
3. ์ธ์ฆ ๋ฐฉ์‹: OAuth2

5-4. ์ •๋ณด ์ž…๋ ฅ

Client ID: (๋ณต์‚ฌํ•œ ํด๋ผ์ด์–ธํŠธ ID ๋ถ™์—ฌ๋„ฃ๊ธฐ)
Client Secret: (๋ณต์‚ฌํ•œ ํด๋ผ์ด์–ธํŠธ ๋ณด์•ˆ ๋น„๋ฐ€๋ฒˆํ˜ธ ๋ถ™์—ฌ๋„ฃ๊ธฐ)


5-5. ์—ฐ๊ฒฐ

"Connect my account" ๋˜๋Š” "Sign in with Google" ํด๋ฆญ
→ prfparkst@gmail.com ์„ ํƒ
→ ๊ถŒํ•œ ์Šน์ธ

✅ ์„ฑ๊ณต ํ™•์ธ

"Account connected" ํ‘œ์‹œ๋˜๋ฉด ์™„๋ฃŒ!


๐ŸŽฏ ๋‹ค์Œ ๋‹จ๊ณ„

  1. ์ƒˆ Google Sheets ์ƒ์„ฑ
  2. Append row ๋…ธ๋“œ์—์„œ ์ƒˆ ์‹œํŠธ ์„ ํƒ
  3. Execute step ํ…Œ์ŠคํŠธ

๋Œ“๊ธ€

์ด ๋ธ”๋กœ๊ทธ์˜ ์ธ๊ธฐ ๊ฒŒ์‹œ๋ฌผ

์• ํ”Œ๋ฆฌ์ผ€์ด์…˜ ๋น„๋ฐ€๋ฒˆํ˜ธ- ๊ทธ ๋ฒˆํ˜ธ๋ฅผ ์ฐพ์•„๋ผ

์ƒˆ ๋ฏธ์…˜: ๋ธ”๋กœ๊ฑฐ ๋ฐœํ–‰๊ธ€์„ ๋„ค์ด๋ฒ„ ๋ธ”๋กœ๊ทธ ํฌ๋งท์œผ๋กœ ๋ณ€ํ™˜ํ•ด์„œ ์ž๋™ ํฌ์ŠคํŒ…ํ•˜๋Š” Workflow C-naver๊ตฌํ˜„

n8n์ž๋™ํ™” ์ฒซ๊ฑธ์Œ - JSON์œผ๋กœ ๋งŒ๋“ ๊ธ€์„ ์ž๋™ํ™” ํ•ด๋ณด์ž