Looking for someone who could integrate and automate process between Google sheets and drive folders, create customized workflows that could automatically initiate at a specific time, that is triggered by time. Mostly you'll have to use scripts.
So, there are 2 tasks we want to achieve.
First is... We want some kind of automation which can remove duplicates, But that's not just after comparing 1 column. Multiple columns should be compared and then if things match up the oldest row should be retained and other(s) should be deleted. Along with each row, there's a folder(at a path defined by two columns of each row) in our Google drive containing relevant documents and images which too must be deleted at the same time... So if a row is deleted from the sheet(manually or by automation or by any 3rd party app), its relevant folder must also be deleted automatically.
Second.. We want to put a workflow in place which shall schedule custom SMS(recommend us a good and affordable SMS service for SMS within India) for each new row which is being added. The data is not directly entered into the sheets. A form is linked to the sheet which inserts the data entered into the forms onto the sheet.
Also.. I would like to add that the SMS is supposed to be 2 way. If the recipient of the message doesn't respond I should get a list of such recipients on daily basis. And if they respond. Let's say "Y" there will be a column of the sheet updated and if they respond "N" once again that particular data along with the relevant folder should be deleted
Further, whenever the date is updated that is after receiving SMS response or manual update once again an SMS is to be scheduled for the 7th day with similar response actions
You may also check out this video where I have explained my requirements.
[url removed, login to view]
I was confused while making the video... it's column E, F, H & I which should match up.
Sorry for the inconvenience
Only offer if you think you can do the above?