Add rows to a Google Sheet, find a row by a column's value, and update rows, from any workflow.
Triggers and actions
Every step Google Sheets adds to FlowWP, named and described as it appears in the editor, with the plan that includes it.
What a workflow can do in Google Sheets.
At the bottom of the tab, under the columns you name. An empty tab takes your column names as its header row.
The first row with a value in a column — an email, an order number. Found or not, the steps after can branch on it.
The first row with a value in a column. Only the columns you name change.
Updates the row with the value in the column you name, or adds one when there is none — one row per customer, say, kept up to date.
In FlowWP Pro, when you add a Google Sheets connection or run a Google Sheets step, FlowWP uses your service account key to get an access token from Google, then sends the rows it writes or looks up to the Google Sheets API.
Nothing runs until you activate a workflow, and every run is recorded step by step.
Templates
Trigger: An order is paid (WooCommerce)Every paid order becomes a row: its number, when it was paid, the customer, what they bought and the total. Point it at an empty tab and the first order writes the header row.
Trigger: A Contact Form 7 form is submitted (Contact Form 7)Each submission becomes a row, with when it came in and which form it came from. Uses the your-name, your-email, your-subject and your-message fields of Contact Form 7’s default form.
Trigger: A user is created (WordPress)Every new account becomes a row: when they joined, their name, username, email and role. A list to share with someone who has no login to the site.
Start with a template or a blank canvas. Nothing runs until you activate it.
