Hi,
I have been gone through with your project description and found that you want Google Sheet Automation by comparing value from Spreadsheet.
Problem:
1. You want to identify duplicate spreadsheet based on cell value in spreadsheet.
2. You want to create new folder and it's name will be based on another spreadsheet cell value.
3. You want to share sheet to email by comparing value in cell.
Proposed Solutions:
Google Apps Script
VBA
Well almost you problem is clear, but there are few queries, better if we discuss you problem would get more clarity.
I have over 5+ years of experience in VBA, .Net platform using C# language with knowledge in different domain like Realtime, Database, IoT, Web development.
I have good Analytical and Communication skill with design of cost effective and robust applied solution.
You can test my work and then we will go for actual task, you project success is guaranteed with me.
Let's talk further on chatbox, waiting for your reply.
Thanks for Attention !!!
Veerendra