In this walkthrough, we'll show you how to use our Spreadsheets data source to display a daily inspirational quote on your dashboard. To do this, we'll be using They Said So, which offers API access to its quotes platform.

Widget displaying a daily inspiration quote
  1. To begin, load our prepared Google sheet that has used ImportXML to fetch the quote and its author.

  2. Make your own copy of the spreadsheet using File > Make a copy.

  3. From the ImportXML URLs in cells B1 and B2 you can see we've chosen the inspire quote category, but this can be changed to management or life quotes etc.

  4. Switch to Geckoboard. Click Add widget in the top right of your dashboard.

  5. You'll see a scrollable list of data sources. Click Google Sheets.

  6. From the Choose File menu, search for, and select, the spreadsheet you want to connect to Geckoboard.

    Choose your Google Sheet from your Google Drive
  7. With your spreadsheet connected, click to select the concatenated cell B3. Click Create visualization.

    Select cell b3 from the connected spreadsheet
  8. From the the visualization options, click on the highlighted Text icon.

  9. On the next screen you'll see a preview of your widget. Click Add to dashboard to return to your dashboard.

  10. Finally, hover over your new widget and add a title like "Quote of the day" by clicking Add a title.

Did this answer your question?