Direct Mail Postcards to personalised websites, from a Google Sheet, using

Personalised QR Codes for Print Postcards to Personalised web, using Hyperise, Zapier &

Written by AshLast update 2 years ago

Using QR Codes, personalised to the recipient, can be a great way to connect offline and online campaigns.  

For example sending a prospect or existing customer a postcard in the actual mail, with a handwritten message on the back and a personalised image on the front, with an actionable personalised QR Code - that would could be a standout campaign.

This image from paints a good argument for trying offline postcard campaigns.

Such a campaign would seem difficult or time-consuming, definitely costly to pull off, before now... 🙂 

In just five steps this is now possible with Hyperise and

Here are the five steps in summary

  1. Create your postcard image and using Hyperise to personalise and add QR code.
  2. Add the prospect data for your campaign to a Google Sheet.
  3. Connect the Google Sheet to the Hyperise Image used for the postcard.
  4. Personalise your campaigns landing page with the Hyperise web personaliser.
  5. Setup a Zap in Zapier to print personalised postcards via when you update the Google Sheet.

Now lets break these steps down into digestible chunks...

1. Create Postcard Image in Hyperise

Creating a personalised image using Hyperise is straight-forward and now with our built in personalised QR Code generator it's even easier to create scannable QR codes, that will take the prospect to a personalised version of your website.

The important details to adhere to when creating an image to be used as the front of your postcard is to set the image canvas size to

width:  1875px 

height: 1275px

2. Add Prospect data to a Google Sheet

In this example we're using Google Sheets as the prospect data store, this gives us a good amount of flexibility, as we'll see later in this guide.

If you don't presently use Google Sheets, or you have your prospect data somewhere else, then you can import data into Sheets using a CSV file. Almost all platforms where your prospect data might be will have a CSV data export, voila problem solved.

Also using Zapier we can pretty much connect any CRM, e-commerce or email platform, using a Zap to insert a record into a google sheet each time something happens, eg a sale in the case of an e-commerce platform.

3. Integrate Sheet to Hyperise Image

Once you have your data in the Sheet, you need to add the Google Sheet as an integration to your personalised postcard image.

Here's the full guide to do this, if you haven't done this before:

The Sheet we use in this example can be accessed here, if you'd like to take a copy and have a play:

4. Setup personalised web page

The  Hyper-Campaign web snippet enables full website personalisation, we've covered how to implement this on your own website in this guide here:

Once setup, whenever the page is called with a value set to the hype_ref parameter, personalisation will be shown, in all other cases the fallback defaults will be shown.

As we've set each prospects QR code to embed their unique ID in the hype_ref parameter, each QR code scan will take the prospect to their own personalised web page.

5. Print Personalised Postcards

Finally, we have a Sheet brimming with customer data and personalised postcard images, now we can leverage to print and send out the postcards.

For this example we've been using a Google Sheets as the data source for our prospects, but these could just as well be a CRM or email automation platform integration with Hyperise.  

To connect the data along with the personalised postcard image to we use Zapier.  Zapier is a FREE online service that connects two different online services together. Think of it as a universal translator of data. 

A sample use case would be sending thank you cards automatically to every new contact added in Salesforce or a new row to a Google Sheet.... 

For this example we are going to connect Google Sheets with so that when a new row is added to a sheet it will trigger a postcard to be sent.

Step 1: Login to Zapier & connect your account.

Head over to the "My Zaps" page, to start building the Zap that will trigger postcards sends from your selected application. Click make a zap.

Choose the app you wish to trigger the sends, in this case, Google Sheets.

Step 2:  
Set up the trigger event, which in this case is "adding a new row"

Step 3: Choose your account, pick the spread sheet to use & finalize the data. your done with the trigger step

Step 4: Choose from the "Do This" drop down.

Step 5:  Choose the send postcard option.

Step 6: Map the variables so that a postcard can send

You need to map the sending details and message data so that it sends correctly, selecting the drop down on the right of each input field gives you access to your Google Sheet Data.

a. If you have address on one line, add it to the full address field it doesn't have to broken into separate fields can take it in one.
b. same with full name if you don't have first and last name separate just add it to the full name field.
c. you need to either enter a message or pick a message template for the card to send.
d. you need to enter the Hyperise image URL for the front of the card to send.

Below is an example of the completed fields:

Step 7: Finalize

Thats it, once you have completed the Test & Continue your Zap is now ready to send personalised postcard whenever your Sheets has a new row of data added to it!

Did this answer your question?