Shopify Flows error with Google Sheet

Hannah99
Visitor
2 0 0

Every time I go to test my shopify flow automation to add a row to a spreadsheet, it consistently gives me this error, regardless of having made the sheet editable and sharing the sheet, inputting the sheet information. What am I doing wrong to link the gsheet?

Hannah99_0-1648751466795.png

 

Replies 5 (5)

paul_n
Shopify Staff
956 128 225

It seems to be saying that your worksheet Tab name is not correct. It's also possible that something in the data you are sending is not allowed. It would help to see the configuration for the Sheets step, if you think the tab name is correct.

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
JordonDM
Tourist
4 0 1

After connecting to the Google sheet, I am unable to connect it to any particular sheet to add a row in. Please help, when I click on Get this app, it shows the first screenshot.

JordonDM_0-1650958518676.png

JordonDM_1-1650958601311.png

 

 

paul_n
Shopify Staff
956 128 225

Immediately after you add Sheets, it may not properly refresh the editor, so if you have not I would first try reloading the editor and see if you can access "Add row to spreadsheet". If that does not improve things, then I would check if you are using the Plus Admin toolbar to access Flow or the App. They handle connectors slightly differently...I would try to access/install it via the App.

 

If you are using the app, I might try to disconnect and then reconnect. It's possible that an error occurred during the connection that needs to be refreshed. 

 

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
JordonDM
Tourist
4 0 1

Thanks, I managed to access it after a while.

JordonDM
Tourist
4 0 1

For me, I got around this issue by setting the Share to anyone with the link is an editor, as well as use the share link rather than the URL in the search bar. 

Make sure the sheet tab name is the same, eg no extra spaces. 

Good luck 🙂