Connect Flow & Google Sheets by adding authorized editor, not sharing entire worksheet

ST36
Shopify Partner
2 0 2

Hello, is it possible to add an authorized editor to a Google Sheet so that Flow can push rows in, rather than making the whole spreadsheet shareable with a link? If so, what should the authorized editor be? Thank you!

Replies 3 (3)

paul_n
Shopify Staff
1009 133 240

Yes, you can add the same user that authenticated the Google Sheets action originally, giving them edit access

 

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.
ST36
Shopify Partner
2 0 2

Hi Paul, thanks but that's what we did originally and we still received an error message saying "The caller does not have permission". The person that owns the spreadsheet is the one that authenticated Google Sheets in Flow. In other API calls to Google Sheets, you can typically add an authenticated user using Google Auth or similar to allow that specific user to edit the sheet, not just anyone. 

{"status":403,"response_body":"{\"message\":\"\",\"body\":\"{\\n \\\"error\\\": {\\n \\\"code\\\": 403,\\n \\\"message\\\": \\\"The caller does not have permission\\\",\\n \\\"status\\\": \\\"PERMISSION_DENIED\\\"\\n }\\n}\\n\",\"return_value\":\"\"}","verb":"POST","url":"https://flow-connectors.sfe.shopifyinternal.com/actions","request_body":"{\"shop_id\":XXXXXX,\"shopify_domain\":XXXXXX

paul_n
Shopify Staff
1009 133 240

That should work, which suggests that the person who auth'd Flow is not who you think it is. If you search for "Sheets" in Flow and choose the "Google Sheets" connector, you should see a "..." menu with a "review settings" link. Can you confirm the person there is listed as an editor on the spreadsheet?

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.