# Generating a newsletter digest from Glide inputs **URL:** \ **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:** 17\ **Page:** 1
**Author:** ![Alexandre\_Durand-Cha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexandre_durand-cha/32/15706_2.png) [@Alexandre\_Durand-Cha](https://community.glideapps.com/u/Alexandre_Durand-Cha)\ **Post date:** [December 30, 2020, 8:19am UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495/1 "2020-12-30T08:19:02Z")
How awesome it would be, uh? Is it only possible ? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 30, 2020, 9:22am UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495/2 "2020-12-30T09:22:51Z")
What content do you want to have for this? I would like something like this too. ---
**Author:** ![Alexandre\_Durand-Cha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexandre_durand-cha/32/15706_2.png) [@Alexandre\_Durand-Cha](https://community.glideapps.com/u/Alexandre_Durand-Cha)\ **Post date:** [December 30, 2020, 9:34am UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495/3 "2020-12-30T09:34:45Z")
curated newsletter you can send weekly to a mailing list and where you can tell to your readers to find all the resources quoted/curated into the app. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 30, 2020, 9:37am UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495/4 "2020-12-30T09:37:04Z")
It is a bit tricky to automate this but probably you can look at using Integromat and Mailchimp to do this. First, create a template in MailChimp that is used as a base for Integromat to write data in. Then in your Sheet, structure the data so that let’s every Monday at 7am, an Integromat scenario will be run to fill the template and send out an email to your users. > **[Mailchimp Integrations](https://www.integromat.com/en/integrations/mailchimp)** > > Integromat gives you the ability to integrate Mailchimp with many other services. ---
**Author:** ![Fabio\_Leanzi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabio_leanzi/32/6838_2.png) [@Fabio\_Leanzi](https://community.glideapps.com/u/Fabio_Leanzi)\ **Post date:** [December 30, 2020, 6:29pm UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495/5 "2020-12-30T18:29:57Z")
i am creating this via amazon SES. A script that allows you to send newsletters / SMS from Glide ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [December 31, 2020, 8:24am UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495/6 "2020-12-31T08:24:13Z")
You can create a zapier with MailChimp like @ThinhDinh says, when a user creates a profile add customer to your data base, then create a post with a zapier that creates a campaign. You’d have to then go to MailChimp to make the email look pretty ---
**Author:** ![Alexandre\_Durand-Cha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexandre_durand-cha/32/15706_2.png) [@Alexandre\_Durand-Cha](https://community.glideapps.com/u/Alexandre_Durand-Cha)\ **Post date:** [January 6, 2021, 10:40am UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495/7 "2021-01-06T10:40:45Z")
Super interested ! Happy to learn more about your script in DM if it’s ok for you ---
**Author:** ![Fabio\_Leanzi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabio_leanzi/32/6838_2.png) [@Fabio\_Leanzi](https://community.glideapps.com/u/Fabio_Leanzi)\ **Post date:** [January 6, 2021, 10:58am UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495/8 "2021-01-06T10:58:01Z")
Oh yes 👍 ---
**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")
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? ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [January 7, 2021, 8:43pm UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495/10 "2021-01-07T20:43:00Z")
Sorry! 😟 I actually never tried it myself, so good to know that it’s not a good solution!!!😀 ---
**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:46pm UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495/11 "2021-01-07T20:46:07Z")
Then I’m very sorry as well, my point wasn’t to blame you since it’s very natural to think about this setup. It was a no brainer to me as well initially. Just wanted to share my experience at doing it and thought the described solution could be of interest for some people. Cheers mate! ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [January 7, 2021, 8:50pm UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495/12 "2021-01-07T20:50:39Z")
Absolutely, and I thank you for this!😀🙏 ---
**Author:** ![Julien\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/julien_b/32/18939_2.png) [@Julien\_B](https://community.glideapps.com/u/Julien_B)\ **Post date:** [January 8, 2021, 8:33pm UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495/13 "2021-01-08T20:33:59Z")
Super intéressant !! J’ai commencer à créer dans Integromat. Est-ce que je peux te contacter pour avoir un peu plus d’infos ? Merci par avance 🤗 ---
**Author:** ![Alexandre\_Durand-Cha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexandre_durand-cha/32/15706_2.png) [@Alexandre\_Durand-Cha](https://community.glideapps.com/u/Alexandre_Durand-Cha)\ **Post date:** [January 9, 2021, 6:44am UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495/14 "2021-01-09T06:44:27Z")
Awesome ! Thx so much I will try this now ---
**Author:** ![Alexandre\_Durand-Cha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexandre_durand-cha/32/15706_2.png) [@Alexandre\_Durand-Cha](https://community.glideapps.com/u/Alexandre_Durand-Cha)\ **Post date:** [January 9, 2021, 6:44am UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495/15 "2021-01-09T06:44:41Z")
Yes no pb 😉 ---
**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 9, 2021, 9:56am UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495/16 "2021-01-09T09:56:48Z")
Feel free to reach out guys @Julien_B @Alexandre_Durand-Cha ---
**Author:** ![Electro1](https://avatars.discourse-cdn.com/v4/letter/e/439d5e/32.png) [@Electro1](https://community.glideapps.com/u/Electro1)\ **Post date:** [March 12, 2021, 1:06am UTC](https://community.glideapps.com/t/generating-a-newsletter-digest-from-glide-inputs/20495/17 "2021-03-12T01:06:30Z")
Hi all, how to add mail chimp newsletter to glide app