Skip to main content

Google Sheet writer

Write the given google sheet on configured Google Drive.

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

Input​

Google Sheetrequired

Google sheet data you want to write, as a JSON value or a file containing JSON.

Parameters​

Accountrequired

Select configured Google Drive which contains your spreadsheet.

Spreadsheetrequired

Pick the spreadsheet to write to directly from the selected Google Drive account. The picker lists the spreadsheets available on that Drive — no need to extract an ID from the spreadsheet URL. Selecting a different account resets the selection.

Value input optionrequired

Wether to interpret formula or not.

  • Raw: will not interpret formula
  • User entered: will interpret formula

Output​

This function is terminal: it has no output connectors. The workflow branch ends after the data is written to the spreadsheet.