Script for gmail/gsheet to send a template email to the latest message in the email thread
Good afternoon,
For work, we use gheet where various project data is entered, including the unique ID email number. One row in the table represents one project with a unique ID email number.
A script needs to be written that, when a trigger is activated in the GSheet row, would find the latest email by its ID and send a template email to it.
-
2 days57 USD2 days57 USD
Good day!
I have already implemented a similar project in terms of functionality, so I can easily help write the script.
Feel free to reach out, I would be happy to discuss your project in more detail.
-
3 days68 USD
571 6 1 1 3 days68 USDHello, Sergey. I am ready to develop a script for sending a template email to the necessary addresses from Google Sheets. Let's discuss.
-
2 days57 USD
762 15 0 2 days57 USDGood afternoon,
I can implement it without any problems.
I would ask you to send the gsheet template in which the script needs to be deployed.
-
3 days102 USD
449 3 1 1 3 days102 USDTo implement the task, I propose the following approach:
Work plan:
Integration with Google Sheets:
We will set up Google Apps Script to work with the spreadsheet.
We will define a trigger that will monitor changes in specific columns or rows of the spreadsheet.
Finding the latest email by unique ID:
… The script will find the last (latest) email corresponding to the unique project ID.
Sending a template email:
We will use the Gmail API in Google Apps Script to automatically send a template message to the found email.
We will create a template for the email in the script, which will be automatically filled in when sent (for example, text, project name, and other information from the spreadsheet).
Main advantages:
Automation: a trigger set up once ensures automatic execution of the task without additional actions.
Ease of editing: you will be able to easily change the email template and sending parameters in Google Apps Script.
Ready to implement and configure the script to work according to your requirements.
-
2 days91 USD
431 28 1 2 days91 USDHello, I am ready to complete this project!
I look forward to collaborating!
-
1 day23 USD
93 1 day23 USDHello Sergey, I already have a script.
I can save you and myself time.
There is also an explanation for the script about what is what and why.
I will be very happy to collaborate with you, and since I am a newcomer on this site, I have a 90% discount.
-
1 day45 USD
259 1 0 1 day45 USDGood afternoon.
I can write the mailing code in a few hours.
I also know a couple of ways to increase the maximum daily limit :)
Feel free to contact me, I will do the job well!
-
1 day28 USD
121 22 2 1 day28 USDGood afternoon. Everything is feasible.
Just in case - free Gmail has daily sending limits, after exceeding them, emails will stop being sent.
-
1 day28 USD
1294 25 1 1 day28 USDGood day, I am working on automating Google Sheets, I can help you. By the end of the day, you will have the script.
-
1 day227 USD
116 1 day227 USDHi,
I can do it.
Looing forward to your response.
Best regards,
Kei
-
3 days159 USD
555 2 0 3 days159 USDHello!
I am Dmitry, a web developer with extensive experience, and I am happy to help you with automating the sending of emails from Google Sheets.
What I offer:
A script for Google Sheets that will automatically find the last entry with the email and project ID, and send a template email to that email.
Automatic launch: we will set up triggers so that the script runs when data changes or on a schedule.
Additional features upon request: if needed, I can add error checks or create a more flexible template for emails.
Current freelance projects in the category Bot Development
I am looking for a strong specialist in trading bots and agents.
250 USD
It is important to start - TODAY I need a person who has experience in writing trading bots on DEXs (needed on the BSC network) with an understanding of transaction costs, gas, etc. I want to test several trading strategies on a real trading agent I need to quickly… Cryptocurrency & Blockchain, Bot Development ∙ 8 hours 15 minutes back ∙ 13 proposals |
Creation of a TikTok farm with income generation
602 USD
Looking for a person who can write software for a TikTok farm, so we can generate traffic and earn income. We are seeking a ready-made solution with a full cycle. Python, Bot Development ∙ 1 day 10 hours back ∙ 15 proposals |
Pocket Option trading bot
71 USD
I need a bot and your expertise who has already been able to create a similar bot when the bets are correct, they are read from Pocket Option I am interested in Brent Oil I do not need a beginner or someone who will just write code for the sake of it I need someone who knows… AI & Machine Learning, Bot Development ∙ 2 days 11 hours back ∙ 19 proposals |
TG BOT for Auto Ria
156 USD
We are interested in creating a bot that can send 1000+ exchange offers per day from one account. Authorization through Ria login and password, with characteristics exclusively those listed on the portal. The ability to limit the number of exchange requests. Also, monitoring… Bot Development ∙ 2 days 12 hours back ∙ 41 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 2 days 13 hours back ∙ 16 proposals |
Никосия