Shata Solutions
← Back to marketplace
E-commerce Automation

Cross Sell

Recommend complementary products in post-purchase emails and packing slip inserts via QR.

Automation overview

What this automation does

This automation starts when shopify order fulfilled webhook + weekly association refresh. It webhooks process via webhooks, google sheets process via google sheets, x (twitter) process via x (twitter), and klaviyo post, then selects top 3 in-stock cross-sells, embeds in Klaviyo post-purchase email day 3, generates unique QR on packing slip PDF linking to collection landing page with.

Trigger
Shopify order fulfilled webhook + weekly association refresh
Main actions
Webhooks process via Webhooks → Google Sheets process via Google Sheets …
Final outcome
selects top 3 in-stock cross-sells, embeds in Klaviyo post-purchase email day 3,…
Execution time
30–90 seconds
Apps used
5 integrations
AI-powered
No
Difficulty
Advanced
Advanced
Workflow diagram

End-to-end scenario flow

Read-only visualization of how data moves from trigger to final result.

Trigger
Shopify
Scheduled run
Step 1
Webhooks
Process via Webhooks
Step 2
Google Sheets
Process via Google Sheets
Step 3
X (Twitter)
Process via X (Twitter)
Step 4
Klaviyo
Post
Result
Klaviyo
Workflow complete
Step-by-step

How each step runs

  1. 1
    ShopifyTrigger
    Scheduled run

    Shopify order fulfilled webhook + weekly association refresh

  2. 2
    Webhooks
    Process via Webhooks

    Order fulfillment webhook queries association rules mined weekly from order line co-occurrence in BigQuery or Sheets

  3. 3
    Google Sheets
    Process via Google Sheets

    Order fulfillment webhook queries association rules mined weekly from order line co-occurrence in BigQuery or Sheets

  4. 4
    X (Twitter)
    Process via X (Twitter)

    customers who bought X also bought Y

  5. 5
    Klaviyo
    Post

    selects top 3 in-stock cross-sells, embeds in Klaviyo post-purchase email day 3, generates unique QR on packing slip PDF linking to collection landing page with

  6. 6
    Klaviyo
    Workflow complete

    selects top 3 in-stock cross-sells, embeds in Klaviyo post-purchase email day 3, generates unique QR on packing slip PDF linking to collection landing page with

Apps used

Connected applications

Shopify

Process via Shopify

Webhooks

Process via Webhooks

Google Sheets

Process via Google Sheets

X (Twitter)

Process via X (Twitter)

Klaviyo

Post

Summary

Automation summary

Trigger
Shopify order fulfilled webhook + weekly association refresh
Inputs
Shopify order fulfilled webhook + weekly association refresh, Business Name, Notification Email, Timezone
Outputs
selects top 3 in-stock cross-sells, embeds in Klaviyo post-purchase email day 3, generates unique QR on packing slip PDF linking to collection landing page with, X (Twitter) process via X (Twitter), Klaviyo post
Business goal
Automate cross sell end-to-end with accurate app routing.
Execution frequency
Weekly
Estimated runtime
30–90 seconds
Error handling
Failed steps retry up to 3 times with exponential backoff; persistent failures notify your configured channel and log to the run history.
Dependencies
Shopify, Webhooks, Google Sheets
Benefits

Why use this automation?

Save ~10 hours/week

Remove repetitive steps from Cross Sell so your team focuses on high-value work.

Reduce manual work

Connected apps sync data automatically instead of copy-paste between dashboards.

Prevent human errors

Standardized logic runs the same way every time, with retries on failure.

Requirements

What you need to get started

Required apps

  • Shopify
  • Webhooks
  • Google Sheets

Required accounts

  • Active Shopify workspace with API access
  • Active Webhooks workspace with API access
  • Active Google Sheets workspace with API access
  • Shata Automation workspace (free tier supported)

Required API keys

  • OAuth tokens for each connected integration

Permissions

  • Read access on trigger sources (forms, sheets, webhooks, or CRM objects)
  • Write access on destination apps (email, chat, CRM, or storage)

Estimated setup time

  • 30 min including app authorization and test run
  • Difficulty: Advanced

Optional apps

  • X (Twitter) (optional)
  • Klaviyo (optional)

Automation runtime

Activate this template

PartialSome steps run in preview until their integrations go live.

Connect required apps via OAuth or API keys. Credentials are encrypted server-side. Dev test runs mock external actions when connections are missing.

Draft
0%
Activation readiness

Est. setup time: ~14 min

Required connections

  • Shopify(required)
    PreviewShopify: workflow actions run in preview
    Missing
  • webhooks(required)
    Previewwebhooks: workflow actions run in preview
    Missing
  • Google Sheets(required)
    Missing
  • x(required)
    Previewx: workflow actions run in preview
    Missing
  • Missing connection: Shopify
  • Missing connection: webhooks
  • Missing connection: Google Sheets
  • Missing connection: x
Manage all connections →View all installations →

Workflow summary

Trigger
Shopify order fulfilled webhook + weekly association refresh
Steps
6 nodes
Required apps
4
Optional apps
1

Trigger

Schedule trigger

Activate this workflow to provision the trigger endpoint.

Run history

No runs yet. Install the template and run a test, or activate to receive webhook/schedule runs.

FeaturedFreeAdvancedPartial30 min setup4.97.2k installs · 101 reviews
Customize for My Business
Analytics

Template performance

48.1k
Views
7.2k
Installs
48
Favorites
4.9
Avg rating
14.9%
Conversion
30 min
Setup time
96%
Success rate
99
Trending score
Most used integrations
ShopifyWebhooksGoogle Sheets

Order fulfillment webhook queries association rules mined weekly from order line co-occurrence in BigQuery or Sheets—customers who bought X also bought Y—selects top 3 in-stock cross-sells, embeds in Klaviyo post-purchase email day 3, generates unique QR on packing slip PDF linking to collection landing page with pre-applied bundle discount.

Some steps run in preview until their integrations go live.

Required apps
ShopifyPreviewWebhooksPreviewGoogle SheetsLiveX (Twitter)Preview
Optional apps
MailchimpPreview
All integrations
ShopifyWebhooksGoogle SheetsX (Twitter)Mailchimp
Workflow preview

How Cross Sell runs

1
Trigger
Refresh associations
2
Process
Rule engine
3
Action
shopify
4
Notify
Alert & log
ShopifyWebhooksGoogle SheetsXMailchimp
Setup steps

Get started in 5 steps

  1. 1
    Connect order and analytics

    Shopify fulfillments, BigQuery or Sheets co-purchase matrix, Klaviyo, PDF packing slip.

  2. 2
    Refresh associations

    Weekly job recalculates SKU pairs with min support count threshold.

  3. 3
    Filter in-stock only

    Inventory check before recommendation render.

  4. 4
    Configure packing slip QR

    Unique Bitly per order tracks scan-to-purchase attribution.

  5. 5
    Test recommendation quality

    Review top pairs manually before enabling auto-send.

Variables

Configurable settings

VariableTypeDefaultRequired
Business NametextYour BusinessYes
Notification EmailemailYes
TimezoneselectYes
Shopify Store DomaintextNo
Google Sheet IDtextNo
Sheet RangetextSheet1!A:ZNo
FAQ

Frequently asked questions

Seasonal pairs?

Season tag on association rules deprioritizes off-season items.

Same category only?

Config excludes same-category pairs to diversify basket.

B2B orders?

Cross-sell disabled for wholesale customer tags.

Email vs insert only?

Toggle channels per product margin strategy.

Get started

Customize Cross Sell for your business

Our team can adapt this template to your exact workflow, apps, and brand requirements.