Hello, I have read all your requirements carefully and I ensure you that we can automate whole process using Google apps script.
You will be able to send mails in bulk on single click.
I have more than 5 years of experience working with G-suite applications and successfully completed 300+ projects with G-sheet, Gmail, Google Docs , Forms, Drive and Google apps script.
Please let me know if we can discuss project details over a call/chat.
Hope to hear from you soon !!
Thanks,
Kishan
Complex Macros/Script Projects:
--> Amazon API,Sheets API, Gmail API,ParseHub API, IGMS API, Facebook API, Zoho API,Formstack , Trello API
--> Zendesk API, Zapier API, Shopify API, Mindbody API,Brid API, Twilio API and Many more .
--> Hospital Managment, Payroll Management, Online Shop, Task Automations.
Data Visualization
--> Google Data Studio/Google Sheets/Klipfolio