How to combine AppSheet with Apps Script - Video tutorial
ฝัง
- เผยแพร่เมื่อ 5 พ.ค. 2024
- 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
Get Apps Script code: github.com/googleworkspace/ap...
Subscribe to our TH-cam channel: / @googleworkspacedevs
Subscribe to our Google Workspace Developer Newsletter: developers.google.com/workspa...
#AppSheet #GoogleAppsScript #GoogleWorkspace - วิทยาศาสตร์และเทคโนโลยี
Subscribe to this channel to learn more about AppSheet and Apps Script.
Thnks! after watching many videos, none explain as clearly as this one! Following the exact step by step it help me making the connection!
Glad the video was useful.
Thanks for you
Welcome 😃
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
Currently, you can choose the following triggers within AppSheet to run an Apps Script: data change, schedule and chat (slash command). Having a button in AppSheet as a trigger is currently not available.
@@googleworkspacedevs Thank you very much for speed answer. I believe that I will try playing of these triggers.
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 ? )
You can call Apps Script from an automation in AppSheet for many different use cases. For this, the data source does not necessarily have to be Google Sheets.
Note, that you do not have the option of making changes directly to AppSheet database the way you can with Sheets.
See the options you have for using Apps Script with AppSheet: support.google.com/appsheet/answer/11997142?hl=en&ref_topic=11997049&sjid=15986310939094142599-EU
@@googleworkspacedevs Thanks a lot 💐for your quick answer ... madame. I expected this answer ( with a little hope for an other solution ) from now on the situation is very problematic for me. appsheet is a nice tool, but has its limit. ( e.g. if you use the pdf output of an bot, you may declare headers and footers for the pdf file, but this does not work ). therefore i had to make a docs template with header and footer ... and with appscript i fill in the data, and after the filling in the script generates the pdf file. the original bot created pdf i got in at about 5 seconds. the process with appscript takes 30 seconds. and so on and so on.
This is only 1 case, where i habe to use appscript.
I worked nearly 40 years in IT, but i never ever had problems like these. crazy ....
Please forgive my bad english, in my whole life i had no issue to use it.
you helped me a lot with your videos ... ❤️
Hi, this function is only available for appsheet core plan right?
You can test the Apps Script tasks in AppSheet with the free plan.
If you want to deploy an app using Apps Script tasks you will need the Core plan or higher. about.appsheet.com/pricing/
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
Glad to see you've been inspired by this video tutorial!
@@googleworkspacedevs How can I manage the email permission to access the folder?
Como anunciar uma empresa visando clientes com interesses específicos?
Are you referring to an AppsSheet application being advertised to customers?
is this a AI bot?
No, this Chat app is not using any AI features.
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.
Sounds like you are looking for a mail merge where you have rows of email addresses in Google Sheets and need to send them email messages.
Check out this sample: developers.google.com/apps-script/samples/automations/mail-merge
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 ${newFolderId}?usp=share_link.
How can I fix the errors above. I appreciate your support.
Issue 2 might mean that there is a typo in the script. This might also be causing issue 1.
@@googleworkspacedevs
Thank you for the reply.
I figured it out to get these issues resolved by asking a friend of mine who knows GAS.
#1, I set trigger condition as Ads only with other condition. Those two triggered the automation twice. I only use AddOnly as the trigger, then it resolved.
#2 issue was obviously that script on the TH-cam was not correct. I changed rerun value to url + constant value. Then it is working now😊
Subscribe to this channel to learn more about AppSheet and Apps Script.