Simple MVP with Google Sheets/Forms/Email

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.

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).


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

Taidot: Javascript, Scripting, Web Development

Näytä lisää: MS WORD , Excel, power point, flash , photo shop , Google sheets , Google forms, Writing skills , data entry , form filling , co, google sheets, excel, google forms, email google sheets, python google spreadsheet, angularjs spreadsheet example, pandas dataframe to google spreadsheet, google sheets api v4 python, python write to google spreadsheet, pandas google sheets, python gdata spreadsheet example, angularjs google spreadsheet example, copy certain text web page php script, flash based forms email submit, customizing google maps forms, joomla simple column layout bio side email form, breezing forms email, email create account bot, customizing google docs forms, google apps forward email address, setup google checkout wrong email address

Tietoa työnantajasta:
( 2 arvostelua ) Canberra, Australia

Projektin tunnus: #15107035

5 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


I can do it but I need details 1- wich fields will have both forms (it will be 2 yes?) 2- what must contain email to each user? And will it contain some link? 3- full list of automatisations Соответствующие навыки и Lisää

$180 AUD 4 päivässä
(9 arvostelua)

Sr. Software Professional having 8+ years experience. Relevant Skills and Experience Angular CLI, Angular 4, Angular 2, Angular Js, C# .Net, MVC , PHP, VB .Net, HTML, CSS, Bootstrap, Typescript, Javascript, Jquery, AS Lisää

$555 AUD 20 päivässä
(3 arvostelua)

Do you really need 2 forms for individual/organization? Won't a single form work with a drop-down individual/organization? I assume emails will be sent via Google Mail. Relevant Skills and Experience Google Sheets API Lisää

$194 AUD 2 päivässä
(2 arvostelua)

Hello Sir, I am an expert in Google sheets and programming and interested in this project. Certainly the project doesn't fall into very small project category. Pls open chat to discuss. Thx Aanvik Relevant Skills and Lisää

$25 AUD 1 päivässä
(0 arvostelua)
$25 AUD 1 päivässä
(0 arvostelua)