Currently trying to figure out a way to have all the data from the download amazon report get pulled (Add Row) into Google Sheet before the next module begins (Search Rows) as currently once 1 row is added to googles sheets the remainder of the scenario runs which causes issues with not having the full data to look at when doing the Shopify Call.
Screen Shot shows the partial part where I am looking to have all data from module 66 pulled into Module 9 before module 32 and beyond begin.
Thank you,
Hi @Fitt_Ops and welcome to the Make Community!
Where does the time spent lie? I suspect it’s in module 66. If so, you would need to poll the status of the report or, if you’re sure of the time it takes to complete the report, you can put a sleep module between the two Amazon modules.
A scenario can run for a maximum of 40 minutes and sleeps run for a maximum of 5 minute. So if creating te report takes more than 5 minutes, you can put 2 or more in a row.
It’s not the ideal solution but it’s the simples and the least costly. Otherwise, if you need the report as soon as it’s ready, for example, you have to implement a polling mechanism which costs more in operations and not as evident to implement.
L
