Extension—Google Sheets

With the Google Sheets extension, you can enter data to a Google sheet through mBlock 5 or obtain data from Google sheets.

Note: This extension can be used only in regions where Google services are available.

Sign in to Google Sheets

Visit Google Sheets https://docs.google.com/spreadsheets and sign in with a Google account.


Create a sheet

1. Click + to create a sheet.


2. Name the sheet My Favorite Fruits.


3. Click Share to set the sharing.


4. Set Anyone on the internet with the link can edit, and click Copy link. Then click Done to save the settings.


Add the Google Sheets extension

1. Click the Sprites tab and click + extension at the bottom of the Blocks area.


2. On the Extension center page that appears, click + Add at the bottom of Google Sheets.


After being added, the extension and its blocks are displayed in the Blocks area.


Use the Google Sheets blocks

1. Drag the Events block when (space) key pressed and Google Sheets block connect to shared sheet ( ) to the Scripts area, and paste the link of the created sheet.


2. Drag the Google Sheets block input ( ) to column ( ) row ( ) to the Scripts area twice. Enter Apple in row 1 of column 1, and Mango in row 2.


3. Press the space key to execute the script and see whether the data is entered into the sheet.


Was this article helpful?
3 out of 3 found this helpful



Please sign in to leave a comment.