Skip to main content

⚙️ Advanced Run Options & Campaign Status

After clicking Fetch Run Config, you can fine-tune how your campaign executes. This page explains the different modes, bulk sending limits, and how to track the success of your merge.

🛠️ Execution Modes​

Before launching, choose the mode that best fits your current goal:

ModePurposeRow LimitBest For...
Debug ModeTroubleshootingSingle RowFinding errors in your script or template logic.
Test ModePreviewingSingle RowVerifying the look and feel in your own inbox.
Select ModeProductionUp to 400Sending actual bulk campaigns to recipients.

Debug & Test Mode​

  • Single Row Only: You must specify a specific row number (e.g., Row 2) to process.
  • Debug Information: Debug mode provides detailed logs in the execution window, which is helpful if the campaign fails to launch.
  • No Status Update: Your spreadsheet will not be updated with a "Sent" status during these runs.

Select Mode (Bulk Sending)​

Use this for your live campaigns. You can select multiple rows to process at once.

  • 400 Row Range: For performance stability, the add-on processes up to 400 rows per batch.
  • Custom Ranges: If your sheet has 1,000 rows, you can run rows 2 to 401, then 402 to 801, and so on.

📊 Tracking Progress & Results​

The Status Column​

Once a run begins, a new column named "Campaign Merge Status" is automatically managed in your sheet:

  • EMAIL_SENT: The message was successfully handed off to Google's mail servers.
  • FAILED: The email could not be sent.
    • Tip: Hover over a "FAILED" cell to see a Note containing the exact error message and the timestamp of the failure.

Re-attempting Failed Rows​

If a row failed (e.g., due to a temporary server error or invalid email), you can re-process it easily:

  1. Navigate to your Google Sheet.
  2. Delete the data in the "Campaign Merge Status" cell for that specific row.
  3. Launch the add-on and run the campaign again; the script skips rows marked "SENT" and only processes empty status cells.

⏳ Quotas & Daily Limits​

Google imposes daily limits on the number of email recipients you can contact. The "Fetch Run Config" screen will display your Daily Remaining Quota.

Account TypeStandard Daily Limit
Personal (@gmail.com)100 recipients / day
Google Workspace (Business/School)1,500 recipients / day

Official Source: For more details on these limitations, please refer to the Google Apps Script Quota Documentation.

Note: These quotas are shared across your entire Google account. This includes emails sent manually via Gmail, other add-ons, or different Apps Script projects.

🏁 Run Summary​

At the conclusion of every run, the add-on displays a summary showing:

  • Total Rows Processed
  • Total Skipped (Rows already marked as SENT, FAILED ), HIDDEN and FILTERED rows are also included here.
  • Total Failed