Audit a Google Drive folder
In this article, we will show how you can use Google Drive by Folgo, and how to use our pre-configured template report (dashboard). We’ll discuss which option is best for your needs.
Use a blank report template
This option can be used if you simply want to list your file data in a table, for example to embed a database in a website (visit this article to learn how!).
Or, if you are familiar or adept with Google Data Studio and you want to fully customize your report (dashboard). You can create your own layout, theme, & insert relevant elements (charts, control, data, ...) that suit your needs.
1. Open Data Studio.
2. Click the Create button > Report:
3. Enter ”Folgo” or ”Google Drive” in the search field > click the Google Drive (by Folgo) card:
4. You will see the Google Drive (by Folgo) setup page:
Blank Setup page
You need to fill out needed information about your target folder (data source):
a. Copy the Google Drive link of your target folder then paste this to the field Enter the URL of a Google Drive Folder:
📌Note: You can leave this field blank if you want to list all the files owned by you.
b. In the Data freshness field, choose an appropriate interval on how frequently you want to update the target folder’s content. We recommend an hourly update so as not to slow your dashboard’s performance:
5. Click the Add button and then ADD TO REPORT:
6. Your untitled Google Drive Connector report editor is now ready. You can give your report a descriptive name, modify the layout & theme, insert relevant elements (charts, control, data, ...) as needed:
Here’s our edited report with a few modifications done:
💡Tip: To display pictures in your table, add the field Thumbnail URL to your table and change the field type to URL > image:
Use the pre-configured template
This option is best for you if you need to inspect a folder, you can use the interactive view to oversee and drilldown the contents of your Google Drive folder.
It can also be useful if you are new to Google Data Studio and you want to easily create a pre-configured report (dashboard). No rigorous customization is needed since everything will be done for you.
1. Open Data Studio.
2. Click the Create button > Data source:
3. Enter ”Folgo” or ”Google Drive” in the search field > click the Google Drive (by Folgo) card:
4. You will see the Google Drive (by Folgo) setup page.
You need to fill out needed information about your target folder (data source):
b. Copy the Google Drive link of your target folder then paste this to the field Enter the URL of a Google Drive Folder:
📌Note: You can leave this field blank if you want to list all the files owned by you.
c. In the Data freshness field, choose an appropriate interval on how frequently you want to update the target folder’s content. We recommend an hourly update so as not to slow your dashboard’s performance:
d. Leave the Use report templates for new reports checked. This will generate a dashboard for your target folder:
Filled-out Setup page
e. Click the CONNECT button.
You will now see the Data Source Schema (editor) where you can add, duplicate, or hide fields:
5. To accept the default report layout, click CREATE REPORT > CREATE REPORT:
Google Drive Connector report in editor mode.
Your Google Drive Connector report editor is now ready.
You can rename the report, edit or modify the layout, theme, & elements (charts, control, data, ...) as needed:
6. Click the View button to display your Google Drive’s interactive views. This contains a Dashboard where you can review and drilldown the content of your Drive folder:
Here’s our Report (Dashboard) for your Google Drive folder that you can interactively drill down.