Playwright Test mod that uses Google Sheets

[grahamlangford]

Acceptance Criteria

• [ ] Test that leverages the Google Sheets APIs
  • [ ] Can be Page Editor, Sidebar mod, or Extension Console, whatever is easiest
  • [ ] Mock the response from the API (https://playwright.dev/docs/mock)
  • [ ] Should successfully call the API and test that the UI is correctly updated with the response

Notes

• Let's timebox initially to 1 day, then revisit. Depending on LoE, we may want to prioritize other Playwright issues first.
• @BLoe has context on the GSheets APIs

[grahamlangford]

@BLoe is there a Postman collection with the relevant APIs?

[BLoe]

@BLoe is there a Postman collection with the relevant APIs?

It's in the "Brick Prototyping" workspace, in the Google Drive and Google Sheets collections. YMMW on cleanliness/completeness of the collections there, but I think most of it is in place. For authentication, the CLIENT_ID, and CLIENT_SECRET should be configured as collection variables, but let me know if there are any issues with that and I can share those values directly.