Is there a daily email limit?

From the Google Docs Add-on

The free version allows you to send 5 emails a merge. With the premium version the add-on does not impose how many emails you can send. However if you send hundreds of emails all in one go, Gmail might throw an error on you. This is Gmail's way of trying to discourage spamming. You also need to aware of the Google imposed quota and not to exceed the user-rate limit. Therefore the following workaround are suggested:

  • Use tracking so you know which emails have been sent before the error is thrown at you. This way on the next merge you can continue sending emails from where you left.
  • Use scheduling so you spread the emails across time rather than all at one go.
  • Send emails over SMTP. You can use 3rd Party SMTP providers (such as SendGrid), use your own SMTP Server or other email accounts from Yahoo!, Microsoft, etc. You can also send emails over Gmail's SMTP. This would give you an additional 500 emails/day.

From the Google Sheets Add-on

The Google Sheets version of the add-on has a limited feature set and is therefore free and does not impose any email limits. However if you send hundreds of emails all in one go, Gmail might throw an error on you. This is Gmail's way of trying to discourage spamming. You also need to aware of the Google imposed quota and not to exceed the user-rate limit. Therefore the following workaround are suggested:

  • Use tracking so you know which emails have been sent before the error is thrown at you. This way on the next merge you can continue sending emails from where you left.