{"id":9013,"date":"2022-05-26T15:48:55","date_gmt":"2022-05-26T08:48:55","guid":{"rendered":"https:\/\/gcloudvn.com\/?p=9013"},"modified":"2023-11-29T17:55:13","modified_gmt":"2023-11-29T10:55:13","slug":"trinh-ket-noi-appsheet-apps-script-moi","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/trinh-ket-noi-appsheet-apps-script-moi\/","title":{"rendered":"Build custom, integrated solutions across Google Workspace with the new AppSheet Apps Script connector"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">We\u2019re introducing a new AppSheet and Apps Script connector which allows you to extend custom, no-code apps to integrate and automate workflows across Google Workspace.<\/span>This greatly extends the abilities of AppSheet apps by letting them access the power that Apps Script provides. For example, an AppSheet app can now use Apps Script to automate workflows with Google Workspace using the Workspace APIs for Drive, Docs, Sheets, and Admin SDK, and more \u2013 as well as <span style=\"font-weight: 400;\">Google services such as YouTube, Google Analytics and <a href=\"https:\/\/gcloudvn.com\/en\/bigquery\/\">BigQuery<\/a>.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/trinh-ket-noi-appsheet-apps-script-moi\/#Ai_bi_anh_huong\" >Who\u2019s impacted<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/trinh-ket-noi-appsheet-apps-script-moi\/#Tai_sao_lai_quan_trong\" >Why it\u2019s important<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/trinh-ket-noi-appsheet-apps-script-moi\/#Bat_dau\" >Getting started<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/trinh-ket-noi-appsheet-apps-script-moi\/#Thoi_gian_trien_khai\" >Rollout pace<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/trinh-ket-noi-appsheet-apps-script-moi\/#Tinh_kha_dung\" >Availability<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ai_bi_anh_huong\"><\/span><b>Who\u2019s impacted<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Admins, End Users and Developers<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tai_sao_lai_quan_trong\"><\/span><b>Why it\u2019s important<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<figure id=\"attachment_9069\" aria-describedby=\"caption-attachment-9069\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9069\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2022\/05\/Untitled-2.png\" alt=\"Custom integration on Google Workspace with AppSheet Apps Script connector\" width=\"600\" height=\"450\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2022\/05\/Untitled-2.png 800w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2022\/05\/Untitled-2-300x225.png 300w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2022\/05\/Untitled-2-768x576.png 768w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2022\/05\/Untitled-2-16x12.png 16w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-9069\" class=\"wp-caption-text\">Custom integration on Google Workspace with AppSheet Apps Script connector<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">AppSheet is Google&#039;s platform for building code-free apps and workflows to automate business processes. AppSheet works well with mixed data sources, even if customer data is stored on Sheets, <a href=\"https:\/\/gcloudvn.com\/en\/cloud-sql\/\">Cloud SQL<\/a> or on-premises database.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Apps Script is Google\u2019s hosted JavaScript platform that makes it easy to build solutions that integrate, automate, and extend Google Workspace. Apps Script is integrated with Google Workspace APIs and includes native integrations to Google services such as YouTube, Google Analytics, and BigQuery.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">You can use the AppSheet Apps Script connector to extend custom no-code apps to integrate and automate workflows across Google Workspace. This is useful in a variety of scenarios, such as use cases in the retail, manufacturing or public sector. For example, you could use the connector with your AppSheet app to:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Receive employee travel requests via the web, and when a request is made, it can look up the requestor\u2019s manager and send a chat or email notification for approval.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Allow workers to capture photos from their mobile device for on-site inspections, and upload images and media to Google Drive and adjust Drive sharing settings to ensure auditors have access.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Manage shift schedules and appointments through a simple web interface, and when a time slot is booked, create an event on Google Calendar with the requestor invited.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Bat_dau\"><\/span><b>Getting started<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Admins and Developers: <\/b><span style=\"font-weight: 400;\">As a feature of AppSheet, this will be available based on the admin control for AppSheet. There is no admin control for this individual feature, only a <\/span><a href=\"https:\/\/support.google.com\/a\/answer\/10100275\" rel=\"nofollow noopener\" target=\"_blank\"><span style=\"font-weight: 400;\">product-level admin control for AppSheet.<\/span><\/a><span style=\"font-weight: 400;\">.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">See the Google Developer Blog for more information on <\/span><span style=\"font-weight: 400;\">Apps Script connector for AppSheet<\/span><span style=\"font-weight: 400;\">.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use our\u00a0 <\/span><span style=\"font-weight: 400;\">AppSheet Help Center documentation<\/span><span style=\"font-weight: 400;\"> and this <\/span><span style=\"font-weight: 400;\">video <\/span><span style=\"font-weight: 400;\">tutorial for more information on calling Apps Script from an automation.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Thoi_gian_trien_khai\"><\/span><b>Rollout pace<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Rapid and Scheduled Release domains: Full rollout (1\u20133 days for feature visibility) starting on April 13, 2022<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Tinh_kha_dung\"><\/span><b>Availability<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Tr\u00ecnh k\u1ebft n\u1ed1i Apps Script s\u1ebd kh\u1ea3 d\u1ee5ng cho ng\u01b0\u1eddi d\u00f9ng trong g\u00f3i AppSheet Core tr\u1edf l\u00ean (kh\u1ea3 d\u1ee5ng cho Google Workspace Enterprise, xem gi\u00e1 c\u1ee7a AppSheet). Ng\u01b0\u1eddi d\u00f9ng trong g\u00f3i Starter c\u00f3 th\u1ec3 th\u1eed nghi\u1ec7m t\u00ednh n\u0103ng n\u00e0y.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Through the above features, we can see that Google is reaping great benefits from applying AppSheet and Apps Script to extend code-free applications to integrate and automate workflow on Google Workspace.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Gimasys<\/b> proud <span style=\"font-weight: 400;\">is a senior partner of Google in Vietnam and has supported the implementation of Google Workspace solution for thousands of businesses in the country. Contact Gimasys for advice on a transformation strategy that is right for your business situation<\/span><span style=\"font-weight: 400;\">:\u00a0<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Gimasys \u2013 Google Cloud Premier Partner<\/b><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Hotline: <\/b><span style=\"font-weight: 400;\">Hanoi: <\/span><span style=\"font-weight: 400;\">0987 682 505<\/span><span style=\"font-weight: 400;\"> - Ho Chi Minh: <\/span><span style=\"font-weight: 400;\">0974 417 099<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Email: <\/b>gcp@gimasys.com<\/li>\n<li aria-level=\"1\"><span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/gcloudvn.com\/en\/dang-ky-dung-thu\/\" rel=\"nofollow\"><strong>Free Trial<\/strong><\/a><\/span><\/li>\n<\/ul>\n<p style=\"text-align: right;\"><strong>Source: <a href=\"https:\/\/gcloudvn.com\/en\/\">Gimasys<\/a><\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>Google \u0111ang gi\u1edbi thi\u1ec7u tr\u00ecnh k\u1ebft n\u1ed1i AppSheet v\u00e0 Apps Script m\u1edbi cho ph\u00e9p b\u1ea1n m\u1edf r\u1ed9ng c\u00e1c \u1ee9ng d\u1ee5ng t\u00f9y ch\u1ec9nh kh\u00f4ng s\u1eed d\u1ee5ng code \u0111\u1ec3 t\u00edch h\u1ee3p v\u00e0 t\u1ef1 \u0111\u1ed9ng h\u00f3a quy tr\u00ecnh l\u00e0m vi\u1ec7c tr\u00ean Google Workspace.\u0110i\u1ec1u&hellip;<\/p>","protected":false},"author":2,"featured_media":9068,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1,134],"tags":[],"class_list":["post-9013","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","category-google-workspace","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/9013","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=9013"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/9013\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/9068"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=9013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=9013"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=9013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}