Google Spreadsheets

Design custom dashboards with data from Google Spreadsheets

Numerics lets you easily display custom data from your Google Spreadsheets.

Once you’ve chosen the type of widget you want to add to your dashboard for Google Spreadsheets, you will first need to connect your account. The account connecting process is standard for Google Spreadsheets, you can see more info about connecting an account here. Once the account is added / chosen, the Spreadsheets and Worksheets accessible by the account get populated automatically. Please choose the appropriate spreadsheet and worksheet that you would like to bring in numbers from. Sometimes, if you’ve added an account earlier, the spreadsheets & worksheets might require to be refreshed to fetch any new sheets that might have been added since.

Next is the Spreadsheet Data Range. The data range is different for each widget depending on its type and has to be defined as the Numerics Widget Data Specification. Below, each of the types of widgets are listed along with examples of data ranges that are compatible with the Numerics Widget Data Specification.

Google Spreadsheets Custom Count

For the range, specify a 1 column by 2 row range. The first row cell must contain a number value and is displayed as the main number tally. The second row cell is displayed as a postfix (units) for the main number displayed and can be any value including date or text. Providing a single row cell value will display the number without any postfix.

For example, if the first column of your spreadsheet looks like this:

| 500 |
| USD |

Adding a range of A1:A2, will display 500 USD on your dashboard.

Google Spreadsheets Custom Label

For the range, specify a 1 column by 2 row range. The first row cell must contain a text value and is displayed as the main text label. The second row will be displayed as a postfix (units) below the custom text label and can be any value including date or text. Providing a single row cell value will display the custom text label without any postfix.

For example, if the first column of your spreadsheet looks like this:

| Sales Conference |
| 5th October |

Adding a range A1:A2, will display Sales Conference, 5th October on your dashboard.

Google Spreadsheets Custom Count and Change

For the range, specify a 1 column by 3 row range. The first row and the second row cells must contain number values. The first cell value is displayed as the main number tally. Below this, the widget will automatically calculate and display the percentage difference from the values of the two cells. The value of the third row cell is displayed as a postfix (units) for the number tally and can be any value including date or text. The first and second row cell values are required, the third row cell displayed is optional.

For example, if the first column of your spreadsheet looks like this:

| 100 |
| 75 |
| Thousand |

Adding a range A1:A3, will display the value 100 Thousand with a percentage change of +33%.

Google Spreadsheets Custom Line Graph

For the range, specify a 2 column by ‘n’ rows range (Max 31). The first column must contain number values that are used as y-axis values to plot your custom line graph. The first value from the second column forms the postfix or units for all the values presented on the line graph and can be any value including date or text. The first column values are required, the second column is optional.

For example, if your spreadsheet looks like this:

| 100 | USD |
| 200 |
| 300 |
| 400 |
| 500 |

To plot your these values on a line graph, add a range A1:B5.

Google Spreadsheets Custom Named Line Graph

For the range, specify a 3 column x ‘n’ rows range (Max 31). The values of the first column will form the names of the items plotted on the x-axis. The second column must contain number values that are used as y-axis values against each item of the x-axis to plot your custom line graph. The first value from the third column forms the postfix or units for all the values presented on the line graph and can be any value including date or text. The first and second column values are required, the third column is optional.

For example, if your spreadsheet looks like this:

| Dec | 100 | USD |
| Jan | 200 |
| Feb | 300 |
| Mar | 400 |

Adding a range for A1:C4, will plot your monthly numbers on a line graph with the currency as the units.

Google Spreadsheets Custom Pie Chart

For the range, specify a 2 column by ‘n’ rows range. The first column must have the names for which the values are provided and can be any format including text, while the second column must have number values that are used to form the slices of the pie. The pie chart automatically calculates the percentage value of each part of the pie, takes the top 5 values to draw 5 slices of the pie. If there are more than 5 values the remaining values are added up to create the 6th slice named ‘Other’.

For example, if your spreadsheet looks like this:

| Jake | 450 |
| Jude | 100 |
| Alan | 150 |
| Rick | 200 |
| Jane | 650 |
| Rose | 200 |
| Peter | 220 |

Adding a range of A1:B7, will display a pie of the total values broken down by the names of the people. The slices for ‘Jude’ and ‘Alan’ would be added up into one slice called other.

Google Spreadsheets Custom Toplist Funnel Chart

For the range, specify a 2 column by ‘n’ rows range. The first column must have the names for which the values are provided and can be any format including text, while the second column must have number values that are used to form the funnel chart. Additionally, the first row of both the columns must have the heading titles for the two sides of the top list. The Top List Funnel chart will automatically sort and pick up the top 5 items from your custom data and draw a funnel chart.

For example, if your spreadsheet looks like this:

| Countries | Sales |
| USA | 450 |
| UK | 100 |
| India | 150 |
| China | 20 |
| Russia | 10 |
| Brazil | 90 |

Adding a range of A1:B7, will display an ordered list of the top 5 countries by sales. The value of ‘Russia’ will be ignored.

Google Spreadsheets Custom Hour Density Chart

The widget displays a 24 hour clock starting at 00 and broken into 24 equal slices, with each slice of the pie representing an hour. Hours with the highest values are the brightest, while hours with lower values are incrementally more transparent and closer to the background color of the widget. For the range, specify a 2 column by ‘n’ rows range (max 24). The first column must list the 24 hours of the day and must be a number value between 0 and 24, while the second column must have number values that indicate the value of each hour.

For example, if your spreadsheet looks like this:

| 0 | 600 |
| 1 | 100 |
| 2 | 300 |

| 23 | 800 |
| 24 | 50 |

Adding a range of A1:B24, considering the second column is a count of visitors, the widget will display the density map of visitors across the day.

Google Spreadsheets Custom Day Density Chart

The widget displays the calendar days of the month, with each block representing a day. Days with the highest values are the brightest, while days with lower values are incrementally more transparent and closer to the background color of the widget. For the range, specify a 2 column by ‘n’ rows range. The first column must list the days of a single month, and must be in date format. The second column must have corresponding number values that indicate the value of each day.

For example, if your spreadsheet looks like this:

| 1/1/2014 | 400 |
| 1/2/2014 | 700 |
| 1/3/2014 | 1001 |

| 1/31/2014 | 600 |

Adding a range of A1:B31, will display the density of sales over the days of the month.