# Automatically Update an Excel file from various actions in GlideApp

**URL:** <https://community.glideapps.com/t/automatically-update-an-excel-file-from-various-actions-in-glideapp/72002>\
**Category:** Ask for Help\
**Created:** [March 24, 2024, 11:14pm UTC](https://community.glideapps.com/t/automatically-update-an-excel-file-from-various-actions-in-glideapp/72002 "2024-03-24T23:14:53Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**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:** [March 25, 2024, 2:56pm UTC](https://community.glideapps.com/t/automatically-update-an-excel-file-from-various-actions-in-glideapp/72002/10 "2024-03-25T14:56:38Z")

</div>

> [@Historical Analytics by Date](https://community.glideapps.com/t/historical-analytics-by-date/71737/4):
>
> I have the exact need as you for my last project. I think there are 2 ways to go here: If you have access to Glide API’s query (on Business/Enterprise), perhaps you can query the whole tables and do aggregation to get the right numbers (of Users, Events, Events Complete - basically re-calculating them in Make/Zapier), then push those to your analytics table. The alternative is to duplicate your app, which will keep your tables intact. Change your app to fully public, clear all tabs and ad…

I think here’s the best option I can share for now.

---

_[View the full topic](https://community.glideapps.com/t/automatically-update-an-excel-file-from-various-actions-in-glideapp/72002)._
