Google Sheets linked to Flow keeps disconnecting

Shopify Plus
, ,
1

I’ve made a flow to send order details from multiple Shopify stores into a Google sheet. After a few days, I noticed it was missing some order data, so I checked some websites and the linked Google Sheets account was disconnected, even though it was connected and sent data before. Can someone please help me understand why it’s doing this and if this is a Flow proper or is the gmail issue? There is no point in sending data if it will just disconnect on its own everyday.

cbm_0-1725115397153.png

cbm_1-1725115611130.png Google Sheets linked to Flow keeps disconnecting

2

Usually a 403 means that the user you used to connect to the spreadsheet does not have access to the spreadsheet. Likely someone (or an automated process) has changed the sharing settings on your spreadsheet. This issue is captured in our help doc: https://help.shopify.com/en/manual/shopify-flow/reference/connectors/add-row-to-spreadsheet

3

The google sheet disconnected automatically from the flow. The linked gmail account is the owner of the sheet so I’m not sure why it’s disconnecting on its own. When I check the gmail account settings, it says access doesn’t expire so not sure what’s happening.

cbm_2-1725352032760.png
cbm_2-1725352032760.png874×561 40.8 KB

cbm_3-1725352044655.png
cbm_3-1725352044655.png1041×310 38.4 KB

4

Can you show the sharing settings on that spreadsheet?

5

Not sure if this is what you mean, but I’m connecting flow through this account that is the owner of the spreadsheet.

cbm_2-1725448481798.png
cbm_2-1725448481798.png433×198 11.5 KB

cbm_1-1725448475583.png
cbm_1-1725448475583.png433×198 11.5 KB

cbm_0-1725448390041.png
cbm_0-1725448390041.png437×169 6.97 KB

6

You may need to contact Sheets to understand why it’s returning that error. I don’t think the error message is fully accurate here.

But one thing I noticed is your sheets URL is the share link but the API wants the URL from the browser (as specified in our docs). Try that instead. Also double-check that you have the right tab name.

7

This is the URL Link I’m using :

cbm_0-1725463820321.png

The tab name is also correct because it starts sending data if I connect the sheets again.

8

Yeah, that’s what I saw in your error message.

Working example:

https://docs.google.com/spreadsheets/d/1NcmvuUm5r4eTM-iM7qOGdB2PVuqtRTkNpJaHYwjMK18/edit?gid=0#gid=0

If stripping off that sharing part doesn’t work, I think you should contact Google support for why they are returning a 403. You can also check if the spreadsheet has too many rows/fields in it. Sheets has a max limit.

9

Honestly, the implementation here leaves a lot to be desired. For MESA, you can have multiple connections, each with their own credentials–and then you choose which one you want to use for that block. For Shopify Flow, I have no idea what user is trying to connect – so I’m not sure who to grant access to. I have gotten a couple Flows to work with Google Sheets but I have no idea why or what the differences are.

Is there a way to specify or at least detect what user Flow is trying to connect to Google with?

10

Yeah the action header is missing a link to the connection we are using. But you can find it by adding a new Action, searching for Sheets and choose the Sheets app (not the Add row to sheets action).

06-59-h0stq-3weux.png
06-59-h0stq-3weux.png3438×1500 106 KB

11

I did check it before I added the “Add to Row” action.

I am logged in as an administrator. This is what I get when I try that:

RSL_IT_0-1736197556261.png
RSL_IT_0-1736197556261.png1372×812 26.3 KB

I am logged in as the Shopify-defined “Admin” role with the new user credentials schema from the Winter Edition. Could that be an issue?

12

I don’t think that would cause an issue. I’ll check for a bug report on our side.

13

I have similar issue, any news how to solve it?

14

You should post more detail about your specific issue

19

Ok, I’ll remove my reply from the other threads

20

Thank you Traiant for understanding.