Woocommerce and Google Sheets integration

[Alfred_Agnew]

Hi There,

I am trying to connect my Woocommerce to my Google sheet doc so that every time a customer orders a product off my website / Woocommerce the order automatically populates a row in Google sheets. so I can track what’s being sold for inventory purposes. I thought I had set up my Make integration for this all correctly but a customer has recently order a product and a row in my Google sheet doc hasn’t been populated. Any help would be much appreciated.

Thanks.

[Greatness_me]

Hey @Alfred_Agnew , do you mind sharing a screenshot of your scenario just so I can pinpoint what’s wrong with it and proffer a solution.

[Alfred_Agnew]

Thank you so much for the reply. Please see below screenshots;

[Greatness_me]

Oh! I see what the problem is.
The trigger you set up is actually a scheduled trigger. This means that the updated data will not be received immediately.

If you want to fix this, you need to setup a webhook so that the updated data will be sent immediately as it arrives.

[Alfred_Agnew]

Thank you. The schedule trigger you are referring to is every 15 minutes so it should have updated the google sheet row by now condensing someone order a product 3 days ago…let me know if I am missing something. Thank you again.

[Greatness_me]

Does the woocommerce module return an array?

[Alfred_Agnew]

Doesn’t appear so and I have made sure it’s verified etc.

[Greatness_me]

Can you share the scenario screenshot?

[Alfred_Agnew]

Here’s a selection. Hopefully this is helpful?

[ipoblete]

Hi @Alfred_Agnew

1. create in woocomerce a webhook when order.created
2. in make, create an scenario linking that webhook, and then add rows en sheets and what ever you want,

Here is an example

It is important that this scenario has to be active and run immediately as soon as the data arrives.

If you want to be even more refined, you can then have a webhook that updates according to the status of each order and subtract only the orders that were completed,

Regards,

[Alfred_Agnew]

Amazing thank you. I was under the impression that I could use WooCommerce watch order modules in Make and simply link that to Google sheets to avoid having to use webhooks but I might be wrong? In the example you sent I can’t see WooCommerce being used in there or is this just an example of a webhook being used and not necessarily a WooCommerce integration example..?

[ipoblete]

hi @Alfred_Agnew
It depends a lot on what you need. For example, I have a webhook that puts all orders in Google Sheets when they are created, and I use another webhook to update processing, delivery, completed, and so on… plus others mailhook that process emails from other services that I have connected to WooCommerce events.

So, in summary, I have, for example

→ webhook for order creation
→ webhook for status changes

• mailhook for other processes

With that, I automatically manage many of the WooCommerce processes.

Best regards,

[Alfred_Agnew]

All noted, thank you. I just need ‘processing’ or ‘completed’ orders in WooCommerce to automatically populate Google sheets. Either status will be fine, I just need the order details so perhaps a webhook is less relevant for me?

[Alfred_Agnew]

Please can someone help?

The picture shows Woocommerce with a green tick but Google Sheets without one. Does this mean that Woocommerce isn’t connecting into Google Sheets?

[ipoblete]

Hi @Alfred_Agnew

Hello,

what the green text says is that it processed it and you should click on the circle with the number 1. That number tells you that you have an operation, but you may not have a result to “send” to the sheet module.

Confirm that you have orders with status you are filtering in module 1.

Please share the configuration of both modules.

Best regars,

[Alfred_Agnew]

Thank you for the response. I believe I have sorted it now.

[Misha]

Hello @Alfred_Agnew

can you please jump in and share the solution? Thank you!