How To Fetch Data From Google Sheets with React and Tabletop.js
Render data from Google Spreadsheets with React and Tabletop.js
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.