I get each order as a bundle with the order rows as arrays. But then I’ve lost the customer ID and shipping address fields that should be on the order level… I’d need some help to get over this hurdle…
Hello @Jonas_Moran, welcome to the make community, I would love to work with you on this, you can book a call Here to discuss the project requirements and you can checkout my upwork profile Here
You have to build the mapping of the fields in Katana with the columns on Google sheet. I would recommend also storing on Google sheet 2 new columns to store the Katana record ID and the last update date-time.
I am doing a co-building session where we work together to build your automation. Working together, we can complete the automation during the session instead of days or weeks while you get trained about the workflow so you can make your updates later by yourself.
Happy to schedule a 30-mins conversation with no commitment to discuss your challenges and try to solve it during the meeting. Here is my calendar link: Solve it in 30 mins | Dimitris Goudis | Cal.com