Woocommerce and Google Sheets integration

Getting Started
,
1

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.

2

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.

1 Like
4

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

image
image1920×2560 895 KB

image
image1920×2560 767 KB

5

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.

6

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.

7

Does the woocommerce module return an array?

8

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

9

Can you share the scenario screenshot?

1 Like
10

Here’s a selection. Hopefully this is helpful?

IMG_2309
IMG_23091920×1440 262 KB

IMG_2310
IMG_23101920×1440 239 KB

IMG_2311
IMG_23111920×1440 246 KB

IMG_2312
IMG_23121920×1440 151 KB

IMG_2313
IMG_23131920×1440 170 KB

IMG_2314
IMG_23141920×1440 109 KB

IMG_2315
IMG_23151920×1440 212 KB

11

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

imagen
imagen1202×627 46.9 KB

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,

12

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..?

13

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,

14

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?