Different Google sheets in staging vs production

Feature Requests
1

When I change the spreadsheet to read from / write to using my Google Sheets resource, in the staging environment, it also changes in prod, and vice versa. I need the staging environment to manipulate a "dummy"/copy of the prod spreadsheet.

2

When in staging/prod and using the same Resource, you will need to write in logic to point to a different sheet {{retoolContext.environment == 'staging' ? 'dummyCopySheet':'actualSheet'}}

1 Like
3

Hi @KaleyWhite! Thanks for reaching out. Do you think you could use the retoolContext.environment property to workaround this? You could also have two separate queries that are triggered according to retoolContext.environment

1 Like
4