How to Create Email Reminders Based on Date from Google Sheets?

You can perform several functions like organizing meetings, creating tasks, and sorting invoices conveniently via Google Sheets. It is simple, productive, and easy to share with others. The inability to send email reminders seems to be the only downside of the versatile application. So, here are the instructions to create email reminders based on the date from Google Sheets.

Make & Export Data from Sheets

If you want to make & export data from sheets, then you need to follow the instructions given below.

• First of all, launch the document on sheets.
• The values of the first row should go with this outline.
• Then beneath the “Subject” header, enter the title of the reminder.
• You can add multiple events, as well as their beginning & ending dates.
• Go to the “File” menu.
• You have to move the cursor above “Download.” 
• You should choose “Comma-separated values.”
• Now, you have to select the location for the CSV document & store it.

Importing the Document to Calendar

You need to import the document to the calendar, follow the steps mentioned below.

• Get started by launching the Google Calendar.
• Then you should select the “Settings” menu.
• Choose Settings.
• Navigate to the menu to the left-hand side of the screen & select “Import and Export.”
• You should go to “Select file from your computer” beneath the “import” section.
• Now, select the save CSV file & import it.

Setting up Notifications & Sharing

If you want to set up notifications & sharing, then you need to follow the instructions given below.

• To begin with, move the mouse above the name beneath the “My Calendars” section to the left-hand side of the Calendar display.
• Then you should click on the vertical ellipsis menu icon near to the name.
• Go to “Settings & Sharing.”
• You should check out the account is listed beneath the “Event notification section.”
• Thereafter you have to select “Email” instead.
• Now, you should adjust the time & date period among the reminder & the event.

Using Add Reminders Add-On

You need to use add reminders add-on, follow the steps mentioned below.

• First, you have to select the “Add-ons” option at the upper part of the display.
• Then you should choose “Get add-ons.”
• You have to go to the search bar & input the “Add Reminders” on it.
• Thereafter select the “Add Reminders” icon & choose “Install.” When the prompt comes, permit permissions & wait for the application to install.
• Navigate to the “Add-ons” option once again & move the cursor above the “Add Reminders” menu.
• Now, choose “Set up/edit reminders.”

Maria Davis is a self-professed security expert; he has been making the people aware of the security threats. His passion is to write about Cyber security, cryptography, malware, social engineering, internet and new media. He writes for Norton security products at norton.com/setup.

Source: http://au-norton.com/how-to-create-email-reminders-based-on-date-from-google-sheets/