Export Woocommerce orders details to google sheet

Hi!
I searched extensively the forum and resources before posting but couldn’t find the help I needed.

I am trying to export to google sheets order details from woocommerce.
I’ve been able to get and transfer to google sheets teh order id and creation date so the API connections should be fine.
However when I try to get the order details (with almost all options available: get order, watch order search order, API call, etc) I always get an error (based on the module used) such as:

  • [200] There was a problem on WooCommerce side, please try again later.
  • Invalid module output. Expected Object, but found String.

I’ve seen many posts but they all regard other issues occuring after the order details import so I’d be greatful if somebody could just point me out how to get them to begin with:)

Thanks,
Michael

Before I forgot ot mention that I’ve tried using the template provided by the platform itself but I always get the 200 error.

Thanks abyone for the help