Currently, Geckoboard isn't able to retrieve pivot table data from a Google Sheet without using ImportRange to reproduce the pivot table in a new sheet. Please check our guide on how to work around this.