How to extract last sheet name from a google spreadsheet

Questions
,
1

:bullseye: What is your goal?

If my sheet last name of my google spreadsheet is not created (which should be the current month name or month number) I should create this new sheet with google sheets standard function to start working with a new month transactions

:thinking: What is the problem & what have you tried?

Exactly what I wrote in my topic

3

Are you using google sheet native function or Make native function? Sometime Make rejects different function input rather than its own function.

If you can share screenshot or more details, it would be easier to understand the actual prolem.

4

Hey Marcelo,

are the sheets named after months? You can use List Sheets, followed by an array aggregator, then an if/else module that checks if the resulting array contains this month. If it does, get the sheet with that name, if it doesn’t, create it.

5

Something to watch with the List Sheets and aggregator route: it takes an extra 3 modules just to answer the yes/no question.
An interesting way of doing it is to actually use error handlers to your benefit. Use the “Add a Row” module to name the sheet after the current month and then use an error handler on that module. When it throws an error because the sheet will not have existed yet, you can then add a sheet with the intended name and then return to the original action. No need for List Sheets or an aggregator or any router logic.

6

Hello,
Everything depends on whole workflow.

If there is no human interaction to create new sheet- you can create it only using automation- one minute after midnight of 1st day of the month create new sheet.

Then in your main workflow use error handler- if there is an error (sheet does not exist)- route it back or involve human in the loop to verify.

If sometimes sheet must be created by hand in advance- you must decide if sheet will always be named as month name “April, May…” or “1, 2, 3…” because it will make your life easier or add extra steps.

Lastly- if there is constant number of additional sheets, you can simply count number of sheets. For 4 tech sheets if you habve 6 sheets it means January and February are done.

Every approach has its pros and cons. Some are easier to implement but harder to scale, some will require extra steps but make you sure that data is validated and there is no possibility of duplication.

There is no perfect or the best solution.

Have a nice day,
Michal