I need a couple Google scripts to integrate workflow among Google Drive/Sheets/Forms.
1. GOOGLE DRIVE -> GOOGLE DRIVE
Drive link: [url removed, login to view]
When a new folder is added to 'Campaigns' folder, identify any existing folder inside folder 'Archive - Recurring Events' that RESEMBLES the folder just added to 'Campaigns' (i.e. the two folder titles contain an identical string of at least two words AND the two folder titles contain a date that falls within one month) and merge the contents of this existing folder with the new folder just added to 'Campaigns'. Add a subfolder to the newly merged folder and entitle it according to the current calendar year (i.e. '2017'). Finally, add a fixed template series of subfolders to the folder entitled according to the current calendar year.
2. GOOGLE SHEETS / FORMS -> GOOGLE SHEETS
Form link: [url removed, login to view]
Sheet link: [url removed, login to view]
When Form receives date/name data in Columns I and W that RESEMBLES data in Columns E and D in Sheet (i.e. when 'EVENT TITLE' contains an identical string of at least two words AND when 'SHORT START DATE' falls within one month), select the Sheet row and replace data in columns G and L of the Sheet with 'Yes' and 'Pending Review', respectively.