bitfocus/companion-module-google-sheets

Stuck on 'Select Spreadsheet'

dxf opened this issue · 3 comments

dxf commented

Describe the bug
Trying to add an Adjust Cell button doesn't show any spreadsheets in the Select Spreadsheet list

To Reproduce
Steps to reproduce the behaviour:

  1. Add new connection to Sheets, including all necessary details + Spreadsheet ID
  2. Create new button to Adjust Cell
  3. Highlight dropdown to select spreadsheet

Expected behaviour
My spreadsheet should appear

Screenshots
If applicable, add screenshots to help explain your problem.
Menu not working
Config

System (please complete the following information):

  • Companion Version 2.4.0 (2.4.0+4723-beta-c3cb02b6)

Additional context
I did check my file permissions - I'm the owner of the file

There's a missing step in the process that hasn't been updated yet, and was discovered in #2 where you need to make sure to enable the Google Sheets API in the libary section in Google Cloud and that should resolve this issue.

dxf commented

I'll give that a go and let you know how I get on.

Thanks!

dxf commented

Works just fine. Cheers!