Cascade Mail Merge

📧 Cascade Mail Merge

Generate personalized assistant schedule emails from shift requirements data.

STEP 01 Configuration

Email Settings

Assistant Schedule Link

Send From

BCC Address

Sheets Integration optional

Apps Script Web App URL

Target Tab Name

The Apps Script URL and target tab are required to pull from Sheets or push processed rows to the mail merge queue. See the setup guide below.

STEP 02 Load Source Data

Fetches data directly from your Google Sheet via the Apps Script endpoint. Paste the Web App URL in Step 1 first.

Add this to a Google Apps Script project and deploy as a Web App (Execute as: Me, Access: Anyone). Paste the deployed Web App URL into Step 1.