MultiBaas for Google Sheets Released

October 20, 2020 · Daenam Kim

MultiBaas for Google Sheets Head Photo by Samuele Errico Piccarini on Unsplash

We are pleased to announce the release of MultiBaas for Google Sheets, an add-on that provides custom spreadsheet functions to interact with the blockchain via MultiBaas.

Why spreadsheets?

Building on the blockchain has typically required both computer programming skills, and in-depth blockchain knowledge. By offering a spreadsheet plugin, we're making the blockchain accessible to the close to 1 billion spreadsheet users.

Spreadsheet Users

Sources: Blockchain Engineers, Software Engineers, Spreadsheet Users

MultiBaas for Google Sheets is explained in the system diagram below. It is an Add-on and acts as a small middleware in between Google Sheets and MultiBaas to work with the blockchain that can be easily installed from the Google Workspace Marketplace.

System Diagram

Requirements

Before using this add-on you must:

  • Setup a new MultiBaas deployment if you do not already have one
  • Go to Google Sheets
  • Create a new spreadsheet
  • Go to Add-ons > Get add-ons in the menu
  • Search for multibaas
  • Install and approve permissions.

You can also watch this video which walks through the above steps.

Now you need to configure your MultiBaas deployment and spreadsheet add-on to work together.

Upload and link a smart contract on the Ropsten public Ethereum test network

You can download a test smart contract here.

Login to your MultiBaas deployment, and navigate to the smart contract upload page.

Config 0

Config 1

Config 2

Select the smart contract you downloaded, and before you submit, select just the master contract as in the screenshot below.

Config 3

Config 4

Select the LINK tab to link to the actual contract deployed on the blockchain with the ABI of the uploaded contract. We are using this contract on Ropsten for this demo.

Config 5

Enter the address 0xE68Ea71C936E86539A38BBB33134E39D3c5c8Aaf and click on LINK ON ROPSTEN.

Config 6

Config 7

Navigate to the linked contract and note the incoming events on the contract. It may take a few minutes for the events to complete their initial synchronization

Config 8

Configure API key and Deployment ID in Google Sheets

In order to access MultiBaas API from the add-on you need to create a new MultiBaas API key or use one that you have already created.

Config 9

Set groups as DApp User and Administrators and click on GENERATE NEW KEY.

Config 10

Copy the generated API key. Note that it will only be displayed once, and if you misplace it, you will need to regenerate it.

Config 11

In your spreadsheet, go to Add-ons > MultiBaas for Google Sheets > Set API Key.

Config 12

Config 13

Config 14

Also you need a deployment ID as follows (in the red box) so copy an entire URL of MultiBaas from the browser address bar.

Config 15

To set the deployment ID, follow similar steps as with the API key: go to Add-ons > MultiBaas for Google Sheets > Set Deployment ID.

Config 16

Retrieve data from the Ethereum blockchain

Try entering either =MBEVENTS("adminupgradeabilityproxy", 100, 0) or =MBEVENTS("0xE68Ea71C936E86539A38BBB33134E39D3c5c8Aaf", 100, 0) in the cell to retrieve events from the Ethereum blockchain. When you linked the smart contract to an address in MultiBaas, it created the alias adminupgradeabilityproxy for address 0xE68Ea71C936E86539A38BBB33134E39D3c5c8Aaf, and either is valid.

Config 18

Config 19

This is only the beginning! Anything you can do in a spreadsheet can now be used with the blockchain: charts, comparing one smart contract's data to another, even signing transactions using the Hardware Security Module (HSM) functionality integrated into MultiBaas.

We'd love to learn more about what you're building! Get in touch with us any time with questions, comments, or feedback.

You can also check out what we have done using the spreadsheet add-on from our HackMoney 2020 and HackMoney 2020 Finale.