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

[ST36]

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!

[paul_n]

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

[ST36]

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]

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?