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.
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.
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.
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-onsin the menu
- Search for
- 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.
Select the smart contract you downloaded, and before you submit, select just the master contract as in the screenshot below.
Enter the address
0xE68Ea71C936E86539A38BBB33134E39D3c5c8Aaf and click on
LINK ON ROPSTEN.
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
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.
Set groups as
DApp User and
Administrators and click on
GENERATE NEW KEY.
Copy the generated API key. Note that it will only be displayed once, and if you misplace it, you will need to regenerate it.
In your spreadsheet, go to
Add-ons > MultiBaas for Google Sheets > Set API Key.
Also you need a deployment ID as follows (in the red box) so copy an entire URL of MultiBaas from the browser address bar.
To set the deployment ID, follow similar steps as with the API key: go to
Add-ons > MultiBaas for Google Sheets > Set Deployment ID.
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.
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.