Hello everyone, this article I would like to share about how to create a simple cronjob on google apps script. If you are in need of creating a cronjob every day to send debt collection mail, or daily send a message to the chatwork to remind you to write reports but you do not have a server or a server, this article will help you to solve that problem … ah Google script also does a lot of interesting things in this section, I just introduce that, you guys learn more.
Introducing Google Apps Script
Google App Script is a JavaScript-based programming language that allows you to create, modify and deploy projects on Apps Script editor, Apps Script code that runs on Google servers. You can program to manipulate and interfere with many Google services such as google sheet, clendar, maps, form, drive … generally most of google services.
There are a few examples you can do with google apps script
- With goole form: it is possible to write code so that when someone submits the form, it will send data to your api server.
- Google sheet: write and read data from google sheet, get data from google sheet to send mail
- Google calendar: reads the schedule data from your file to create an event on google calender
…
I can do a lot of other things, but now I will guide you to create a cronjob to send mail and send messages to chartwork.
Cronjob sent mail
1. To use google script, you need a google account (this must have everyone)
2. Go to script.google.com to open a code editor
3. Select + dự án mới to write code
4. To send mail, you use the following code
1 2 3 4 5 6 7 | <span class="token keyword">function</span> <span class="token function">myFunction</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token keyword">var</span> subject <span class="token operator">=</span> <span class="token single-quoted-string string">'Hello viblo.asia'</span> <span class="token punctuation">;</span> <span class="token keyword">var</span> body <span class="token operator">=</span> <span class="token single-quoted-string string">'Xin chào viblo.asia, Bài viết này thuộc về trang web viblo.asia'</span> <span class="token punctuation">;</span> <span class="token keyword">var</span> mailTo <span class="token operator">=</span> <span class="token single-quoted-string string">' <a class="__cf_email__" href="/cdn-cgi/l/email-protection">[email protected]</a> '</span> GmailApp <span class="token punctuation">.</span> <span class="token function">sendEmail</span> <span class="token punctuation">(</span> mailTo <span class="token punctuation">,</span> subject <span class="token punctuation">,</span> body <span class="token punctuation">)</span> <span class="token punctuation">;</span> <span class="token punctuation">}</span> |
After reading through, you will also understand this code, this code will use the email that you log into the app to send mail to mailTo
5. Click the button 
for a test run
You need to give permission for this script
Select review rights
Select Advanced
Choose to go to project … (unsafe)
And click on allow to grant permissions to the email.
So finished sending test mail, 1 mail has been sent to the recipient.
6. Create triggers to run cronjob
In the edit section select the current project animation
Select Add Trigger in the lower right corner of the screen.
Modal setting appears and you install the parameters, as above, I set the script code to run around midnight to 1am.
So created the cronjob to send mail, ezz, right
Cronjob message to chatwork
I need to create cronjob and send message to chatword at 5:00 pm to remind me to write report at the end of the day. This is quite simple to do as the above email conjob and replace with the following code
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | <span class="token keyword">function</span> <span class="token function">myFunction</span> <span class="token punctuation">(</span> <span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token keyword">var</span> token <span class="token operator">=</span> <span class="token single-quoted-string string">'your_bot_chatwork_token'</span> <span class="token punctuation">;</span> <span class="token keyword">var</span> roomId <span class="token operator">=</span> <span class="token single-quoted-string string">'your_room_id'</span> <span class="token punctuation">;</span> <span class="token keyword">var</span> message <span class="token operator">=</span> <span class="token single-quoted-string string">'Viết report cuối ngày đi'</span> <span class="token punctuation">;</span> <span class="token keyword">var</span> params <span class="token operator">=</span> <span class="token punctuation">{</span> <span class="token single-quoted-string string">'method'</span> <span class="token punctuation">:</span> <span class="token single-quoted-string string">'post'</span> <span class="token punctuation">,</span> <span class="token single-quoted-string string">'headers'</span> <span class="token punctuation">:</span> <span class="token punctuation">{</span> <span class="token single-quoted-string string">'X-ChatWorkToken'</span> <span class="token punctuation">:</span> token <span class="token punctuation">}</span> <span class="token punctuation">,</span> <span class="token single-quoted-string string">'payload'</span> <span class="token punctuation">:</span> <span class="token punctuation">{</span> <span class="token single-quoted-string string">'body'</span> <span class="token punctuation">:</span> message <span class="token punctuation">}</span> <span class="token punctuation">}</span> <span class="token punctuation">;</span> UrlFetchApp <span class="token punctuation">.</span> <span class="token function">fetch</span> <span class="token punctuation">(</span> <span class="token double-quoted-string string">"https://api.chatwork.com/v2/rooms/"</span> <span class="token operator">+</span> roomId <span class="token operator">+</span> <span class="token double-quoted-string string">"/messages"</span> <span class="token punctuation">,</span> params <span class="token punctuation">)</span> <span class="token punctuation">;</span> <span class="token punctuation">}</span> |
We need your_bot_chatwork_token to be the token of the bot that you use to send you message to the chatwork using the bot’s account to get the token here.
With room_id, you go to the chat box where you want to send the message to get on the url, it is a string of numbers after the id.
Fix the code and then do the same as send mail. Thanks mn for watching.