Automation Recipe: Automated Transaction File Setup

What This Builds

Every time you add a new transaction to your Google Sheets pipeline tracker, this automation instantly creates a complete Google Drive folder structure for that transaction. with pre-named subfolders, a copy of your checklist template, and an empty task log. all organized and ready before you finish your morning coffee. The 20-30 minutes of file setup work per new deal is done before you even open your email.

Prerequisites

• Comfortable with Google Sheets transaction tracker (Level 2 guide)
• Google Drive organized with a clear folder structure (or willing to create one)
• Make account (free tier at make.com. handles up to 1,000 operations/month)
• A "template" Google Drive folder to copy for each new transaction

The Concept

Make is like a visual recipe builder for connecting apps. You build a "scenario" (Make's word for automation) by dragging modules onto a canvas and connecting them with lines. Each module is an action: "Watch Google Sheets for new rows" → "Create a Google Drive folder" → "Copy template files into it." No coding required, you're just specifying which data goes where.

Build It Step by Step

Part 1: Create Your Transaction Template Folder

In Google Drive, create a folder structure you'll copy for every new deal. Make it thorough:

📁 TEMPLATE — Transaction Folder
  📁 01 - Contract Documents
  📁 02 - Disclosures
  📁 03 - Inspection
  📁 04 - Appraisal
  📁 05 - Loan Documents
  📁 06 - Title & Escrow
  📁 07 - Correspondence
  📁 08 - Closing
  📄 Transaction Checklist (Google Sheets template)
  📄 Communication Log (Google Docs template)

Right-click the template folder → Get link → copy the folder ID from the URL (the long string of letters and numbers after /folders/). Save this ID, you'll need it in Make.

Part 2: Set Up Your Google Sheet Trigger Column

In your transaction pipeline sheet, add a column: H: File Setup Needed

Format as checkboxes (Format → Cells → checkboxes). When you add a new transaction, check this box. The automation will trigger when it detects a new checked box, and uncheck it when done.

Part 3: Build the Make Scenario

1. Go to make.com → Create free account → click "Create a new scenario"

2. Module 1. Trigger: Watch Google Sheets for new rows

• Click the + circle → search "Google Sheets" → "Watch Rows"
• Connect your Google account
• Select your spreadsheet and sheet tab
• Set "Where to Start": choose "From now on" (so it doesn't process your entire history)

1. Module 2. Filter: Only process rows where File Setup = checked

• Click the wrench between modules → Add a Filter
• Condition: Column H (File Setup) = TRUE

1. Module 3. Create the transaction folder in Google Drive

• Click + → "Google Drive" → "Create a Folder"
• Parent folder: your main "Active Transactions" folder ID
• Folder name: map from column A (Property Address) → format as: [map: Property Address]: [map: TODAY's date]

1. Module 4. Copy your template folder contents

• Click + → "Google Drive" → "Copy a File"
• File: your template folder ID
• Destination: map the folder ID from Module 3's output (the newly created folder)

Repeat this module for each subfolder and template file you want copied.

1. Module 5. Update Google Sheet to mark as done

• Click + → "Google Sheets" → "Update a Row"
• Row ID: map from the trigger
• Column H (File Setup): set to FALSE (unchecks the box. signals done)

1. Name and save → click "Save" → click "Run once" to test

Part 4: Test and Refine

Add a test transaction to your sheet with a clearly fake address (e.g., "123 Test Street"). Check the "File Setup Needed" box.

Run your Make scenario manually by clicking "Run once."

What you should see: A new folder appears in your Google Drive "Active Transactions" folder named "123 Test Street: [today's date]" with all your subfolders and template files copied inside. Column H in your sheet is unchecked.

If it works: set your scenario to "Scheduled" mode, check every 15 minutes or every hour.

Real Example: Opening a New Transaction

Setup: You have Make running on your Google Sheets tracker. Your transaction template folder has 8 subfolders and 2 template documents.

Input: At 9:15am, you add a new row to your sheet: "1847 Maple Court | Under Contract | 3/18/2026 | ..." and check the "File Setup Needed" box.

Output: By 9:20am (next scheduled check), Make has created: a new Google Drive folder named "1847 Maple Court. 2026-03-18" with all 8 subfolders and your 2 template documents copied in. Column H is unchecked. You receive no notification, it just happens.

Time saved: 20-30 minutes of manual folder creation, naming, and template copying → 0 minutes. You open the deal in your transaction platform and the Drive folder is already organized and waiting.

What to Do When It Breaks

• "Google Sheets module error: Could not find row" → Your column mapping may have shifted if you added or deleted columns. Re-open the Watch Rows module and re-map the columns.
• "Google Drive error: Insufficient permissions" → Make needs to be re-authorized to access your Google Drive. Go to Connections → reconnect Google Drive.
• Folder created with wrong name → Check your column mapping in Module 4. If Property Address is in Column A and you mapped Column B by mistake, fix the mapping.
• No folder created after checking the box → Check that your scenario is set to "On" (active). The free tier may have a delay of up to 15 minutes between checks.

Variations

• Simpler version: Skip the folder copying and just create the folder with the right name. Add subfolders manually after, still saves you 5-10 minutes of naming and organizing.
• Extended version: Add a Module after folder creation that sends you (or the agent) a confirmation email: "Transaction file for [Property Address] is ready in Google Drive. Link: [link to new folder]."

What to Do Next

• This week: Build and test the automation with one real transaction
• This month: Run it for 10 new transactions; note the time saved and any adjustments needed
• Advanced: Add a Zapier (or Make) step to also create a SkySlope/Dotloop transaction stub automatically from the same Google Sheet row

Advanced guide for Real Estate Transaction Coordinator professionals. Make's free tier supports 1,000 operations/month, sufficient for most individual TCs. Heavy users may need the Core plan ($9/month).