skip to Main Content
Welcome to Gimasys!
Hotline: +84 974 417 099 (HCM) | +84 987 682 505 (HN)

Build custom, integrated solutions across Google Workspace with the new AppSheet Apps Script connector

We’re 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.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 – as well as other Google services like YouTube, Google Analytics, and BigQuery.

Who’s impacted

Admins, End Users and Developers

Why it’s important

appsheet and apps script connector
Tích hợp tùy chỉnh trên Google Workspace với trình kết nối AppSheet Apps Script

AppSheet is Google’s platform for building no-code custom apps and workflows to automate business processes. AppSheet works well with mixed data sources, even if customer data is stored across Sheets, CloudSQL, or on-premise databases.

Apps Script is Google’s 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.

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:

  • Receive employee travel requests via the web, and when a request is made, it can look up the requestor’s manager and send a chat or email notification for approval.
  • 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.
  • 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.

Getting started

  • Admins and Developers: 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 product-level admin control for AppSheet.
  • Xem Blog phát triển của Google để biết thêm thông tin về Apps Script connector for AppSheet
  • Use our  AppSheet Help Center documentation and this video tutorial for more information on calling Apps Script from an automation.

Rollout pace

  • Rapid and Scheduled Release domains: Full rollout (1–3 days for feature visibility) starting on April 13, 2022


  • The Apps Script Connector will be available for users in the AppSheet Core plan and above (available to Google Workspace Enterprise, see AppSheet pricing). Users in the Starter plan can test the feature.

Qua những tính năng trên, ta có thể thấy Google đang đạt được lợi ích lớn từ việc áp dụng AppSheet và Apps Script để mở rộng các ứng dụng không cần code nhằm tích hợp và tự động hóa quy trình làm việc trên Google Workspace.

Gimasys tự hào là đối tác cấp cao của Google tại Việt Nam và đã hỗ trợ triển khai giải pháp Google Workspace cho hàng nghìn doanh nghiệp trong nước. Liên hệ Gimasys để được tư vấn chiến lược chuyển đổi phù hợp với tình hình thực tế doanh nghiệp của bạn

  • Gimasys – Google Cloud Premier Partner
  • Hotline: Hanoi: 0987 682 505 - Ho Chi Minh: 0974 417 099
  • Email:

Source: Gimasys

Back To Top
0974 417 099