Sheetex

For when you just want to fetch some rows from a Google Sheet in Elixir.

In order to use this package, you need a valid API key or OAuth token that will be passed to the Google Sheets API: https://developers.google.com/workspace/guides/create-credentials.

See documentation: https://hexdocs.pm/sheetex.

Installation

The package can be installed by adding sheetex to your list of dependencies in mix.exs:

def deps do
  [
    {:sheetex, "~> 0.5.0"}
  ]
end

Testing

Before running mix test, you need to create an .env.testing file and add the GOOGLE_SHEETS_API_KEY variable.