LB Google Sheet Data ·

A plugin to get Google Sheet data on Lioran Board

How to Install

• ❗❗❗ Download this file.
• Move it to your LioranBoard extension folder.
• Start your LioranBoard receiver.
• Click on Install Extension.
• Select Google Sheet Data and your tsl_transmitter.
• Done 🎉

Requirements

To use this extension, you need a Google API key. To generate it go to this link, click on Enable the Google Sheets API.

On the modal set any name (you can use Lioran Board for reference) and click in Next.

Close the modal after it's done and click on Create API key.

Input the same name that you used before (Lioran Board, for reference) and copy the value that will appear on the modal.

If you lost your key somehow, you can get it on this link and click on this icon:

To use this extension, you need to change your Google Sheet from Restricted to

Parameters

This extension follows this api documentation:

• api_key: your google API Key.
• sheet_id: your google sheet id (without /).
  • You can get it on your Google Sheet url:
• range: a range of your google sheet cells.
• dimension: possible values are ROWS or COLUMNS.
• render: possible values are FORMATTED_VALUE, UNFORMATTED_VALUE and FORMULA.
• row_number: which row or column you are getting the data.

All those data are sent to a stack called SheetValuesStack on LioranBoard.

Demo

On this spreadsheet, this button

will produce this result