Bincom Mail Merge is a Google Workspace app that allows you to send bulk emails via either Gmail or Mailgun API directly from Google Sheets. It helps automate email campaigns, making it easier to send personalized emails to a large number of recipients.

To install the Bincom Mail Merge Add-On, simply go to the Google Sheets "Add-ons" menu and search for "Bincom Mail Merge." Follow the installation steps to add it to your workspace.

After installation, open Google Sheets and go to the "Bincom Mail Merge" Add-On in the extension tab. Select "Mail Merge Setup," and fill in the necessary fields such as:

• Email Body Template URL (Google Doc link for the email body)
• Recipient column name (ensure your sheet has a column with email addresses) Save your setup to complete the configuration.

The "Email Body Template URL" refers to a link to a Google Doc that contains the template for the email body. This template will be used as the content for your email.

In the setup, you will need to specify the column name where the recipient email addresses are stored. If you don’t have this column, you can create it manually or use the prompt feature to generate it.

Once you’ve set up the Mail Merge, click on "Send Emails" from the Bincom Mail Merge tab. You must be signed in to Google Sheets with the Gmail account you want to send emails from. After following the prompts, you can send emails directly.

Yes, Gmail has a daily sending limit of 100 recipients. If you need to send more emails, you may need to use Mailgun.

To send emails through Mailgun, enter your Mailgun API key in the "Mail Merge Setup" section. Also, fill in the "Sender Email" (email from which the emails will be sent) and optional "Support Email" (email to receive any error reports). The "Email Body Template URL" and recipient column name must also be provided.

Yes, you need a Mailgun account to generate an API key for sending emails via Mailgun. You can obtain the API key from your Mailgun account settings.

After installing the Add-On, try reloading the Google Sheets document. This often resolves any display issues.

Check the following:

• Ensure you are signed in with the correct Gmail account if using Gmail to send emails.
• Verify that the "Email Body Template URL" is correct and the linked Google Doc is accessible.
• Make sure the recipient email addresses are correctly specified in your Google Sheets.

Ensure that the "Email Sent" column exists in your sheet. If it was created manually, check that it is correctly populated. This column should automatically populate with the current date once emails are sent.

Check your Mailgun API key for any errors or updates. If you’re facing delivery issues, ensure that your Mailgun account has no restrictions or limits. You can also check your Mailgun logs for more detailed error information.

Yes, when using Mailgun, there are no strict recipient limits like Gmail. However, ensure you have enough credits in your Mailgun account for large-scale email campaigns.

Yes, you can personalize emails by including placeholders in your email body template. The placeholders should be wrapped in curly brackets {} and must exactly match the column names in your Google Sheets. For example, if your sheet has columns named Name, Date, and Company, your email body template should have placeholders like {Name}, {Date}, and {Company}.

Important:

• The placeholders must match the column names exactly, including font, characters, and case.
• If the placeholder is not spelled exactly as it appears in the sheet (e.g., different case or extra spaces), it will not be replaced with the corresponding data from the sheet.

Sending emails through Mailgun reduces the likelihood of emails being marked as spam compared to using Gmail, especially for bulk emails. However, be sure to follow email best practices, such as avoiding spammy language and ensuring proper email authentication (SPF, DKIM).