bitfocus/companion-module-google-sheets

Won't update the google sheet

jalmar2000 opened this issue · 1 comments

jalmar2000 commented

Describe the bug
I've added the instance succesfully with the OK signal in de connections tab. I've made a button which just posts a value of "test' into cell A1 but when I click the button it doesn't show in the cell.
I've added some screenshots to show you how I've set it all up. I also noticed that the instance hasn't made any write requests yet.
Screenshot 2022-12-13 at 12 54 57
Screenshot 2022-12-13 at 12 54 12

  • Companion Version 2.4.1 (2.4.1+4898-v2-4.1-9646192a)
jalmar2000 commented

I found the problem myself. So i'll add this for any future users. The "cell" field needs a little more information then just A1 in my experience. As I am dutch I had to use the following cellinformation "Blad1!A1" which probably translates to "sheet1!A1" hope this helps someone else.