Connect Google Sheets to Thanks.io and automate your tasks

Why integrate Google Sheets with Thanks.io

The Google Sheets to Thanks.io integration helps you sync data, automate manual tasks, and keep your stack aligned — without writing code.

Log every Shopify order to a Google Sheet automatically

When an order is placed in Shopify, MESA writes the relevant details — customer, line items, order value, fulfillment status — to the right sheet in real time. Your team works from a current, structured record without anyone running manual exports or copying data out of the Shopify admin.

Build a live ops dashboard your whole team can see

When Shopify order, inventory, and customer events occur, MESA pushes the details to Google Sheets as they happen. Your team tracks what's in motion from a single shared view without digging through the Shopify admin or waiting for a scheduled report.

Trigger Shopify workflows when a Google Sheet is updated

When a row is added or a value changes in a designated sheet — a product approved, a vendor confirmed, a reorder threshold flagged — MESA kicks off the corresponding action in Shopify. Your spreadsheet-based processes connect directly to your store operations without a manual handoff step between them.

Send a handwritten postcard the moment an order is placed

When a Shopify order is placed, MESA triggers a Thanks.io postcard to the customer's shipping address automatically. Your store delivers a physical, personal touch without anyone writing or mailing a single card by hand.

Reach lapsed customers with direct mail when digital channels go quiet

When a customer passes a re-engagement threshold in Shopify — no purchase in 90 days, a dropped loyalty tier, an unsubscribed email — MESA triggers a Thanks.io postcard to their address. Your win-back effort reaches them on a channel that doesn't compete with a crowded inbox.

Send direct mail at the loyalty milestones that matter most

When a customer hits a VIP tier, a spend threshold, or a significant anniversary in Shopify, MESA triggers a Thanks.io card with a personalized message. Your best customers receive a physical acknowledgment at the moment it means the most without anyone manually curating the send list.

Build any Google Sheets and Thanks.io automation

MESA helps you connect apps to automate repetitive tasks. A trigger is an event that starts a workflow, and actions are the steps that occur when it's running.

Row Created

Starts when a row is added to your spreadsheet.

Row Updated (Advanced)

Trigger a workflow after each spreadsheet edit. Requires creating an Apps Script in Google Sheets.

Create Preview

Create a preview of a postcard, notecard, or letter.

• Message
• Handwriting Style
• Type

Create Recipient

Create a recipient.

• Mailing List
• Name
• Address
• Address 2
• City
• Province
• Postal Code
• Country
• Dob
• Custom1
• Custom2

Delete Recipient

Remove a recipient.

List Build Image

Obtain a list of image builder.

List Handwriting Style

Obtain a list of handwriting styles.

• Handwriting Style ID
• Name

List Image Template

Obtain a list of image templates.

• ID
• User ID
• Sub Account ID
• Type
• Name
• Image
• Canva ID
• Default
• Created At
• Updated At

List Letters

Obtain a list of letters.

• ID
• Lob ID
• Title
• Front Image URL
• Front Thumbnail URL
• Back Image URL
• Back Thumbnail URL
• Available
• Default
• Created At
• Updated At

List Mailing List

Obtain a list of mailing lists.

• ID
• User ID
• Sub Account ID
• Type
• Description
• File
• Field Map
• Shape Data
• Total Recipients
• Processed
• Created At
• Updated At
• Leads Data
• Deleted At

List Message Template

Obtain a list of message templates.

• ID
• User ID
• Sub Account ID
• Handwriting Style ID
• Name
• Content
• Default
• Created At
• Updated At
• Type

Order Stats

Obtain a summary of stats for orders.

• Delivered
• Processing
• Printed
• In Transit
• In Local Area
• Processed For Delivery
• Re Routed
• Returned To Sender
• Failed
• Total Cost
• Total Requests
• Total Sent

Retrieve Letter

Grab all details about the letter.

• ID
• Lob ID
• Title
• Front Image URL
• Front Thumbnail URL
• Back Image URL
• Back Image URL
• Available
• Default
• Created At
• Updated At

Retrieve Mailing List

Grab all details about a mailing list.

• Current Page
• Data
• First Page URL
• From
• Last Page
• Last Page URL
• Next Page URL
• Path
• Per Page
• Prev Page URL
• To
• Total

Retrieve Order

Grab all details about an order.

• Order
• Stats
• Errors
• Returned

Retrieve Recipient

Grab all details about the recipient.

• ID
• Mailing List ID
• Session ID
• Name
• Address
• Address 2
• City
• Province
• Postal Code
• Country
• Dob
• Custom1
• Custom2
• Deliverability
• Can Deliver
• Created At
• Updated At
• Mailing List

Send Letter

Mail a letter to a customer.

• Center
• Distance
• Address Count
• Cost

Send Notecard

Mail a notecard to a customer.

• Type
• Message
• Email Cc
• Method
• Style
• Front Image
• Transaction ID
• Total Estimated Recipients
• Authorization Total
• Leads Fee
• Envelope ID
• Sub Account ID
• Return Name
• Return Address
• Return Address 2
• Return City
• Return Province
• Return Postal Code
• Allow Share
• Session ID
• User ID
• Updated At
• Created At
• ID
• Display Status
• Display Trigger
• Handwriting Image
• Share URL

Send Postcard

Mail a postcard to a customer.

• Type
• Message
• Email Cc
• Method
• Style
• Front Image
• Transaction ID
• Total Estimated Recipients
• Authorization Total
• Leads Fee
• Size
• Sub Account ID
• Return Name
• Return Address
• Return Address 2
• Return City
• Return Province
• Return Postal Code
• User ID
• Updated At
• Created At
• ID
• Display Status
• Display Trigger
• Handwriting Image

Update Recipient

Modify a recipient.

• Name
• Address
• Address 2
• City
• Province
• Postal Code
• Country
• Dob
• Custom1
• Custom2

Add Row

Add a row to an existing Google Sheets document.

• Spreadsheet ID
• Updated Range
• Updated Rows

Add Sheet

Add a new sheet to an existing Google Sheets spreadsheet

• Spreadsheet
• Sheet Name

Bulk Add Rows

Add multiple rows to a Google Spreadsheet

• Spreadsheet
• Sheet Name

Create New Spreadsheet

Create a new Google Sheets spreadsheet.

• Spreadsheet name
• Folder

Query Rows

List a selection of rows in a spreadsheet based on a query.

Update Row

Modify an existing row in your spreadsheet.