MCC UpdateMode Explained

Update your MCC script without breaking everything. Migrate to new versions while preserving all your account configurations and historical data.

The Problem UpdateMode Solves

Standard approach: Install new script version → manually reconfigure all accounts → recreate all settings → lose historical context. For 20+ client accounts, that's hours of work and high error risk.

UpdateMode approach: Point script at your old sheet → script creates new sheet with updated structure → all accounts and settings migrated → you verify and swap URLs. 10 minutes, zero data loss.

The Update Process (Step by Step)

1. Get Your Current Sheet URL

Open your existing MCC sheet and copy the URL from the browser address bar.

2. Tell the Script Where to Find Your Old Data

In the script editor, find line 13:

const MCC_SHEET_TO_UPDATE = ''

Paste your old sheet URL between the quotes:

const MCC_SHEET_TO_UPDATE = 'https://docs.google.com/spreadsheets/d/YOUR_OLD_SHEET_ID'

3. Run the Update

Click “Preview” instead of “Run” if you want to watch the migration happen in real-time via the logs.

The script will:

  • Create a new MCC sheet with the updated structure
  • Migrate all account configurations and settings
  • Update all individual client sheets

4. Find the New Sheet URL

Once complete, find the URL of the newly created MCC sheet in the logs.

5. Update the Master Sheet URL

In the script, replace the URL on line 6 (MASTER_SHEET_URL) with your new MCC sheet URL.

6. Clean Up the Update URL

Delete the URL from line 13. After cleanup it should say:

const MCC_SHEET_TO_UPDATE = ''

7. Save and Schedule

Save the script and schedule it to run hourly.

The script will now update client sheets periodically, based on the times set in the “Run at” column of the MCC sheet.

Note: The first run after a major update might take multiple cycles to update all client sheets. This is normal and will stabilize after a few hours depending on the number of accounts you have.

← Back to MCC Script