Google Sheet reader

Fetch the given google sheet on configured Google Drive.

Pre-requisite: Install Google Drive application Profile > {Organization} > Applications to grant Zparse access.

Input

Trigger

An event that will trigger spreadsheet fetching.

Account—REQUIRED

Select configured Google Drive which contains your spreadsheet.

Spreadsheet ID—REQUIRED

Select configured Google Drive which contains your spreadsheet.

Example: Get spreadsheet id from the url.

Url: https://docs.google.com/spreadsheets/d/xxx-yyy-zzz/edit?gid=0#gid=0
ID : xxx-yyy-zzz

Google sheet

Loaded given spreadsheet.