AffiliatePress tracks affiliates, commissions and payouts inside WordPress. FlowMattic copies that activity to Google Sheets, so finance gets a commission ledger and a payout log, and managers can approve affiliates or record offline sales from a sheet. For store owners and affiliate managers who report from spreadsheets.
23 triggers 34 actions 7 example workflows 1 ready-made template Unlimited runs
When this happens in AffiliatePress17 triggers
Do this in Google Sheets19 actions
1. TriggerNew Commission Created2. ActionAdd New RowWhen AffiliatePress fires New Commission Created, FlowMattic runs Add New Row in Google Sheets with the data from that event.
You build this in the FlowMattic workflow builder on your own site. See the setup steps
Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.
Ready-made templateEvery commission is written with the affiliate, order reference, amount and status, giving finance a list for the weekly revenue report without logging in to WordPress.
New Commission CreatedAdd New Row
View the template Lookup Row Data finds the commission's row by its ID and Update Row changes the status, so the ledger shows what will actually be paid.
Commission Status ChangedLookup Row DataUpdate Row
New affiliates are listed with their details. When a manager sets the Decision column to approved or rejected, a second workflow changes the affiliate's status in AffiliatePress.
Update Specific Column ValueUpdate Affiliate Status
When a payment is marked paid, the affiliate, amount and date go to the payout tab, which becomes the record your accountant asks for at year end.
Payment Marked PaidAdd New Row
A Schedule reads the affiliate roster with Get Rows, loops over it and pulls visits, commissions and unpaid totals for each one into their row.
ScheduleGet RowsIteratorGet Affiliate StatsUpdate Row
Sales from events or phone orders never pass through checkout. Add them as rows with the affiliate's ID and amount, and Create Commission records each one in AffiliatePress.
New Spreadsheet RowCreate Commission
When an affiliate is approved, their referral link to your main landing page is built and written with their name and email to the roster tab your marketing team shares.
Affiliate ApprovedGet Affiliate Referral LinkAdd New Row
At the end, every new AffiliatePress commission is added to your ledger sheet as a row.
Create a sheet with columns for commission ID, affiliate, order reference, amount, status and date.
Under Connects, add a Google Sheets connection that can edit the ledger. AffiliatePress runs on your site and needs no connection.
Create a workflow with the AffiliatePress New Commission Created trigger and make a test referral sale so FlowMattic captures a commission.
Add Add New Row, map the commission fields to the ledger columns, test the step and switch the workflow on.
1. Trigger in AffiliatePress
New Commission Created
2. Action in Google Sheets
Add New Row
Fields mapped from the earlier steps (a typical setup)
| From AffiliatePress | To Google Sheets |
|---|---|
| Commission ID | Commission ID |
| Affiliate ID | Affiliate |
| Reference | Order reference |
| Amount | Amount |
| Status | Status |
| Date | Date |
A trigger starts a workflow. An action is something FlowMattic does in the app as a step.
AffiliatePress and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.
Affiliate earnings and payout records move from your WordPress site to the sheet through your own server, with no outside automation account in between.
Runs are unlimited, so a promotion that produces thousands of commissions writes every row on the same FlowMattic plan.
Sheet triggers can approve affiliates and add commissions in AffiliatePress, so managers who live in spreadsheets need no WordPress login for routine work.
Create a workflow with the AffiliatePress New Commission Created trigger and add Google Sheets Add New Row. Map the commission ID, affiliate, amount and status to columns, and every new commission is added from then on.
Yes. Use the Google Sheets Update Specific Column Value trigger on a Decision column, then AffiliatePress Update Affiliate Status with the affiliate ID from the same row.
Yes. Run a workflow that loops over your affiliates with Iterator, calls Get Commissions for each one with the date range you need, and writes the results with Add New Row.
The commission, affiliate and payout events work with AffiliatePress itself. Only the steps marked [PRO], such as affiliate groups, custom rates and affiliate meta, need the Pro version.
Yes. Start from Commission Status Changed set to rejected, or Commission Deleted, find the row with Lookup Row Data and run Delete Row, or update its status if you prefer to keep a record.
Did not find your answer? You can browse the help center or ask us directly.
Google Sheets and Slack149 shared templates
Google Sheets and AI Agents26 shared templates
Google Sheets and Fluent Forms23 shared templates
Google Sheets and WooCommerce20 shared templates
Google Sheets and FluentCRM19 shared templates
Google Sheets and WPForms12 shared templates
Google Sheets and ActiveCampaign11 shared templates
Google Sheets and Gmail11 shared templatesInstall FlowMattic, connect both accounts and import a template. Every run stays on your own server.
30-day money-back guarantee Unlimited workflows and runs Self-hosted
Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. AffiliatePress integration 1.0.0, Google Sheets integration 2.2.4.
