GCPã®ãµãŒãã¹ã¢ã«ãŠã³ãã§ãã¡ã€ã«ãæäœããæã®æ³šæç¹
GCPã®ãµãŒãã¹ã¢ã«ãŠã³ããå©çšããŠãGoogle Driveã®ãã¡ã€ã«ãèªã¿æžãããå ŽåããããŸã§ã¯ãµãŒãã¹ã¢ã«ãŠã³ãã®ã¡ãŒã«ã¢ãã¬ã¹ããã¡ã€ã«ã®å ±æã«è¿œå ãããšãã£ãäºãããŠããŸããããããããã€ã®éã«ããã®ææ³ã䜿ããªããªã£ãŠããããã§ãããŸãããã®å ŽåããµãŒãã¹ã¢ã«ãŠã³ããããã¡ã€ã«ãæäœããéã®ææ³ãå€æŽã«ãªã£ãŠããããã§ããããã®æ³šæç¹ã«ã€ããŠãŸãšããŠã¿ãããšã«ããŸããã
â»ããŸãGASã§ãµãŒãã¹ã¢ã«ãŠã³ãã䜿ã£ãŠãã¡ã€ã«æäœã¯ããããšããªãã®ã§æ°ãä»ããŸããã§ããã確ãã«æè¿ããã®ä»¶ã«ã€ããŠã©ããã§æ å ±ãèŠãèšæ¶ãããã®ã§ããããã¥ãŒã¹ãœãŒã¹ãèŠã€ããããã
ç®æ¬¡
å ±æãžè¿œå ã§ããªããªã£ãïŒ
ãããŸã§ããµãŒãã¹ã¢ã«ãŠã³ããèªã¿æžãããå¿ èŠã®ãããã¡ã€ã«ã«ã€ããŠã¯ãGoogle Driveäžã®å¯Ÿè±¡ã®ãã¡ã€ã«ã«ã€ããŠå ±æã«ãiam.gserviceaccount.comãã®ãã¡ã€ã³ã®ã¢ã«ãŠã³ããè¿œå ããäºã§èš±å¯ãšããŠããŸããã2021幎é ãŸã§ã¯ç¢ºãã«ãã®æ¹æ³ã§åããŠããŸãããããããæšä»ã®ã»ãã¥ãªãã£åäžã®äžç°ã§OAuth2.0èªèšŒã§ãªããã°ã¢ã¯ã»ã¹ãããªãããã«å¶éãå ãã£ãã®ãããããŸããã
èªåãäœãããã®ããªïŒãšæ¢çŽ¢ãããšããããã¡ãã®ãµã€ãã«çç±ãæžãããŠããŸããã
- Google Workspaceã®ç®¡çã³ã³ãœãŒã«ã«æŒããŠããã©ã€ããšããã¥ã¡ã³ãã®å ±æãªãã·ã§ã³ãããªã³ã以å€ã®å Žåè¿œå ã§ããªã
- èš±å¯ãªã¹ãç»é²æžã¿ãã¡ã€ã³ãšããŠãiam.gserviceaccount.comãè¿œå ããããšããŠãè¿œå ããäºã¯åºæ¥ãŸãã
- ãŸããè¿œå ããŠããµãŒãã¹ã¢ã«ãŠã³ããã¢ã¯ã»ã¹ããã«ã¯è²ã æš©éãå¿ èŠ
æ ã«å³å¯ã«ããã°å ±æäžå¯ã§ã¯ãªããã®ã®ãçŸåšãã®æ¹æ³ã¯æšå¥šãããŠããªãããã§ããå€éšå ±æããªã³ãããªããã°ãã¡ãšãªããšãéåžžã®äŒæ¥ã®ã»ãã¥ãªãã£ããªã·ãŒãèãããšãªã³ã«ã¯åºæ¥ãŸãããçµç¹éšéãåã£ãŠãã®çµç¹éšéã ããã®èšå®ã«ããå°çšã®ã¢ã«ãŠã³ããçšæããŠãå°çšã®å Žæã§ã ãèš±å¯ãããšãã£ãå³æ Œãªéçšãå¿ èŠã«ãªããŸãã
å³ïŒç®¡çã³ã³ãœãŒã«ã§ã®å€éšå ±æã®èšå®
å³ïŒãµãŒãã¹ã¢ã«ãŠã³ããå ±æã«è¿œå ããæ§å
Google Workspaceã§é«åºŠãªã¢ã¯ã»ã¹å¶éãå®çŸãã
ãµãŒãã¹ã¢ã«ãŠã³ããå©çšãã
ãµãŒãã¹ã¢ã«ãŠã³ããGASããæäœãã
ãã§ã«éå»ã®ãšã³ããªãŒã§ãGASãããµãŒãã¹ã¢ã«ãŠã³ããå©çšããŠã®æäœèªäœã¯å®çŸããŠããŸããGoogle Vertex APIãå©çšããã±ãŒã¹ãªã©ã§GASã®oauthScopesã«ãhttps://www.googleapis.com/auth/cloud-platformããè¿œå ããŠãæåã«èªèšŒãããäºã§ããŒã¯ã³ãååŸããªã¯ãšã¹ãããããšãã圢ãåããŸãã
ãŸãããã®ææ³ä»¥å€ã§ã¯StackOverflowã§ãèšåãããŠããŸããã察象ã®GCPãããžã§ã¯ãã®å¯Ÿè±¡ã®ã¹ã³ãŒããGoogle Workspaceã®ãã¡ã€ã³å šäœã®å§ä»»ã«è¿œå ãããšããææ³ãåãããŠè¡ããŸãããããããã¡ã€ã³å šäœã®å§ä»»ã§è¿œå ããææ³ã¯ãã»ãã¥ãªãã£çã«ã©ããªã®ãïŒãšããæžå¿µãããããšãããå©çšããå Žåã¯ããªãå³æ Œã«ã¢ã«ãŠã³ã管çãé©çšç¯å²ãçµã£ãŠããå¿ èŠæ§ããããŸãã
Google Apps Scriptã§äžéšã ãããŠãŒã¶æš©éã§åããããæã¯ïŒ
ãµãŒãã¹ã¢ã«ãŠã³ãã«ãã¡ã€ã«ãèªã¿æžããããå Žå
ãã¡ã€ã³å šäœã«å§ä»»ããŠã®æäœã¯ã¡ãã£ãšã¢ã¬ãšããäºã§ããã°ããã¯ãããã¯OAuth2.0èªèšŒã§ãµãŒãã¹ã¢ã«ãŠã³ãã®èªèšŒãè¡ããããŒã¯ã³ããã£ãŠããŠAPIããæäœããå¿ èŠæ§ããããŸãããã®å Žåã察象ã®ãã¡ã€ã«ã«å¯ŸããŠãµãŒãã¹ã¢ã«ãŠã³ãã®ã¡ã¢ããè¿œå ããå¿ èŠããªãã®ã§ããã©ã€ãå ±æãªãã·ã§ã³ããªã³ã«ããå¿ èŠããããŸããã
ãã¡ãã§çŽ¹ä»ãããŠããããªãGoogleã°ã«ãŒãã«ãµãŒãã¹ã¢ã«ãŠã³ããè¿œå ããŠãä¿¡é Œã«ãŒã«ãšããŠè¿œå ãããšãã£ãææ³ããããããªã®ã§ããããã®æ段ã¯Enterprise Standard以äžã§ãªããã°å©çšãåºæ¥ãŸããã
ãã®è©³çŽ°ã¯åè¿°ã®Google BardãåŒã³åºãã®äžã«èšè¿°ãããŠããããªææ³ã§ãã¹ã³ãŒããšããŠã¯Google Sheets APIãªã©å¯Ÿè±¡ã®ããã¥ã¡ã³ãã®APIãå ããŠãããŸã(æåã§ãhttps://www.googleapis.com/auth/spreadsheetsãè¿œå )ããããããæå¹ãªAPIãšãµãŒãã¹ã«ãŠGoogle Sheets APIãè¿œå ããŠããå¿ èŠããããŸããGoogle Driveã®Scopeãè¿œå ããŠãããŸãããã
OAuthã©ã€ãã©ãªã§èªèšŒãè¡ãäºã§èš±å¯ãããŠèªã¿æžããå¯èœã«ãªããŸãã
ãšã¯ããããã¡ãã®æ¹æ³ã¯æ¹æ³ã§Client IDãSecretãOAuth2.0èªèšŒã«ããAccess Tokenãå©çšããŠã¢ã¯ã»ã¹ãããŠããã®ã§ããŒã¯ã³ã®æµåºçãšãã£ããªã¹ã¯ããããŸãã®ã§å³æ Œã«ç®¡çããå¿ èŠæ§ãããã®ã«ã¯å€ãããŸããã
å³ïŒSheets APIãæå¹å
å³ïŒScopeãšããŠè¿œå ãã
ãµãŒãã¹ã¢ã«ãŠã³ããäœã£ããã¡ã€ã«ã«ã€ããŠ
ãµãŒãã¹ã¢ã«ãŠã³ãã§ãã¡ã€ã«ãäœæãããšãäžæè°ãªæåã«ãªããŸãããã®èŸºãã«ã€ããŠã¯ãã¡ãã®ãµã€ããéåžžã«çŽ°ããæ€èšŒãšãŸãšããè¡ã£ãŠããŸãã
- ãã¡ã€ã«ã®ãªãŒããŒã¯ãµãŒãã¹ã¢ã«ãŠã³ããšãªãïŒèªåã§ã¯ãªãïŒ
- ãã¡ã€ã«ã®çœ®ãå Žã¯ããµãŒãã¹ã¢ã«ãŠã³ãã®ãã€ãã©ã€ãã«ãã©ã«ããäœæãããŠããã¡ã€ã«ãäœæããããã©ã«ããèªåã«å ±æããã
- ãã¡ã€ã«ãåé€ããŠããµãŒãã¹ã¢ã«ãŠã³ããããéãããµãŒãã¹ã¢ã«ãŠã³ãã®ãã€ãã©ã€ãã«ååšãç¶ãã
- ãã¡ã€ã«ã®ãªãŒããŒã¯èªåã«å€æŽããããšãåºæ¥ããäœãå€æŽã«ã¯å¶éã䌎ã
- ãµãŒãã¹ã¢ã«ãŠã³ããåé€ãããšãããã®ãã¡ã€ã«ãå šãŠåé€ããã
- æ ã«ãã¡ã€ã«ã«ã€ããŠã¯å ±æãã©ã€ããªã©ã«ç§»åããã®ãæãŸãã
é¢é£ãªã³ã¯
- ãGASããµãŒãã¹ã¢ã«ãŠã³ããšã㊠Google Cloud ã®APIã䜿çšããæ¹æ³
- ãµãŒãã¹ã¢ã«ãŠã³ãã䜿ã£ãŠ Google Drive(ãã€ãã©ã€ã) ã«äœæãããã¡ã€ã«ã®ãªãŒããŒã¯ãµãŒãã¹ã¢ã«ãŠã³ã
- Google WorkspaceïŒãã©ã€ããšããã¥ã¡ã³ãã®å ±æãªãã·ã§ã³ãããªã³ã以å€ã®å ŽåããµãŒãã¹ã¢ã«ãŠã³ãããå ±æãã«å ããããšãã§ããªã
- ãµãŒãã¹ ã¢ã«ãŠã³ãèªèšŒæ å ±
- å ±æå¶éä»ãã®Googleã¹ãã¬ããã·ãŒããGCPãµãŒãã¹ã¢ã«ãŠã³ãã§èªã¿èŸŒãæ¹æ³
- Google Service Account can't be added to sheet in shared drive
- Google Service Account that has access to Shared Drives without explicit access permission
- Google Sheet API stopped working post restricting Drive's External sharing to Allowlisted domains
- Google Spreadsheet ããµãŒãã¹ã¢ã«ãŠã³ãã«å ±æããã«Google Spreadsheet APIããèªã¿ã ãæ¹æ³
- Google ãã©ã€ãã®ä¿¡é Œã«ãŒã«ïŒããŒã¿çïŒã䜿çšããŠãã¡ã€ã«ã®å ±æããã现ãã管ç
- Google Sheets API ã¹ã³ãŒãã®éžæ
- Okta ãããã³ã°ãäŒç€Ÿã®ã©ãããããã§å人㮠Google ã¢ã«ãŠã³ãã䜿çšããåŸæ¥å¡ãéé£ããã
- JSONãè¿ãã¡ãã£ãšããAPIãªãã¹ãã¬ããã·ãŒãã§ãµã¯ããš
- ãµãŒãã¹ã¢ã«ãŠã³ãã«ã©ã®æš©éãå²ãåœãã£ãŠããã確èªããã
- Google Cloud ã®ãµãŒãã¹ ã¢ã«ãŠã³ã ããŒãå®å šã«ç®¡çãã
- GitHub Actions ããã®ããŒãªãã®èªèšŒã®æå¹å
- AWS ã®æ©èœã GCP ã®ãµãŒãã¹ã¢ã«ãŠã³ãã§èªèšŒããŠå©çšãã