Create and Send Emails from a Google Sheet with Zapier and Postmark
Zapier provides a great way to quickly combine the functionality of Postmark and Google Sheets. Use this tutorial to create a Zap that sends an email using Postmark whenever a row is added to a Google Spreadsheet you specify.
What You Will Need
Create a Sheet in Google Sheets
Once you have your Postmark, Zapier, and Google accounts set up, log into Google Sheets. Create a new sheet.
Add the following column headers so that it looks like the example below:
- Recipient
- From
- Subject
- Body
- HTMLBody
Note: You can name your column headers anything but try to make them descriptive to make it easier when matching the column headers to corresponding fields in Postmark. Each row will contain all of the information needed to create and send an email.
Add an example row in your sheet using a legitimate recipient for the recipient’s email address. Be sure to only use email addresses in your From column that are confirmed Sender Signatures on your Postmark account.
Create Zap
Once your Google Sheet is created, log into Zapier and click Make a Zap! Zaps have two components, a trigger and an action. The trigger tells Zapier what to look for, which in our case is “a row is added to my Google Sheet”. The action component provides the Zap with instructions on what action to take once the trigger occurs. For our action, we will be saying to Zapier “send an email through Postmark with the information added to the Google Sheet”.
Set Up a Trigger
In the search bar, type in Google Sheets and then select Google Sheets for the Trigger App. Google Sheets will be the trigger app in our case, since changing our sheet is what triggers an action in Postmark.
Choose New Spreadsheet Row for the trigger. Each time Zapier detects a new row is added to the sheet we specify, it will trigger an email to be sent from Postmark.
Click Connect a New Account and log into your Google account where the sheet you will use is located. This step will connect this Zap with your Google Account so your sheet can be accessed.
Once your Google Account is successfully connected, you will see a Success message. Save and Continue.
Set Up Google Sheets Spreadsheet Row
For the Spreadsheet, select the spreadsheet we created earlier in the tutorial. For Worksheet, use the sheet that contains the headers we created, likely called Sheet1 unless you changed the name.
Click Continue and then test the spreadsheet. You will see a Test Successful message confirming that Zapier found the spreadsheet in your Google account.
Set Up the Postmark Action
Now we can add the Postmark action that is triggered when a new row is added to the Google Spreadsheet we just connected. Enter Postmark in the search bar and select Postmark when it appears.
For the Postmark Action, select Send an Email then click Save and Continue. This lets our Zap know we want to send an email via Postmark when we add a new row to our sheet.
Set up Postmark Email
Add the columns from your Google Sheet that match the corresponding Postmark field. Your column header names may be different, just be sure to match up the appropriate columns with their corresponding fields in Postmark. In my case, I am using from for From Email Address, recipient for To Email Address, body for Text email body (the plain text body of the email), subject for Email Subject, and htmlbody for Html Body of the Message. Once you have mapped your Zap, click Continue.
You will now see a prompt requesting to send a test using the Zap you just created. Proceed with the test to ensure the Zap is working as expected. The test will use the first row found in your Google Sheet to populate the test email with the recipient, sender, email subject, body, and HTML body. Click Create & Continue to proceed with the test.
Once the test passes, you can proceed to turn on your Zap. Head to your My Zaps area of the Zapier dashboard to see your newly created Zap. Turn it off or on with the toggle and use the dropdown to remove, rename, or edit your Zap.
Once enabled, your zap will now check your Google Sheet every five minutes and send an email each time a new row is detected!