Configuration
To configure Google Sheets with Mage, you’ll need to enable several APIs in your GCP project and add credentials to Mage.Enable relevant APIs
Using Google Sheets in Mage requires the following to be enabled via GCP:- Google Drive API
- Google Sheets API
Add credentials
Adding credentials for Sheets is the same as adding credentials for other Google services, i.e. BigQuery, GCP. Before you begin, you’ll need to create a service account key. Please read Google Cloud’s documentation on how to create that. Once your finished, following these steps:- Create a new pipeline or open an existing pipeline.
- Expand the left side of your screen to view the file browser.
- Scroll down and click on a file named
io_config.yaml
. - Enter the following keys and values under the key named
default
(you can have multiple profiles, add it under whichever is relevant to you) - Note: you only need to add the keys under
GOOGLE_SERVICE_ACC_KEY
or the value for keyGOOGLE_SERVICE_ACC_KEY_FILEPATH
(both are not simultaneously required. If you useGOOGLE_SERVICE_ACC_KEY_FILEPATH
, please deleteGOOGLE_SERVICE_ACC_KEY
in theio_config.yaml
).