I am trying to build an Alteryx workflow that uploads information to a specific google sheet. My workflow has two Google Sheets Output Tools that upload information to two different worksheets within a same google sheet.
In options, Existing File Action is set to "Overwrite"
However, every time I run the workflow, it deletes Alteryx - Employees worksheet and leaves Alteryx - Loads worksheet in the Google Sheet.
I am not sure why this is happening.
I am having a related issue with the Google Drive Output tool. I select the sheet I want to overwrite, set the action to Overwrite file, but when I run the workflow is overwrites all sheets and the Sheet Name parameter shows the name of the first sheet in the file. I am trying to write to a gsheet. The input tool works great but I can't seem to get this output tool to work. @Pardeep were you ever able to resolve your problem?
I am experiencing the same issue. Were you able to resolve it? Thanks!