- Install an add-on
- Create a template with Files Cabinet
1 - Install the add-on
Inside Google Sheets, go to Add-ons > Get Add-ons
In the add-ons pop-up:
Type-in "Files Cabinet" in the search bar (1)
Click Free (2) to install the add-on.
Choose the pertinent Google account to be used in Awesome Table. Click Allow.
The Files Cabinet add-on is now successfully installed on Google Sheets.
2 - Use Files Cabinet to display Google Drive contents
1.) To start using Files Cabinet, create or open a blank sheet within Google Sheets then rename the file.
2.) Select Add-ons > Files Cabinet by Awesome Table > Start Listing.
3.) Under Current folder, select Please pick a folder (Pick).
4.) Choose the target folder that contains the files you want to publish then click Select
5.) Click Create List of Files.
6.) After the script successfully executes, you’ll be presented with the automatically-generated datasource.
At this point, you could either:
- Proceed to Step 7 or
- Take the time to apply all pertinent keyword(s) for your specific use-case.
7.) Click the Create button to automatically-generate and direct you to a preconfigured AwesomeTable view.
* You can further customize the view according to your specifications. Click here to learn how.
Information about the number of generated folder(s) and files are available in the sidebar.
* Note that there are currently 28 files.
3 - Use your own metadata
With Files Cabinet, you can even add your own metadata.
Let’s say you have a list of PDF invoices, you can add a new column to your spreadsheet with the customer’s name for each invoice. Or, if you renamed or added files within the target folder (including files in subfolders), new information like the PDFs title, creation date or last update will be reflected in the datasource (and view) after running the add-on.
Note: If needed, only insert additional column(s) to the right of the Custom Metadata columns. This way, the values you entered for each file will be retained / untouched even after updating.
Otherwise, if you inserted column(s) anywhere within the automatically-generated columns, the Header & Keyword rows will get overwritten while retaining the metadata values you entered - causing unintended results or conflicts in the published view.
In this tutorial, you learned how to use the Files Cabinet add-on to create a completely new view. In the next tutorial, you’ll learn how to update your existing datasource and view quickly and easily.