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.

1596706028667-f516fd74-1653-4912-9f9d-5bad37ff7227.png

Create a sheet

1. Click + to create a sheet.

1596706029359-4ac558db-777b-4361-8caa-5fc6c0d121d8.png

2. Name the sheet My Favorite Fruits.

image.png

3. Click Share to set the sharing.

$57WYK$]GY8F1L)JRM{YKX1.png

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

%5CAP4L86_~`~[M{ZG75G_D.png

Add the Google Sheets extension

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

1596678324368-09d85f7e-60ff-4c06-b35c-189b1765b5bc.png

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

1596706349331-fa84b5a7-0a7e-45b0-8e67-668f6524344c.png

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

1596706412527-e3c88a77-cee0-443b-99b4-d226b014e6f9.png

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.

12.gif

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.

H~DCK)@2LNU%WK88P01V5LO.png

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

7N5773$)7R5N13O(EGZ5`YQ.png

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

Comments

0 comments

Please sign in to leave a comment.