Project translated automatically. Log in or register, to view the original I am looking for a programmer who can write a script in Google Sheets AppScript to automatize messages. How this is happening now and it is necessary to reproduce the script: creates a mail with a specific topic and a pre-made mail template in Gmail > the employee filters the data of a specific agency from a table > enters the data in the mail body after the text > sends - so repeats for each agency and each type of mail We want to automatize this process. The wishes: - in the subject of the letter to submit the agency whose data is contained in the letter The possibility of changing the body of the letter Data example in the Google Sheet file - https://docs.google.com/spreadsheets/d/14IG7MzV6V4Hm3Ci6ostHNKK3-Uzn_E3M4ZFtFviESE8/edit?usp=sharing Green tables - examples of data Orange tables - example of templates of letters and thema Red tab - an email list for each agency

Proposals 3

Dan Sotnikov
Kharkiv, Ukraine

Projects 2
Rating -
Rating 224

Automation of Google Sheets (app script)

Client's review of cooperation with Artem S.

Automation of Google Sheets (app script)

5.0

Dan Sotnikov

Freelancer's review of cooperation with Dan Sotnikov

Automation of Google Sheets (app script)

5.0

Artem S.

Proposals concealed

Proposals are currently absent

Current freelance projects in the category Javascript and Typescript

Development of Telegram Mini App (RPG Game)

Automation of creating vertical videos of one type using a plugin in After Effects.

Development of a Tampermonkey script for automating responses in the internal CRM via the OpenAI API.