Hello there @nallich,
for creating path I would prepare file name and extension in Variable Expression node (the logic itself depends on the time you are running flow - before/during/after quarter has started but if function should do it) and then use Create File/Folder Variables node to combine it with location on Google Sheets.
Workflow design is shared here:
Br,
Ivan