# Notification Digest Texts - Sheet Formulas + Integromat

**URL:** https://community.glideapps.com/t/notification-digest-texts-sheet-formulas-integromat/21172
**Category:** Ask for Help
**Created:** [January 14, 2021, 7:05pm UTC](https://community.glideapps.com/t/notification-digest-texts-sheet-formulas-integromat/21172 "2021-01-14T19:05:08Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Mauronic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mauronic/32/21726_2.png) [@Mauronic](https://community.glideapps.com/u/Mauronic)
#### Post date: [January 14, 2021, 7:05pm UTC](https://community.glideapps.com/t/notification-digest-texts-sheet-formulas-integromat/21172/1 "2021-01-14T19:05:09Z")

</div>

I have been struggling with this problem for a while and I thought I should ask the community for help. 😀

In my social app, there are several activities and events that prompt user notifications. A user could get several a day, but I don’t want to spam them with texts. So, based on user preferences, I would like to send a daily text with the most important notification followed by a summary:

“📅 A new event was posted at Loma Alta Park. See 4 more notifications LINK”

> **Design Details Here**
>
> - Here are some sample notifications:
> 
> ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/d/dd1153f91620aab443c0f2aa38672a9e7a08d77c.png)
> 
> - This is what the sheet looks like. Each one has a category ID “type” that can be compared to user preferences to determine if it is eligible for a text - “Text Notifications”
> 
> ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/2/1208c969da4f29d1134cff761b4a502951efbf72.png)
> 
> - And here are the preferences:
> 
> ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/7/57bb9aa1c0436bb9e7ef1378720018e61c85118d.png)
> 
> (Later I will add a preference for Instant vs. Daily)
> 
> - Sample user preferences for notifications
> 
> ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/0/70f6f4912e9e2e06805df813b2e827c751674507.png)

So, I am trying to figure out the best way to summarize unread notifications each day so I can send text digests to users via Integromat.

Does anyone have any ideas?
