G Suite Google Apps Script Spreadsheet Folder File Lister
5.0 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,277 students enrolled

G Suite Google Apps Script Spreadsheet Folder File Lister

Explore how you can list your Google Drive content into a spreadsheet G Suite GDrive and Spreadsheet app content
5.0 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,277 students enrolled
Created by Laurence Svekis
Last updated 5/2020
English
English [Auto]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 10 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Google apps script
  • How to select drive items
  • How to append content to a spreadsheet
  • Files and folders in Drive get details
Course content
Expand 21 lectures 01:04:24
+ Introduction to Google Apps Script DriveApp spreadsheet project
21 lectures 01:04:24
Resources
00:22
Source Code
00:02
DriveApp list folder Contents
07:15
Source Code
00:06
Append To Spreadsheet
06:27
Source Code
00:09
More File Object Details
10:31
Source Code
00:14
Get folder by Name.
04:21
Source Code
00:17
UI Prompt Value
03:59
Source Code
00:29
Dynamic File Details Search
05:15
Source Code
00:39
Folder Searcher.
03:51
Source Code
01:01
Folder Lister Conclusion
06:20
Source Code
01:17
Requirements
  • JavaScript and coding experience
  • Google Account
  • Google Script experience
Description

Explore how you can create an application to list folder and file info into your spreadsheet using Google Apps Script. Introduction to Google Apps Script DriveApp spreadsheet project

Explore using Google Apps Script to list content contained within your drive folders, list out files and folders and track into a spreadsheet

Excellent way to track who content is shared with and who have what access into you files and folders.

Google apps script is like JavaScript in the cloud, allowing you to connect the Google Suite of products together to do some amazing things.

Within the lessons of this course we'll demonstrate how to list folder and file details into a Google Spreadsheet

JavaScript is a prerequisite to this course, DO NOT take the course without prior coding experience.

Use the Sheet UI to add a button to our spreadsheet

Click the button run the function that selects from the drive

List files and folder properties into your spreadsheet

Discover the power of Google Apps Script and some of the amazing things that you can do with it.

Taught by a Google Developer Expert with many years of web development experience - ready to help you learn more about Google Apps Script

What are you waiting for join now and start creating awesome applications with Google Apps Script.

Who this course is for:
  • Web developers
  • Application developers
  • Google apps Script developers
  • JavaScript programmers