Hello,
I read about your project. I understand the issue. You need to use batch operations and minimize calls to other services. If you are are using getValue function, you need to convert it to an array. Please share your script so I can help you improve the performance of your script.
Hello, I am a Consultant with one of the most reputed Edtech companies in India. I have created many Mail merge(Rich text and HTML/CSS) Email triggers for Parents, team members, and Students ( Monthly reports, Payslips, GMail Draft Mail Merge, and Docx Mail Merge) through a spreadsheet data. I have experience in UUID Version 4 for creating unique IDs for customers to trigger journeys through services like Webengage and Freshworks. I will share my repository of projects undertaken.
Technical Experience --
I am an App script expert. I have worked on many different projects on Google Sheets. I have also created chatbots and virtual assistants. I have been working on Sheets, database, App script for 6 years now, I have undertaken projects with different APIs, combined all Google services (Forms, studio, PostgreSQL, Calenders, analytics, map API, sites, etc)and several other consumer services like Freshdesk, WebEngage, Infobip, WordPress. I also have a repository in Github and more appropriately I have been guiding interns for the past year.
Shruti