I am new in make.com.
Basically I am watching one google spreadsheet every 15 min interval of time, if new data is add in this sheet, this scenerio will trigger, and the second module is google drive search module, this module will search if today date google spreadsheet file (eg: 2024/09/02 is name of the spreadsheet) is present in the google drive or not, if not present then create one sheet with name will be today date (eg: 2024/09/02) and add the data into this file. forget about the last three google drive modules.
And if file is present then just add those data which is coming from the every 15 min.
Now when data change to 2024/09/03 which means next day, again it will check today date file is present or not, if not then it will create google spreadsheet file with today name and add a row will add the data which is coming from the very first module of google sheet and the it will go to search for files/folder it will search is there any previous day naming file is present with .csv extension if not then download the file 2024/09/02 google spreadsheet file and upload the previous spreadsheet file data into .csv file.
In simple words, Create every day new spread sheet and if data is coming in every 15 min then add this data in google spreadsheet and next day when again a new spreadsheet will create then I want the previous spread sheet data will be converted into csv file and upload to google drive. In this way whenever a new spreadsheet will create download previous spreadsheet data and convert into .csv file and upload the google drive.
if it is not possible, then just tell me how to download the google spread sheet data to csv , if sheet contain 100 rows, then I want all 100 rows and
