# Automatically Update an Excel file from various actions in GlideApp **URL:** \ **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:** 10\ **Page:** 1
**Author:** ![FilipeAz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/filipeaz/32/57289_2.png) [@FilipeAz](https://community.glideapps.com/u/FilipeAz)\ **Post date:** [March 24, 2024, 11:14pm UTC](https://community.glideapps.com/t/automatically-update-an-excel-file-from-various-actions-in-glideapp/72002/1 "2024-03-24T23:14:53Z")
Hi everyone, I’m developing an app that monitors a interclass competition in a public school in Portugal for students between the 7th and 9th grade. Each class is evaluated by their teachers and operational assistants that work with them in a scale of 1-5. The average grade reverts directly to points for each class. They can also receive points if they reach the objectives defined by the School Board when it comes to their performances in tests or the behaviors of merit they had during the semester. Finally, to further engage students Quizzes were also added to the app. The results are positive so far, but to further analyze the data from the competition and alert teachers and operational assistants of the grade submission I’m having a lot of manual work in the weekends. I have a Pro Account and I have Push Notifications that I send (even though I’m not yet figure out the best way to create a time trigger that sends the reminder to certain teachers) and I have to export the CSV of each GlideTable that contain the submissions and analyze them in an Excel. I already optimize the Excel so that the data is showcased in a more friendly manner and I’m even working with PowerBI to improve this. My question is simple: can you help me pass the information from GlideApps to Excel in real time? What options do I have using GlideApps integrations and how expensive are they? I’ve tried Zappier, but my API key doesn’t work and I don’t understand why. If you could help me I would be extremely helpful. I’m a part of a bigger team that works in their off time with the goal of improving the way public school operate in Portugal accross all levels and we are extremely motivated in our mission. Thank you! ---
**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 24, 2024, 11:45pm UTC](https://community.glideapps.com/t/automatically-update-an-excel-file-from-various-actions-in-glideapp/72002/2 "2024-03-24T23:45:38Z")
> [@FilipeAz](#): > > even though I’m not yet figure out the best way to create a time trigger that sends the reminder to certain teachers Time-based actions are not available in Glide for now. > [@FilipeAz](#): > > My question is simple: can you help me pass the information from GlideApps to Excel in real time? What options do I have using GlideApps integrations and how expensive are they? By Excel here, do you mean Google Sheets or an online Excel workbook? ---
**Author:** ![FilipeAz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/filipeaz/32/57289_2.png) [@FilipeAz](https://community.glideapps.com/u/FilipeAz)\ **Post date:** [March 24, 2024, 11:58pm UTC](https://community.glideapps.com/t/automatically-update-an-excel-file-from-various-actions-in-glideapp/72002/3 "2024-03-24T23:58:14Z")
Excel workbook ---
**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, 12:03am UTC](https://community.glideapps.com/t/automatically-update-an-excel-file-from-various-actions-in-glideapp/72002/4 "2024-03-25T00:03:35Z")
So it’s stored on Sharepoint or somewhere else? By the way, your plan doesn’t allow you to do a query to get data. If the file is stored on Sharepoint, maybe an option is to connect it directly with Glide? I can’t recall if Excel is available on Pro Legacy. ---
**Author:** ![FilipeAz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/filipeaz/32/57289_2.png) [@FilipeAz](https://community.glideapps.com/u/FilipeAz)\ **Post date:** [March 25, 2024, 12:55am UTC](https://community.glideapps.com/t/automatically-update-an-excel-file-from-various-actions-in-glideapp/72002/5 "2024-03-25T00:55:25Z")
It is stored in Sharepoint. I don’t know a way to use an action in GlideApps as a trigger to update an online Excel Workbook. ---
**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, 12:57am UTC](https://community.glideapps.com/t/automatically-update-an-excel-file-from-various-actions-in-glideapp/72002/6 "2024-03-25T00:57:47Z")
Excel is available as a data source. > **[Microsoft Excel | Glide Docs](https://www.glideapps.com/docs/excel)** > > Connect your app to Excel Workbooks ---
**Author:** ![FilipeAz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/filipeaz/32/57289_2.png) [@FilipeAz](https://community.glideapps.com/u/FilipeAz)\ **Post date:** [March 25, 2024, 1:03am UTC](https://community.glideapps.com/t/automatically-update-an-excel-file-from-various-actions-in-glideapp/72002/7 "2024-03-25T01:03:30Z")
Can I change DataSources right now? Or do I have to create a new app? I had no idea this was a thing ---
**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, 1:04am UTC](https://community.glideapps.com/t/automatically-update-an-excel-file-from-various-actions-in-glideapp/72002/8 "2024-03-25T01:04:43Z")
You can add that Excel file to your list of data sources (providing your plan allows it), but if you want to connect that to components/flows in your app you would have to re-do it. ---
**Author:** ![FilipeAz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/filipeaz/32/57289_2.png) [@FilipeAz](https://community.glideapps.com/u/FilipeAz)\ **Post date:** [March 25, 2024, 1:10am UTC](https://community.glideapps.com/t/automatically-update-an-excel-file-from-various-actions-in-glideapp/72002/9 "2024-03-25T01:10:21Z")
I’m more interested in passing the information from Glide to Excel and not the other way around. Is their anything I can use without re-doing what I have previously done? Thanks ---
**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")
> [@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.