2016

How to send a bulk emailing campaign with mail merge for Gmail

No comments

bulk emailing campaign with mail merge for Gmail

An account executive for a popular online coupon company, Sam regularly sends product updates to a list of business owners and managers interested in using coupons to promote their business.

Much of what he says in the emails is the same for each client, but Sam is good at his job. He doesn’t want any of them to think that he was lumping him in with a group of prospects; he will never use a mass mailing product. He shudders thinking of another company’s logo and an unsubscribe button making their way into his messages.

wz_mailmerge_2 copy

Wizy.io will be perfect for Sam. It is is a Chrome extension that lets you send email campaigns to a list of receptive clients straight from your Gmail. That means that Sam’s messages will be automated, but will look like regular email that he tapped out one by one.

Making the experience better is that dynamic fields are recognized, so Sam goes beyond a “Hi all” greeting (another thing he dislikes), and keeps everything personal.

Additional useful features include templates, access to Google Contacts groups, the possibility of using a CSV file, and the tracking of open rates, clicks and replies.

Get my Free Wizyio now

Apol MassebieauHow to send a bulk emailing campaign with mail merge for Gmail
Read more

Automated Teacher Performance Appraisal made possible by G Merge at Associated Hebrew Schools

1 comment

We have a special spot for our education users, and was happy to hear that Data Merge has been helping the Associated Hebrew Schools of Canada become more efficient as they move their operations to the cloud.

Brian Pugh, head of literacy, is one of the forerunners in this development at AHS. Come this year’s evaluation season, the middle school will begin using a system that he has been working on since the summer. Teacher Performance Appraisal (TPA) will be performed using Data Merge with a Google spreadsheet.

It begins when the vice-principal or one of the two principals evaluates a teacher by submitting a TPA. There are about 160 questions in the appraisal, and the resulting spreadsheet is more than 700 columns wide. When the second principal gives his approval, it’s time to merge all that spreadsheet information into a document. No easy feat, given all the data!

spreadsheet

In the beginning they tried the add-on Autocrat, but that didn’t work, as they found that it wasn’t powerful enough to handle the sheer number of spreadsheet formulas. “It maxed out at around 150 formulas,” says Brian.

“I had given up for a while,” he continues, “but then I found G Merge.” Happily, our add-on can easily do the job. “It was so easy to use. It found all my merge tags in, like, two minutes. It’s so efficient.”

FiltersWith G Merge’s new release (just in time for evaluation season!) Brian can now use the filters and the scheduler to make the add-on run on a schedule, with the condition being “Approval Decision Contains Approved.”

SchedulerG Merge automatically creates the merged document, and sends the URL to the approving principal for e-signing, before the document is passed on to the teacher for review. When the system is up and running, the number of teachers can go up to 200. As G Merge now displays the url of the generated document right inside the spreadsheet, keeping track of the evaluation forms is easy.

URL
He’s spent many hours on the project, so Brian is understandably ecstatic to see it about to become part of the school’s systems. “I really thought it was never going to happen,” he says, “and it wouldn’t have happened except for Data Merge.”

Available in the GSuite Add-Ons Marketplace, you can start using G Merge right now. Enjoy a free 200 document or mail merges trial or get the unlimited plan for only $6/month.

team-imgWizy.io’s customer success director Apol Massebieau has been a newspaper journalist, magazine editor, TV show host/producer, essay and fiction writer, and toy designer. She was an early adopter of Etsy and continues being fascinated by how small businesses thrive online.

Apol MassebieauAutomated Teacher Performance Appraisal made possible by G Merge at Associated Hebrew Schools
Read more

G Merge made even better

No comments

First of all, allow us to say that we are thrilled to have such an amazing community of users. You have been very generous with your feedback, and we’d like to say thank you.

Since the last major upgrade of G Merge, the Wizy.io engineering team has been working very hard, using your suggestions to create a user experience even more powerful for everybody.

Based on what you had to say, we tweaked the add-on so that you will now find the following features in G Merge:

Column Matching

We brought back the possibility of picking any spreadsheet column to match with the Document Title and Shared to fields in the add-on sidebar. This is now Data Merge’s default mode.

Turn the switch on if you want G Merge to create the following columns automatically: Document Title, Shared to/Recipient and Email Subject.

feb 16 blog pic 1

The Active Sheet

No need to rename your sheet “Data Source” to run a merge, G Merge will work on the active sheet. Just select the sheet you want to process and click Generate!

feb 16 blog pic 2If you are scheduling an automatic batch in one sheet, the add-on stays locked on the sheet. To be able to use the add-on again you will need to unschedule the job.

Google Forms & G Merge

For the many of you using Google Forms linked to G Merge, we have great news. With this new release, you will now be able to program G Merge so that it runs automatically on form submission.

Document titles and email subjects can now be configured so they are generated automatically based on a prefix. For example, documents can be Document – 1, Document – 2 and Document – 3.

Want to share documents with only one user and send emails to just one recipient? Set document sharing and email recipients with a fixed email address.

feb 16 blog pic 3Search Templates

Now you don’t have to lose time scrolling through your templates to find what you need. The new search function in your shared templates list makes templates management easier.

Even More Improvements

To finish off all these great new features, we have also fixed it so that all your tracking and scheduling details will follow the time zone settings of your spreadsheet, independently of that of your device. To set your spreadsheet time zone, go to File in your spreadsheet menu, and choose the item Spreadsheet settings.

The add-on will now write your dates  on your documents exactly as you write them in your data-source spreadsheet, for example 16 February 2016 or 02/16/2016.

feb_16_blog_pic_4We are listening to what you have to say. Rest assured that we will continue to work hard to deliver a great G Merge.

Keep the feedback coming!

momoWizy.io product manager Mohamed Bahri started his career in informations systems consulting with companies like Accenture and E&Y, before going on his own and working freelance for different SAP programs as project manager. “My passion is entrepreneurship and business development,” says Mohamed, who co-founded Wizy.io in 2015.

Mohamed BahriG Merge made even better
Read more