How to log details of new Google Drive files to your Airtable data base

Relay.app is an automation tool that lets you automate actions across Google Drive, Airtable, and many other apps. In this guide, we'll show you how to automatically run the “add record to table” action in Airtable for each file added to folder in Google Drive using Relay.app.
Google Drive logoGoogle Drive > Airtable
Trigger
Last triggered
Google Drive logoFile added to folder
Airtable logoAdd record to table
1

Set the Google Drive trigger as “File added to folder”

Add the Google Drive trigger to initiate your playbook's actions before adding the file to a folder.

To do this, click "Add trigger" in your playbook. Choose the "File added to folder" trigger from the Google Drive options, then choose a folder where you want to store your files (e.g., "My Drive"). It will enable your playbook to identify newly added files and trigger necessary actions automatically.

If you have yet to connect your Google Drive account to Relay, a prompt will guide you through the connection process.

2

Add the “Add record to table” in Airtable step

Integrate the Airtable automation to instantly add records from new Google Drive files.

Select "Add Step" and search for the "Add row to sheet" automation. Then, choose the table where you want to add a record - let's say it's the "Files" table. Once you've selected the table, click on all the relevant fields and fill in the necessary details, such as Actual file, Creation time, Last time modified, Mime type, Modified by me or not, Parent folder, and Title.

If you still need to connect your Airtable account to Relay, you will be prompted to complete that connection. Make sure to allow the necessary permissions for Relay to add records through your Airtable account.

3

Activate your playbook

Activating your playbook is the final step to automate the tracking of Google Drive files via Airtable. Once turned on, it will respond to log new Google Drive files in Airtable without manual intervention.

To enable your playbook, click the toggle button located in the header. It is advisable to perform a test run of your playbook beforehand to ensure all steps work seamlessly together.

More how-to guides featuring Google Drive and Airtable

See all how-to guides ➔

What will you automate?

Sign up and get started with your first Relay.app workflow today.
Background imageBackground image