Google Drive

Google Sheets + Google Drive Integration

List files from Google Drive into Google Sheets

What is Sheet Director?

Sheet Director is a Google Workspace add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho etc. 

It is available in the Google Workspace Marketplace. Please check the Installation instructions to install the add-on. 

What is Google Drive?

Google Drive is a file storage and synchronization service developed by Google. 

Google Drive allows users to store files on their servers, synchronize files across devices, and share files.

Files created and edited through the office suite are saved in Google Drive

Google Drive to Google Sheets: Use Case(s)

> Select a folder from google drive and list all its files inside sheet - List Files

Google Drive

Sheet Director

Google Sheets

Setting up Google Drive in Sheet Director

Choosing App and Service:

Google Drive Configuration:

Destination Settings:

Scheduler Settings:

Notification Settings:

 Sample Output: