Тёмный

Google Apps Script: A Google Drive Tutorial 

saperis
Подписаться 30 тыс.
Просмотров 19 тыс.
50% 1

Опубликовано:

 

22 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 42   
@haroldpierre1726
@haroldpierre1726 Год назад
I had no idea Google Apps Script existed. Thank you for this video.
@saperis
@saperis Год назад
You are more than welcome 😀
@PartTimeHero77
@PartTimeHero77 2 года назад
You are an amazing instructor. Thank you for all you teach us.
@saperis
@saperis 2 года назад
You are very welcome 😀
@djerikgerst12
@djerikgerst12 Год назад
thank you. very usefull. regards erik
@saperis
@saperis Год назад
Glad it was helpful! 😀
@ianthomson5336
@ianthomson5336 2 года назад
Hey thanks a bunch for the help. Was wondering what code I would need to include in order to past a link to the folder in status rather than "complete". would you be able to help me with this?
@saperis
@saperis 2 года назад
Thanks for watching our videos. We share our knowledge, tips and ideas through this channel. But we don't do any coding for viewers or customers. Here maybe some hints so you can achieve your goal yourself. When creating a new folder or file you can get the respective link and then simply add it to the file. Check the official documentation to see how you can use Google Apps Script to interact with your files and folders: developers.google.com/apps-script/reference
@GenNextAnalyst
@GenNextAnalyst 2 года назад
Thanks a lot Chanel!
@saperis
@saperis 2 года назад
You are welcome! 😀
@nssdesigns
@nssdesigns 2 года назад
I'm in a career where I deal with data and i simply want to merge PDF files from my GDrive into one document using sheets to filter the files needed. I have collected the data and written the sheets but i'm looking for an apps script to merge the files. Is this something your course can help me develop?
@saperis
@saperis 2 года назад
No, that is nothing we cover in our Apps Script online course.
@ntc2203921
@ntc2203921 2 года назад
Hello. Thank you for sharing this video. I have a problem as follows. Can you help me. How to add path to another directory. for example, when I choose A, it will automatically create folders and files into folder 1. When I choose B, it will automatically create folders and files into folder 2
@saperis
@saperis 2 года назад
As demonstrated in the video you access that folder you want and create the file within it. Access the folder with the getFolderById() for example. See how to use Google Apps Script for Google Drive in the documentation: developers.google.com/apps-script/reference/drive
@robertclemons9669
@robertclemons9669 2 года назад
Thanks!
@saperis
@saperis 2 года назад
You're very welcome and thank you for supporting our channel. 😀
@pratikgiri878
@pratikgiri878 2 года назад
Hi can we run a JavaScript or python code when a specific file changes in drive ?. Let's say we have a form in drive and form contains quiz question and answer . if the form question or answers are edited . I wanna run some code . is this possible ?
@saperis
@saperis 2 года назад
If you want to use Node.js or Python to access any files on Google Drive, you would have to use the Google Drive API. developers.google.com/drive/api If you want to use a trigger, an on Edit trigger, that triggers your code to run when a file changes, you would have to use Apps Script like in the video. So you either use the Drive API with a language like Python or Node.js or you use Apps Script that gives you access to Drive like I do in my videos.
@pratikgiri878
@pratikgiri878 2 года назад
@@saperis thank you for your reply . also would onEdit trigger work on form ? because the drive file that I want to track changes of is a google form file
@ferneychauxcoorado9691
@ferneychauxcoorado9691 2 года назад
Saludos desde Colombia, sería muy chévere ver los subtítulos en español
@saperis
@saperis 2 года назад
Hola Ferney. Talvez en futuro podremos añadir subtitulos en español.
@wassup102
@wassup102 Год назад
Hi, how do I check if the folder already exists before creating it?
@saperis
@saperis Год назад
You would have to add a conditional if statement before you have a new folder created. www.w3schools.com/js/js_if_else.asp
@siddharth3419
@siddharth3419 Год назад
Hi is there any way to show images from google Drive url without sharing it??
@saperis
@saperis Год назад
I don't understand, you want to show (to whom and where) images without sharing them?
@siddharth3419
@siddharth3419 Год назад
@@saperis I want to show images in google sheet, url also and images also from google Drive, but will I have to. Set images to. Anyone with the link can view, to. Show images in google sheet
@saperis
@saperis Год назад
@@siddharth3419 You can add images to Google Sheets (Insert > Image). The image should be visible to anyone who has access to the Sheets file.
@quangnguyenduy3358
@quangnguyenduy3358 Год назад
Hi, my code: function printMessage() { const folder = DriveApp.searchFiles("test"); Logger.log(folder.next().getName) } However, when the script reaches the line 'var folder = DriveApp.getFolderById("myfolderID");' I encountered an 'Exceeded maximum execution time' error. how to fix?
@saperis
@saperis Год назад
Maybe this article can help: pulse.appsscript.info/p/2021/08/an-easy-way-to-deal-with-google-apps-scripts-6-minute-limit/
@БогданКалічка
@БогданКалічка 2 года назад
It is awesome what you did. Can I hire you to create a similar code for my task?
@saperis
@saperis 2 года назад
No, I don't offer any coding services.
@Jerome-N
@Jerome-N 2 года назад
Hello ma'am I have a question. Can my organization access my folders in my google drive without me knowing?
@saperis
@saperis 2 года назад
Not directly. But an admin could reset your password and log in as you. So indirectly there are ways to do so. But most companies have regulations that inhibit admins of doing such things. Anyway, always keep in mind: whatever data you create and store with your company account belongs to the company. If you want to store personal things than your company's My Drive isn't a good choice.
@Jerome-N
@Jerome-N 2 года назад
@@saperis That was insightful. Thank you ma'am! 😊
@Jerome-N
@Jerome-N 2 года назад
@@saperis Last question ma'am, could the admin reset the password and log in as me without notifying? Even though the 2-step verification is activated and my phone number is linked into it.
@saperis
@saperis 2 года назад
@@Jerome-N According to this support article from Google that wouldn't work: support.google.com/a/answer/9176734?hl=en But we are only experts for the enduser side of things. If you want a 100% security on this you should reach out to a Google Workspace admin.
@Jerome-N
@Jerome-N 2 года назад
@@saperis thank you ma'am!!
@thomas.albert
@thomas.albert Год назад
How do I access files in Google Drive that was deleted 6 months ago? please help me
@saperis
@saperis Год назад
If it was deleted then there is nothing to access. If your account is a paid Google Workspace your employer might be using Vault. In that case contact your Google Workspace administrator.
@techcrowd8248
@techcrowd8248 2 года назад
Hi how do I access css files in Google apps script
@saperis
@saperis 2 года назад
You have to put it in a separate .html file within the script editor and between style HTML tag. See the details here: developers.google.com/apps-script/guides/html/best-practices#page.html
Далее
Google Apps Script Tutorial for Beginners
23:54
Просмотров 383 тыс.
Make a Copy of a Google Sheet with Apps Script
10:00
Просмотров 4,3 тыс.
what is Google Apps Script?  [Tutorial]
10:48
Просмотров 134 тыс.
Approachable AI: Get started with Apps Script & Gemini
34:45