@swiper/import-google-sheets v0.0.21

@swiper/import-google-sheets

Import your membership data from a Google Sheets spreadsheet.

Setup

In order to use this, you need to provide the spreadsheet id and an api key in the configuration file. Here is how you do that.

You will need to add a section to your config file that looks like this:

---
importer:
  package: "@swiper/import-google-sheets"
  spreadsheet_id: "<your-spreadsheet-id-goes-here>"
  api_key: "<your-api-key-goes-here>"

spreadsheet_id

To get the values you need to fill in the spreadsheet_id and the api_key, go to https://docs.google.com/spreadsheets and find your spreadsheet. Click on it to open it and once you can view it you'll find you are at a URL that looks like this:

https://docs.google.com/spreadsheets/d/gjds9g2j0sgjlsdkjgal2359sgsdg991351U2_usQ6oo/edit

That long string of random letters and numbers near the end is the spreadsheet id. Take everything between the /d/ and the /edit and add it to your config file in the spreadsheet_id field.

api_key

const demo = require('@swiper/demo');

// TODO: DEMONSTRATE API