🔄Workflow Routing

Two-Way Sync: Sheet Edits Reach WordPress

When someone edits a row in your Google Sheet, Two-Way Sync passes that row to your WordPress site. SheetLink's Lead Inbox uses it to keep a lead's status and owner in step with the sheet, WooCommerce Sync can use it to change an order's status or a product's price and stock, and your own code can use it for anything else.

Included in Pro$79/yr or $199 lifetime - also in Agency

Ships in SheetLink Pro, a separate plugin installed next to the free SheetLink Forms plugin. The free plugin contains no locked features.

Two-Way Sync: Sheet Edits Reach WordPress diagram

Key Benefits

Lead Status and Owner Follow the Sheet

With the Lead Inbox and the one-click Google connection, changing a lead's status or assigned-to cell in the sheet changes that lead in WordPress. The change is recorded in the lead's activity.

WooCommerce Orders and Products Follow the Sheet

With WooCommerce Sync, editing the status cell of an order row can move the order to that status, and editing the regular_price, sale_price or stock_quantity cell of a product row can change the product. Each is off until you switch it on, and only the cell you edit is acted on. It uses the Apps Script method. From SheetLink Pro 1.3.0.

An Action Hook for Everything Else

Every edited row is handed to WordPress on the sheetlinkwp_sheet_update action, with the spreadsheet ID, the row number and the row values by column heading. A developer can hook it to update posts, form entries or anything else. SheetLink does not change those by itself.

No Script With the One-Click Connection

If your site uses the one-click Google connection, SheetLink Pro reads the sheet on a schedule and finds the rows that changed. Nothing is installed in the sheet. For other sheets, a small Apps Script sends each edit as it is made.

Echo Suppression

Rows that SheetLink itself has just written are not reported back as edits, so a new submission does not come round again as a change.

How It Works

Two-Way Sync has two ways to notice an edit. With the one-click Google connection, SheetLink Pro reads the connected spreadsheet on a schedule, compares each row with what it saw last time, and reports the rows that changed. The check runs every 60 seconds at the earliest and covers the first 500 rows under the header of each tab it watches. WordPress runs scheduled tasks when someone visits the site, so on a quiet site the check can run later. Without the one-click connection, you paste a small Apps Script into the sheet. It sends the edited row to SheetLink's relay, which checks your licence and passes the row to your site. Either way the plugin lists the edit under Recent incoming updates and fires the sheetlinkwp_sheet_update action. Out of the box, two parts of SheetLink act on an edit. The Lead Inbox follows a lead's status and owner. From SheetLink Pro 1.3.0, WooCommerce Sync can change an order's status and a product's price and stock, once you switch that on; it needs the Apps Script method, because the script says which cell was edited and the scheduled check does not. Form entries, posts and users are not changed unless your own code does it. Two-Way Sync works with Google Sheets, not Excel.

Real-World Use Cases

Sales Marking Leads as Contacted

Sales reps work through leads in a shared Google Sheet. When a rep changes a lead's status to Contacted or Qualified, or puts a colleague in the assigned-to column, the lead in the SheetLink Lead Inbox changes to match. The status has to be one the Lead Inbox knows (New, Contacted, Qualified, Won, Lost or Spam) and the owner has to match a WordPress user.

Fulfillment Team Marking Rows

Your fulfillment team works in the orders sheet that WooCommerce Sync fills. When someone changes the status cell of an order row to completed, the order is completed in WooCommerce, which sends its usual email to the customer. You choose which statuses the sheet may set, and a note typed into another cell of the row changes nothing.

Content Team Managing Submissions

A content team triages submissions in Sheets and marks entries 'Approved' or 'Rejected'. Two-Way Sync passes each edit to WordPress, where a developer's code on the action hook can change the entry or send an email. SheetLink does not do that step itself.

Feature Comparison

FeatureOne-Way (Core)Two-Way Sync
Data flowWordPress → Sheets onlyWordPress → Sheets, and sheet edits passed back
Sheet edits in WPNot seenPassed to an action hook and listed on the Two-Way Sync screen
Lead status and ownerChanged in WordPress onlyLead Inbox follows the sheet (one-click Google connection)
WooCommerce orders and productsNot changedStatus, price and stock can follow the sheet (WooCommerce Sync, Apps Script method)
Posts, form entries, usersNot changedNot changed unless your own code does it
Loop preventionN/ASheetLink's own writes are not reported back

Frequently Asked Questions

What does Two-Way Sync change in WordPress?

By itself, two things. With the Lead Inbox and the one-click Google connection, a lead's status and owner follow edits made in the sheet. With WooCommerce Sync, from SheetLink Pro 1.3.0, an edit to the status cell of an order row can change the order's status, and an edit to a price or stock cell of a product row can change the product, once you switch that on. Every edit is also passed to the sheetlinkwp_sheet_update action hook and listed on the Two-Way Sync screen. Form entries, posts and users are not changed unless a developer adds code on that hook.

Can I change a WooCommerce order by editing the sheet?

Yes, from SheetLink Pro 1.3.0, with WooCommerce Sync and the Two-Way script in the sheet. Edit the status cell of an order row and the order moves to that status. It is off until you switch it on, you choose which statuses the sheet may set, and WooCommerce sends its usual customer emails as it would for a change made on the order screen. Setting an order to Refunded records a refund but does not send money back through the payment gateway.

Why does the sheet need version 2 of the script for WooCommerce?

Because one order has several rows in the sheet, each holding the status the order had at that moment. Version 2 of the script tells your site which cell was edited, so a change is applied only when the status, price or stock cell itself was edited. A sheet still running the earlier script keeps working for everything else, and WooCommerce changes from it are ignored.

What is echo suppression?

When SheetLink writes a row to the sheet, that write would otherwise look like an edit. With the Apps Script method the plugin remembers what it sent for 60 seconds and drops an incoming edit with the same values. With the one-click connection it records each row it writes, so the next check does not report it.

Can I choose which columns sync?

No. Two-Way Sync passes the whole edited row, every column by its heading. The Lead Inbox reads two of them, the status column and the assigned-to column, and you can set their headings in Lead Settings. WooCommerce Sync reads four: status on an order row, and regular_price, sale_price and stock_quantity on a product row, and only when that cell is the one that was edited. Your own code can read any column.

How fast do Sheets edits reach WordPress?

With the Apps Script method the edited row is sent as each edit is made. With the one-click connection the sheet is checked every 60 seconds at the earliest. WordPress runs scheduled checks when someone visits the site, so a quiet site can take longer.

Does Two-Way Sync work with shared Google Sheets?

Yes. It does not matter who edits the sheet. Each edited row is passed on separately.

Does Two-Way Sync work with Excel?

No. It reads Google Sheets only.

Let sheet edits reach WordPress

The Lead Inbox follows status and owner changes made in the sheet, WooCommerce orders and products can follow it too, and an action hook hands every edited row to your own code.