Shata Solutions
← Back to marketplace
E-commerce Automation

Price Update

Apply price changes from Sheets price master to all connected storefronts and marketplaces.

Automation overview

What this automation does

This automation starts when google Sheets price row approval checkbox checked. It box compare and x (twitter) compare, then current Shopify price; if delta >1% pushes update to Shopify variants, Amazon listing price API, Noon price endpoint, and WooCommerce, logs old/new in audit she.

Trigger
Google Sheets price row approval checkbox checked
Main actions
Box compare → X (Twitter) compare
Final outcome
current Shopify price; if delta >1% pushes update to Shopify variants, Amazon li…
Execution time
1–3 minutes
Apps used
6 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
Google Sheets
Event detected
Step 1
Box
Compare
Step 2
X (Twitter)
Compare
⑂
Router
Shopify
Pushes
Result
Slack
Workflow complete
Step-by-step

How each step runs

  1. 1
    Google SheetsTrigger
    Event detected

    Google Sheets price row approval checkbox checked

  2. 2
    Box
    Compare

    Google Sheets price row approval checkbox triggers compare vs.

  3. 3
    X (Twitter)
    Compare

    Google Sheets price row approval checkbox triggers compare vs.

  4. 4
    Shopify
    Pushes

    current Shopify price; if delta >1% pushes update to Shopify variants, Amazon listing price API, Noon price endpoint, and WooCommerce, logs old/new in audit she

  5. 5
    WooCommerce
    Pushes

    current Shopify price; if delta >1% pushes update to Shopify variants, Amazon listing price API, Noon price endpoint, and WooCommerce, logs old/new in audit she

  6. 6
    Slack
    Pushes

    current Shopify price; if delta >1% pushes update to Shopify variants, Amazon listing price API, Noon price endpoint, and WooCommerce, logs old/new in audit she

  7. 7
    Slack
    Workflow complete

    current Shopify price; if delta >1% pushes update to Shopify variants, Amazon listing price API, Noon price endpoint, and WooCommerce, logs old/new in audit she

Apps used

Connected applications

Google Sheets

Compare

Box

Compare

X (Twitter)

Compare

Shopify

Pushes

WooCommerce

Pushes

Slack

Pushes

Summary

Automation summary

Trigger
Google Sheets price row approval checkbox checked
Inputs
Google Sheets price row approval checkbox checked, Business Name, Notification Email, Timezone
Outputs
current Shopify price; if delta >1% pushes update to Shopify variants, Amazon listing price API, Noon price endpoint, and WooCommerce, logs old/new in audit she, Box compare, X (Twitter) compare
Business goal
Automate price update end-to-end with accurate app routing.
Execution frequency
On demand with batch fallback
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
Google Sheets, Box, X (Twitter)
Benefits

Why use this automation?

Save ~4 hours/week

Remove repetitive steps from Price Update 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

  • Google Sheets
  • Box
  • X (Twitter)

Required accounts

  • Active Google Sheets workspace with API access
  • Active Box workspace with API access
  • Active X (Twitter) 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

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

Optional apps

  • Shopify (optional)
  • WooCommerce (optional)
  • Slack (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

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

Workflow summary

Trigger
Google Sheets price row approval checkbox checked
Steps
7 nodes
Required apps
4
Optional apps
2

Trigger

Manual trigger

Run workflows on demand via Test run or Live test. Activate to enable scheduled/webhook triggers on other templates.

Run history

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

FreeAdvancedPartial5 min setup★4.37.7k installs · 75 reviews
Customize for My Business
Analytics

Template performance

16.1k
Views
7.7k
Installs
402
Favorites
4.3
Avg rating
47.7%
Conversion
5 min
Setup time
92%
Success rate
67
Trending score
Most used integrations
Google SheetsBoxX (Twitter)

Google Sheets price row approval checkbox triggers compare vs. current Shopify price; if delta >1% pushes update to Shopify variants, Amazon listing price API, Noon price endpoint, and WooCommerce, logs old/new in audit sheet, and optional Slack notify if margin drops below floor from COGS column.

Some steps run in preview until their integrations go live.

Required apps
Google SheetsLiveBoxPreviewX (Twitter)PreviewShopifyPreview
Optional apps
WooCommercePreviewSlackLive
All integrations
Google SheetsBoxX (Twitter)ShopifyWooCommerceSlack
Workflow preview

How Price Update runs

1
Trigger
Load COGS for margin check
2
Process
Rule engine
3
Action
google-sheets
4
Notify
Alert & log
Google SheetsBoxXShopifyWoocommerceSlack
Setup steps

Get started in 5 steps

  1. 1
    Connect price endpoints

    Sheets price master, Shopify, Amazon, Noon, WooCommerce, Slack.

  2. 2
    Load COGS for margin check

    COGS column calculates margin; block update if below floor unless override flag.

  3. 3
    Map variant IDs

    Sheets SKU maps to each channel listing ID via lookup tab.

  4. 4
    Configure approval

    Checkbox requires manager role in Sheets or Slack approve for >10% changes.

  5. 5
    Test single SKU

    One approved row updates all channels within 10 minutes.

Variables

Configurable settings

VariableTypeDefaultRequired
Business NametextYour BusinessYes
Notification Emailemail—Yes
Timezoneselect—Yes
Shopify Store DomaintextNo
Slack Channeltext#generalNo
Google Sheet IDtextNo
Sheet RangetextSheet1!A:ZNo
FAQ

Frequently asked questions

Sale schedules?

Start/end datetime columns schedule compare-at and sale price automatically.

Currency per channel?

EGP, SAR, USD columns push to region-specific listings.

MAP pricing?

Minimum advertised price rule blocks discount below MAP in workflow.

Rollback?

Audit log `revert` checkbox restores previous price all channels.

Get started

Customize Price Update for your business

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

Request custom automation →Talk to an expert