Build your own Agenda Notifier in Google Drive with Javascript

Check out the Spreadsheet template

January
  • Task: Brief description about the task we need to do. For example: “Washing the car”, “Do the shopping” or whatever action we want to be notified.
  • Notified (From/Till): We introduce the range of days of the month in which we want to be notified.
  • Done: There’s a selectable in which the only option is “completed”.

Open the script editor

Let’s code our notifier!

  • We read the sheet with given name.
  • We iterate over all the rows and we push in the array the tasks that should be notified today and they have not been completed yet.
  • We create a temporary Google document and put the list of tasks to be done
  • Document is sent by email to the email account in variable emailTo
  • Remove the temporary document

Run the main function and retrieve an email

Create a trigger and be notified

  • Click on Add trigger button (It’s shown on the bottom right of the page)

If you enjoyed the article, please share it!

--

--

--

If tech can change the world... why don't we use it to make it better? https://www.linkedin.com/in/ivan-corrales-solera/

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Matha Pachee, a game built using React-Native

Creating an SVG Image Map with Figma and a Touch of Javascript

https://umarfarooqshaik.blogspot.com/2022/01/real-love.html?m=1

Day6 - #100DaysOfCode - Finish React, Start Redux

Binary Search

The impact of passing components as props with arrow functions in React

Writing a Reusable Custom React Hook

Integrating SvelteKit and Stripe Checkout

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Iván Corrales Solera

Iván Corrales Solera

If tech can change the world... why don't we use it to make it better? https://www.linkedin.com/in/ivan-corrales-solera/

More from Medium

What is NodeJS?

Printing in Node.js with Electron (ElectronForge + node-printer + webpack)

Create and publish your first npm package

Front-end Development: Tables