The FRH Mail Merge Script is a powerful tool designed to automate the process of sending emails in batches from Google Sheets. This guide will walk you through the steps to configure and use the script efficiently.

1. Why This is Useful

This script is particularly useful for:

• Automating Email Sending: It helps in sending multiple emails in batches, avoiding hitting email limits imposed by your provider.
• Customization: You can customize each email with specific fields using placeholders.
• Scheduling: The script allows scheduling the start time for email batches, ensuring timely delivery without manual intervention.

Important Warning: Due to Google’s email sending limits, it is recommended that you send no more than 100 emails per day using this script. Exceeding this limit may result in your account being temporarily restricted from sending emails.

2. How to Use It

2.1 Access the Code

You can access the script for free here – Bulk Email Script ( Sign up is required )

Note: You might be asked to grant permissions to the script when you run it for the first time. This is necessary for the script to access your Gmail and Google Sheets.

2.2 Verify Permissions

Before using the mail merge script, it’s important to ensure that the script has the necessary permissions to execute properly. The “Set Permissions” function is designed to help you verify these permissions.

How to Verify Permissions:

1. Go to the FRH – Mail Merge menu and select Set up > Set Permissions.
2. If the script has all the required permissions, a pop-up will appear with the message “You have all permissions.”
   • If there is an issue with permissions, an error message will be displayed, prompting you to resolve the issue.

Why Verify Permissions?

• Verifying permissions ensures that the script can access your Google Drive, send emails, and perform other necessary actions without interruptions.
• Running this check before starting your mail merge helps prevent potential errors during execution.

Privacy Assurance:

• No Access to Personal Information: We do not have access to any of your personal information. The script runs entirely on your account.
• Your Data, Your Control: You are giving access to the script to perform its functions, not to anyone else. Your data remains secure and private.

2.3 Set Up the Config Page

Once you have the sheet:

• Draft Subject: Create the email you want to send and keep it in the draft and add the subject here.
• Email Delay: Set the delay between each email in the batch (e.g., 2 minutes). The script runtime is not calculated on this, so there could be a 30-second to 40-second delay from the set delay.
• Daily Email Limit: Specify the maximum number of emails you want to send in a day. Set this to 80 or fewer to avoid hitting Google’s sending limits.
• Batch Delay: Define the delay between each batch of emails. This is by default set as 2, and we don’t recommend changing it.
• Everyday Timer: Just select one from the drop-down. Refer to section 2.5 to update the Dropdown.
• Enable Attachment: Specify ‘Y’ if you want to include attachments with the emails. If set to ‘N’, the attachment function will be disabled.
• Folder URL: Provide the Google Drive folder URL where the attachments are stored.
• Max File Size: Specify the maximum allowed file size for attachments (e.g., “500 kb”, “1 mb”). The script will check each attachment’s size before sending.

Here’s how the config page should look (refer to the image in the Config sheet):

2.4 Add the Emails and Custom Fields

In the “Email” sheet:

• Custom Fields: Add any placeholders you wish to use in your email body. You can add any number of fields. To include data from the spreadsheet in your email, use placeholders that correspond to column names surrounded by curly braces, such as {{First name}}.
• Recipient: Enter the email addresses of the recipients.
• Attachment: Provide the file name (e.g., “document.pdf”, “image.png”) that matches the file stored in the Google Drive folder specified in the Config sheet. The script will attach this file to the email if the attachment function is enabled.
• Email Sent: This column will automatically update once the emails are sent. It will also indicate if there were any issues with the attachment, such as “File not found” or “File Size error”.

2.5 Run the Start Time Dropdown

• Go to the FRH - Mail Merge menu and select Set up > Start Time Dropdown.
• This will generate a dropdown list for the everyday timer of the Config sheet with date-time options for scheduling your email batch.
• Note – The email will start sending the batch for the day at this time every day.

2.6 Run the Batch Process

• Select Set up > Batch Process from the FRH - Mail Merge menu.
• This will populate columns F, G, and H in the Config sheet with the batch name, email count, and estimated delivery time.
• This will give you an idea of how your emails are split into batches as per the config file, and when each batch is estimated to be sent.

If you are satisfied with the output of the batch process, you can proceed to send the emails.

3. Send Emails

• If everything is configured correctly and you’re satisfied with the batch process, go ahead and select Send Email from the FRH - Mail Merge menu.
• The script will handle the rest, sending out your emails according to the specified configuration.

Important Warning: Be mindful of Google’s email-sending limits. Exceeding the recommended 100 emails per day could result in temporary suspension of your email-sending capabilities. Always ensure you stay within safe limits to maintain your account’s functionality.

4. Updates

How to Check for Updates:

1. Go to FRH – Mail Merge Menu:
   • In your Google Sheet, select FRH - Mail Merge > Check for Updates.
2. Confirmation:
   • If you’re on the latest version, you’ll see a message confirming it.
   • If an update is available, you’ll be prompted to download the latest version.

Stay up-to-date for the best experience!

5. Report Issues or Suggestions

If you encounter any issues or have suggestions for improvement, please use the “Issues & Suggestion” option in the FRH - Mail Merge menu. This will open a feedback form where you can provide your input.

Note: Ensure your browser is not blocking pop-ups, as this might prevent the feedback form or other important dialogs from appearing.

Version Log

Version 1.0 - 18/8/2024  
- Add coustom Fields
- Set Timer for Emails and Batches 
- Schedule emails 

Version 1.2 - 20/8/2024  
- All Features from Version 1.0
- Can add unique attachement to each email. (Created based on feedback from - Prahalathan (Doc) K K | Co-Founder, Bhumi)