GCP/Apps Script

Apps Script ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์ƒ์„ฑํ•ด์„œ ๋‹ค๋ฅธ Apps Script์—์„œ ์‚ฌ์šฉํ•˜๊ธฐ

whistory 2022. 9. 6. 08:41
๋ฐ˜์‘ํ˜•

๐Ÿ’ก Apps Script ํ”„๋กœ์ ํŠธ๋ฅผ ์ง„ํ–‰ํ•จ์— ์žˆ์–ด,
     ์œ ์ง€๋ณด์ˆ˜๋ฅผ ์šฉ์ดํ•˜๊ธฐ ์œ„ํ•ด์„œ, ๊ณตํ†ต๋ชจ๋“ˆ์„ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ๋กœ ๋ฐฐํฌํ•˜์—ฌ ์‚ฌ์šฉํ•˜๋Š” ๋ฐฉ๋ฒ•์ด๋‹ค.

 

 

(์‹ค์ œ ์‚ฌ์šฉ ์ƒ˜ํ”Œ / 2023-02-24 ์ถ”๊ฐ€)

 

Apps Script ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์ƒ์„ฑํ•ด์„œ ๋‹ค๋ฅธ Apps Script์—์„œ ์‚ฌ์šฉํ•˜๊ธฐ - ์‹ค์ œ ์‚ฌ์šฉ ์˜ˆ

๐Ÿ’ก Apps Script ๋ฅผ ์ด์šฉํ•ด ์‹ค์ œ๋กœ ๊ฐœ๋ฐœํ–ˆ๋˜ ๋‚ด์šฉ์„ ์š”์•ฝํ–ˆ๋‹ค. https://whiseung.tistory.com/entry/Apps-Script-%EA%B0%9C%EB%B0%9C%EC%9D%84-%EC%9C%84%ED%95%9C-%ED%8C%8C-%EC%84%A4%EA%B3%84 Apps Script ๊ฐœ๋ฐœ์„ ์œ„ํ•œ ๊ตฌ์กฐ ์„ค๊ณ„ ์ด๋ฒˆ ํ”„

whiseung.tistory.com

 

 

 

๊ณตํ†ต์œผ๋กœ ์‚ฌ์šฉํ•ด์•ผ ํ•  ํ•จ์ˆ˜๋“ค์„ ํฌํ•จํ•œ library ๋ฐฐํฌํ•ด์„œ,

๋‹ค๋ฅธ app script ์—์„œ ๋ฐฐํฌํ•œ library ๋“ฑ๋ก ๋ฐฉ๋ฒ•์ด๋‹ค.

1. ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์ƒ์„ฑ

1.1 [๋ฐฐํฌ] - [์ƒˆ ๋ฐฐํฌ]

1.2 [์œ ํ˜•์„ ํƒ] - [๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ] - ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ๋ช… ์ž…๋ ฅ

1.3 [์„ค์ •] - [์Šคํฌ๋ฆฝํŠธID] ๋ณต์‚ฌ

 

 

 

 

 

 

 

 

2. ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์ถ”๊ฐ€ ๋ฐ ์‚ฌ์šฉ

2.1 ์‚ฌ์šฉํ•  ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์กฐํšŒ

์œ„์—์„œ ๋ณต์‚ฌํ•œ ์Šคํฌ๋ฆฝํŠธ ID๋ฅผ ์กฐํšŒ

2.2 ์‚ฌ์šฉํ•  ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ๋ฒ„์ „ ๋ฐ ์‹๋ณ„์ž ๋“ฑ๋ก

๋ฐฐํฌ ๋ฒ„์ „์€ [Head] ์„ ํƒ, ํ˜ธ์ถœํ•  ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ์˜ ์‹๋ณ„์ž ์ž…๋ ฅ

 

 

 

 

 

 

 

 

2.3 ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ์˜ ํ•จ์ˆ˜ ์‚ฌ์šฉ

[์‹๋ณ„์ž๋ช…] + [ํ•จ์ˆ˜๋ช…] ํ˜•์‹์œผ๋กœ ํ˜ธ์ถœํ•˜์—ฌ ์‚ฌ์šฉ

 

๋ฐ˜์‘ํ˜•