Zapier Google Sheet Direct Mail Integration

Our Zapier Google Sheet Integration makes it super easy to send automated postcards and letters to your audience with ChurchStamp. With this Integration, you’ll be able to trigger personalized direct mail using a Google Sheet. The setup is easy and then even the least tech-savvy people will be able to trigger personalized and tracked direct mail pieces.

How to Use the Zapier Google Sheet Direct Mail Integration

Zapier works as the intermediary to move data from your Google Sheet over to your ChurchStamp Triggered Drip Campaign so that a mailpiece is sent out whenever there is new or updated data within the Google Sheet. It takes a little setup, but we’ve outlined the steps for you below so that you’ll be up and running in no time.

Step 1: Set up a “Triggered Drip” campaign in ChurchStamp using the Zapier Action method

Having a ChurchStamp Triggered Drip Campaign is required for you to trigger mail from a Google Sheet. Setting it up is simple, just follow the directions in the article link below:

Set Up a ChurchStamp Triggered Drip Campaign

Step 2: Set up your Google Sheet to be direct mail ready

Set up your Google Sheet to include the fields below:

Required Name Fields

• First Name (20 characters, alphanumeric)

• Last Name (20 characters, alphanumeric)

• AND/OR Company (40 characters, alphanumeric)

Required Address Fields

• Address (64 characters, alphanumeric)

• Address 2 fields on records that require it (64 characters, alphanumeric). Use this field for things such as apartment number, suite number, etc.

• City (200 characters, alphanumeric)

• State (2-letter state short-name code “MA” or valid full state name “Massachusetts”)

• Zip code (5-digit numeric “02370” or 5 dash 4 digits numeric “02370-1234”

There are also additional optional fields you may want to include. These fields are not used in the address part of the mailer but can easily be inserted into the creative.

Personalization And Other Common Fields

• Common contact info such as email address, phone number, occupation/job title

• Up to 35 user-defined fields (we call them Variable Data fields).

Step 3: Create your Zapier “Zap” between your Google Sheet and ChurchStamp

In your Zapier account select ‘Create Zap’ to begin

Name your Zap and select your Trigger. Here you’ll choose Google Sheets

Next, choose your Trigger Event.

Click Continue, then you’ll choose the Google Account you want Zapier to connect to.

Then click Continue

Next, you’ll set up your trigger by selecting the Spreadsheet, Worksheet, and Trigger Column, then click Continue

The next step is to allow Zapier to test the Trigger. You’ll receive a sample of the data in your Google Sheet to verify that your Zap is connected to the correct Sheet.

Select ‘Test trigger’

You should receive a message that the test was successful and you’ll be able to review the data from the test.

Once confirmed, move on to the next part of the Zap. This is the ‘Action’.Select ChurchStamp.

If you don’t see it you can use the search function to find it.

Once selected, you’ll see that the app is ‘ChurchStamp’ and the Event is ‘Send and Track a Postcard or Letter’. There are no other options to choose from for the Event, so click ‘Continue’.

Now choose the ChurchStamp account that Zapier will connect to, then click ‘Continue’.

You’ll now select the Triggered Drip Campaign that you set up in Step 1, and map each of the data fields you want to send to ChurchStamp from your Google Sheet.

Be sure to include all of the required fields listed above.

Click ‘Continue’

Zapier will now conduct a test to make sure the connection between your Google Sheet and ChurchStamp happens properly. 

Select "Test & Continue".

Back in your ChurchStamp Triggered Drip Campaign, once the Zapier test has been completed, you should see one valid contact in the ‘Total Valid Contacts’ area

Step 4: Do a complete test of your Triggered Drip Campaign

Now that the setup is done, and you’ve tested the Google Sheet connection and ChurchStamp connection with Zapier, you’ll want to turn on your Zap in Zapier and trigger a record through your Google Sheet based on the trigger defined in the Zap.

Turn on your Zap and then test.