Mage supports writing/reading from Google Sheets using the Google Sheets API via the gspread library. Read on to learn about reading/writing data to Sheets.
io_config.yaml
.default
(you can
have multiple profiles, add it under whichever is relevant to you)GOOGLE_SERVICE_ACC_KEY
or the
value for key GOOGLE_SERVICE_ACC_KEY_FILEPATH
(both are not simultaneously
required. If you use GOOGLE_SERVICE_ACC_KEY_FILEPATH
, please delete GOOGLE_SERVICE_ACC_KEY
in the io_config.yaml
).