Managing Live and Staging Environment Data Sources

Hi, I have a customer’s app built using Google Sheets as a data source. As you might imagine, we continue to iterate on the app, we need to be able to switch between Production data sources and Staging data sources.

However I don’t see the “Merge Environment” function, only a “Copy Environment” function that overwrites the destination environment (i.e. Production) with everything from the source environment (i.e. Staging). That’s obviously not ideal.

I know a workaround that requires us to update the Staging data source to point to the Production Google sheet before copying over, but I was wondering if anyone has managed to do this in a more streamlined manner.

We recently updated the environment feature and now it is (Copy Environment) it works pretty the same though