Googlesheets: Enter the Spreadsheet name by the name or ID
I'd like a way to make copying and maintaining recipes with a Google Sheets connector easier for my client who is a franchise based business.
My client has 40+ markets across the country for which we're setting up recipes. In their account, I have a "Template" folder which houses all of our recipes. We then have folders for each of their franchise markets. For each market, we create a child copies of the parent recipes in the template folder.
Each of the franchise Markets also has their own google sheet they call their "Gbase." Each of these sheets has the same schema but different operating data specific to that market. When creating child copies of new recipes, or when releasing an update to the parent recipe by updating the version of child recipes, there's a huge inefficiency in having to manually select a different google sheet for every single child recipe action that uses the Google Sheets app.
Instead of having to manually select a spreadsheet from a drop down for every Sheets action, it would be ideal if we could enter the Spreadsheet by a Name or ID string. That way, I can use a formula, config param, or lookup table to pull the correct spreadsheet for each market without having to select it manually.