唳ㄠΝ唰囙Ξ唰嵿Μ唳�, 2022


Google Workspace-唳忇Π 唳膏唳灌唳唳 唳∴唳唳侧Κ唳距Π唳︵唳� 唳多唳栢唳�, 唳む唳班 唳曕Π唳� 唳忇Μ唳� 唳Α唳� 唳曕Π唳距Π 12唳熰 唳︵唳班唳︵唳ㄠ唳� 唳夃Κ唳距Ο唳�

2022 唳唳︵唳о唳� 唳唳班 唳涏唳侧イ Google Workspace-唳忇Π 唳忇唳� 3 唳唳侧唳唳ㄠ唳班 唳唳多 唳唳Μ唳灌唳班唳距Π唰€ 唳忇Μ唳� 唳唳多唳唰佮Α唳监 8 唳唳侧唳唳ㄠ唳� 唳唳多 唳呧Π唰嵿Ε唳唳班Ζ唳距Θ唳曕唳班 唳椸唳班唳灌 唳班Ο唳监唳涏啷� 唳忇Μ唳� Google Workspace Marketplace 5 唳唳侧唳唳ㄠ唳班 唳唳多 唳呧唳唳� 唳囙Θ唳膏唳熰Σ 唳曕Π唳距Π 唳忇唳熰 唳嗋唰€唳Θ 唳唳囙Σ唳Σ唳� 唳呧Δ唳苦唰嵿Π唳� 唳曕Π唰囙唰� 唰� 唳忇Δ 唳Π唳苦Μ唳班唳むΘ唰囙Π 唳︵唳唳班 唳氞唳灌唳ㄠ唳� 唳忇唳熰 唳唳� 唳多唳� 唳曕Π唳距Π 唳溹Θ唰嵿Ο, 唳嗋Ξ唳班 唳曕唳涏 唳Α唳� 唳嗋Κ唳∴唳熰唰佮Σ唳苦唰� 唳唳ㄠΠ唰佮Ζ唰嵿Η唳距Π 唳曕Π唰囙唳� 唳 Google Workspace 唳曕 唳唳Μ唳灌唳班唳距Π唰€, 唳椸唳班唳灌 唳忇Μ唳� 唳∴唳唳侧Κ唳距Π唳︵唳� 唳溹Θ唰嵿Ο 唳忇唳囙Ν唳距Μ唰� 唳膏Μ唳氞唳唰� 唳夃Θ唰嵿Ξ唰佮唰嵿Δ 唳忇Μ唳� 唳忇唰嵿Ω唳熰唳ㄠΩ唳苦Μ唳� 唳唳侧唳唳熰Λ唳班唳� 唳曕Π唰� 唳む唳侧啷�




唳唳曕唳多唳距Π唰€ 唳膏唳唳�


Asana 唳曕唳唳 Google Workspace 唳唳侧唳唳熰Λ唳班唳� 唳唳Μ唳灌唳� 唳曕Π唰� 唳む唳� 唳椸唳班唳灌唳︵唳� 唳曕唳涏 唳唳侧唳� 唳嗋Θ唳唳� 唳曕Π唰囙唰�

Gmail 唳忇Μ唳� Google 唳撪Ο唳监唳班唳曕Κ唰嵿Σ唰囙Ω 唳呧唳唳�-唳呧Θ唳椸唳侧 唳唳曕唳� 唳曕Π唳距Π 唳唳о唳Ξ唰�, Asana 唳熰唳唳� 唳溹Θ唰嵿Ο 唳曕唳� 唳栢唳佮唰� 唳唳撪Ο唳监 唳忇Μ唳� 唳膏唳唳椸唳む 唳曕Π唳� 唳嗋Π唳� 唳膏唳� 唳曕Π唰� 唳む唳侧唳涏啷� 唳唳灌唳む 唳囙Ξ唰囙Σ, 唳∴唰佮Ξ唰囙Θ唰嵿 唳忇Μ唳� 唳膏唳侧唳囙Α唳椸唳侧 唳忇唳� Asana-唳� 唳嗋Π唳� 唳唳多 唳呧唳唳曕唳膏唳膏Ο唰嬥唰嵿Ο, 唳む唳� 唳 唳︵Σ唳椸唳侧 Asana 唳忇Μ唳� Google Workspace 唳夃Ν唳唳� 唳唳Μ唳灌唳� 唳曕Π唰� 唳む唳班 唳嗋Π唳� 唳膏唳苦唳唳 唳む唳︵唳� 唳唳班唳侧唳唰佮Σ唳� 唳熰唳班唳唳� 唳曕Π唳む 唳唳班啷� 唳曕唳溹唳� 唳唳粪Ο唳监 唳曕Ξ 唳膏Ξ唳 唳唳Ο唳� 唳曕Π唳距Π 唳膏唳ム, 唳︵Σ唳椸唳侧 唳嗋Π唳� 唳唳多 唳膏唳溹Θ唳多唳� 唳о唳班Γ唳距唰� 唳膏唰嵿Ψ唳� 唳曕Π唳む 唳唳班, 唳曕Π唰嵿Ξ唳氞唳班唳︵唳� 唳唳Ω唰嵿Δ唳む 唳夃Θ唰嵿Θ唳� 唳曕Π唳む 唳唳班 唳忇Μ唳� 唳唳Μ唳膏唳唳苦 唳侧唰嵿Ψ唰嵿Ο唳椸唳侧唳� 唳曕唳涏唳曕唳涏 唳嗋Π唳� 唳曕唳班唳唳班Ν唳距Μ唰� 唳膏唳班唳Ζ唰嵿Η 唳曕Π唳む 唳唳班啷�

唳嗋Π唳� 唳溹唳ㄠ唳�

唳氞唳唳� 唳呧唳唳唳� 唳溹Θ唰嵿Ο 唳曕唳班唳�-唳唳む唳む唳� UI 唳む唳班 唳曕Π唳�

唳嗋Ξ唳班 唳嗋Π唳� 唳曕唳班唳� 唳熰唳Κ唰嵿Σ唰囙 - 唳曕唳班唳� 唳熰唳Κ唰嵿Σ唰囙唰囙Π 唳膏Ξ唳距Η唳距Θ 唳椸唳唳侧唳班 - 唳忇Μ唳� 唳嗋Π唳� 唳曕唳班唳�-唳膏Ξ唰嵿Κ唳班唳曕唳� 唳唳曕唳多唳距Π唰€ 唳椸唳囙Α 唳膏 唳嗋Ξ唳距Ζ唰囙Π Google Chat 唳呧唳唳� 唳∴唳唳侧Κ唳唳ㄠ唳� 唳∴唰佮Ξ唰囙Θ唰嵿唰囙Χ唳ㄠ唳� 唳Π唳苦Κ唰傕Π唳� 唳氞唳侧唳唰� 唳唳氞唳涏啷� 唳唳� 唳多唳� 唳唳Μ唳灌唳班唳距Π唰€唳� 唳呧Ν唳苦唰嵿唳む唳� 唳溹Θ唰嵿Ο 唳唳膏唳溹唳� , 唳囙Θ唰嵿唳距Π唳呧唳唳曕唳苦Ν唳苦唳� , 唳忇Μ唳� UI 唳夃唳溹唳熰唰佮Σ唳苦Π 唳嗋Κ唳∴唳熰唰佮Σ唳� 唳Π唰€唳曕唳粪 唳曕Π唰佮Θ 唰�

唳嗋Π唳� 唳溹唳ㄠ唳�

唳膏唳溹 Google Workspace API 唳Π唳苦唳距Σ唳ㄠ 唳曕Π唰佮Θ

唳嗋Ξ唳班 唳膏Ξ唰嵿Κ唰嵿Π唳む Google 唳曕唳侧唳夃Α 唳曕Θ唳膏唳侧唳� 唳唳о唳Ξ唰� Google Workspace API-唳椸唳侧 唳呧唳唳曕唳膏唳� 唳曕Π唳距Π 唳溹Θ唰嵿Ο 唳忇唳熰 唳愢唰嵿Ο唳Ζ唰嵿Η 唳夃Κ唳距Ο唳� 唳唳� 唳曕Π唰囙唳库€擥mail, Google Drive, Docs, Sheets, Chat, Slides, Calendar 唳忇Μ唳� 唳嗋Π唳� 唳呧Θ唰囙唰囙Π 唳溹Θ唰嵿Ο APIs啷� 唳膏唳栢唳� 唳ム唳曕, 唳忇唳� 唳嗋Κ唳ㄠ唳� 唳膏Ξ唳膏唳� Google Workspace API 唳椸唳侧 唳Π唳苦唳距Σ唳ㄠ 唳曕Π唳む 唳忇Μ唳� 唳唳Μ唳灌唳� API-唳忇Π 唳溹Θ唰嵿Ο 唳膏Ξ唳膏唳� 唳忇唳む唳班唳� 唳唳熰唳班唳曕唰佮Σ唳� 唳︵唳栢唳� 唳溹Θ唰嵿Ο 唳嗋Κ唳ㄠ唳� 唳曕唳涏 唳忇唳熰 唳曕唳ㄠ唳︵唳班唳 唳呧Μ唳膏唳ム唳� 唳班Ο唳监唳涏啷� 唳曕唳唳 唳多唳班 唳曕Π唳唳� 唳む 唳溹唳ㄠ唳ㄠイ


唳忇唳� 唳︵唳栢

唳熰唳囙唳距Π 唳嗋Ξ唳距Ζ唰囙Π 唳呧Θ唰佮Ω唳班Γ 唳曕Π唰佮Θ

唳膏Π唰嵿Μ唳多唳� 唳唳侧唳唳熰Λ唳班唳� 唳嗋Κ唳∴唳�, 唳栢Μ唳�, 唳膏Ξ唰嵿Κ唰嵿Π唳︵唳 唳膏Ξ唳距Η唳距Θ, 唳忇Μ唳� 唳樴唳ㄠ 唳唳�. 唳嗋Ω唰佮Θ 唳忇Μ唳� 唳曕Ε唰嬥Κ唳曕Ε唳ㄠ 唳唳椸Ζ唳距Θ 唳曕Π唰佮Θ啷�


唳嗋Ξ唳距Ζ唰囙Π 唳呧Θ唰佮Ω唳班Γ 唳曕Π唰�



唳曕Ξ唳苦唳ㄠ唳熰 唳膏唳唳侧唳囙


唳呧唳唳Ω 唳膏唳曕唳班唳唳� 唳唳Μ唳灌唳� 唳曕Π唰� 唳む唳班 Google 唳Δ唰嵿Π唳曕唳� 唳溹Θ唰嵿Ο 唳撪Κ唰囙Θ 唳膏唳班唳� 唳曕唳膏唳熰Ξ 唳唳傕Χ唳� 唳嗋Ξ唳︵唳ㄠ 唳曕Π唰佮Θ啷� @choraria 唳︵唳唳班

唳曕唳膏唳熰Ξ 唳唳傕Χ唳ㄠ唰佮Σ唳� 唳嗋Κ唳ㄠ唳曕 https://github.com/custom-functions/google-sheets/tree/main/functions- 唳� 唳む唳侧唳曕唳唳曕唳� 唳撪Κ唰囙Θ 唳膏唳班唳� 唳班唳唳溹唳熰Π唳苦Δ唰� 唳呧唳唳Ω 唳膏唳曕唳班唳唳� 唳唳Μ唳灌唳� 唳曕Π唰� 唳む唳班 唳曕Π唳� 唳唳傕Χ唳ㄠ唰佮Σ唳苦唰� 唳む唳む唳曕唳粪Γ唳苦唳唳 唳嗋Ξ唳︵唳ㄠ 唳曕Π唳む 唳︵唳 啷� 唳忇Ξ唳ㄠ唳� 唳嗋Κ唳ㄠ 唳呧唳唳�-唳呧Θ 唳ム唳曕 唳忇唳熰 唳ㄠ唳班唳︵唳粪唳� 唳唳傕Χ唳� 唳呧Θ唰佮Ω唳ㄠ唳о唳� 唳曕Π唳む 唳唳班唳ㄠイ



唳嗋Κ唳ㄠ唳� Google Workspace 唳呧唳唳�-唳呧Θ 唳曕唳唳 唳Θ唳苦唳距唳� 唳曕Π唳唳� 唳む 唳溹唳ㄠ唳ㄠイ @frenchcooc 唳︵唳唳班

Mailmeteor-唳忇Π 唳膏-唳唳班Δ唳苦Ψ唰嵿唳距Δ唳� Corentin Brossault-唳忇Π 唳忇 唳ㄠ唳班唳︵唳多唳曕, 唳曕Ο唳监唳� 唳唳� 唳嗋唰� 唳唳� 唳む唳ㄠ Google Sheets-唳忇Π 唳溹Θ唰嵿Ο 唳む唳佮Π 唳唳� 唳唳班唳� 唳呧唳唳�-唳呧Θ唳曕 唳曕唳唳 唳ㄠ唳︵唳曕Π唳� 唳曕Π唳唳� 唳む 唳ㄠ唳唰� 唳椸Μ唰囙Ψ唳` 唳曕Π唳涏唳侧唳�, 唳む唳� 唳む唳ㄠ 唳氞唳ㄠイ 唳忇Μ唳� 唳む唳� 唳忇 唳唳侧 唳唳膏唳熰 唳む唳ㄠ 唳嗋Κ唳ㄠ唳� 唳膏唳ム 唳唳� 唳曕Π唰囙唰囙Θ 唳曕唳唳 唳む唳ㄠ 唳唳囙Σ唳唳熰Π 唳� 唳忇唳� 唳曕Π唰囙唳苦Σ唰囙Θ唰�





唳膏Ξ唳距Η唳距Θ 唳膏唳唳侧唳囙


唳囙Ν唰囙Θ唰嵿 唳Π唳苦唳侧唳Θ唳�: 唳忇唳熰 唳呧Λ唳膏唳囙唰囙Π 唳溹Θ唰嵿Ο 唳忇唳熰 唳膏唳囙Θ 唳嗋Κ 唳む唳班 唳曕Π唰佮Θ

唳忇唳熰 唳忇Θ唰嵿Α-唳熰-唳忇Θ唰嵿Α 唳呧Λ唳膏唳囙 唳曕唳班唳唳侧唳� 唳膏唳囙Θ 唳嗋Κ 唳膏唳膏唳熰唳� 唳む唳班 唳曕Π唰佮Θ啷� 唳膏Ξ唳距Η唳距Θ唳熰 唳曕Π唰嵿Ξ唰€唳︵唳� 唳む唳︵唳� 唳曕唳班唳唳侧唳唳� 唳唳ㄠ唳︵唰佮Σ唳� 唳唳班唳距Χ 唳曕Π唳距Π 唳溹Θ唰嵿Ο 唳忇唳熰 唳Π唰嵿Ξ 唳む唳班 唳曕Π唰� 唳忇Μ唳� 唳曕唳班唳唳侧唳唳� 唳膏Ξ唳唳膏唳氞唳� 唳膏唳ム 唳曕Π唰嵿Ξ唳氞唳班唳︵唳� 唳唳ㄠ唳︵唰佮Σ唳苦唰� 唳唳侧唰�



Gmail-唳� AppSheet 唳呧唳唳唰佮Σ唳� 唳嗋Θ唳� 唳灌唰嵿唰�

AppSheet 唳∴唳唳ㄠ唳唳� 唳囙Ξ唰囙Σ Gmail-唳� 唳ㄠ-唳曕唳� 唳呧唳唳唳� 唳多唰嵿Δ唳� 唳ㄠ唳唰� 唳嗋Ω唰� 唳唳む 唳曕唳ㄠ 唳呧唳唳唳� 唳膏唳ム 唳囙Θ唰嵿唳距Π唳呧唳唳曕唳� 唳曕Π唳距Π 唳溹Θ唰嵿Ο 唳嗋Κ唳ㄠ唳曕 Gmail 唳涏唳∴唰� 唳唳む 唳灌Μ唰� 唳ㄠ啷� AppSheet 唳忇Π 唳膏唳ム 唳唳侧唳∴唳� 唳忇Π 唳忇 唳Π唰嵿Μ唰�, Google 唳∴唳唳侧Κ唳距Π 唳呧唳唳∴Ν唰嬥唰囙 唳曕唳班唳多唳氞唳唳距Θ 唳多唳侧唳� 唳呧唳唳Χ唳苦唰囙Π 唳曕唳涏 唳椸Δ唳苦Χ唰€唳� 唳囙Ξ唰囙Σ 唳曕唳粪Ξ唳む 唳唳班Ζ唳班唳多Θ 唳曕Π唰囙唰囙Θ, 唳唳� 唳Η唰嵿Ο唰� 唳唳Μ唳灌唳班唳距Π唰€唳︵唳� 唳侧唳囙Ν 唳∴唳熰唳� 唳膏唳ム 唳囙Θ唰嵿唳距Π唳呧唳唳曕唳� 唳曕Π唳距Π 唳呧Θ唰佮Ξ唳む 唳︵唳撪Ο唳监 唳忇Μ唳� 唳囙Ξ唰囙Σ 唳唳夃Δ唰� 唳ム唳曕 唳呧Μ唳膏唳ム唳 唳∴唳熰 唳Π唳苦Μ唳班唳むΘ 唳溹Ξ唳� 唳︵唳撪Ο唳监 唳膏啷� 唳嗋Κ唳ㄠ 唳曕唳唳 唳呧唳唳Χ唳苦 唳∴唳唳ㄠ唳唳� 唳囙Ξ唰囙Σ 唳唳Μ唳灌唳� 唳曕Π唳む 唳唳班唳� 唳む 唳溹唳ㄠΔ唰� 唳︵唳栢唳�!





唳膏唳ㄠ唳む 唳熰唳班唳唳曕唳班唳� 唳膏唳ム 唳忇 唳Π唳膏唳 唳膏唳ㄠ唳む唳曕 唳呧Θ唰佮Ω唳班Γ 唳曕Π唰佮Θ

唳膏唳ㄠ唳む 唳熰唳班唳唳曕唳� 唳灌Σ Google-唳忇Π 唳忇唳熰 唳唳班唳粪唳� 唳愢Δ唳苦唰嵿Ο, 唳唳栢唳ㄠ 唳忇唳熰 唳撪Ο唳监唳� 唳唳粪唳犩 唳班Ο唳监唳涏 唳 24唳多 唳∴唳膏唳唳Π 唳膏唳ㄠ唳む唳� 唳唳む唳班唳� 唳膏Ξ唳 唳む唳� 唳Π唰嵿Δ唳唳� 唳呧Μ唳膏唳ム唳� 唳︵唳栢唳, 唳膏唳囙Ω唳距Ε唰� 唳∴唳膏唳唳Π 唳溹唳∴唰� 唳嬥Δ唰� 唳膏Ξ唰嵿Κ唳班唳曕唳� 唳椸唳� 唳忇Μ唳� 唳唳∴唳� 唳膏 唳忇唳熰 唳膏唳椸唳 唳撪Ο唳监唳Ω唳距唳熰イ