I am looking for a bid on project to develop Google sheet custom-addon.
Goal of the addon is to allow users to automatically send customized gmail mails to customers and automatically follow up. Also user has to have ability to manually change individual customers current campaign and template depending of their response. These automated emails should be on individual level and not bulk send.
- Data tab (Contains all email customization columns of email such as Email Address, First Name, Last Name + addon's required data to choose correct template: Campaign, Template 1, Sending date & time etc. User should be able to create new column titles into google sheet. Addon would search titles and insert data into email template. Example: I make new column title called "xyz" and insert into template "How are things in [xyz]" and addon would replace [xyz] with data in Data tab for that individual person.
- Rules tab (Contains rules for the follow up emails. Rules need to contain following: Wait (How many days from last email to send next one) + uses same send time as earlier, Campaign (What email campaign's email templates is used), Template (Which email template is send next to this person inside selected Campaign)
- Templates tab (Contains following columns: Campaign, Template, Subject/Content, Template area.) Goal here is user can select created campaign and template set in rules tab. Choose is the template area for email subject or content area and write the text in template area. If Template does not have subject area, then addon will find last email sent to this person and replies into that email chain.
If Template area is empty, addon does not send email for that individual and stops for this person until User changes campaign and template in Data tab.
This addon also should have some randomized delay between all individual sends so google wouldn't mark email sender as spammer.
User should be able to change sending date, campaign and template manually in Data tab and addon would check the data tab if today needs to be sent some emails.
Sending date needs to include time also so it doesn't send emails at 00:01 each day.
16 freelancer đang chào giá trung bình €139 cho công việc này
I have many experiences in Excel VBA developing and data mining. I'm software engineer and algorithm expert. Your task is suitable with me. I'm also perfected in C, C++, C#, SQL, PHP .... Thank you.
I can do best of my [login to view URL], I think my experience speaks for itself, but I'd be happy to tell you a story to illustrate any quality that you'd like to know more about.