# Help configuring NEW data every day

**URL:** https://community.glideapps.com/t/help-configuring-new-data-every-day/16659
**Category:** Ask for Help
**Created:** [October 2, 2020, 2:21pm UTC](https://community.glideapps.com/t/help-configuring-new-data-every-day/16659 "2020-10-02T14:21:28Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![videotoast](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/videotoast/32/14651_2.png) [@videotoast](https://community.glideapps.com/u/videotoast)
#### Post date: [October 2, 2020, 2:21pm UTC](https://community.glideapps.com/t/help-configuring-new-data-every-day/16659/1 "2020-10-02T14:21:28Z")

</div>

I am building (or trying) to build an app that uses data from a new inventory spreadsheet that is emailed every morning at 9a.

I have ZAPIER pulling the attachment from gmail and saving to my Google drive.

I would like Glide to grab the new file automatically. How can I do that?

Please help, if you are able.

---

<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: [October 2, 2020, 2:38pm UTC](https://community.glideapps.com/t/help-configuring-new-data-every-day/16659/2 "2020-10-02T14:38:25Z")

</div>

You have to write the content of the file to the source spreadsheet for Glide, is that correct?

---

<div class="post-metadata">

### Author: ![videotoast](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/videotoast/32/14651_2.png) [@videotoast](https://community.glideapps.com/u/videotoast)
#### Post date: [October 2, 2020, 2:41pm UTC](https://community.glideapps.com/t/help-configuring-new-data-every-day/16659/3 "2020-10-02T14:41:37Z")

</div>

When I made the initial app, yesterday, I selected the file from 10-1, and used it as the source.

(I am very new to this - I may not know some of the terminology correctly)

Now, this morning, new file came in, I renamed and replaced the same as the original source file (from yesterday) in my Google Drive

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 2, 2020, 2:57pm UTC](https://community.glideapps.com/t/help-configuring-new-data-every-day/16659/4 "2020-10-02T14:57:16Z")

</div>

The filename name be the same, but a new file will create a new underlying file ID that Google and I assume Glide uses. That allows you to rename a file without destroying the underlying ID. You may be able to just overwrite the same file in Google drive instead of copying and renaming. Otherwise you will have to switch the connected sheet in the glide editor each day.

Glide apps can only connect to one sheet at a time.

---

<div class="post-metadata">

### Author: ![videotoast](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/videotoast/32/14651_2.png) [@videotoast](https://community.glideapps.com/u/videotoast)
#### Post date: [October 2, 2020, 3:02pm UTC](https://community.glideapps.com/t/help-configuring-new-data-every-day/16659/5 "2020-10-02T15:02:20Z")

</div>

I will try that, but it seems now, even if I try to replace the source file, the dialog box does not show all the files in my Google drive, or even all the files in the original source folder.

Am I just lucky that I am getting the bugs today, or is this the right way to create an up to date (daily) inventory access for our sales team?

Daily email from inventory system (SAP) with inventory. Simple search function to see whats in stock and back order from the app.

---

<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: [October 2, 2020, 3:03pm UTC](https://community.glideapps.com/t/help-configuring-new-data-every-day/16659/6 "2020-10-02T15:03:35Z")

</div>

You have to find a way to update that data to one sheet only, that sheet should not be changed based on daily inventory email.

---

<div class="post-metadata">

### Author: ![videotoast](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/videotoast/32/14651_2.png) [@videotoast](https://community.glideapps.com/u/videotoast)
#### Post date: [October 2, 2020, 3:06pm UTC](https://community.glideapps.com/t/help-configuring-new-data-every-day/16659/7 "2020-10-02T15:06:05Z")

</div>

So source should always be the same, I just need to overwrite that original document, every day.

I appreciate the input, I will let you know how it goes Monday morning.
