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: n8n.cloud
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:
