## About This flow is ideal for online schools that use Zoom to teach classes and Google Classroom for storing materials and homework. It listens for Zoom webhooks that come after each recorded call is uploaded to Zoom Cloud (you'll need Zoom paid plan). When new meeting comes, it filters out calls that last less than 30 mins. After duration check, it checks if there is a Google Class that matches the call name. Your call must be named exactly as the Google Class you want the call to be uploaded to. If the class is found, it will extract the Class ID. This flow assumes that you have a specific topic used for storing class recordings and materials, so it will look for this topic and upload the material. If topic is not found, you'll get an email. ## Requirements You'll need a: - Zoom paid plan that supports Zoom Cloud - Google cloud console to set up Classroom API and Gmail API - OpenAI API key or any other provider

View

Template-based Google Drive folder generation with Forms and Apps Script

### Overview Stop manually creating folder structures for every new client or project. This workflow provides a simple form where users enter a name, and automatically duplicates your template folder structure in Google Drive—replacing all placeholders with the submitted name. ### What This Workflow Does 1. Displays a form where users enter a name (client, project, event, etc.) 2. Creates a new main folder in Google Drive 3. Calls Google Apps Script to duplicate your entire template structure 4. Replaces all `{{NAME}}` placeholders in files and folder names ### Key Features - **Simple form interface** — No technical knowledge required to use - **Recursive duplication** — Copies all subfolders and files - **Smart placeholders** — Automatically replaces `{{NAME}}` everywhere - **Production-ready** — Works immediately after setup ### Prerequisites - Google Drive account with OAuth2 credentials in n8n - Google Apps Script deployment (code below) - Template folder in Drive using `{{NAME}}` as placeholder ### Setup **Step 1: Create your template folder** ``` 📁 {{NAME}} - Project Files ├── 📁 01. {{NAME}} - Documents ├── 📁 02. {{NAME}} - Assets ├── 📁 03. Deliverables └── 📄 {{NAME}} - Brief.gdoc ``` **Step 2: Deploy Apps Script** 1. Go to [script.google.com](https://script.google.com) 2. Create new project → Paste code below 3. Deploy → New deployment → Web app 4. Execute as: `Me` | Access: `Anyone` 5. Copy the deployment URL **Step 3: Configure workflow** Replace these placeholders: - `DESTINATION_PARENT_FOLDER_ID` — Where new folders are created - `YOUR_APPS_SCRIPT_URL` — URL from Step 2 - `YOUR_TEMPLATE_FOLDER_ID` — Folder to duplicate **Step 4: Test** Activate workflow → Open form URL → Submit a name → Check Drive! --- ### Apps Script Code ```javascript function doPost(e) { try { var params = e.parameter; var templateFolderId = params.templateFolderId; var name = params.name; var destinationFolderId = params.destinationFolderId; if (!templateFolderId || !name) { return jsonResponse({ success: false, error: 'Missing required parameters: templateFolderId and name are required' }); } var templateFolder = DriveApp.getFolderById(templateFolderId); if (destinationFolderId) { var destinationFolder = DriveApp.getFolderById(destinationFolderId); copyContentsRecursively(templateFolder, destinationFolder, name); return jsonResponse({ success: true, id: destinationFolder.getId(), url: destinationFolder.getUrl(), name: destinationFolder.getName(), mode: 'copied_to_existing', timestamp: new Date().toISOString() }); } else { var parentFolder = templateFolder.getParents().next(); var newFolderName = replacePlaceholders(templateFolder.getName(), name); var newFolder = parentFolder.createFolder(newFolderName); copyContentsRecursively(templateFolder, newFolder, name); return jsonResponse({ success: true, id: newFolder.getId(), url: newFolder.getUrl(), name: newFolder.getName(), mode: 'created_new', timestamp: new Date().toISOString() }); } } catch (error) { return jsonResponse({ success: false, error: error.toString() }); } } function replacePlaceholders(text, name) { var result = text; result = result.replace(/\{\{NAME\}\}/g, name); result = result.replace(/\{\{name\}\}/g, name.toLowerCase()); result = result.replace(/\{\{Name\}\}/g, name); return result; } function copyContentsRecursively(sourceFolder, destinationFolder, name) { var files = sourceFolder.getFiles(); while (files.hasNext()) { try { var file = files.next(); var newFileName = replacePlaceholders(file.getName(), name); file.makeCopy(newFileName, destinationFolder); Utilities.sleep(150); } catch (error) { Logger.log('Error copying file: ' + error.toString()); } } var subfolders = sourceFolder.getFolders(); while (subfolders.hasNext()) { try { var subfolder = subfolders.next(); var newSubfolderName = replacePlaceholders(subfolder.getName(), name); var newSubfolder = destinationFolder.createFolder(newSubfolderName); Utilities.sleep(200); copyContentsRecursively(subfolder, newSubfolder, name); } catch (error) { Logger.log('Error copying subfolder: ' + error.toString()); } } } function jsonResponse(data) { return ContentService .createTextOutput(JSON.stringify(data)) .setMimeType(ContentService.MimeType.JSON); } ``` --- ### Use Cases - **Agencies** — Client folder structure on new signup - **Freelancers** — Project folders from intake form - **HR Teams** — Employee onboarding folders - **Schools** — Student portfolio folders - **Event Planners** — Event documentation folders ### Notes - Apps Script may take +60 seconds for large structures - Timeout is set to 5 minutes for complex templates - Your Google account needs edit access to template and destination folders

View

Automate real estate client folder creation with Google Sheets and Drive

## What this workflow does This workflow automates backend setup tasks for real estate client portals. When a new property transaction is added to your Google Sheets database with a buyer email but no document folder assigned, the workflow automatically creates a dedicated Google Drive folder, updates the spreadsheet with the folder URL, and adds an initial task prompting the client to upload documents. This automation eliminates manual folder creation and task assignment, ensuring every new transaction has its documentation infrastructure ready from day one. Your clients can access their dedicated folder directly from the portal, keeping all property-related documents organized and accessible in one place. ## Key benefits - **Eliminate manual setup**: No more creating folders and tasks individually for each transaction - **Consistent client experience**: Every buyer gets the same professional onboarding process - **Organized documentation**: Each transaction has its own Google Drive folder automatically shared with the client - **Time savings**: Focus on closing deals instead of administrative setup ## Setup requirements **Important:** You must make a copy of the [reference Google Sheets spreadsheet](https://docs.google.com/spreadsheets/d/1UJPaBd_qHsNgInA2mrYaq7wgXLHzFw9jcTUoSpTxMDk/edit?usp=sharing) to your own Google account before using this workflow. Your spreadsheet needs at minimum two tabs: - **Transactions tab**: Columns for ID, Buyer Email, Documents URL, Property Address, and Status - **Tasks tab**: Columns for Transaction ID, Task Name, Task Description, and Status ## Configuration steps 1. Authenticate your Google Sheets and Google Drive accounts in n8n 2. Update the Google Sheets trigger node to point to your copied spreadsheet 3. Set the parent folder ID in the "Create Client Documents Folder" node (where transaction folders should be created) 4. Customize the initial task name and description in the "Add Initial Upload Task" node 5. Verify all sheet names match your spreadsheet tabs The workflow triggers every minute checking for new transactions that meet the criteria (has buyer email, missing documents URL).

View

👨‍💻

Need Custom Automation?

N8N Automation Expert

Specialized in N8N automation, I design custom workflows that connect your tools and automate your processes.