1. FAQs
  2. SAM Studio
  3. Getting Started with SAM Blockly

What is the Spreadsheets function on SAM Blockly?

The Spreadsheets function on SAM Blockly allows certain blocks to send or read data on a Google Sheet. This allows you to see or record a live reading from the sensors, such as recording the values of a Light Sensor. In addition, the Spreadsheets function allows you to send data to a block. For example, you can send speed data to a DC Motor block which will then use that data to determine how fast or slow to run the motor. 


To add a Google Spreadsheet, follow these steps:

  1. Click on the 'Devices' button in your SAM Blockly workspace. Screenshot 2021-02-22 at 14.08.45
  2. Scroll down and select 'Spreadsheet.' It will appear on the left side of your workspace under 'DISCONNECTED DEVICES.' Under the Spreadsheet, click 'Add Spreadsheet'Screenshot 2021-02-24 at 16.37.01
  3. Click on 'New Spreadsheet' or 'Existing Spreadsheet,' if you select 'New Spreadsheet', name your spreadsheet and click 'Submit' 
    Screenshot 2021-02-24 at 16.42.03
  4. Your spreadsheet will now appear under 'CONNECTED BLOCKS' and is ready to be opened! 
    Screenshot 2021-02-24 at 16.46.47

Note: If your Google Account is not connected to your SAM Studio, you will first be taken to your Google Account login to connect your account