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.
Find the Google Drive writer in the list of writers and create a new configuration. Name it.
As the next step, click the Authorize Account button. Select one of the two authorization methods:
Click the New Table button to add a new table:
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:
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:
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:
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.