Google Drive

This writer sends tables as CSV files into a single Google Drive account. It allows you to write entire tables as CSV files, or Google Sheets files. To write tables as partial modifications to an existing sheet, use the Google Sheets writer. Writing tables as CSV files is not bound by Google Sheet limits.

Configuration

Create a new configuration of the Google Drive writer. Then click Authorize Account to authorize the configuration. Then click the New Table button to add a new table:

Screenshot - Add Table Step 1

Select a table from Storage. You may also specify additional filters as well as incremental processing. All options may be modified later. Click Next to select how to load the table to Google Drive:

Screenshot - Add Table Step 2

When the Update file option is selected, the file name (specified in the next step) will be honored and the file will be overwritten with each run of the writer. When the Create new file option is selected, the creation time will be appended to the file name – e.g. cars (2019-01-06 17:46:22). Click Next to configure where the file should be stored:

Screenshot - Add Table Step 3

In the last step, you can select the folder and file name on Google Drive, where the table will be stored. When you select the Convert to Google Docs format option, the file will be saved as a Google Sheets table; otherwise it will be saved as a CSV file. Keep in mind that the Google Sheets format is subject to certain limits, If these are exceeded, the table load will fail.

When done, click the Save button to finish the table configuration. Configured tables are stored as configuration rows.