Create a Google Drive Folder for Every New Client Automatically
Short answer: Decide on one folder template first, with a parent folder named in a sortable pattern and a fixed set of subfolders. Then pick the trigger that matches where new clients start: a won deal in your CRM, a submitted onboarding form, or a new row in a client sheet. Zapier and Make can create the parent folder, the subfolders and the sharing in a few steps; Google Apps Script does the same for free from a spreadsheet. Whichever route you choose, write the new folder's link back to the client record and check for an existing folder first, so a client entered twice does not end up with two folders.
Why bother automating it
In a small bookkeeping practice or a marketing agency, client folders tend to drift. One person creates "Smith Ltd", another "SMITH LTD 2025", a third forgets the Contracts subfolder. Six months later nobody can find the signed engagement letter. A template applied automatically removes the decision from people's hands and makes every folder look the same.
Step 1: Design the folder template
Write the structure down before building anything. For an accountancy practice it might be:
C0147 - Northfield Bakery Ltd01 Engagement and ID02 Bank statements03 Receipts and invoices04 Payroll05 Year-end and returns06 Correspondence
For a web agency, perhaps Brief, Brand assets, Content, Design, Contracts and Invoices.
Keep it to six or seven subfolders. Deep nesting looks organised on paper and becomes a maze in practice.
Naming rules that sort well
- Start with a client code (C0147) or a reverse date (2026-11) so folders sort predictably.
- Use the legal or trading name exactly as it appears in your CRM.
- Number subfolders (01, 02) so they appear in the order you want, not alphabetically.
- Avoid slashes and characters that cause trouble when files are synced to a computer.
Put all client folders inside one parent, such as a shared drive called Clients, so permissions and backups are handled in one place.
Step 2: Choose your trigger
| Trigger | Best for | Watch out for |
|---|---|---|
| Deal won in CRM | Agencies and firms with a sales pipeline | Deals that are marked won and then reopened |
| Onboarding form submitted | Accountants collecting details from new clients | Duplicate submissions and typos in names |
| New row in a client sheet | Small teams without a CRM | Rows added before details are complete |
Pick the moment when the client is definitely confirmed. Creating folders for every enquiry clutters Drive with folders for people who never signed.
Step 3: Build it
Option A: Zapier
- Trigger: your CRM's "deal stage changed" or "new deal won" event, or "new form response".
- Action: Google Drive, Create Folder, inside the Clients parent folder, using the naming pattern from your data fields.
- Further actions: create each subfolder with the parent set to the folder created in the previous step. That is one action per subfolder.
- Action: add sharing permissions where needed.
- Action: update the CRM record with the folder URL.
Simple, but each subfolder uses a task on every run, which adds up on a busy month. Check Zapier's current plan limits.
Option B: Make
Make lets you loop through a list of subfolder names with an iterator, so the scenario stays short even with seven subfolders. The flow is: trigger, create parent folder, iterator over the subfolder list, create folder for each, then update the CRM. Copying a template folder is not a single native action in Drive, which is why the loop approach is common.
Option C: Apps Script from a sheet
If clients live in a Google Sheet, a short script can create folders for any row that does not yet have a link. The DriveApp reference documents the methods. A compact version:
function createClientFolders() {
const sheet = SpreadsheetApp.getActive().getSheetByName('Clients');
const parent = DriveApp.getFolderById('PARENT_FOLDER_ID');
const subs = ['01 Engagement and ID','02 Bank statements','03 Receipts and invoices','04 Payroll','05 Year-end and returns','06 Correspondence'];
const rows = sheet.getDataRange().getValues();
for (let i = 1; i < rows.length; i++) {
const [code, name, , link] = rows[i];
if (!code || !name || link) continue;
const folder = parent.createFolder(code + ' - ' + name);
subs.forEach(s => folder.createFolder(s));
sheet.getRange(i + 1, 4).setValue(folder.getUrl());
}
}
Column A holds the client code, B the name, D the folder link. Add a time-driven trigger to run it every hour, or attach it to a custom menu so the office manager runs it after adding clients.
Step 4: Permissions
Decide who sees what before switching anything on.
- Internal staff: usually inherit access from the shared drive, so no per-folder sharing needed.
- Client: share only the folder they upload to (for example Receipts and invoices), not the whole client folder with your internal notes.
- Freelancers: add them to individual client folders and remove access when the job ends.
If you share with clients automatically, double-check the email address comes from a verified field. Sharing a folder full of financial records with a mistyped email is a data protection incident.
Step 5: Write the link back
The folder is only useful if people can find it. Write the folder URL into a field on the CRM contact or deal, or into the sheet row. Staff then open the client record and click straight through. It also gives you the duplicate check in the next step.
Step 6: Handle duplicate clients
Duplicates happen when a form is submitted twice, a deal is reopened, or someone adds a client already in the sheet.
- Before creating a folder, check whether the client record already has a folder link. If it does, stop.
- Search the parent folder for a folder starting with the client code. Zapier and Make both have a "find folder" step; in Apps Script use
getFoldersByName. - Only create a new folder if both checks come back empty.
- Send yourself a notification when a duplicate is detected so you can merge records.
Client codes help enormously here, because names vary ("Northfield Bakery" versus "Northfield Bakery Ltd") while codes do not.
FAQ
Can we copy a template folder with files inside it?
Drive has no single "copy folder" action, so tools recreate the folders and copy individual template files one by one. Keep template files few, for example one engagement letter and one checklist.
Will this work with shared drives?
Yes, as long as the account running the automation is a member of the shared drive with permission to add content.
Which option is cheapest?
Apps Script costs nothing beyond your Google Workspace subscription. Zapier and Make use operations or tasks per run, so cost depends on volume.
What happens if someone renames the folder later?
The link keeps working because it uses the folder ID, not its name. Your duplicate search by name may miss it, though, so rely on the stored link first.
If you want client onboarding to create folders, CRM records and welcome emails in one go, ask us how we would set it up for your practice.