Hi, my goal is to create a new Google Sheets File have the file name “TestFile_Q1_2025” for every quarter in a google drive folder. The file name changes based on the quarter and the year. How do I achieve this using Knime?
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
1 Like