This writer sends tables as worksheets into a single Google Sheets account. It allows you to write tables into individual sheets of a spreadsheet document and append rows into an existing sheet. Be aware that Google sheets have strict limits on the size of the document. If you are getting close to them, use the Google Drive writer to avoid failed writes.
Find the Google Sheets 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 whether to create a new file or write to an existing one:
In the last step, you can select to which worksheet the data should be written and whether to append or overwrite worksheet rows. When worksheet rows are appended, the table header is written only when the worksheet is empty.
When done, click the Save Sheet 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.