I’ve built 2 scenarios where Scenario A generates data that’s dropped into Google Sheets across 300 rows. It also drops an additional data row on a separate tab within the same Google Sheets.
I want Scenario B to access the data across 300 row and the row from the separate tab in Scenario A.
I’ve tried http and webhooks, i’ve tried using range values in google sheets in Scenario B and i’m just not being able to make it work.
I might be doing something incorrectly, and/or, I’m missing something in make’s capabilities.
Generally you can definitely have multiple scenarios on the same google sheets. The question for you probably is “how do I find the correct rows & data to work with in the second scenario?”.
It might be helpful to have a column “ID” to uniquely identify certain rows. Alternatively, when I’m working with google sheets, I always add a column “Row” which contains the formula “=ROW()” inside. This way, you can get the row number if you use the ‘Search Rows’ module.
I’m not sure of your exact setup and your goal but maybe sub-scenarios is your way to go.
Scenario A runs and as the last step you start Scenario B.
It really depends on the exact challenge here Maybe with some more context I can give more specific advice
Maybe with some more context I can give more specific advice