Workflow: Sync New Files From Google Drive with Airtable
Integrations: airtable, googleDrive, googleDriveTrigger, stickyNote, stopAndError

{"id": "uLHpFu2ndN6ZKClZ", "meta": {"instanceId": "workflow-06d72cb3", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:55.291940", "updatedAt": "2025-09-29T07:07:55.291955", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "name": "Sync New Files From Google Drive with Airtable", "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "nodes": [{"id": "f648b663-8adb-4587-bf80-cff7554b72c4", "name": "Share File with Recipient", "type": "n8n-nodes-base.googleDrive", "notes": "Share File via Email", "position": [660, -20], "parameters": {"fileId": {"__rl": true, "mode": "id", "value": "={{ $json.id }}"}, "options": {}, "operation": "share", "permissionsUi": {"permissionsValues": {"role": "writer", "type": "user", "emailAddress": "test@gmail.com"}}}, "credentials": {"googleDriveOAuth2Api": {"id": "", "name": ""}}, "notesInFlow": true, "typeVersion": 3}, {"id": "29c9dacf-e9fa-49b7-81e5-0416dbdbc9ba", "name": " Log File Metadata", "type": "n8n-nodes-base.airtable", "notes": "Store File Metadata", "position": [940, -160], "parameters": {"base": {"__rl": true, "mode": "url", "value": ""}, "table": {"__rl": true, "mode": "url", "value": ""}, "columns": {"value": {"FileId": "={{ $('Google Drive').item.json.id }}", "sentId": "={{ $json.id }}", "FileName": "={{ $('Google Drive').item.json.name }}", "CreatedTime": "={{ $('Google Drive').item.json.createdTime }}", "ModifiedTime": "={{ $('Google Drive').item.json.modifiedTime }}"}, "schema": [{"id": "FileName", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "FileName", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "FileId", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "FileId", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "CreatedTime", "type": "dateTime", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "CreatedTime", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "ModifiedTime", "type": "dateTime", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "ModifiedTime", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "sentId", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "sentId", "defaultMatch": false, "canBeUsedToMatch": true}], "mappingMode": "defineBelow", "matchingColumns": []}, "options": {}, "operation": "create"}, "credentials": {"airtableTokenApi": {"id": "", "name": ""}}, "notesInFlow": true, "typeVersion": 2.1}, {"id": "f2a4c6af-cf00-4549-88af-1a3e125508d6", "name": "Google Drive", "type": "n8n-nodes-base.googleDriveTrigger", "notes": "Fetch New File", "position": [420, -180], "parameters": {"event": "fileCreated", "options": {}, "pollTimes": {"item": [{"mode": "everyMinute"}]}, "triggerOn": "specificFolder", "folderToWatch": {"__rl": true, "mode": "url", "value": ""}}, "credentials": {"googleDriveOAuth2Api": {"id": "", "name": ""}}, "notesInFlow": true, "typeVersion": 1}, {"id": "14da3a1a-def0-4718-8456-f3f11c0fb238", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [400, -20], "parameters": {"width": 150, "height": 140, "content": "This node retrieves the newly added file from the specified folder in Google Drive."}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "d9224406-31e5-46a6-a2da-56effb86c8eb", "name": "Sticky Note1", "type": "n8n-nodes-base.stickyNote", "position": [640, -180], "parameters": {"width": 170, "height": 140, "content": "This node sends the fetched file via email to the specified recipient."}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "cad9869a-cf58-4786-8d0a-d696bf3a0c84", "name": "Sticky Note2", "type": "n8n-nodes-base.stickyNote", "position": [920, 0], "parameters": {"width": 180, "content": "This node stores the file\u2019s metadata (name, ID, creation time, modification time, and recipient email) in Airtable."}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "0f6c1ffc-7d9e-41ee-b5f4-ee65f792222e", "name": "Sticky Note3", "type": "n8n-nodes-base.stickyNote", "position": [320, -240], "parameters": {"width": 860, "height": 420, "content": "### Automatic File Upload & Sharing Workflow with Google Drive & Airtable Integration\n\n"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "99acf1d1-ce4e-4942-bb6c-d053ef886a29", "name": "Sticky Note4", "type": "n8n-nodes-base.stickyNote", "position": [320, 220], "parameters": {"width": 860, "height": 120, "content": "### Description:\nThis workflow automatically fetches newly uploaded files from a specific folder in Google Drive, shares them via email with specified recipients, and logs the file details (name, ID, created time, modified time) into Airtable for easy tracking. It streamlines the process of file sharing and management while keeping track of important metadata in a central place.)"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "error-64eaff99", "name": "Error Handler", "type": "n8n-nodes-base.stopAndError", "typeVersion": 1, "position": [1000, 400], "parameters": {"message": "Workflow execution error", "options": {}}}], "active": false, "pinData": {}, "settings": {"executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000}, "versionId": "c4ff2316-a648-4cd2-9af8-b29c29115ac6", "connections": {"f648b663-8adb-4587-bf80-cff7554b72c4": {"main": [[{"node": "error-handler-f648b663-8adb-4587-bf80-cff7554b72c4-b6b68ab0", "type": "main", "index": 0}]]}, "f2a4c6af-cf00-4549-88af-1a3e125508d6": {"main": [[{"node": "error-handler-f2a4c6af-cf00-4549-88af-1a3e125508d6-952da3d6", "type": "main", "index": 0}]]}}, "description": "Automated workflow: Sync New Files From Google Drive with Airtable. This workflow integrates 5 different services: stickyNote, googleDriveTrigger, airtable, googleDrive, stopAndError. It contains 10 nodes and follows best practices for error handling and security.", "notes": "Excellent quality workflow: Sync New Files From Google Drive with Airtable. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}