Google Sheets integration stopped working

Hi,

May I ask you to check the automation and try to save it again? Additionally, please send me screenshots of this automation and send me information on which version of ShopMagic plugins you are using.

Hi,

I haven’t heard from you in a while, so I’m marking this thread as resolved. Please don’t hesitate to open a new one if you encounter other issues while using our plugin.

Have a fantastic day,

Hello, Dominik!

Sorry for the delay, I was not able to contact the Google Sheet manager.
So, we did the re-connection without any result. Still “Failure” in the log.

The automation is pretty simple. It just adds the new row to the Google Sheets once a new WooCommerce order is created.
https://prnt.sc/v4BO0WUJ0Ir2

ShopMagic for Google Sheets ver 2.0.6
ShopMagic for WooCommerce ver 4.2.9

https://prnt.sc/mApOd-7hNx3r

Best regards,
Constantine.

Hi,

Sorry for the long wait, however, I am getting back to you.
Unfortunately, the current screenshots tell us little, so I would ask you to export the automation that is causing the problems. You can do this by going to ShopMagic → Automation and selecting this button https://monosnap.com/file/PxnCt82t05kIlZUij0tKABtD8uuJ45

Hello )

Here it is:

{“id”:null,”parent”:null,”name”:”Credicycle Google Sheets”,”description”:null,”status”:”publish”,”event”:{“name”:”shopmagic_order_new_event”,”settings”:[]},”actions”:[{“name”:”shopmagic_add_sheets_row”,”settings”:{“_action_title”:”CrediCycle to Google Sheets”,”google_sheets”:””,”spreadsheet”:”1f8YzCy2o_f7OHM42n-F-QmRHaGyYxyVY1Gjq4XTtPyw”,”spreadsheet_tab”:”Sheet1″,”use_header”:true,”values”:[“{{ customer.first_name }} {{ customer.last_name }}”,”{{ order.total }}”,”{{ order.products_ordered }}”,”{{ order.customer_note }}”,”{{ order.date_completed }}”,”{{ order.date_paid }}”,”{{ order.admin_url }}”,”{{ order.payment_method }}”,”{{ order.billing_address }}”],”_action”:”shopmagic_add_sheets_row”}}],”filters”:[],”language”:null,”recipe”:false,”_links”:[]}

Thx a lot, will be waiting!

Hi,

Thanks for sending the automation – I see that the data is supposed to fly to Sheet1 – please make sure that the name of this sheet and the sheet itself are in place and no one has deleted/changed it. The issue here is not the entire file, but a single sheet from a spreadsheet.

Hello, Dominik!

Thanks a lot for all your help. You were right, the problem was the GS manager renamed the Sheet Tab )

Have a nice daytime, and best of luck with your amazing plugin!

Best regards,
Constantine.