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.
You'll need to use ImportRange to reproduce the pivot table in a new sheet.
Updated over a week ago