davincilord / use-google-sheets

📝 A React Hook for getting data from Google Sheets API v4

useGoogleSheets

A React Hook wrapper library for google-sheets-mapper for getting data from Google Sheets API v4

---

Installation

Package can be added using yarn:

yarn add use-google-sheets

Or, use NPM:

npm install use-google-sheets

UMD build available on unpkg.

---

Usage

1. Go to Google Cloud Console to get API key for Google Sheets API.
2. Create a Google Sheet and add some data. See example sheet.
3. Share it with "Anyone with this link can view".
4. Get sheet id from url of the sheet.

https://docs.google.com/spreadsheets/d/[THIS-IS-THE-SHEET-ID]/

5. I suggest adding API key and sheet id to .env file

---

Examples

Get data from all sheets inside the spreadsheet

import useGoogleSheets from 'use-google-sheets';

const App = () => {
  const { data, loading, error } = useGoogleSheets({
    apiKey: process.env.REACT_APP_GOOGLE_API_KEY,
    sheetId: process.env.REACT_APP_GOOGLE_SHEETS_ID,
  });

  if (loading) {
    return <div>Loading...</div>;
  }

  if (error) {
    return <div>Error!</div>;
  }

  return <div>{JSON.stringify(data)}</div>;
};

Get data from specific sheets inside the spreadsheet

Don't use single quotes on sheet names, they will be removed because when using space in sheet name it will be returned wrapped with single quotes and plugin will remove them for clean string id.

import useGoogleSheets from 'use-google-sheets';

const App = () => {
  const { data, loading, error } = useGoogleSheets({
    apiKey: process.env.REACT_APP_GOOGLE_API_KEY,
    sheetId: process.env.REACT_APP_GOOGLE_SHEETS_ID,
    sheetsNames: ['Sheet1'],
  });

  if (loading) {
    return <div>Loading...</div>;
  }

  if (error) {
    return <div>Error!</div>;
  }

  return <div>{JSON.stringify(data)}</div>;
};

---

API Documentation

The useGoogleSheets hook takes an object with three properties:

Name	Value
apiKey	string
sheetId	string
sheetsNames	array

• apiKey is a Google Sheets API v4 key from Google Cloud Console.
• sheetId is the id of the sheet.
• sheetsNames is an array of specific sheet names. Can be left out then it will fallback to all sheets inside the spreadsheet.

Exposed Data

The hook produces an HookState object:

const { data, loading, error } = useGoogleSheets({ apiKey, sheetId });

Name	Value
data	array
loading	boolean
error	null or object

• data is an array of mapped data objects.

[
  {
    id: 'Sheet1',
    data: [
      { value: 'et', key: 'language' },
      { value: 'Test sheet', key: 'title' },
    ],
  },
];

• loading lets you know whether data is being fetched and mapped.
• error lets you know when there is something wrong. It returns an error object where you can get specific error properties from error.response

{
  status: '404',
  statusText: '',
  url: 'https://sheets.googleapis.com/v4/spreadsheets/...',
}