Right now I am listing all my callrail calls in a google spreadsheet. Right now they map to a sheet called January 2026. When February arrives, is there a way to automatically update the sheet the workflow is active in?
Right now I have it set to:
{{ new Date().toLocaleDateString(‘en-US’, { month: ‘long’, year: ‘numeric’ }) }}
But this doesn’t work because it requires a list, URL, or ID.
@ryanslabroom You cannot directly use an expression for sheet name in the dropdown, so generate the current month-year string in a prior node (like a Code node or a Date/Time node) and feed that into the “Sheet Name (By Name)” expression of the Google Sheets node.
hello @ryanslabroom,
You can use an expression with a name without any issues if you’re referring to a sheet inside the spreadsheet:
If you mean the spreadsheet itself, you can connect Google Drive, extract the required sheet URL or ID with your condition, and pass that as an expression.
