Connect shopify to Google Sheets

[Tokyorob]

Hi All,

I had a coder work on connecting my orders to google sheets.

It has stopped working and the coder has dissapeared. Any ideas on how to fix this?

Thanks in advance

Robert

[CodingFifty]

Hey! @Tokyorob,

If your Shopify orders were syncing to Google Sheets and have suddenly stopped, the issue could be due to a broken webhook, expired token, or a problem with the script or tool (like Zapier or Google Apps Script) used to set up the integration. Start by checking if any automation apps like Zapier, Make, or Shopify Flow were used, or if there's custom code in your Google Sheet under Extensions > Apps Script. You can also test the integration by placing a test order and checking for logs or errors

[Tokyorob]

Hi CodingFifty,

Sadly it seems the account my coder used is his own Google accout and I have been added. He has since ghosted me. I think that means I can't do anything?

I may have to set it up again.

[rddev]

Hi Robert

Sorry to hear your coder ghosted you. You may be better off with a pre-built solution that can sync your order data to Sheets.

DataFlowed is one solution and it sounds like you may be able to use the free plan.

https://apps.shopify.com/dataflowed

Here is a blog post showing how it is done:
https://dataflowed.com/blog/export-shopify-orders-to-google-sheets/

This should save you having to manage an external developer or pay them to maintain your connector. 

Regards
Ryan