Hi, did anyone get anywhere with this? I'm trying to do the same thing and found this thread via a google search. I can pull in information to google sheets very easily from any of my crypto brokers via a simple apps script but haven't found a single traditional broker that makes it easy...
It`s very easy to use, but the developers clearly didn`t finalize it. I was annoyed by its intrusiveness. As soon as you start manipulating the files on your computer, no matter if it`s a backup or something else, IB immediately stops functioning normally. All in all, I stopped working with Google Sheets, I couldn't link them either, so I was recommended a more simplified option, using a google docs and slides template, which has greatly simplified some aspects of my work.