Google Sheets plugin

The Google Sheets plugin lets you point a data source at any Google Sheets document that the connected Google account can read.

Setup

Admin level (org config):

• Open Admin → Plugins → Google Sheets.
• Click Connect and authorize the Google account you want to use.
• Save.

Editor level (per data source):

• Create a data source of type Google Sheets.
• Enter or paste the sheet's URL.
• Pick a tab (worksheet) within the sheet.
• Pick the header row (usually row 1).
• Save.

Refresh

• Default: every 5 minutes.
• Manual: Refresh now on the source.

Tips

• Share the sheet with the Google account that was connected — the plugin cannot read sheets the account has no access to.
• Keep the header row stable. Mappings reference columns by header name.
• Use Google Sheets formulas for cleanup (trim whitespace, format dates) rather than post-processing in a mapping — it is easier to debug at the source.

Permissions

The plugin has read-only access; it cannot modify the sheet.