Sunset Supreme

A Google sheets plugin for MultiBaas (a REST API for Ethereum) to allow display, interaction, and analysis of data on the blockchain.

Demo Video Live Demo Source Code

Description

We created a JavaScript plugin for Google Sheets that seamlessly connects with our product MultiBaas. MultiBaas is a software platform that allows for users to interact with Ethereum and OmiseGO networks via a REST API. The purpose of this platform is to make simple for traditional software developers to build on top of the blockchain. Our Google sheets plugin allows for users to pull blockchain data directly into a spreadsheet. For example, you may read events from an arbitrary smart contract and quickly transform and visualize the data. Or, you may sign and submit a transaction directly from Google sheets, which opens the door for blockchain-based accounting.

How It's Made

We built the plugin using JavaScript running in Google's Script Editor. To integrate with Google Sheet's API, we used Google's clasp framework. This allows for API calls to be made to MultiBaas from Sheets by setting a cell's value to a function call, eg: `=mbquery(...)`. Additionally, this framework allows for the JSON responses from MultiBaas to be translated into spreadsheet data (rows and columns).

Team

Dan Briskin Jeff Wentworth Daenam Kim Noboru Nakahara Dadi Zhang
← click here to see all projects