Geckoboard automatically interprets pivot tables from your Excel spreadsheets. For Google Sheets, you can retrieve pivot table data by using ImportRange to reproduce the pivot table in a new sheet.
- Add a new sheet to the Google Sheet that contains the pivot table. For reference, see our example.
- Use ImportRange on this new sheet to reproduce the pivot table. For this, you'd type
range_stringis the entire range of your pivot table, in cell
A1. This will import all the data in your pivot table.
- Now when you connect this Google Sheet to Geckoboard you can use this new sheet to start building visualizations from the data.
Using Spreadsheets as part of your free Geckoboard account? Unlock all our data sources when you try Pro for free.