Send mail to many recipients

[Alfredo_Pou]

Usually my app sends 2 or 3 mail to 3 mailboxes in each operation.
I want to send mail to all my client list. Do I have to take any precaution to avoid breaking spam rules? As for example send batches of certain amount of mails every certain amount of time? Or simply send to the entire list?
Thanks

[Phil]

Can you clarify the number of email addresses you will be addressing with each email, and the frequency of emails you are planning to send?

I am in the midst of implementing “Rate Limiting”. This will allow us to better monitor and control the volume of emails, SMS messages, notifications, and the like, that each user and application is sending.

Our motivation for this work is to make certain our service remains reliable. We want to ensure that no single user or application floods the system because of an inadvertent error or malignant intent.

[Alfredo_Pou]

To date I have about 1485 records, which increase by an average of 5 per day, and the idea is to send news as much once a month, or every certain number of months.

[Phil]

Hi Alfredo,

That volume of emails sounds completely reasonable.

Please be certain that your users can “opt out” of receiving your monthly email.

Also be certain that you provide a way for your recipients to “unsubscribe” if they no longer want to receive your monthly email. You might do that by including a DeepLink in your monthly email that takes them to an “unsubscribe” view in your app.

Email services, like the one we use, are very sensitive to complaints about “spam” that does not require “opt in” or that cannot be turned off.

[Henry_Scott]

@Phil. Is there an example how to do this DeepLink in an email that will take the Recipient back to a view in Appsheet?

[LeventK]

@Henry_Scott
You can use this URL syntax:
https://www.appsheet.com/start/{AppId}#control=YourViewName

[Henry_Scott]

Ok great.
Thanks again for helping us out @LeventK

[Alfredo_Pou]

But a deeplink would not be valid only for public app?
I had thought about putting a link to a Google form and filtering the list of clients excluding the list of unsuscribers.

[Henry_Scott]

LeventK:

https://www.appsheet.com/start/{AppId}#control=YourViewName

I think for a Public App that the URL provided by @LeventK will open a Browser if the users do not have Appsheet installed

[Henry_Scott · Accepted solution]

LeventK:

https://www.appsheet.com/start/{AppId}#control=YourViewName

@LeventK the URL works and takes me to my “Unsubscribe View”. How do I get to filter the view based on a Customer Key that I send the Customer via the email.
They never login as a User to the App, but get Emails based on my Users logging information about them, like how many times they visited our establishment. They complete a verbal questionnaire that my staff ask them a couple of questions, which include “Do you want to subscribe to our Newsletter”.
I need to supply them a way to Unsubscribed and sending them to the Embedded URL like you explained must give them access only to their Customer Record to Unsubscribe. So need a filter parameter for the the View defined in the URL

[LeventK]

@Henry_Scott
If the customers don’t have access to the app, than the URL you have forwarded will say that “you are not authorized”. There are a couple of workarounds to maintain that.

[Henry_Scott]

@LeventK suggestions for the workarounds?
Because with the new laws around the World one needs an Unsubscribe option to the Customer on a mailing list (non App User)
I do not want to farm the Google Sheet out to MailChimp because it defeats the benefit then of my Appsheet Workflow, making it null and void

[LeventK]

@Henry_Scott
The best option could be settings up a standalone webapp which will make a call to AppSheet API and set an i.e. unsubscribed record for that customer

[Henry_Scott]

@LeventK ok will try my hand at GAS. It is more the logistics of where to host the standalone webapp

[LeventK]

@Henry_Scott
Standalone webapp will be in your gDrive actually. When you deploy your code as web-app, just you need to choose “run as me” and accept “anyone, even anonymous”. Done…

[Henry_Scott]

@LeventK going to give it a try. Thanks

[LeventK]

@Henry_Scott you’re welcome

[Alfredo_Pou]

Ok. Many thanks