Google Drive Tool: Create new date tab based on field

[rm1390]

Hi,

I've been trying to output to a Google sheet by using the Google Drive tool but it won't perform the action that we require.

I'm looking to run a Workflow at the start of every month and I want a new tab to be created on the Google Sheet with the corresponding date, e.g. 01/01/2023, 01/02/2023, etc.. I have created a new field called 'date' (giving the current date) which is the selected data range. 

I've tried the various settings on the 'Configure File' tab but it either creates a new file or overwrites the tab.

We used to be able able to do this with the deprecated Google Sheets tool.

Thanks in advance,

Rob

[DavidTeter]

I am having this same issue. 

[apathetichell]

you can do this in a batch macro. you need an action tool to update the specific tab you are writing to in the gsheet. it's not particularly intuitive.