Prepare your spreadsheet
Parepare your spreadsheet for Geckoboard by importing data to it, formatting it, performing calculations and reducing errors.
8 articles
Prepare your spreadsheet for connecting to Geckoboard
Use import functions to get data into a spreadsheet
Use ImportRange to extract data needed for Geckoboard to a new spreadsheet
Calculate spreadsheet data before connecting to Geckoboard
Calculate the number of unique values in a spreadsheet column
Aggregate Google Adwords and AdSense data in Google Sheets
Set refresh rate for Spreadsheets widgets powered by import functions
Use IFERROR/ISBLANK to avoid "No data to visualize" in Google Sheets