Issue 1: Ensuring App Script Continuity and Email Deliverability
I have created a set of Google Forms integrated with Google Sheets and App Script to manage Health & Safety compliance activities for a client. The scripts send weekly and monthly reminders and follow-ups via email. Currently, I am using a free Gmail account (e.g. [email protected]) to run these scripts. I am concerned about the continuity of these services and the guaranteed deliverability of emails.
Can I/Should I upgrade this Gmail account to ensure that the App Script will continue to function without interruption? Or is having a developer account something else?
Is there a way to guarantee email deliverability, possibly by purchasing a domain name specifically for this project? note: not the clients actual domain
Issue 2: Google Account Requirement for Form Submission with File Uploads
The users filling out the forms need to upload files, which requires them to have a Google account. However, the organization uses Microsoft for their office suite and is reluctant to pay for 10 additional Google accounts solely for occasional form submissions.
Is there a solution that allows users to upload files without needing a Google account?
Can the file upload feature be enabled in a way that does not mandate a Google account? Each of the 10-or so users have signed up to a google account but because this is upto them to do some have mistakenly signed up to a Google Trial Workspace account not a Google web user account tied to any email address.
Context:
- The forms are filled out by about 10 users a handful times a month.
- Both head office staff and a third party have shared access to the Sheets for data visibility.
- the forms send standard receipts and add-on receipts to HQ
- The App Scripts use triggers to send a “fill in this form” email, and follow up on incomplete forms.
Or: Should I just use a completely different form solution like Airtable?
I just dont want to build this system out for another client and hit the some set of reliability issues in a few weeks.