Google Sheets to Google Drive, deal folders ready
You add a new deal to your spreadsheet, and then the scramble starts. Create the folder. Name it correctly. Share it. Paste the link back into the sheet. Hope nobody “helpfully” makes a duplicate in the wrong Drive.
Real estate agents feel it first, honestly. But transaction coordinators and small ops teams get buried in the same Sheets Drive folders automation problem the moment volume picks up. This workflow gives every new transaction a ready-to-use document portal, without the manual setup.
You’ll see how it detects new rows in Google Sheets, creates the right Google Drive folder, writes the folder URL back to the sheet, and even adds a starter task so clients know exactly what to upload.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Google Sheets to Google Drive, deal folders ready
flowchart LR
subgraph sg0["New Transaction Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "New Transaction Trigger", pos: "b", h: 48 }
n1@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Filter Missing Folder & Email", pos: "b", h: 48 }
n2@{ icon: "mdi:cog", form: "rounded", label: "Create Client Documents Folder", pos: "b", h: 48 }
n3@{ icon: "mdi:database", form: "rounded", label: "Update Transaction With Fold..", pos: "b", h: 48 }
n4@{ icon: "mdi:database", form: "rounded", label: "Add Initial Upload Task", pos: "b", h: 48 }
n0 --> n1
n1 --> n2
n2 --> n3
n3 --> n4
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0 trigger
class n1 decision
class n3,n4 database
The Problem: Deal document setup is repetitive and error-prone
Deal intake sounds simple until you’re doing it all day. Someone adds a transaction to Google Sheets, then you have to jump into Google Drive, create a folder in the right parent directory, name it consistently (address, client name, transaction ID, pick your poison), share it with the buyer, and paste the URL back into the sheet. And that’s before you’ve assigned the first “please upload your documents” task. Miss one step and you’ll feel it later, usually right before a deadline, when you’re hunting through Drive search results trying to remember which folder is the real one.
The friction compounds. It’s not one big mistake, it’s a hundred tiny ones.
- Folder naming drifts over time, so your Drive turns into a messy archive that’s hard to search.
- Links don’t get pasted back into the sheet, which means teammates keep asking “where’s the folder?”
- Clients get inconsistent onboarding, so you spend extra time chasing missing docs.
- Manual sharing invites mistakes, including giving access to the wrong person.
The Solution: Automatically create and link a Drive folder for each new deal
This workflow watches your Transactions tab in Google Sheets for new rows that match a simple rule: the deal has a buyer email, but there’s no Documents URL yet. When it finds one, it creates a dedicated Google Drive folder in your chosen parent directory, using a consistent naming pattern tied to the transaction data (like ID and property address). Then it writes the new folder link straight back into the same Google Sheets row, so your spreadsheet becomes the source of truth for “where the docs live.” Finally, it appends an initial task to your Tasks tab so the client experience starts the same way every time, with a clear prompt to upload documents.
The workflow starts with a scheduled Google Sheets trigger that checks every minute. It filters to only the rows that need setup, generates the client docs folder in Google Drive, updates the sheet with the folder URL, and logs a starter upload task so nothing slips through the cracks.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you onboard 15 new transactions in a week. Manually, you might spend about 10 minutes each creating a folder, sharing it, copying the URL back into Google Sheets, and adding a “please upload docs” task. That’s roughly 2.5 hours of admin work. With this workflow, intake stays in the spreadsheet and the setup runs in the background every minute. Your “work” becomes adding the buyer email, which takes a minute, then you move on.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets to store transactions and tasks.
- Google Drive to create and store deal folders.
- Google account access (OAuth connection inside n8n)
Skill level: Beginner. You will connect Google accounts, point to the right spreadsheet, and paste a parent folder ID.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
A new transaction appears in Google Sheets. The workflow checks your Transactions tab on a short interval (every minute) so new deals don’t sit around waiting for someone to “get to setup.”
Only the right rows move forward. A quick validation filters for transactions that include a buyer email and are still missing a Documents URL, so it won’t recreate folders for deals you’ve already handled.
A dedicated Google Drive folder gets created. n8n creates the folder under your chosen parent folder, using the transaction data to keep naming consistent across every deal.
The portal link and starter task get written back. The workflow updates the original Google Sheets row with the folder URL and appends a first task in your Tasks tab so the client immediately knows what to upload.
You can easily modify the folder naming format to match your team’s conventions based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Google Sheets Trigger
Set up the workflow to listen for new transactions in your Google Sheet.
- Add the Transaction Intake Trigger node as the workflow trigger.
- Set Document to
Real Estate Client Portaland Document ID toYOUR_SPREADSHEET_ID. - Set Sheet Name to
Transactions(gid=0). - Keep the poll schedule at Every Minute to check for new rows.
- Credential Required: Connect your
googleSheetsTriggerOAuth2Apicredentials.
Step 2: Connect Google Sheets
Configure the Google Sheets nodes that update the transaction record and create a task.
- Open Update Record with Folder Link and confirm Operation is set to
update. - Set Document to
Real Estate Client Portaland Document ID toYOUR_SPREADSHEET_ID. - Set Sheet Name to
Transactionsand match on Matching Columns =ID. - Set ID to
={{ $('Transaction Intake Trigger').item.json.ID }}and Documents URL to=https://drive.google.com/drive/u/0/folders/{{ $json.id }}. - Open Append Starter Upload Task and set Operation to
append. - Set Sheet Name to
Tasks(use your task sheet ID in the selector) and keep Document ID asYOUR_SPREADSHEET_ID. - Map Status to
To Do, Task Name toPlease update your documents to the documents folder., Transaction ID to={{ $('Transaction Intake Trigger').item.json.ID }}, and Task Description to.... - Credential Required: Connect your
googleSheetsOAuth2Apicredentials for both Update Record with Folder Link and Append Starter Upload Task.
Step 3: Set Up Validate Email & Folder
Ensure the workflow only proceeds when the buyer has an email and there is no existing folder link.
- Add the Validate Email & Folder filter between the trigger and folder creation.
- Configure the first condition to check Buyer Email is not empty with
={{ $json["Buyer Email"] }}. - Configure the second condition to check Documents URL is empty with
={{ $json["Documents URL"] }}. - Keep the combinator as AND so both conditions must pass.
Step 4: Configure Generate Client Docs Folder
Create a dedicated Google Drive folder for each buyer, named by email.
- Add Generate Client Docs Folder after Validate Email & Folder.
- Set Resource to
folder. - Set Name to
={{ $json["Buyer Email"] }}. - Set Drive to
My Driveand Folder ID to[YOUR_ID](your parent folder). - Credential Required: Connect your
googleDriveOAuth2Apicredentials.
Step 5: Test and Activate Your Workflow
Run a manual test to confirm folder creation, record update, and task append work end-to-end.
- Click Execute Workflow and add a new row in the Transactions sheet with a valid Buyer Email and empty Documents URL.
- Verify Generate Client Docs Folder creates a Google Drive folder named after the buyer’s email.
- Confirm Update Record with Folder Link writes the URL to the Documents URL field.
- Check Append Starter Upload Task adds a row in the Tasks sheet with the correct status and transaction ID.
- When results look correct, toggle the workflow to Active for production use.
Common Gotchas
- Google Sheets permissions can be the silent killer. If the workflow can’t update the Documents URL, check the n8n Google connection and confirm it has edit access to the spreadsheet (and that you selected the right file).
- If you’re relying on the every-minute check, timing can look “off” during busy periods. Processing times vary, so if a downstream node runs before Drive returns the folder ID, increase any waiting you use and re-test with a single sample row.
- Google Drive folder creation depends on the parent folder ID being correct. If folders are showing up in “My Drive” instead of the intended location, revisit the “Generate Client Docs Folder” configuration and paste the parent folder ID again.
Frequently Asked Questions
About 30 minutes once your spreadsheet and Drive folder are ready.
No. You’ll connect Google accounts in n8n and paste in your spreadsheet and parent folder details.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You typically won’t have extra API costs here beyond Google itself.
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
Yes, but keep it simple at first. You’ll update the naming inputs in the “Generate Client Docs Folder” step (for example, using Transaction ID + Property Address instead of just the address). Common tweaks include adding the client last name, adding the closing date, or writing the folder URL into a different column if your sheet layout is unique.
Usually it’s permissions or the wrong spreadsheet reference. Reconnect Google Sheets in n8n, confirm the account has edit access, and verify the node points to your copied reference spreadsheet (including the correct tab names). If it still fails, check if the column headers changed, because the workflow expects fields like Buyer Email and Documents URL to exist. Also worth checking: your organization’s Google Workspace settings can block third-party app access.
Plenty for most small teams. On n8n Cloud Starter you’re limited by monthly executions, while self-hosting has no execution cap (it depends on your server). Because this workflow runs a simple check every minute and only processes rows that match the criteria, it typically stays fast even with a larger sheet. If you’re onboarding hundreds of deals a week, you’ll want tighter filtering so it only scans recent rows.
Often, yes, if you expect this to grow. n8n handles branching logic and filtering cleanly, and self-hosting can be a big cost win once you have lots of deals. You also get more control over how you search for “rows missing a link,” which is the heart of this workflow. Zapier or Make can still work if your setup is tiny and you prefer the simplest UI, but you may end up paying more as runs increase. If you want a quick recommendation based on your volume, Talk to an automation expert.
Once this is live, every new deal starts with a clean folder link and a clear first task. It’s not flashy. It’s just the kind of operational calm you’ll miss the moment it’s gone.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
