# Generating a newsletter digest from Glide inputs

**URL:** https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495
**Category:** Ask for Help
**Created:** [December 30, 2020, 8:19am UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495 "2020-12-30T08:19:02Z")
**Posts on this page:** 1
**Showing post:** 9

<div class="post-metadata">

### Author: ![gregcha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gregcha/32/18566_2.png) [@gregcha](https://community.glideapps.com/u/gregcha)
#### Post date: [January 7, 2021, 8:22pm UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495/9 "2021-01-07T20:22:16Z")

</div>

I had the same need so I did exactly as described by @PabloMFalero.

But quickly realized all the limitations of this setup:

- It’s very hard to create a campaign and send it automatically with non-paid plans on Zapier
- Managing subscriptions is very challenging, especially if you want your users to be able to toggle their subscriptions from your app (an unsubcribe link - managed by Mailchimp - HAS to be present in every email sent, which fucks up everything / requires so many zaps to sync both lists)

Then I discovered a much better combination with Integromat and Mailjet:

- Users can subscribe / unsubscribe from my app, subscriptions are only managed by the Users’ sheet (true / false + last subscribed at timestamp)
- Every week at fixed hour, Integromat wakes up, looks at the new content and the list of subscribers from my spreadsheets, generates a newsletter and sends it automatically. For this I use the built-in email feature by Integromat and some SMTP credentials from Mailjet.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/8/582d49ac19ceae5476ac9a5fadde7d55e7d7cd08.png)

It’s not perfect and still has limitations\* but it’s working pretty well, automatically and for free!  
Thank you @V88 for pointing up this great solution [right here](https://community.glideapps.com/t/notifications-using-integromat-zapier/14879/8).

\*Can you think about a way to generate a unique 1-click unsubscribe link to be added within each email, so I don’t force users to sign-in to unsubscribe?

---

_[View the full topic](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495)._
