How to automatically update Airtable records whenever new Google Drive folders are added

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 use Relay.app to automatically run the AirtableUpdate record” action for each Google DriveFolder created” event.
Google Drive logoGoogle Drive > Airtable
Trigger
Last triggered
Google Drive logoFolder created
Airtable logoUpdate record
1

Set the Google Drive trigger as “Folder created”

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

To do this, click "Add trigger" in your playbook. Choose the "Folder created" trigger from the Google Drive options. It will enable your playbook to identify newly created folders and trigger necessary actions automatically.

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

2

Add the “Update record” in Airtable step

Integrate the Airtable automation into your playbook to ensure prompt updates for every folder added to a particular table.

To add a step to your playbook, select "Add Step" and look for the "Get record" automation. Then, choose the table you want to work with; for example, let's say you want to work with the "Folders" table. Once you've chosen the table, select an identifier in the "Add filter" from your sheet data to match the Google Drive data. In this example, the identifier is "Creation time".

Afterward, add another step to your playbook by selecting "Update record." Next, click on the relevant fields you want to update and fill in the necessary details, such as creation time, mime type, and last date modified.

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

3

Activate your playbook

Activating your playbook is the last step in the process. Once you turn it on, it will automatically update Airtable records whenever new Google Drive folders are added 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 playbook today.
Background image