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.

Create New Configuration

Find the Google Drive writer in the list of writers and create a new configuration. Name it.

Screenshot - Create configuration

As the next step, click the Authorize Account button. Select one of the two authorization methods:

Screenshot - Authorize account

  • Instant – Use this if you have access to the Google Drive account; the authorization will be done immediately.
  • External – If you need to authorize access to the service from someone who does not have an account in KBC, you can generate an external link, which will guide them through this process.

Configure Tables

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. The table is added to the configuration:

Screenshot - Table List

You can add other tables, or run (write to Google Drive) the individual tables or the entire configuration. The configuration can write as many tables as you wish. The list is fully searchable, and you can delete or disable each table. In addition, you can explicitly write one table only.