Converting Sheets to CSV

This task will convert a Google Sheet into a CSV file.

Settings

Google Workspace Connection

Required
The Google Workspace connection to use. See the Connecting to Google Workspace article if you require more information on how to create/manage connections.

Range

Required
Specify the sheet name and/or range of cells to export, using either A1 or R1C1 notation. E.g. Sheet1!A1:B2. Defaults to Sheet1, which will select all data from the worksheet called 'Sheet1'.

Spreadsheet ID

Required
The ID of the spreadsheet to export. This can be found in the URL of the spreadsheet.

Output File

Required
The file to write the data from the spreadsheet to.

Separator

Required
The character to use as the separator in the CSV file. This would usually be a comma , or pipe | character. The default is a comma.

The task will automatically surround any values that contain the separator character or line breaks with double quotes. Any values that contain a double quote will be automatically escaped.

Zynk Settings

See Common Task Settings

Examples

Sample output file:

SKU,Name,NominalCode,Note
20000,Large Red T-Shirt,4000,"For pricing, check online"
20001,Small Blue Hoodie,4001,