Start with a trigger
Select a trigger that sets your workflow in motion.
This could be anything from a new order in your Shopify store to a customer signing up for your newsletter.
Triggers are the starting points that tell MESA when to act.
Google Sheets to Yotpo Loyalty Automations | MESA
Google Sheets to Yotpo Loyalty Automations
MESA is the most flexible way automate Google Sheets to Yotpo Loyalty. Easily add workflows to simplify your work.
Build your own workflows.
MESA helps you make workflows that keeps your business running. A trigger is the event to start a workflow then, actions are performed.
-
Topic
-
Name
-
Redemption
-
Redemption Option
-
Email
-
Customer
-
Perk
-
Topic
-
Name
-
Redemption
-
Redemption Option
-
Email
-
Customer
-
Topic
-
Name
-
Email
-
Customer
-
Topic
-
Name
-
Email
-
Customer
-
Perk
-
Redemption
-
Redemption Option
-
Topic
-
Name
-
Email
-
Customer
-
Topic
-
Name
-
Redemption
-
Redemption Option
-
Email
-
Customer
-
Topic
-
Name
-
Redemption
-
At Checkout
-
Is Pos
-
Redemption Option
-
Redemption Option ID
-
Redemption Option Name
-
Email
-
Customer
-
Topic
-
Name
-
Email
-
Customer
-
Topic
-
Name
-
Email
-
Customer
-
Perk
-
Redemption
-
Redemption Option
-
Topic
-
Name
-
Email
-
Customer
-
Previous Balance
-
Current Balance
-
Difference
-
Added Or Removed
-
Points Changed Reason
-
Topic
-
Name
-
Email
-
Customer
-
Perk
-
Topic
-
Name
-
Email
-
Customer
-
Points Needed
-
Redemption Option
-
Topic
-
Name
-
Point Redemption ID
-
Reward Text
-
Customer
-
Topic
-
Name
-
Redemption Option
-
Redemption Option ID
-
Redemption Option Name
-
Number Of Unused Codes
-
Topic
-
Name
-
Email
-
Customer
-
Redemption Option
-
Topic
-
Name
-
Perk
-
Email
-
Referrer
-
Referral Code
-
Referred Customer
-
Topic
-
Name
-
Email
-
Referral Link
-
Referral Code
-
From
-
Customer
-
Topic
-
Name
-
Email
-
From
-
Customer
-
Referral Link
-
Topic
-
Name
-
Email
-
Customer
-
Vip Stats
-
Vip Stats Needed Maintain
-
Vip Stats Needed Next
-
Topic
-
Name
-
Email
-
Customer
-
New Tier
-
Old Tier
-
Topic
-
Name
-
Email
-
Customer
-
Old Tier
-
New Tier
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.
Approve Point Redemption Cancellation
Confirm point redemption cancellation request.
-
ID
-
Email
-
First Name
-
Last Name
-
Phone Number
-
Country Iso Code
-
Has Account
-
Opted In
-
Opted In At
-
Pos Account ID
-
Tags
-
Customer Email
-
Customer ID
-
Total Amount Cents
-
Currency Code
-
Order ID
-
Status
-
Created At
-
Coupon Code
-
Ip Address
-
User Agent
-
Ignore Ip Ua
-
Discount Amount Cents
-
Tags
-
Clerk Employee ID
-
Clerk Name
-
Store Address
-
Store City
-
Store State
-
Channel Type
-
Items
-
Customer
-
Customer External ID
-
Customer Email
-
Phone Number
-
Redemption Option ID
-
Delay Points Deduction
-
Currency
-
Points To Redeem
-
ID
-
Order ID
-
Total Amount Cents
-
Items
-
Item
-
Currency
Delete Customer’s Anniversary
Remove customer’s set anniversary date.
-
ID
-
Merchant ID
-
Email
-
Referral Link
-
Referral Discount Code
-
Reward Points
-
Referral Receipts
-
ID
-
Created At
-
Updated At
-
Details
-
Expires At
-
Type
-
Username
-
Share Text
-
Entity ID
-
Hashtags
-
URL
-
Question
-
Title
-
Display Order
-
Default Email Body
-
Reward Text
-
Icon
-
Cta Text
-
Min Actions Required
-
Action Name
-
Ask Year
-
Max Completions Per User
-
Next Page Info
-
ID
-
Name
-
Description
-
Points Multiplier
-
Entry Threshold
-
Retain Threshold
-
Regain Threshold
-
ID
-
Created At
-
Updated At
-
Merchant ID
-
Customer ID
-
Type
-
Referral ID
-
Ip Address
-
User Agent ID
-
Parent Perk ID
-
Name
-
ID
-
Name
-
Description
-
Icon
-
Cost Text
-
Amount
-
Applies To Product Type
-
Duration
-
ID
-
Code
-
Third Party ID
-
Email
-
ID
-
Name
-
Description
-
Icon
-
Cost Text
-
Amount
-
Applies To Product Type
-
Duration
-
Type
-
Discount Amount Cents
-
Discount Rate Cents
-
Discount Percentage
-
Discount Type
-
Total Spend Cents
-
Total Purchases
-
Perks Redeemed
-
Last Purchase At
-
Email
-
Points Earned
-
Points Balance
-
Points Expire At
-
First Name
-
Last Name
-
Last Seen At
-
Thirty Party ID
-
Third Party ID
-
Pos Account ID
-
Has Store Account
-
Day
-
Month
-
Year
Send Referral Emails Referral Referrer
Share referral links by email to a list of email addresses.
Set Customer’s Anniversary
Establishes a customer’s anniversary.
Set Customer’s Birthday
Establish a customer’s birthday.
-
Spreadsheet ID
-
Updated Range
-
Updated Rows
-
Spreadsheet
-
Sheet Name
-
Spreadsheet
-
Sheet Name
-
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.
Thousands of professionals trust MESA to help them multiply their impact without multiplying their work.
Why automate Google Sheets to Yotpo Loyalty?
Google Sheets to Yotpo Loyalty automations get more done in less time. Automate the everyday tasks holding back your potential growth.
Automate Your Order Tracking
By integrating Google Sheets with your Shopify store, every new order will automatically appear in a designated spreadsheet. You'll gain immediate insights into sales, order statuses, and customer information, allowing you to stay on top of your orders and streamline your shipping process.
Sync Your Inventory in Real-Time
Link your Shopify's inventory data with Google Sheets to create a live inventory dashboard. Whenever you make a sale or adjust your stock in Shopify, your Google Sheets will automatically reflect these changes. This ensures accurate stock levels across different platforms and helps prevent overselling.
Personalize Your Marketing
Import customer data into Google Sheets to create specific segments based on purchase history or preferences. Create targeted email campaigns, personalized offers, or reward programs that resonate with customers. Make your marketing efforts more effective and engaging.
Gain Insights with Financial Reporting
Connect your Shopify store's financial data with Google Sheets to create tailored financial reports. Feed sales, revenue, expenses, taxes, and profit into Google Sheets, where you can apply your specific calculations and analyses. It’s an excellent tool to understand your financial performance and identify trends that impact your bottom line.
Collaborate on Your Product Catalog
Utilize Google Sheets as a central hub to manage your product catalog. With a direct connection to Shopify, any changes made in Google Sheets (like price updates or new product additions) are instantly mirrored in your store. This enables you and your team to work together on product management more seamlessly.
Loyalty Program Creation
Create customized loyalty programs that resonate with your brand. Offer points for purchases, referrals, social media engagement, and more. With Yotpo, managing these programs becomes seamless, attracting loyal customers and incentivizing repeat purchases.
Personalized Rewards
Offer personalized rewards to your customers based on their purchasing habits and interactions with your brand. Whether it's a special birthday discount or exclusive access to new products, Yotpo Loyalty helps you create offers that make customers feel valued.
UGC Reviews
Leverage the power of social proof by integrating customer reviews and user-generated content within your loyalty program. Reward customers for leaving reviews, sharing photos, or engaging on social media, building trust and enhancing your brand image.
Real-Time Analytics & Insights
Gain valuable insights into your customers' behavior and the performance of your loyalty program. Yotpo's real-time analytics help you understand what drives customer loyalty, enabling you to make informed decisions to further enhance your program.
Multi-Channel Engagement
Engage your customers across various channels, from email to social media, and provide a consistent experience wherever they interact with your brand. Yotpo helps create targeted marketing campaigns that resonate with your audience, building lasting connections.
Automate your work in less clicks
MESA makes automation achievable so you can multiply your impact without multiplying the work.
Try MESA for free 7-day trial included. Cancel anytime.How MESA works
MESA helps you connect two or more apps to handle repetitive tasks automatically, no code necessary.
Step 1.
Step 2.
Add an action
Next, choose the action that should follow the trigger.
Actions are the tasks that MESA will perform automatically, such as sending a confirmation email or updating your product inventory.
Linking actions to triggers is how you build a seamless workflow process.
Step 3.
Personalize
Make your workflow even more flexible using built-in apps.
Customize your automation with tools that match your specific needs, whether it's scheduling theme changes or syncing with your CRM.
Personalization ensures your workflows fit your unique business requirements.
All set!
You just made a workflow
Finally, enable your workflow. You've just automated a task that will save you time and reduce manual effort.
With MESA, complex processes become simple, freeing you up to focus on what matters most—growing your business.
Learn how to automate Yotpo Loyalty
Learn how to automate Google Sheets
Fully supported by automation experts.
Get help from our team of experts and industry partners, who are dedicated to ensuring your MESA experience is smooth, efficient, and tailored to your exact business needs.
