WC Affiliate Integration as a Trigger

WC Affiliate Integration: WC Affiliate is a WooCommerce plugin that lets you easily create, manage, and grow your own affiliate program, including tracking referrals, setting commissions, and handling payouts.

Bit Integrations is a WordPress plugin that can help you automate and integrate your WC Affiliate with over 346+ popular platforms, including Zoho CRM, Zoho Sheet, ActiveCampaign, Airtable, Agiled CRM, Copper CRM, Capsule CRM, HubSpot, Groundhogg, Google Drive, Google Sheet, and MailPoet.

In this tutorial, I’ll show you how to automate WC Affiliate with Bit Integrations in 9 steps:

1. Create A New Integration
2. Select WC Affiliate as the Trigger app
3. Add Google Sheets as an Action app
4. Authorize the connection
5. Prepare the sheets
6. Select the spreadsheets and worksheets
7. Field mapping
8. Save the integration
9. Integration log

Step 1: Create a New Integration

Go to your WordPress dashboard and open Bit Integrations. From the Bit Integrations dashboard, click the Create Integration button to start creating a new automation. This is where you will connect WC Affiliate with Google Sheets.

Step 2: Select WC Affiliate as the Trigger

On the trigger selection screen, search for WC Affiliate and select it.

 After selecting WC Affiliate, choose the event you want to automate. This means the integration will run only when you add or edit the selected event in WC Affiliate. In this case, we selected Affiliate Application Rejected.

After choosing the event, click the Fetch button. While the Fetch button is spinning, submit the selected event from your WC Affiliate plugin.

Once the data fetching is completed, click Set Action to continue.

Step 3: Select Google Sheets as the Action

After successfully fetching the form submission data, click on “Set Action” to choose where you want to send the form submission data.

Search for Google Sheets from the action app list and select it. In this workflow, Google Sheets will work as the action app, where the user registration data will be saved automatically.

Step 4: Authorize the Google Sheets Connection

After selecting Google Sheets as an action, you will be redirected to the authorization page. Enter your Google Client ID and Client Secret, then click Authorize. If you are unsure how to obtain these credentials, follow the Google Sheets authorization guide.

After successful authorization, click Next to continue

Step 5: Prepare Your Google Sheet

Before mapping the fields, make sure your Google Sheets is ready. Open Google Sheets and create a spreadsheet with the columns you want to use.

For this example, the spreadsheet has two columns: Affiliate ID  and User Name. These column names will appear inside Bit Integrations during field mapping, so keep the header row clear and simple. You can add more columns based on the data you want to store.

Step 6: Select the Spreadsheet and Worksheet

Now return to the Bit Integrations setup screen. Select the Google Spreadsheet where you want to store the WC Affiliate data. Then choose the correct Worksheet.

Step 7: Field Mapping

In the Map Fields section, match the data fetched from WC Affiliate with the correct Google Sheets columns.

For example, map the Affiliate ID field from WC Affiliate to the Affiliate ID column in Google Sheets. Then map the WP Display Name field to the User Name column.

This tells Bit Integrations exactly where each piece of submitted data should be placed in the sheet. After mapping all required fields, click Next.

Step 8: Save the Integration

After setting up the integration according to your preferences, click the “Finish & Save” button to save the integration.

Your WC Affiliate to Google Sheets integration is ready. From this point, whenever the selected WC Affiliate event is submitted, Bit Integrations will send the data to your selected Google Sheets automatically.

Step 9: Integration Log

Every integration provides a timeline where you can review its activity and see whether the Integration was successful or if any errors occurred.