Automate Google Drive File Sharing & Logging with Airtable

What This Workflow Does

This workflow checks a Google Drive folder for new files automatically.

When a new file appears, it shares the file by email and then records details about the file into Airtable.

This saves time and makes sure no file is missed or logged incorrectly.

Who Should Use This Workflow

This workflow is good for people who manage files for a team or clients.

It helps to send new files quickly and keep a clear record of what was shared.

Users do not need to check folders manually or write down file details.

Tools and Services Used

• Google Drive: To detect new files and share them via email.
• Airtable: To store and track file information.
• n8n: To build and run the automation workflow.

Inputs, Processing, and Outputs

Inputs

• New files added in a specific Google Drive folder.
• Recipient email addresses for sharing files.
• Airtable base and table settings for logging file data.

Processing Steps

• The Google Drive Trigger detects each new file.
• The Google Drive node shares the file to a specified email.
• The Airtable node records the file’s ID, name, creation time, modification time, and recipient email.

Outputs

• An email sent with the shared file.
• A new record in Airtable logging file details.

Beginner Step-by-Step: How to Use This Workflow in n8n

Step 1: Import the Workflow

1. Download this workflow using the Download button on this page.
2. Open the n8n editor.
3. Choose Import from File and load the downloaded workflow.

Step 2: Configure Credentials and Settings

1. Add your Google Drive OAuth2 credentials in n8n.
2. Add your Airtable API Key and connect to the right base and table.
3. Update the Google Drive Trigger node with the exact folder ID you want to watch for new files.
4. Update the Google Drive node with the recipient email address to share files.
5. Check the Airtable node field mappings to match your table schema.

Step 3: Test and Activate

1. Upload a test file to the Google Drive folder you selected.
2. Check if an email is sent and a record is added to Airtable.
3. If all works, activate the workflow.
4. Make sure n8n stays running continuously. For example, use self-host n8n or a cloud server.

Customization Ideas

• Add multiple email recipients by duplicating the permissions in the Google Drive node.
• Watch other or more folders by changing the folder ID or adding multiple triggers.
• Add more columns in Airtable for file size, type, or uploader user to get more detail.

Common Problems and How to Fix Them

• Problem: No trigger when files are added.
  Fix: Check you selected the right folder ID and that OAuth credentials have access.
• Problem: File sharing emails not sent.
  Fix: Make sure recipient emails are entered correctly and permission type is set to user.
• Problem: Airtable records missing.
  Fix: Verify Airtable API Key is correct and field names match exactly.

Summary

✓ Saves time by automating file sharing and record keeping.

✓ Avoids missed emails and logging errors.

✓ Keeps clear record of shared files with details in Airtable.

→ Runs automatically when new Google Drive files appear.

→ Sends files by email and logs metadata in Airtable.