I would like an MVP built that uses Google Sheets as a database and sends automatic summary emails to users based on their details.
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.
Detail input:
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).
Viewing:
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
I have experience in databases, Once I have written Scripts to Mail data from My Emails, I should be able to o it in 5 days
Relevant Skills and Experience
Database developer, script Writer
Proposed Milestones
$30 AUD - Build as expected
I would ask question if needed