Connect with us

Publications

How to Automate Birthday Emails with Google Sheets in 5 minutes

Published

on

Manfye Goh Hacker Noon profile picture

@manfyeManfye Goh

Pharmacist and Software Engineer in Malaysia, graduated from Master in Data Science and Analytics

Often small and medium-sized businesses use email to keep in contact with their customer. Email such as seasonal greetings, festival greetings are great; it is even more fabulous when you can personalize the email to each of your customers, such as a birthday greetings email which provides special offers to your customers for a particular month. This will greatly improve customer engagement.

Scenario: Your company has the DOB and Email of customers and wants to send a birthday email greeting to the customers to show your appreciation to them.

Step 1: Prepare your Google Sheet

Prepare your google sheet as below, make sure you had formatted the column DOB to Date format using:

Format → Number → Date

This will tell google sheet that this field is a date field, you can choose the format you prefer such as

dd/MM/yyyy

or

MM/dd/yyyy

according to your preferences. In this case, my sheet name will be “CustomerDb”. You can view my example of google sheet here.

2. Setup Google App Script

Go to Tools → Script Editor to open up and the Authorized Google Apps Script, you will notice a file named

Code.gs

on the left of your screen and the code area on the right of your screen.

Paste the following code inside:

function sendBirthdayEmails() {
// Get the sheet where the data is, in sheet 'CustomerDb'
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("CustomerDb")
//Setting up today date, the date when the function activated
var now = Utilities.formatDate(new Date(), "GMT+8", "dd-MM");
// Get all value of the sheet
var data = sheet.getDataRange().getValues();
// Loop through each row of the sheet
data.forEach(function (row) {
// Check if the date (month and day) are matched to today date, send email when matched
if (Utilities.formatDate(new Date(row[2]), "GMT+8", "dd-MM") === now) {
Logger.log("Send Email")
MailApp.sendEmail({
to: row[3],
subject: "Happy Birthday " + row[1],
htmlBody: "Dear " + row[1] + "," + "<br>" + "<br>" +
"Happy Birthday to you! " + "<br>" + "<br>" +
"<img width='500' src='https://images.pexels.com/photos/3905849/pexels-photo-3905849.jpeg?auto=compress&cs=tinysrgb&dpr=2&h=750&w=1260'>" +
"<br>" +
"Sincerely from," + "<br>" + "DS Company"
});
}
else {
Logger.log("Birthday Not Match")
}
});
}

The code will run through each row of the database, and the row[0], row[1], row[2], row[3] in the code is corresponding to the column A, B, C, D in the datasheet.

Whenever the code found matches between today date and the DOB (exclude the year):

Utilities.formatDate(new Date(row[2]), "GMT+8", "dd-MM") === now

It will fire a function “sendEmail”.

Test the code by saving and click the Run button on top. You will get an email as below:

As the date of writing this article is 30/5/2021, the function will only send to customer with a DOB of 30/5, which is “Manfye Goh 0″, customize your email according to your organization’s need.

3. Scheduling Daily Checking

The idea of this function is to schedule the

sendBirthdayEmails()

to run every day to check the birthday in the database. It is easily done as Google App Script offers a few types of triggers according to the user’s needs.

In this case, I would like the function to be triggered every day 10 am — 11 am as it is a perfect period of time to open a Birthday Greeting Email. Lastly, save the trigger, and you have will never miss any birthday greet email to your customer anymore!

This simple setup only took 5 minutes and it will improve your relationship with your customers, try it out!

Final words:

This article demonstrates how to schedule send birthday emails according to the data in the cells, with slight modification and understanding of the code, you can modify it to automate schedule email such as invoice reminder, seasonal greeting, or even schedule a specific email at a specific time.

Do share with me your creativity if you do so.

Lastly, Thank you for your time in reading my article!

Credits and References:

by Manfye Goh @manfye. Pharmacist and Software Engineer in Malaysia, graduated from Master in Data Science and AnalyticsRead my stories

Tags

Join Hacker Noon

Create your free account to unlock your custom reading experience.

Coinsmart. Beste Bitcoin-Börse in Europa
Source: https://hackernoon.com/how-to-automate-birthday-emails-with-google-sheets-in-5-minutes-tqm36xg?source=rss

ZDNET

Tim Cook claims sideloading apps would destroy security and privacy of iOS

Published

on

apple-ceo-tim-cook.png
Image: Apple

Tim Cook has claimed in an interview with Brut that if Apple was forced to allow sideloading of apps, as Android does, it would destroy security and privacy of iOS.

Speaking to the Digital Markets Act proposed by the European Commission, Cook said sideloading was not in the “best interests of the user”.

“That would destroy the security of the iPhone and a lot of the privacy initiatives that we’ve built into the App Store where we have privacy nutrition labels and app tracking transparency, where it forces people to get permission to track across apps,” Cook said.

“These things would would not exist anymore except in people that stuck in our ecosystem and so I worry deeply about privacy and security.”

The Apple CEO said Android has 47 times more malware than iOS, and this was directly due to Apple’s ecosystem being tied down to one app store and all apps being reviewed.

“That keeps a lot of this malware stuff out of our ecosystem, and customers have told us very continuously how much they value that, and so we’re going to be standing up for the user in in the discussions and we’ll see where it goes,” he said.

Cook did say there were parts of the Digital Services Act (DSA) that could be used to fight online disinformation.

“We do suffer today from vast disinformation … it’s clear that there needs to be something done here,” he said.

“This is not an acceptable state of the world and as I look at the DSA, there’s some parts of it that I think will help this, but I’m not sure that anybody yet has a handle on how to fix it entirely and I think it deserves more discussion and more debate.”

In recent testimony as part of the Epic vs Apple trial, Cook said without curation, Apple’s App Store would be a toxic mess.

Related Coverage

Coinsmart. Beste Bitcoin-Börse in Europa
Source: https://www.zdnet.com/article/tim-cook-claims-sideloading-apps-would-destroy-security-and-privacy-of-ios/#ftag=RSSbaffb68

Continue Reading

ZDNET

Tim Cook claims sideloading apps would destroy security and privacy of iOS

Published

on

apple-ceo-tim-cook.png
Image: Apple

Tim Cook has claimed in an interview with Brut that if Apple was forced to allow sideloading of apps, as Android does, it would destroy security and privacy of iOS.

Speaking to the Digital Markets Act proposed by the European Commission, Cook said sideloading was not in the “best interests of the user”.

“That would destroy the security of the iPhone and a lot of the privacy initiatives that we’ve built into the App Store where we have privacy nutrition labels and app tracking transparency, where it forces people to get permission to track across apps,” Cook said.

“These things would would not exist anymore except in people that stuck in our ecosystem and so I worry deeply about privacy and security.”

The Apple CEO said Android has 47 times more malware than iOS, and this was directly due to Apple’s ecosystem being tied down to one app store and all apps being reviewed.

“That keeps a lot of this malware stuff out of our ecosystem, and customers have told us very continuously how much they value that, and so we’re going to be standing up for the user in in the discussions and we’ll see where it goes,” he said.

Cook did say there were parts of the Digital Services Act (DSA) that could be used to fight online disinformation.

“We do suffer today from vast disinformation … it’s clear that there needs to be something done here,” he said.

“This is not an acceptable state of the world and as I look at the DSA, there’s some parts of it that I think will help this, but I’m not sure that anybody yet has a handle on how to fix it entirely and I think it deserves more discussion and more debate.”

In recent testimony as part of the Epic vs Apple trial, Cook said without curation, Apple’s App Store would be a toxic mess.

Related Coverage

Coinsmart. Beste Bitcoin-Börse in Europa
Source: https://www.zdnet.com/article/tim-cook-claims-sideloading-apps-would-destroy-security-and-privacy-of-ios/#ftag=RSSbaffb68

Continue Reading

ZDNET

Tim Cook claims sideloading apps would destroy security and privacy of iOS

Published

on

apple-ceo-tim-cook.png
Image: Apple

Tim Cook has claimed in an interview with Brut that if Apple was forced to allow sideloading of apps, as Android does, it would destroy security and privacy of iOS.

Speaking to the Digital Markets Act proposed by the European Commission, Cook said sideloading was not in the “best interests of the user”.

“That would destroy the security of the iPhone and a lot of the privacy initiatives that we’ve built into the App Store where we have privacy nutrition labels and app tracking transparency, where it forces people to get permission to track across apps,” Cook said.

“These things would would not exist anymore except in people that stuck in our ecosystem and so I worry deeply about privacy and security.”

The Apple CEO said Android has 47 times more malware than iOS, and this was directly due to Apple’s ecosystem being tied down to one app store and all apps being reviewed.

“That keeps a lot of this malware stuff out of our ecosystem, and customers have told us very continuously how much they value that, and so we’re going to be standing up for the user in in the discussions and we’ll see where it goes,” he said.

Cook did say there were parts of the Digital Services Act (DSA) that could be used to fight online disinformation.

“We do suffer today from vast disinformation … it’s clear that there needs to be something done here,” he said.

“This is not an acceptable state of the world and as I look at the DSA, there’s some parts of it that I think will help this, but I’m not sure that anybody yet has a handle on how to fix it entirely and I think it deserves more discussion and more debate.”

In recent testimony as part of the Epic vs Apple trial, Cook said without curation, Apple’s App Store would be a toxic mess.

Related Coverage

Coinsmart. Beste Bitcoin-Börse in Europa
Source: https://www.zdnet.com/article/tim-cook-claims-sideloading-apps-would-destroy-security-and-privacy-of-ios/#ftag=RSSbaffb68

Continue Reading

Ecommerce

A look inside Google’s first store, opening in NYC’s Chelsea neighborhood tomorrow

Published

on

There have been plenty of pop-ups over the years, but tomorrow Google’s first store opens in NYC’s Chelsea neighborhood. The brick and mortar model finds the company joining peers like Apple, Microsoft, Samsung and even Amazon, all of whom have a retail presence in Manhattan, including several just around the corner from Google’s new digs.

The new space, which opens tomorrow morning at 10 a.m. local time, fills 5,000 square feet of selling space in Google’s big, pricey West Side real estate investment. The retail location was previously occupied by a Post Office and Starbucks, which vacated the premises once their leases expired under their new corporate landlord.

Image Credits: Photos courtesy of Google and Paul Warchol

The store’s layout is designed to be experiential, highlighting the company’s growing hardware portfolio along with select third-party partners. Essentially it’s a way for the company to get Pixel phones, Home offerings, Stadia, WearOS and the newest addition to the hardware portfolio, Fitbit devices, in front of tourists and locals.

“We really used the pop-ups over the last several years to get a better sense of what are customer expectations for what we can uniquely deliver at Google,” VP Jason Rosenthal said during a press preview week. We’ve taken learnings from our 2016, 2017, 2018 and 2019 pop-ups and really fed that learning into what we’re opening[…] in Chelsea.”

Due to pandemic restrictions, the preview was virtual. And while it’s open to the public this week, the company will be maintaining the standard safety precautions, as the city deals with (knock on wood) the tail end of the pandemic.

And while COVID-19 almost certainly slowed the planned opening, Google promises that things will be in full force starting tomorrow. This follows several weeks of piloting, wherein the store’s 50 or so staffers were put through their paces, while the company put the finishing touches on the experience. Prior to this, Google built a full-size store mockup in a hangar space in Mountain View to test out ideas.

Image Credits: Google and Paul Warchol

In addition to product screens and dioramas lining the 17-foot windows, the company filled the store with “sandboxes” — effectively scenarios like a living room, not dissimilar to what you might find in a large furniture store — albeit better lit. There’s also a gaming area for playing Stadia and a soundproof spot for testing out various Home/Nest products.

Like Apple’s Store, customers can bring in for repair broken devices like Pixels. The company says it’s growing the number of devices that can be repaired on-site, while certain issues, like a broken screen, should be able to be fixed same day.

It seems likely that the store is a pilot in and of itself, with further plans to open additional locations in the U.S. and, perhaps, international markets where the company sells hardware. For now, however, Google won’t discuss the subject beyond tomorrow’s opening in Chelsea.

Coinsmart. Beste Bitcoin-Börse in Europa
Source: https://techcrunch.com/2021/06/16/a-look-inside-googles-first-store-opening-in-nycs-chelsea-neighborhood-tomorrow/

Continue Reading
Esports4 days ago

Lost Ark Founders Pack: Everything You Need to Know

Aviation4 days ago

Delta Air Lines Flight Diverts To Oklahoma Over Unruly Off-Duty Flight Attendant

Aviation3 days ago

Spirit Airlines Just Made The Best Argument For Lifting LaGuardia’s Perimeter Rule

Cleantech5 days ago

Tesla Model S 420 Plaid Is The Best Car In The World (But Not For Me)

Energy5 days ago

Daiki Axis Co., Ltd. (4245, First Section, Tokyo Stock Exchange) Overview of Operating Performance for the First Three Months Ended March 31, 2021

Esports2 days ago

Clash of Clans June 2021 Update patch notes

Esports4 days ago

Genshin Impact Murals: Location Guide

Blockchain3 days ago

Africa Leading Bitcoin P2P Trading Volume Growth in 2021

Esports2 days ago

Legends of Runeterra Patch 2.10.0 brings bug fixes and Pool Party cosmetics

Blockchain5 days ago

DCR Technical Analysis: Look for Support Levels of $130.13 and $126.01

Gaming3 days ago

Forza Horizon 5 Announced, Launches November 9

Cyber Security5 days ago

Cybersecurity Degrees in Colorado

Aviation2 days ago

Boeing 727 Set To Be Turned Into Luxury Hotel Experience

Esports4 days ago

Genshin Impact Music Rock Puzzle Guide

Blockchain5 days ago

Bitcoin Weekly Chart Appears to be in the Green Zone

Big Data2 days ago

In El Salvador’s bitcoin beach town, digital divide slows uptake

Blockchain2 days ago

Since It Adopted Bitcoin As Legal Tender, The World Is Looking At El Salvador

Blockchain4 days ago

Binance Is Launching a Decentralized NFT Platform

Blockchain4 days ago

Ripple price analysis: Ripple retests $0.80 support, prepares to push higher? 

HRTech2 days ago

Pre-Owned Luxury Car dealer Luxury Ride to add 80 Employees across functions to boost growth

Trending