I would like an MVP built that uses Google Sheets as a database and sends automatic summary emails to users based on their details.
This will need to be done twice - I need two input forms - one for organisations and one for individuals.
There will be two sheets needed:
One with user details (first name, last name, individual/organisation, email, free/paid, mobile type, computer type)
One with alert details (products and service names across the columns, and dates down the side)
I then need a script to be run daily that sends an email to each user with the information from the cells that match their preferences in certain columns to the products and services names. They should only receive new information added in the past 24 hours.
users will fill in a form (that they can also update their details with)
Admin (me can edit all details as well as be the only one to create items in alert details).
There needs to be a page that users can call info (search and filter) from the alert sheet.
*note - I can easily edit the content etc but I just need help with scripting and integrations. I figure this will be google sheets with integration to send email - google forms to add/update details - and some sort of view service to view/call info from the alert sheet