Tag Archives: AppSheet

Extract and categorize data in AppSheet with the power of Gemini

What’s changing

At Google Cloud Next 2025, we introduced Gemini in AppSheet solutions for AppSheet Enterprise Plus users. Now you can automatically extract key information from uploaded photos, parse through complex PDFs, or even categorize, route and prioritize incoming requests based on their content – all seamlessly within your existing AppSheet apps. The new AI Task (Preview) feature, powered by Gemini, makes this a reality.

AppSheet Enterprise Plus users can now leverage this new 'AI Task' when building automations. These AI tasks make Gemini handle the heavy lifting, allowing it to supercharge your processes. Whether it's extracting details from equipment photos, processing PDF purchase orders, or categorizing incoming requests by their nature, Gemini is here to assist—all directly within your AppSheet.

To ensure these AI-powered features work precisely as you intend, you can quickly test individual steps within your workflow using the integrated AI Task Step Testing feature, now generally available (GA). This allows you to iterate with speed and confidence.

The AI Task, extract, and categorize functionality is available for all AppSheet Enterprise Plus users in preview. AI Task Step testing is now GA for all AppSheet Enterprise Plus users.

Testing the extract AI Task feature in AppSheet


Who’s impacted

Admins and end users


Why it’s important


AI Made Easy & Powerful: Integrating Gemini into AppSheet significantly simplifies how you incorporate advanced AI functions, such as data extraction and categorization, into your apps. It's designed to be user-friendly and effective:
  • Get started quickly: The extract and categorize AI capabilities work out-of-the-box once enabled (see "Getting started" below).
  • Customize with context: Easily add additional context or instructions to tailor the results to your specific needs.
Here are just a few examples of what you can do:


Extract Information:
  • Have technicians snap a photo of equipment; use the AI Task to automatically extract the Serial Number, Model Number, or Meter Reading into your AppSheet table.
  • Process uploaded purchase orders (PDFs) or photos of shipping labels to extract PO numbers, company names, tracking numbers, or addresses.
  • Extract key details like location, date, or names from incident reports.
  • Extract purchase details from a PDF contract, categorize order details by fulfillment team, and assign follow up action items.

Categorize Records:
  • Analyze the description in employee expense submissions and automatically categorize them by type ("Travel", "Meals", "Software", "Training").
  • Read incoming facility maintenance requests and categorize them by urgency ("High", "Medium", "Low") or equipment type ("HVAC", "Plumbing", "Electrical").
  • Classify customer survey responses or feedback form submissions into types like "Bug Report", "Feature Request", "Positive Feedback", or "Billing Inquiry".

Before deploying your AI-powered automations, remember you can use the AI Task Step Testing feature, now in GA, to rigorously validate how your AI Tasks (Preview) perform with your specific data and instructions. This crucial step allows you to iterate, refine configurations, and see immediate results on data from your table, ensuring your AI-powered automations work as intended without needing to test the entire bot.


Additional details

  • Usage of AI tasks during preview: During this Public Preview phase, AppSheet Enterprise Plus users have complimentary access to explore and learn these Gemini AI Task capabilities. We plan to track usage against entitled credits when these AI Task features become generally available.
  • Testing quotas: Running inline tests using the AI Task Step Testing feature will count towards your general AppSheet automation limits and entitled credits when AI Task becomes generally available.
  • Admin governance policies can be applied as described below in "Getting started."
  • App creators must enable preview features for their apps as described below in "Getting started."


Getting started

  • Admins: 
    • Optional: For AppSheet Enterprise Plus accounts, Gemini features are accessible to app creators who follow the steps below. However, Admins can define governance policies to control or disable the use of AI Tasks powered by Gemini. Learn more about controlling which app creators can use AI in automations.

  • End users:
    •  App Creators - Required for Preview access: 
      • To use Gemini in AppSheet solutions’ AI Tasks during this public preview, please follow the instructions to turn Gemini in AppSheet solutions on or off.

        As part of this process, you will need to ensure your app is included in the AppSheet preview program - learn more about the AppSheet preview program here. This step is required for access unless an organization or team policy prevents usage (see the Admin section above).

      • As you explore the new Gemini AI Task capabilities in AppSheet, your feedback is invaluable in helping us shape this feature for GA. We encourage you to take a few minutes to share your thoughts through our feedback survey. Your responses are confidential and will be used for research purposes only. 

Rollout pace

  • Gemini in AppSheet solutions’ Extract and Categorize AI tasks are now available in preview.
  • AI Task Step Testing is GA for all AppSheet Enterprise Customers. 

Availability

  • Gemini in AppSheet solutions (preview) and AI Task Step Testing require an AppSheet Enterprise Plus account

Resources



Introducing AppSheet User Pass

What’s changing

Starting today, you can license any user of your apps with AppSheet User Pass. Each User Pass grants unlimited access to an AppSheet app for the month and your users can consume as many User Pass licenses as they need. This gives you the flexibility to pay for the features that will make a difference for your users, whether they are internal or external to your organization, signed-in or unauthenticated.

Additional details

How is an AppSheet User Pass is different from traditional Google Workspace licenses?:

  1. User Pass licenses are available to your app users as a pool, rather than assigned to individual users through the Google Admin console. Licenses are automatically consumed each time an eligible user accesses one of your AppSheet Enterprise Plus or AppSheet Core apps. Eligible users include those that do not already have an AppSheet license or have a license of a lower tier than the app owner, including internal, external, or unauthenticated users.

  2. Users consume a license for each app they use - allowing you to license your app users at a discounted rate. User Pass will not independently grant these users the ability to build apps with Core or Enterprise features, but it is possible for an eligible user to consume more than one User Pass license if they access multiple unique apps in a month. For example:


Please also note that:
  • The pool of User Pass licenses resets at the end of the calendar month and unused licenses do not rollover. You will only be charged for the user pass licenses that you have committed to purchase.
  • AppSheet User Pass will be available through Workspace and the Partner Sales Console. 
  • We recently alerted customers that starting April 10, 2025, the AppSheet Enterprise Standard External User and AppSheet Enterprise Plus External User licenses will no longer be available for purchase. Customers with existing external user licenses will not see any interruption in service during this transition and will receive additional notice with next steps.

Getting started

Rollout pace

Availability

Available for Google Workspace:
  • Business Starter, Standard, and Plus
  • Enterprise Starter, Standard, and Plus
  • Education Standard and Plus
  • Frontline Standard
  • AppSheet Enterprise Plus

Resources


Embed AppSheet apps directly in Google Sites

What's changing

We're excited to announce that you can now embed authenticated AppSheet applications as iframes directly within Google Sites pages. While previously only public apps could be added to Sites, now, apps that require sign-in can be embedded so that users can securely interact with the app directly on a Google Sites page. 

Key Benefits

  • Streamlined user experience: Eliminate the need for users to navigate between multiple tabs. Users can now interact with authenticated AppSheet apps directly within Google Sites pages, boosting productivity and efficiency.
  • Centralized workflows: Build powerful, interactive business applications like intranet portals and wikis by embedding key tools and information directly into Google Sites.
  • Controlled by policy: Leverage AppSheet’s existing in-app authentication and policy rules, ensuring consistent and secure access to your applications. Creators have control to disable embedding functionality in their apps.

Embed AppSheet Apps in Google Sites





Overall, support for iframe embeds of authenticated apps in Sites enables secure, seamless integration of your enterprise-grade AppSheet applications and empowers you to create more robust and user-friendly Google Sites. 


Additional details

  • Embedding authenticated (e.g. "sign-in required” or “restricted”) apps is only supported for Google Sites pages. “Public apps” continue to be embeddable in any website.
  • Use a Chromium-based browser with third-party cookies enabled. Incognito mode and blocking cookies will prevent apps from functioning properly.
  • We recommend ensuring the embedded AppSheet app (iframe) is fully visible. Partial visibility or excessive zoom may cause interaction issues.

Getting started



Rollout pace


Availability



Resources


Google Workspace Updates Weekly Recap – February 21, 2025

1 New update

Unless otherwise indicated, the features below are available to all Google Workspace customers, and are fully launched or in the process of rolling out. Rollouts should take no more than 15 business days to complete if launching to both Rapid and Scheduled Release at the same time. If not, each stage of rollout should take no more than 15 business days to complete.



Improved experience for highlighting and annotating images for AppSheet apps on Android 
We're pleased to introduce a new experience for marking up images within AppSheet apps on Android devices. Now, your users can add precise highlights and markings to images, making visual communication clearer and more effective:
  • Add geometric shapes: Draw rectangles, ellipses, and arrows to highlight key areas 
  • Include text: Add labels and descriptions directly onto the image 
  • Move and edit: Reposition shapes and text annotations with ease 
  • Zoom: Zoom in and out before and after adding drawings for added precision 
Improved experience for highlighting and annotating images for AppSheet apps on Android
This update makes it easier for users to direct attention to specific details, which is especially helpful when you need to require proof, like submitting an incident report, or submit documentation, like inventory checks. | Rollout to Rapid Release and Scheduled Release domains is complete. | Available to AppSheet Free, AppSheet Core and AppSheet Enterprise Plus. Google Workspace editions that include AppSheet Core can be viewed here. | Visit the AppSheet community to learn more about this feature and check out the Help Center to get instructions for allowing users to draw on images.




Previous announcements

The announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.


Workspace data loss protection (DLP) for Gmail is now generally available
A big threat organizations must prepare for is the risk of data exfiltration through unwanted and/or unauthorized means. Whether it’s small-scale, unintended sharing, or a larger breach scenario, organizations need powerful defenses to protect themselves from these risks. To that end, we’re pleased to announce that today Data Loss Prevention (DLP) is generally available in Gmail, alongside Drive and Chat. | Learn more about DLP for Gmail. 

“Take notes for me” in Google Meet now captures “next steps” 
We’re pleased to announce that “take notes for me” will capture next steps discussed during the meeting in a new “suggested next steps” section. | Learn more about “next steps”.

Scroll through live captions and translated captions in Google Meet 
We’re improving the live captions and translated captions experience in Google Meet by including the ability to scroll through the text. | Learn more about live captions and translated captions in Google Meet. 

Updating the access experience in Google Drive 
Last year, we introduced a beta that allows shared drive managers and My Drive owners to restrict folders to specific users. Today, we’re excited to announce the general availability of this feature in shared drives and My Drive, which means that users can restrict access to their My Drive folders using the two options outlined below, and by 2026, we will simplify and align the restricted access principles for My Drive and shared drives. | Learn more about access in Drive. 

Expanding data regions coverage to Google Classroom 
We previously added data regions coverage to Google Drive, Docs, Sheets, and Slides, and this week, we’re extending data region coverage to primary user data for Google Classroom for the U.S. and E.U. data regions. | Learn more about data regions coverage in Google Classroom. 

Use Gemini in the side panel of Workspace apps in seventeen more languages 
Gemini in the side panel of Google Docs, Google Sheets, Google Drive, and Gmail can be used in seventeen additional languages | Learn more about language availability. 

Updated design for Google Meet meeting controls on Android and iOS 
We are updating the location of some Google Meet meeting controls on Android and iOS devices, which are intended to organize features in a more intuitive way. | Learn more about meeting controls on mobile.

Migrate data from Microsoft Teams channels to Google Chat spaces using CloudM
Building on last year’s announcement of the general availability for Chat APIs to import data from messaging platforms to Google Chat, we’re excited to introduce a new migration solution from a Workspace partner, CloudM. | Learn more about migrating data to Chat.

The Policy API is now generally available with support for auditing more security features
We recently introduced the Policy API in open beta, letting super admins programmatically access information regarding how their Google Workspace environment service level settings and rules are configured. Beginning today, the Policy API is now generally available with more functionality. | Learn more about the Policy API.

“Take notes for me” in Google Meet now captures citations to transcripts
Recently, we announced that next steps will automatically be captured when using “take notes for me” in Google Meet. Building upon that momentum, your meeting notes document will now include citations, or timestamps, which correlate to the exact point in the meeting transcript that references the summarized notes. | Learn more about Meet citations to transcripts. 

Gemini Deep Research and most experimental models now available to Google Workspace users in Gemini Advanced
We’re pleased to announce the launch of Deep Research and most experimental models to Google Workspace users with access to Gemini Advanced. | Learn more about Deep Research.

New Chat Usage Analytics Updates for Admins and Developers
Starting today, customerUsageReports.get and userUsageReports.get for Google Chat are available via the Admin SDK Reports API for customers to use in their own customized dashboards and reporting tools. This gives admins more ways to analyze Chat usage data. | Learn more about Chat Usage Analytics updates.


Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog posts for additional details.


Rapid Release Domains: 
Scheduled Release Domains: 
Rapid and Scheduled Release Domains: 

    For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).       

    Now generally available: Monitor and manage AppSheet usage in your organization with the AppSheet Admin console

    What’s changing 

    Beginning today, we’re pleased to announce that all Google Workspace Admins with the AppSheet service privilege can access the AppSheet Admin Console. The AppSheet Admin console is a consolidated location to monitor, manage and govern AppSheet across your organization. Previously, the AppSheet Admin Console was only available to those with an AppSheet Enterprise Plus license in public preview, but now any admin with sufficient privileges has access to monitor and manage their users (note: some features require an enterprise license for the admin and the user). 


    The AppSheet Admin Console gives admins visibility into the users, apps and licenses associated with their AppSheet users. From here, admins can: 
    • Review the most popular apps and creators. 
    • Review how many apps are owned and used for every user account. 
    • View all of their organization's app users. 
    • Verify the AppSheet licenses purchased, assigned and used. 
    • Export a list of accounts, users, apps and licenses. 

    Since Public Preview, we’ve added more functionality: 
    • Historical app usage: Admins can see app usage history for all accounts in their organization up to three months starting today and soon extending to six months. 
    • Self-serve provisioning: Admins can choose how their enterprise licenses are provisioned - either through license assignment in the Workspace Admin Console or automatically upon login to AppSheet.  
    • Organizations as the new standard: New and existing Workspace customers can manage all of their secondary domain users under a consolidated AppSheet organization.
    The AppSheet Admin Console



    Who’s impacted

    Admins


    Why it’s important

    We’ve heard from our customers that in order to effectively manage AppSheet activity in their organizations, they need visibility into its usage. This includes information regarding how many users are using an AppSheet license, who is accessing their teams apps, and more. Expanding access to the AppSheet Admin console provides admins with these critical metrics, enabling them to understand how the tool is being used and govern the use of the tool as needed.


    Additional details

    The Licenses page will remain in public preview pending some supporting launches and additional enhancements expected early in 2025.


    Getting started


    Rollout pace


    Availability


    Resources


    Google Workspace Updates Weekly Recap – August 30, 2024

    2 New updates

    Unless otherwise indicated, the features below are available to all Google Workspace customers, and are fully launched or in the process of rolling out. Rollouts should take no more than 15 business days to complete if launching to both Rapid and Scheduled Release at the same time. If not, each stage of rollout should take no more than 15 business days to complete.


    The AppSheet Admin Console is now available in public preview
    For the first time, Workspace admins will have visibility into the users, apps and licenses associated with their AppSheet users via the AppSheet Admin Console. Previously, these advanced monitoring capabilities were limited to AppSheet Enterprise customers. Now all Workspace admins with the AppSheet service privilege can use this data to gain a deeper understanding about how their users are interacting with AppSheet. With the AppSheet Admin Console, you can view all the app users across any of your organization’s apps, review the most popular apps and creators, and more. Admins can also take actions like exporting a list of accounts, users, apps, and licenses for their organization or set the role of users in their organization. Eligible customers can access the AppSheet Admin Console using this direct link or clicking out from Apps > Google Workspace > Settings for AppSheet in the Workspace Admin Console. | The open beta for the AppSheet Admin Console is available now for AppSheet Enterprise customers and AppSheet Core entitled customers. | Visit the Help Center to learn more about using the AppSheet Admin Console.
    The AppSheet Admin Console

    Google Workspace for Education users can now set and share personal pronouns and name pronunciation
    Google Workspace for Education admins of K-12 and higher education institutions can now give their students the option to set their pronouns from their Google Account at aboutme.google.com. This option is OFF by default and can be enabled for all users or a subset of them (such as for a specific location or class). User-defined pronouns will appear in personal information cards displayed when hovering over or clicking someone’s profile photo across Workspace apps like Gmail, Calendar, Docs, Sheets, Slides, Chat, and Drive. Pronouns will also appear in Google Contacts, accessed by clicking “Open detailed view” from the personal information cards. | Pronouns are rolling out now to Rapid Release and Scheduled Release domains. | The ability to add name pronunciation will be available by the end of Q3, 2024. | Available to all Google Workspace for Education customers. | Visit the Help Center to learn more about allowing Directory users to change their pronouns and changing pronouns in your Google Account settings.
    EDU - personal pronouns and name pronunciation


    Previous announcements

    The announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.


    Automate your workflows on Google Chat with IFTTT and UKG Flow integrations 
    Following the announcement at Google Cloud Next 2024, we’re excited to introduce Google Chat integrations with IFTTT and UKG Flow. | Learn more about Chat integrations with IFTTT and UKG Flow. 

    Picture-in-picture in Google Meet will now open automatically when switching tabs
    Picture-in-picture mode will now automatically trigger when you switch tabs during a meeting. | Learn more about picture-in-picture in Meet. 

    Business Starter customers will soon have access to shared drives 
    Business Starter will officially have access to shared drives starting mid-September. When shared drives are made available to Business Starter customers, all users will be able to create shared drives by default. If this default behavior is undesired, admins can update their settings before Business Starter users gain access to the feature starting on September 23, 2024. | Learn more about shared drives for Business Starter. 

    Reply to emails in Gmail faster on Android devices 
    You can now reply to emails directly from the bottom of the conversation, without opening a new screen, making it easier to reference the email you’re replying to. | Learn more about replying to emails on Android. 

    Upload additional types of documents to Gemini (gemini.google.com) for insights and analysis 
    Google Workspace users with a Gemini Business, Enterprise, Education or Education Premium license can now upload a variety of files from Google Drive or locally from your device into Gemini. | Learn more about document upload with Gemini. 

    “Take notes for me” in Google Meet is now available 
    “Take notes for me” is an AI-powered feature in Google Meet that automatically takes notes, allowing you to focus on discussion, collaboration, and presentation during your meetings. | Learn more about “Take notes for me” 

    Google Meet provides consolidated email for all meeting artifacts 
    Currently, Google Meet sends an email for each type of meeting artifact initiated in a meeting, including meeting recordings, meeting transcripts, Gemini notes with “take notes for me,” live streams and more. Going forward, you’ll receive one email consolidating these artifacts. | Learn more about Meet’s meeting artifacts. 

    Customize Gemini (gemini.google.com) for your specific needs with Gems 
    Gems are now available to Google Workspace customers with a Gemini Business, Enterprise, Education, or Education Premium add-on. | Learn more about Gems.

    Gmail Q&A: A new way of searching your inbox with Gemini on Android devices
    Gmail Q&A feature is rolling out now on Android devices and coming soon to iOS. | Learn more about Gemini in Gmail.

    Additional data protection in Gemini (gemini.google.com) when using a school account is now available
    Earlier this year, we brought Gemini for Google Workspace to education communities with two new paid add-ons. At that time, we announced that educators and students 18 years and older who did not have a Gemini Education license would soon get added data protection when using Gemini (gemini.google.com) as an Additional Service with their school accounts. Beginning this week, that added data protection is now available — free of charge. | Learn more about data protection in Gemini. 


    Completed rollouts

    The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog posts for additional details.



    Rapid Release Domains: 
    Scheduled Release Domains: 
    Rapid and Scheduled Release Domains: 

    For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).  

    Google Workspace Updates Weekly Recap – August 9, 2024

    3 New updates

    Unless otherwise indicated, the features below are available to all Google Workspace customers, and are fully launched or in the process of rolling out. Rollouts should take no more than 15 business days to complete if launching to both Rapid and Scheduled Release at the same time. If not, each stage of rollout should take no more than 15 business days to complete.


    Appointment slots booking pages are no longer available in Google Calendar 
    Earlier this year, we announced that the appointment slots feature will be replaced by appointment schedules in Google Calendar. Starting this week, appointment slots booking pages will no longer be available and all new appointments will need to be booked through appointment schedules. | Rollout to Rapid Release and Scheduled Release domains is scheduled to complete by the end of August 2024. |  Appointment schedules are available to Google Workspace Business Starter, Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Standard, Education Plus, the Teaching and Learning Upgrade, Nonprofits, Google Workspace Individual, Google One Premium users and users with personal Google accounts. | Visit the Help Center for detailed information about appointment schedules. 

    Dark mode now available in Google Classroom on mobile 
    Similar to the recent announcement of dark mode in Google Drive, users will now be able to change the color theme of Google Classroom on their mobile device. This new setting aims to provide users with a more comfortable, customizable viewing experience and also reduces battery usage. | Available to Google Workspace Education Fundamentals, Standard, Plus, the Teaching & Learning Upgrade customers. | Rollout to Rapid Release and Scheduled Release domains is complete. | Visit the Help Center to learn more about using Dark Mode in Classroom.
    Dark mode in Classroom

    New automation event for AppSheet databases is now generally available 
    We’re excited to announce the general availability of AppSheet database automation events, allowing users to kick off automation workflows based on changes made directly in their AppSheet database. | Available to AppSheet Free, AppSheet Core and AppSheet Enterprise Plus. Google Workspace editions that include AppSheet Core can be viewed here. |  Rollout to Rapid Release and Scheduled Release domains is complete. | Visit the AppSheet community to learn more about this feature and check out the Help Center to get instructions for building your first automation using an AppSheet database.

    New automation event for AppSheet databases

    Previous announcements

    The announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.


    Available in open beta: configure third-party apps by select API scopes 
    We’re giving admins another layer of granular control for third-party apps. Specifically, you can now configure apps to be limited by selected OAuth 2.0 Scopes for Google APIs, such as Drive or Gmail scopes. | Learn more about the beta to configure third-party apps by select API scopes. 

    Providing student engagement signals for Google Drive file attachments in Google Classroom 
    We’re introducing a new feature that surfaces richer student engagement data on assignments with Google Drive attachments in Google Classroom. With this update, teachers will have easily accessible visibility into whether students have made progress on assignments with Drive attachments through pre-existing workflows in Classroom. | Learn more about Drive file attachments in Classroom.

    “Take notes for me” in Google Meet is rolling out soon; pre-configure access with a new admin setting
    “Take notes for me,” an AI-powered feature in Google Meet that automatically takes notes during your meetings, will be rolling out soon. Prior to end user availability, admins can now configure whether their users can use this Google AI note-taking feature with a new Admin console setting. | Learn more about the admin setting for “Take notes for me.”

    Completed rollouts

    The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog posts for additional details.



    Rapid Release Domains: 
    Scheduled Release Domains: 
    Rapid and Scheduled Release Domains: 


      For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).  



      Introducing AppSheet Organizations

      What’s changing 

      We’re making it easier to manage your AppSheet users with the introduction of AppSheet Organizations. An AppSheet organization creates organization administrators with a centralized tool to manage all of the teams in the organization and delegate team management responsibilities to team administrators. 

      This chart shows the hierarchical relationship between an organization, and its teams and members. 




      An organization is based on a Workspace organization and is tied to your primary domain. One organization can contain multiple teams based on Google groups and Workspace organizations.


      Who’s impacted

      Admins


      Why you’d use it

      AppSheet organizations significantly simplify the management of users and policies across all their AppSheet teams. Admins can:
      • Access self-serve tools to make changes that formerly required manual Support team intervention.
      • Create and manage organization-level policies that apply to all teams and manage individual team policies.
      • Create new teams with distinct admins, users and policies as needed. Admins can also independently assign or remove team, root, or organization administrator roles of any user.


      Additional details

      Support for non-Google authenticated users
      For new and existing customers with AppSheet Organizations, any user from your verified primary or secondary domains that does not authenticate through Google will be shown in your domain-based teams alongside any group-based teams that have been created. These users will be subject to the same policies and team settings that apply to your users that authenticate through Google.


      Getting started


      Rollout pace



      Availability


      Resources


      Available in open beta: Build AppSheet automations using Google Forms

      This announcement was part of Google Cloud Next ‘24. Visit the Workspace Blog to learn more about the next wave of innovations in Workspace, including enhancements to Gemini for Google Workspace.

      What’s changing

      AppSheet helps users automate manual workflows by integrating with data sources like Google Drive and Sheets, and today we’re excited to announce its integration with another data collection tool in Workspace: Google Forms.


      Many companies rely on the data collected via form submissions when they are performing tasks for ticketing or incident reporting. However, prior to today you could only view information from form submissions via email, spreadsheet or in the Forms app itself. 


      With this update, Google Forms submissions can act as event triggers within AppSheet Automations. These automations can then take many different actions, such as sending notifications or approval requests to Gmail or Google Chat, or even calling a custom Apps Script function. 
      Build AppSheet automations using Google Forms is now available in beta


      Who’s impacted 

      Admins, end users and developers 


      Why you’d use it 

      This integration enables users to receive actionable notifications based on responses to Google Forms.


      Getting started 

      • Admins: 
        • AppSheet admins can use AppSheet’s Policy Engine to control access to this feature by App Creators in their organization. Visit the Help Center to learn more about policy enforcement in AppSheet policies and specific guidance on preventing app creators from using Google Forms. 
        • This feature is available as an open beta, which means AppSheet app creators can use it without enrolling in a specific beta program. 
      • Developers and end users: Visit the Help Center to learn more about building automations using Google Forms. 

      Rollout pace 


      Availability 

      Available for Google Workspace: 
      • Business Starter, Standard, Plus 
      • Enterprise Standard, Plus 
      • Enterprise Essentials Plus 
      • Education Fundamentals, Standard, Plus and the Teaching & Learning Upgrade 
      • Frontline Starter, Standard 
      • AppSheet Starter, Core, Enterprise Standard, Enterprise Plus 

      Resources 

      AppSheet smart chips for Google Docs

      What’s changing 

      In Google Docs, you can already insert smart chips for Docs, Sheets and Slides files, date chips, Calendar event chips, and more. Beginning today, you can now insert smart chips for AppSheet content. These smart chips allow you to access AppSheet data directly into Docs — you’ll be able to view and take action on the data, including triggering automations, without having to leave Docs.







      Getting started


      Rollout pace

      • This feature is available now.

      Availability

      • Available to Google Workspace customers with AppSheet licenses.

      Resources