What are you trying to achieve?
I need to generate and fill a google sheet for every new order I receive in my store. I need a new sheet for every order then generate headers inside the sheets and lastly add a row under the generated headers.
Steps taken so far
I was able to generate a new sheet and the headers in each sheet. Now I’m stuck in the last step which is to fill a row under the headers. In the last ‘add a row’ module, it doesn’t detect generated headers made by the previous module. It only displays the values of the headers(image). How can i make the module recognize the headers?
1 Like
Hi Damian,
I’ve read your problem and I understand it. I’ve looked into it myself and I also do not quite know how to solve it, however, looking at your problem from a broader perspective: Why do you need a new sheet for every order? Is it true that all your orders are on a new sheet with the same header? (CustomerOrderNo., RoutingCode, etc.)?
In that case: why don’t you add every order in the same sheet, in a new row? You have probably already looked into it, but sometimes (in my experience), the solution is not in fixing the current scenario, but changing the scenario.
Let me know if I miss something here - VDW Intelligence
