Is it possible to get the SpreadSheet name and the sheet name?

I am looking for a way to get the name and sheet name of a SpreadSheet.
Is it possible to retrieve them?

What we are trying to do is create a spreadsheet for each month and then a sheet in that spreadsheet for each day.

  • **Running n8n via:

I am afraid the Google Sheets node would not currently read the name of a sheet/spreadsheet (which is also why you’d need to provide the Spreadsheet ID manually when reading a file).

That said, creating spreadsheets with specific names and sheets therein should work fine. Assuming you are using a recent version of n8n (including the Luxon library), this workflow would do the job:

After running it, you’d have one Spreadsheet named after the current month and one sheet for each day of the month: