What is your goal?
I am using woocommerce an when an order is placed and paid ie marked as Processing or complete I want it to send the order details to a google sheet in my google drive and I want to run this immediately as data arrives.
What is the problem & what have you tried?
I am new here and this is my first attempt but I have been on it about 5 hours so far and canât get it to work. I have what I understand is the correct set up and I have the webhook set up on woocommerce site. I have woocommerce â Iteratorâ Google sheets as the model see image but it never gets past the first step.
If anybody can offer any help would be appreciated. If any more info is needed please ask and I will provide.
Thanks
Nick
Screenshots (scenario flow, module settings, errors)
It looks to me like woo is seeing the order come in and even though it is marked as processing as it was paid by card itâs not making it through to the Iterator.
With advice from Chat GPT I updated it to this (added a get an order) and removed the filters but still not working.
Hey Nick,
can you show what the output bundle looks like and what you were filtering for?
Ok I was filtering to only allow order status processing or complete to pass through. And I canât find the output bundles can you tell me where to look for them? Thanks
In the scenario history, you can get one from one of the previous runs.
Thanks I have just tried that and there is nothing there am I right in thinking I need to see the bubble to to get the output?
Hi Nick! Donât give up! If I hit this kind of error I just do one step at a time. So right click to unlink the first and second modules, save and ignore the warnings that it isnât set up properly and run the scenario so I can see if data comes into my first module (then you get 2 little ticks above the module like the first photo you shared). Then you can map the data that comes out to the sheets module. But until you have the one successful run there isnât data to map.
Nick_Porter,
Did you set a starting point in your module 1?
Make is watching new events from the certain point (this point should be set (right click on module 1), and if you want to test the workflow with old events you need to set it manually).
From you screenshots it seems that make is watching (1 credit per check) but you donât have new orders. Try to set âstart fromâ to older orders that you can select manually.
Let me know.
Gleb
Thanks @Alice_Jennings I will have a look at doing that later when I get back home.
Thanks @gleb_logautomate I have had about 30 new orders come in today but no triggers. I will try changing the start date to 5 days ago and see if it captures anything.
@Nick_Porter I think there is an issue with your webhook. if you donât see any orders coming through then it makes sense to check setting on woocommerce side.
@gleb_logautomate Thanks I have checked it and it is all entered correctly in Woocommerce. Do you know if there a way to check if it is actually working? Appreciate any help
This is how I have it set at the moment if this helps?
And this is how the Google sheet connector looks.
OK I am getting there now it was the web-hook it wasnât firing for some reason so switched back to âWatch Ordersâ and have managed to get it 95% of the way there.
The only problem I have left is mapping the variations but working on it.
Anybody know of a good youtube video that covers mapping variations?
I have managed to get it to pull in 1 variation but not them all a lot of my products have at least 2.
@Nick_Porter having error is fine you are still learning how to use the app but thatâs cool anyway just give it a goal at atime and with make.com academy basics you did achieve your goals with make.com
Well done in keeping at it, you are making great progress. You can always try adding Make MCP as a connector in Chat GPT, which allows it to directly call your scenario and the logs and each module. You can also use routers to manage the flow and filters if needed.
Hi @Nick_Porter Iâve made a lot of Woocommerce scenarios. Not a youtube video, but Iâve made you these screenshots how to do this.
- Set up an iterator after âwatch ordersâ like this with âline itemsâ in the Array box
- This Iterator will output variations in an order, here as an eg is colour and size of t-shirt
- Iâve added a âToolâ module to show you the next step, but you can use the formula from this tool in any module to produce the same output. Type this in:
- You get the outputs of the variations (here âathletic heatherâ and âmâ as the colour & size)
Hope this helps
Sarah
@Sarah_D thanks I will look at this this week appreciate your help.
