Guide

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

Are you tired of manually keeping track of all the files that enter your important Google Drive folders? We understand how frustrating it can be to spend a lot of time on record-keeping, which can negatively impact your productivity and workflow. But worry not. With Relay, you no longer have to worry about manually recording file additions. It automatically logs all the necessary details of the added files to an Airtable database, making it easy to access and reference them whenever needed. This integration empowers you to easily collaborate with others on Google Drive, knowing that all file additions are being tracked and recorded. In this guide, we’ll show you how to set this integration up in four easy steps. Let's get started!
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.

Google Drive logo Google Drive
More information

More how-to guides featuring Google Drive and Airtable

See all how-to guides ➔
Google Drive iconAirtable icon
Automatically update Airtable records whenever new Google Drive folders are added
Managing work across multiple platforms can be daunting in today's fast-paced professional world. Professionals often need help keeping up with document management, record-keeping, and tracking folders and files, which can be time-consuming and get in the way of more meaningful work. Fortunately, with Relay.app automation, organizing work has been much easier. Relay.app bridges your Google Drive and Airtable, allowing you to manage your work efficiently. With this workflow, a corresponding record is either updated or created in Airtable whenever a new folder is created in Google Drive. This seamless connectivity fosters better document management and record-keeping, boosting productivity while ensuring smooth operations across both platforms. In this guide, we’ll show you how to set this integration up in four easy steps. Let's get started!
Google Drive iconAirtable icon
Create Google Drive file shortcuts for new Airtable records
Do you ever get tired of spending a lot of time searching for files on your computer? Looking for that crucial document amidst multiple folders can be frustrating and time-consuming. However, managing your documents can be much easier than you think. With the help of a Relay automation, you can have all your essential files in one place that's easily accessible. You'll never have to worry about misplacing important files or wasting time searching for them again. In this guide, we’ll show you how to set this integration up in four easy steps. Let's get started.
Google Drive iconAirtable icon
Update selected Airtable records with new files added in specific Google Drive folders
Are you tired of constantly switching between different tools and struggling to maintain accurate data records? With Relay, you can now keep your Airtable records updated and organized without any tedious manual effort. By setting up this automation, you can ensure that whenever a new file is added to a specific folder in Google Drive, the corresponding record in your Airtable base will be automatically updated. This will not only save you time and effort but also help you maintain consistency and accuracy in your data records. In this guide, we’ll show you how to set this integration up in four easy steps.

Get started with Relay.app

Sign up now and get started with your playbook today