SheetsSheets
SheetsCertified

Tasks that read, write, create, delete, and watch Google Sheets.

Provide Sheets/Drive scopes, spreadsheet IDs, ranges, and optional value/input options to read or load data, create or delete spreadsheets, and use the sheet modification trigger to launch flows on updates.

How to use this plugin

Authentication

All tasks must be authenticated for the Google Cloud Platform. You can do it in multiple ways:

  • By setting the task serviceAccount property that must contain the service account JSON content. It can be handy to set this property globally by using plugin defaults.
  • By setting the GOOGLE_APPLICATION_CREDENTIALS environment variable on the server running Kestra. It must point to an application credentials file. Warning: It must be the same on all worker nodes and can cause some security concerns.

Create automations with Googleworkspace Sheets