Google Sheets append/update node confusion

Hi,

Just using the Google Sheets Writer, Updater and Appender. While I can get them working individually, I can’t wrap my head around how to deal with the concept of writing, appending, updating to the same sheet.

In my example I want to be able to run a workflow that will either export the data to a new sheet if the sheet name doesn’t exist - Appender - or overwrite and update if the sheet does exist - Updater. My intention is to dynamically create the sheet name (e.g. based on month names) that will be able to be automated, but I want to be able to “force” update an existing sheet if necessary (e.g. if I add a new column, and want to update historically).

Does anyone have a solution? I am quite new to knime, so use small words and speak slowly 🙂

Thanks,

Jarrod