How to Submit Form Data to Google Sheets and Brevo With Next.js + Google Apps Script

Let's say you are building a form for a client or a project. Submissions need to go somewhere the whole team can access, not a database only you can query, not an admin panel only a developer can navi