# Dynamic Files in Parabola

**URL:** <https://community.parabola.io/t/dynamic-files-in-parabola/355>\
**Category:** Show and Tell\
**Created:** [April 18, 2020, 2:38pm UTC](https://community.parabola.io/t/dynamic-files-in-parabola/355 "2020-04-18T14:38:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Patrick\_Hoban](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/patrick_hoban/32/224_2.png) [@Patrick\_Hoban](https://community.parabola.io/u/Patrick_Hoban)\
**Post date:** [April 18, 2020, 2:38pm UTC](https://community.parabola.io/t/dynamic-files-in-parabola/355/1 "2020-04-18T14:38:31Z")

</div>

Hi all,

A common need of mine is to be able to run the same workflow on multiple different Google Sheets. For example, I pull new contact data every day and use Parabola to clean the data by removing titles I don’t want, segmenting it, and formatting the data.

Parabola only connects to a static Google Sheet, rather than some way to rotate the Google Sheet. I found a nice workaround that makes Parabola a lot more flexible.

1. Drop your newest file into a Google Drive folder.
2. A new file in that folder is the trigger to replace a Google Sheet with the file from step 1 via Zapier.
3. The Google Sheet being replaced each day is connected to Parabola.

The effect is that Parabola is connected to a single file, but the contents of that file change daily. This lets me not have to edit my Parabola workflow everyday, but can run it on new data every day!

---

<div class="post-metadata">

**Author:** ![andrew](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/andrew/32/36_2.png) [@andrew](https://community.parabola.io/u/andrew)\
**Post date:** [April 18, 2020, 7:28pm UTC](https://community.parabola.io/t/dynamic-files-in-parabola/355/2 "2020-04-18T19:28:41Z")

</div>

This is super cool @Patrick_Hoban! Very creative workaround 🙂 Thanks for sharing.