How to combine AppSheet with Apps Script - Video tutorial

Have you ever combined AppSheet, Google’s no-code solution, with Apps Script, Google’s low-code tool?

In this video, you are going to learn how you can create an application with AppSheet and automate actions within it with Apps Script.

00:00 Intro
00:19 Prepare the data
01:58 Create the app
02:44 Customize app
06:10 Add Apps Script
09:44 Test app

#AppSheet #GoogleAppsScript #GoogleWorkspace

[googleworkspacedevs]

Join us for a full day of learning and inspiration at the Google Workspace Developer Summit!

[robinpuerta]

Thnks! after watching many videos, none explain as clearly as this one! Following the exact step by step it help me making the connection!

[cameronkirby]

This changes the entire approach to my app im building with the bot connected to the apps script. Very epic and cool video by my best buds at google

[googleworkspacedevs]

Subscribe to this channel to learn more about AppSheet and Apps Script.

[AlberichRheinmann]

your videos .... madame Chanel No 1 are the best tutorial videos ( i think webwide 😊 ). Meanwhile i have no problems to acess data ( these are spreadsheets ) via appscript. One serious problem with handling data via sheets is a time problem. i think spreadsheets are not the best way to store data, it takes to much tasktime. My question now: can i work with appscript, if the data is stored in an appsheet database ? and then, how to do it ( same way as with sheets ? )

[chrisder]

hello When there is no module to copy paste my API key then I have to use a script?

[petersoncpxb]

this is what I'll do. since we can't multi select images, I will create an app script to create a driver folder and once I open it I will select multiple images and then create folder view I. the app... I hope it works

[danielfernandolegorretacis]

Hello, good material, I just have a question about a script I wrote for several spreadsheets, I would like a script to be executed depending on the record in appsheet with a button... Do you think it's possible? Thank you

[AdilsonChrestaniJunior]

Question > Is it possible to automatically create a view on the appsheets through google script?

[mundobinariobyaxel]

Hi, this function is only available for appsheet core plan right?

[LosInmortalesGallos]

Hi. I'm trying to add a function to a simple app I created. I have a google sheet file with two tables one is called "patients" and the second one is called "dates". in the "dates" table the patients are schedule appointments weekly or every 10 days by inputing the next appointment date in a cell titled "next appointment date" after each visit. In the "patient" table there is also a cell titled "next appointment date". I want the cell in the patient table to automatically get the "next appointment date" from the input in the "dates" table., How can I do this?

[jay_wright_thats_right]

This video must be for onboarding a team at a company. I feel like I'm watching an HR video.

[lhjeejt]

Como anunciar uma empresa visando clientes com interesses específicos?

[qdczdfi]

This makes absolutely no sense to me at all. I just need to send emails from google sheets and everything I search says I can but these videos are speaking way above my head. I don't even know if this is the correct video to watch but it's what google sent me to.

[xohtmrs]

This is great video and I tried and pertially workd. Two issues are
1. For some reason, two same folders were created
2. Folder URL has some error. GAS script does not show color chaged for
How can I fix the errors above. I appreciate your support.

[googleworkspacedevs]

Subscribe to this channel to learn more about AppSheet and Apps Script.