Option to import files in a folder from the Oldest to the Newest file

silviafini

Hello, I would like to be able to pull data automatically from files in a folder every time a new file is added to the folder. If this is not possible, I would like to be able to have the data pulled from the folder (when pulling all files in the folder) to be sorted from Oldest to Newest instead of Newest to Oldest as the current default setting. Is that possible? Thank you!

Karoline from Sheetgo

silviafini Hi Silvia,

That’s a great idea! Thanks for thinking of it!
It’s always important to have a two-way street right?! ;)

Karoline from Sheetgo

silviafini Hi Silvia,

I’m happy to inform you that your request has been developed and released by our outstanding team!
Now we have options to better assist you in your needs!

Please, test it out and let me know if you’re enjoying it! ;)

Rafael Vidal

@Eugenia @Jonatan This is an interesting idea. Do you see more users requesting this feature?

Eugenia

Struggling a bit to understand this here.
Feature 1 would be the possibility to trigger the connection/workflow based on adding a new file to a folder (this one is easy enough to understand)

Feature 2 would be to pull only the oldest file in a folder? Wouldn’t that be deprecated data?
Or are we talking about the order in which the data is sorted inside the new spreadsheet? If that’s the case, I believe this new trigger - Feature 1 - (which could be done with the open API) + append should yield exactly the desired result.

@Rafael Vidal right?

@Oliver what do you think?

Oliver

Eugenia With the open API it should be possible. We would have to create a script that counts the files in a folder and if that number has increased since last time it ran it will fire the workflow.

I’m already in contact with Silvia for another topic, I’ll ask her about this.