GOOGLE SHEET AUTOMATION

€20-70 EUR

Закрито

Опублікований

over 6 years ago

€20-70 EUR

Оплачується при отриманні

We're looking for a developer who can automate Google Sheet. The Google Sheet has different columns, one of them being DATE OF APPOINTMENT, other EMAIL, and, other PROVINCE. We need to: 1st. Send e-mail automatically (template) if the date of the appointment is in the next 24 hours. 2nd. Send e-mail automatically (template) everytime we write the PROVINCE, to a list of e-mails in another Google Sheet that matches the same PROVINCE. 3rd. Send e-mail automatically (template) when 24 passed since the appointmante date.

Software Architecture

ID проекту: 15721620

Про проект

12 пропозицій(-ї)

Дистанційний проект

Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

12 фрілансерів(-и) готові виконати цю роботу у середньому за €52 EUR

@celalaybar

Hello. I can write Google Apps Script to automate Google Spreadsheet and send emails automatically. Relevant Skills and Experience I am good at Google Apps Script and JavaScript. I have done with a very similar job recently. https://www.freelancer.com/projects/javascript/Google-sheets-script-writing-for/ Proposed Milestones €99 EUR - Done.

€99 EUR за 3 дні(-в)

5,0

(205 відгуки(-ів))

6,9

@DevvTime

Hello there i am a professional and have extensive experience, can you please contact to answer couple of questions please? i am waiting Thanks Regards Relevant Skills and Experience php,mysql,html,css,js Proposed Milestones €72 EUR - complete having few questions can you please pm?

€72 EUR за 10 дні(-в)

4,8

(33 відгуки(-ів))

5,6

@mohamedkaram93

Hi! We can use Google script time driven triggers to achieve the first and second flows you described. While we will use onEdit trigger to achieve the second one. The script for the first and third tasks will run continuously to check if an appointment is 24 hours away from the script run time or 24 hours passed. If either condition is true, the right template will be sent. For the second task, onEdit trigger for the sheet will be installed. Whenever you enter a new row and you enter the province for that row, the script will run, read the list of emails that have the same province from the other sheet and send the templated email to them. I started my career as a general web developer, then I specialized in Google Apps Script language which captured my heart =) I may be unresponsive during Saturday, but I will be responsive back on Sunday. You can alway expect less than 24 hours response time! I will be more than happy to address any of your questions! Sincerely, Mohamed

€70 EUR за 3 дні(-в)

5,0

(35 відгуки(-ів))

5,4

@abhinovpankaj

I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Relevant Skills and Experience -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application -- Worked on Google spreadsheets,calendar and -- JS,Google extensions and google scripts Proposed Milestones €50 EUR - Google Sheet

€50 EUR за 4 дні(-в)

4,9

(51 відгуки(-ів))

5,3

@ShawnMoon

Hi there, I would be able to create your google sheets email automation project. I have created automated emails with google's script service before depending on google sheets cell values. Relevant Skills and Experience I am a PHP/MySQL/JS developer with 6+ years of experience working in a studio environment, tackling a wide variety of projects including many of google's API's and scripting.

€111 EUR за 2 дні(-в)

5,0

(12 відгуки(-ів))

4,9

@SoufianeAch

Hi! I'm experienced with Google sheet. I have completed many automation task for the company I'm interning in currently. I'm rigorous and accurate and I can deliver the work within an hour or 2. I'm always aware about the responsibility given to, so I'll make sure to complete this project to the highest standards. I hope to hear back from you and wish you a nice day. Soufiane.

€29 EUR за 1 день