About the talk
AppSheet now supports seamless integration with powerful Workspace technologies including AMP for Email and Apps Script. The first demo shares how to use the AppSheet Amp feature to send out emails with form controls. This allows recipients to submit responses back to the AppSheet app without having to leave their email context (no app required). The second demo shows how to connect an AppSheet app with existing Apps Script functions, allowing sophisticated Workspace automations.
Google Apps Script Documentation → https://goo.gle/3vqUZDJ
Building with AppSheet video series → https://goo.gle/2QvsNRv
AMP on Google → https://goo.gle/3xtEQzg
Speakers: Christian Schalk, Sarmad Hashmi
Google Workspace at Google I/O 2021 Playlist → https://goo.gle/io21-GoogleWorkspace
All Google I/O 2021 Technical Sessions → https://goo.gle/io21-technicalsessions
All Google I/O 2021 Sessions → https://goo.gle/io21-allsessions
Subscribe to Google Workspace → https://goo.gle/GoogleWorkspace
product: Cloud - API Management - AppSheet; event: Google I/O 2021; fullname: Christian Schalk, Sarmad Hashmi; re_ty: Premiere;
I'm passionate about Product Management, Developer Advocacy and overall Cloud technologies. At Google I've worked as a Cloud Developer Advocate, Technical Program Manager and also served as the first Product Manager to productize Google App Maker. I've also worked previously at Oracle as an Applications Developer and ultimately a Principal Product Manager for Oracle JDeveloper and ADF.View the profile
Passionate about changing the world for the better with software. Love to work on innovative and impactful products.View the profile
Hello and welcome to the Google IO session developing integrated apps apps, with workspace, app, for email and ask for it. By name is Christian shock. I'm going to Google developer Advocate and I'm joined today by sarmad. Who's the Google software engineer in this video will be introducing two, powerful new app sheet work space Integrations with app for email and ask her if the app for email integration, with out sheet. Hi. My name is Steven, Hauschka me. And I'm a software engineer on top sheet. Enables you to build. No code applications and automations back by Common data sources such as
Google Sheets XL, my Sequel and many more. I'm excited to tell you about a brand new capability were working on adding top sheet that extends your option, applications into Gmail, what's begin with a demo of how users can interact with actual applications right from within their email? For this demo, I built a new application that lets an employee. What's a simple request office equipment and have their manager. Let's say, Maria approve. These types of requests. And finally have our fulfillment team deliver the equipment to Santosh all the applications, but it could just as easily be
in a sales force or my sequel. Database manager can approve such a request from her email leveraging, the Dynamics in Gmail, and then I'll show you how you can build a wide variety of a pin, Gmail in minutes entirely, in a, no code manner. Let's separate into the shoes of an application user and request an item. What's the weather tonight? Mm? Add some justification. And hit submit request. As an application editor. I'm going to switch to the Google sheet now, which my
application uses as the data source. You'll see here that the request, I just submitted was successfully added to the sheet in a separate room, but noted some columns like approved status and approval notes. They remain empty because do be filled out later by the approver. My app already includes an automation, that's in the manager of Maria and approval request. So whenever a new request comes in asking for her approval, for any items that were requested. Automations in action today. Allow you to trigger certain steps based on events later. I'll actually
show you how I set these up for now though. Let's head over to Gmail in Maria's inbox. You'll see that she's received an email from a cheap. This is an 8mp or dynamic email. The beauty of this integration is that Maria is interacting with a fragment of my option application right here inside Gmail. She never has to switch way to a browser or the actual application. The email Josie here. Contains the details. I entered earlier as a user but in addition to that, it contained some editable fields. I'll go ahead and add some approval notes.
And then get approved. And now, again, switching back to the app editor perspective. If I go back to the Google sheet, I can see now that the status is updated and my notes were added to the same row as earlier. The Fulfillment team can now take this forward. All Maria had to do was open up her email and approve the request. So what's involved in this in this approval to your own application? There's the application view were Santosh makes the request. The automation, that sends an email to Maria and the ANP application approved the request.
Would just a few steps, you're actually application experience is extended into Gmail. You might be wondering what's so different? From what we haven't actually today. Some of you may not be familiar with that cheese. So let me give you a very brief introduction. Actually. Does Google's no code platform. You can build entire applications without ever having to code. The application that you just saw with all its interactions was built entirely without she and I'll show you how in just a bit now. Without she, you could already build apps and automations to do most of this. For
example, you could create a mobile app for equipment requests and create an automation to inform managers by email. But today, those emails were just getting a link to open the app managers would actually have to log in and perform the approval in the app itself. And that's what we've now enhanced with Dynamic emails, Dynamic, email application views directly inside Gmail by leveraging. A m p, this is simple, but powerful. And now, let me show you how it all comes together. And now, she I'm going to head over back to a sheet and see how this is all configured in the
application editor. Here's the request of you that's endorse used to request an item. And here is the approve of you which is similar to the one. Maria saw in her email. The only difference is that right. Now this doesn't contain any editable Fields, but we want the approval status and approval notes just like we had in the email. Secure in the application editor. I'm going to add some quick at. It feels would enable managers to edit those fields from within this View. You'll see now that in the application, the fields are editable.
And I did this all in just a few clicks. So now, let's head over to the automation Tab and see how we can configure this view in a dynamic email. Here's an automation. I already have that sends a simple email to approvers. Whenever I request is created all the, you know, does right now is send the approval, a link to open the request in the air here. Is that step? I'm going to update it so that it now send the approval of you in a dynamic email instead. Here. Also like the AMT email task. Select the approve review.
Enter Maria's email and it's safe. This automation will not take the selective. You convert it into a dynamic email and send it off to Maria for approval. In a couple of steps and without writing any code, I created an automated approval workflow that takes minimal human effort. Without applications and dynamic emails. The possibilities for Rich email interactions are endless in just a few seconds. And without any code, you can construct a logical application and render it through Dynamic email. So that users can respond to it within
their Gmail inbox from the simple example. The value that a m p brings to your existing a no code applications and process automation. Thank you. And hello again from Christian. I'll be introducing the new app sheet and apps gift integration future. I should point out that this feature is currently in limited review and is expected to change over time. But we wanted to give you at least a general idea of how this new feature currently works today. Some basic assumptions before continuing though. You'll need to be familiar with app, scripts development. And more
importantly, a script project configuration and deployment, you'll also need to be familiar with GCB project. Configuration as well as how to set up a lot of clients on the app. Side, you'll need to be familiar with basic app sheet development, including setting up webhooks as well as general account configuration. So at a high-level, the integration works by having a nap sheet. Webhook call an applicant function, that belongs to an app script project that has been deployed as API executable. If you don't know what some of those terms mean right now, no worries. We'll walk through them in
more detail. And once you set up this integration, it enables some very sophisticated hybrid apps script and app sheet applications. For example, in our demo will show how you can connect an app sheet front and application to capture photos and then pass these photos to an abstract function, which place has them into a Google Slides presentation. Before showing the demo. Let's briefly walk through the necessary configuration steps for TCP app script and a half sheet, starting off with gcp. You'll first, have to enable the app script API and your gcp project. You'll also need to take note of
the project number. And finally You'll need to set up an OS, web app, client ID, and secret, as you'll need these. When configuring apps, you on the app script side, you want to create or identify and that's good function that you wish to call from absolute. You'll then need to associate your apps script functions project with your gcp project, by setting it up with the gcp project. Number that you saved in the prior step. Finally. You'll need to deploy the apps group project as an API executable, as you deploy. Save the deployment ID as well as any Oma Scopes associated with the project as
app sheet will need these as well. Switching over to the app. She configuration in your app sheet accounts page. You'll add a new outbound Channel integration of type apps script beta. In addition, to name your channel. You'll set the channel options with your g, c, p, o, s, client ID in secret, as well as any apps script projects. You're almost done. You can now build applications that can call app Scribd functions. You'll still need to configure a weather though. Call your apps script. Don't you, let's walk through that now. So for our final steps, you'll first need any basic app
that can save data that can be used as an absolute function parameters for example, image URL and to trigger the called to ask if you'll need to create a workflow or automation task to trigger a webhook, when a row is added, you'll then need to configure the webhook with the following set. A script as the preset option, as well as the deployment ID that you say from your apps script project appointment, not the script ID. That is the absolute function name, which is to be called by the webhook as well. As any function parameters that are needed in such as the image URL example, and
that's it. Once the setup is complete. You can run the app and Trigger the webhook by adding a new row. Let's now switch to the demo to see an example of a hybrid app, sheet apps script app in action. What are done, is that created a simple on demo app here? And actually, we're especially I'm able to save any images and image URL and the title. I built up a couple of images here and the way it works is that whenever I save this record in my up here, it will call and ask it function and then the apps function. Well, then add the image URL as well as the
title. So every time I insert a new record, I got a new slide appended to my slide deck here. So let's dig a little bit deeper on the application itself. So first off in order for me to act on, when the new record is created. I created a simple workflow rule that will go through and it will call the abstract function and it will run this task, the webhook task. So, the webhook task is set up to call the app script function, that takes in the two arguments for immaterial entitled. And so, what I can do now is just switch back to the apps script function. So, if I can show
you here, here's my apps script code that says he takes the two arguments and pens that in the slide deck. So pretty straightforward. So, in order for this to work though, I had to deploy this project as an API executable. So I have the safety. I actually kill ball and I have this deployment ID. So that's essentially deployment ID that I specified in the webhook settings. All right, and also you may have noticed. The other thing is that for the project itself. I had to set it up. So that it's using this app. Great project is now bound to a tsp project and the
gcp project has its own ohap Prudential. So I thought he had clients secrets and I use those to set up the, the outbound apps script Channel, which is the source of the new feature that helps you provide so that you can actually call the function, that that's the toys, Mexico boxer. Obviously, that was going fairly quickly. But let's just go ahead and insert a new, record. You'll see it in action. So, go ahead and grab an image. all right, and then I'll say,
So now I have that it. So now all I have to do is go over to the slide deck and I will see that my my new image is also in my presentation. All right, we'll switch back over to this. And there we go. We have a new slides. I got it started. Thanks to calling the accurate function. As you've just seen in this video, how she is further enhanced by both the app for email integration where you can send apps apps over email and take actions within your application without leaving G and the app scripts and app sheet integration where you can both preserve your existing apps trip, business,
Buy this talk
Buy this video
Our other topics
With ConferenceCast.tv, you get access to our library of the world's best conference talks.