New files in your Google Drive need to reach the right person fast. This setup finds each new file in a chosen folder, shares it with a set email, and records key details in Airtable for tracking. Teams that move documents every day will value the speed and clean audit trail.

It runs on a Google Drive event that checks the folder every minute and picks up new files. Next, a Google Drive step grants writer access to the recipient so they get instant access by email. Finally, an Airtable step adds a row with file name, file ID, created time, modified time, and the recipient email. The path is simple and direct, which keeps the flow stable and easy to maintain.

You need a folder in Drive and an Airtable base and table ready. Connect Google Drive with OAuth and Airtable with a personal access token, then replace the test email with your own. Expect less manual sharing, fewer mistakes, and clear logs for audits. It fits onboarding packs, client uploads, and vendor handoffs.

• Google Drive trigger watches a specific folder for new files every minute.
• Share File action grants writer access to a chosen email address automatically.
• Airtable create record stores file ID, name, created time, modified time, and recipient email.
• OAuth2 connection for Google Drive and token based connection for Airtable in n8n Cloud.
• Straight line flow from trigger to share to log for fast processing and easy upkeep.

• Reduce manual sharing work from 20 minutes to 2 minutes per file
• Automate 100 percent of new file log entries in Airtable
• Improve data accuracy by 95 percent by pulling metadata directly from Drive
• Connect Google Drive and Airtable without manual exports or copy paste
• Create a searchable audit trail of who received which file and when
• Handle hundreds of new files per day with no extra effort

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Drive and Airtable. See the Tools Required section above for links to create accounts with these services.
3. Prepare resources: create or choose a Google Drive folder to watch. In Airtable, create a base and table with columns for FileId, FileName, CreatedTime, ModifiedTime, and RecipientEmail.
4. In the n8n credentials manager, open the Google Drive Trigger node and click Create new credential. Choose Google Drive OAuth2, then follow the on screen steps to sign in and authorize your account. Name the credential clearly, for example GDrive Main.
5. Configure the Google Drive Trigger: set Trigger on to specific folder, pick your folder, choose the file created event, and keep the poll time at every minute for fast pickup.
6. Open the Share File with Recipient node. Set Operation to share. In permissions, set role to writer, type to user, and enter the recipient email. Replace any test email with your real recipient address.
7. In the Airtable node, click Create new credential and choose Airtable Token. Generate a Personal Access Token in your Airtable account API page, paste it into n8n, and save with a clear name like Airtable PAT Operations.
8. Select your Airtable base and table. Map fields to expressions from the Google Drive trigger so FileId and FileName come from the trigger item. Include CreatedTime, ModifiedTime, and the same recipient email you share with.
9. Activate the workflow. Upload a test file to the watched Drive folder. Confirm the recipient gets access by email and check that a new Airtable row appears with the correct metadata.
10. If files are not shared, verify the email is correct and allowed by your domain. If no records appear in Airtable, check the base and table selection and confirm field names match.
11. For timing issues, confirm the workflow is active and the poll interval is every minute. Check time zones and ensure the file is newly created in the watched folder.
12. For security, use reader instead of writer if editing is not needed. Limit credential access in n8n and rotate Airtable tokens on a regular schedule.