Shopify Flow is an ecommerce automation platform that enables you to automate tasks and processes within your store and across your apps.
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!
Yes, you can add the same user that authenticated the Google Sheets action originally, giving them edit access
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
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?
The year-end shopping spree is around the corner! Is your online store ready for the ...
By JasonH Nov 10, 2024We recently spoke with Zopi developers @Zopi about how dropshipping businesses can enha...
By JasonH Oct 23, 2024A big shout out to all of the merchants who participated in our AMA with 2H Media: Holi...
By Jacqui Oct 21, 2024