All Collections
Connect your spreadsheets
Pull in data from Google Sheets and Excel spreadsheets.
57 articles
Prepare your spreadsheet for connecting to Geckoboard
Import data into your spreadsheet before connecting to Geckoboard
Use ImportRange to extract data needed for Geckoboard to a new spreadsheet
Calculate spreadsheet data before connecting to Geckoboard
Calculate number of unique values in a spreadsheet column
Aggregate Google Adwords and AdSense data in Geckoboard
Why we don't support calculations or aggregated data using Spreadsheets
Set refresh rate for Spreadsheets widgets powered by import functions
Automatically refresh your Google Sheets data daily with Supermetrics
Use IFERROR/ISBLANK to avoid "No data to visualize" in Google Sheets
Get help with your spreadsheet data
Connect your Google Sheet to Geckoboard
Connect your Excel spreadsheet from Google Drive
Connect your Excel spreadsheet from Dropbox
Connect your Excel file from OneDrive
Connect your Excel spreadsheet from SharePoint
Create share links for connecting single spreadsheet files to Geckoboard
Connect your Excel spreadsheet stored on a local machine
Make your connected Google Sheet private
Send Data from Google Sheets using Datasets to calculate metrics and build visuals
Grant admin consent to connect OneDrive or SharePoint to Geckoboard
Customize spreadsheets widgets
Create gauge widgets from spreadsheets
Create line chart widgets from spreadsheets
Create number widgets from spreadsheets
Create column chart widgets from spreadsheets
Create bar chart widgets from spreadsheets
Create leaderboard widgets from spreadsheets
Create table widgets from spreadsheets
Create text widgets from spreadsheets
Create dynamic spreadsheet widgets
Compare two numbers in your spreadsheet
Display data from pivot tables in Geckoboard
Create multiple series charts using spreadsheets
Add goals to track progress on your spreadsheet data
Highlight important changes to your spreadsheet data
Create a event countdown Number widget
Add milestones to a table widget
Highlight table widget cells in spreadsheets using Emoji
Use Google Forms to collect information and display it on a dashboard
Display a 'quote of the day' text widget using spreadsheets
How to build visualizations from data dumps
Refresh rate for Spreadsheets widgets
Manually refresh Spreadsheets widgets
Use ImportData to display online data in Geckoboard
Use Google Sheets’ ImportHTML function to display data in Geckoboard
Use GoogleFinance to display market data in Geckoboard
Create a weather widget using Google Sheets
Import Looker data into Geckoboard using Google Sheets
Display Google Calendar events on your dashboard via Google Sheets
Excel spreadsheet file not showing in Geckoboard
Spreadsheet FetchError: 'Could not find spreadsheet file'
Spreadsheets error: 'Error fetching the list of spreadsheets'
Spreadsheet import error: 'File too large'
Connected Excel spreadsheet not updating after making changes
Deleted spreadsheet on Google Drive still powering widgets
Spreadsheets error: 'Cannot read property "offsetWidth" of undefined'