How to Send Ultimate Member Data to Googlesheets

Googlesheets is a platform platform. Ultimate Member manages a user registers or updates their profile, but sending that data to external platforms needs an integration. AFI bridges that gap to Googlesheets.

Why not just use Zapier?

For connecting Ultimate Member to platform, a cloud automation service adds cost and a dependency on an external server. AFI runs on your site with no task limits.

What you will need

• A WordPress site with Ultimate Member installed and configured.
• A Googlesheets account.
• The Advanced Form Integration plugin (free from WordPress.org).

Connect Googlesheets to AFI

Googlesheets uses OAuth 2.0 for authentication. In AFI → Settings → Googlesheets, click Authorize and grant access. This is a one-time step.

Setting up the integration

1. Create a new integration

Go to AFI → Add New. Name it Ultimate Member to Googlesheets.

2. Pick your trigger

Select Ultimate Member as the form provider. AFI fires when a user registers or updates their profile, giving you access to user name, email, username, account type, and custom profile fields.

3. Select Googlesheets as the destination

Choose Googlesheets from the platform dropdown and pick Add Record. This creates a record in Googlesheets.

4. Map fields

Match each Googlesheets field on the left to the corresponding Ultimate Member field on the right. Common mappings include user name, email, username, account type, and custom profile fields. You can also use smart tags like {{_submission_date}}.

5. Add conditions if needed

Only want to send certain records? Set up a conditional rule based on any field value.

6. Save and test

Click Save Integration. Trigger a test event in Ultimate Member. Check Googlesheets to confirm the data arrived. If anything looks wrong, open AFI → Log to see the exact request and response.

Free vs Pro

The free version maps name and email to Googlesheets with unlimited records. Pro adds custom field mapping. No per-record fees on any plan.

Frequently asked questions

Which Ultimate Member events trigger the integration?

AFI fires when a user registers or updates their profile. This covers new submissions and relevant status changes.

Will adding this slow down my site?

No. AFI sends data to the destination after the event completes. Your site performance is not affected.

Can I send data to multiple platforms?

Yes. Create a separate integration for each destination, and every record flows to all of them simultaneously.

Get started

Install Advanced Form Integration free from WordPress.org and connect Ultimate Member to Googlesheets in minutes.