How To Fetch Data From Google Sheets with React and Tabletop.js

Render data from Google Spreadsheets with React and Tabletop.js

Trevor-Indrek Lasn
vowel magic

--

Google spreadsheets

Spreadsheets are popular since they act as a database that’s easy to modify for non-developers. Anyone with a laptop and internet connection can use spreadsheets and insert useful information.

As developers, we’re constantly searching for ways to improve our everyday workflow. Here’s a way to save time by fetching data straight from Google sheets with React and tabletop.js.

We’re going to use tabletop since it easily integrates with Google Spreadsheets. The library is used for getting JSON from a Google Spreadsheet without jumping through a thousand hoops.

Become a Medium Member to directly support my work. Thanks in advance!

Getting started

Step One: make a Google Spreadsheet and click “Publish to Web.”

Step Two: Install the tabletop library.

yarn add tabletop

Step Three: Write the React component that fetches the data from Google sheets.

--

--