How to Log New WordPress Users to a Google Sheet

A spreadsheet of sign-ups is easy to filter, share and chart. Zapify appends a row for every new account with the free A user registers trigger and the Add a row to a spreadsheet action. Google Sheets is a Zapify PRO integration.

What this automation does

The automation is one trigger plus one action:

Trigger: A user registers (WP_USER_REGISTERS, WordPress)
Action: Add a row to a spreadsheet (GOOGLESHEETS_APPEND_ROW, Google Sheets)

When a new account is created, Zapify adds a row to your spreadsheet with the details you chose.

Before you start

A Google account with access to the destination spreadsheet.
The spreadsheet's Spreadsheet ID — the long string in its URL, between /d/ and /edit.

PRO feature

Google Sheets is a Zapify PRO integration and needs a Connection under Settings → Connections. The A user registers trigger itself is free.

How to build the automation

Step 1: Connect Google Sheets

Google Sheets connects by signing in rather than pasting a key.

Go to Settings → Connections and click Add New.

Connections Tab

Choose Google Sheets and click Connect.
Sign in with the Google account that has access to your sheet, and approve the permissions Google asks for.

Google Sheets "Client ID" & "Client secret"

See Connections for more on how OAuth connections work and how to reconnect one that expires.

Step 2: Create a new automation

In the WordPress admin, go to Zapify → Automations.
Click Add New to open the builder.
Name it clearly, such as Log new users to a sheet.

Create a new automation

Step 3: Add the "A user registers" trigger

Click Add Trigger.

Choose WordPress as the app.

Select WordPress as the trigger

Select A user registers.

Select A user registers

Step 4: Add the "Add a row to a spreadsheet" action

Click Add Action.

Choose Google Sheets as the app.

Select Google Sheets as the action

Select Add a row to a spreadsheet.

Select Add a row to a spreadsheet

Step 5: Configure the action

Field	Required	What it does
Connection	Yes	The Google account you connected in Step 1.
Spreadsheet ID	Yes	The long ID from the sheet's URL.
Sheet name	No	The tab to append to. Defaults to the first one.
Columns	Yes	One entry per column, left to right — insert User email, Display name and Registration date tokens.

Match the order of your Columns entries to the order of the columns in your sheet — the first entry becomes the first column, and so on.

Values that look like formulas are escaped

A submitted value that starts with =, +, -, or @ would otherwise be read by Sheets as a formula. Zapify escapes these automatically so it lands in the sheet as text.

Step 6: Set the steps Live and save

Each trigger and action has its own Live / Off / Draft switch. A new automation starts as a Draft and does nothing until its steps are Live.

Set the trigger and every action to Live.
Click Save.

Step 7: Test it

Register a test account. A new row should appear in the sheet within a minute, or open Zapify → Logs to see the response.

Tokens you can use

Token	What it holds
User email	The new account's email address.
Display name / First name / Last name	Name parts, if set.
Username	The login name.
Registration date	When they registered.

Conclusion

With the free A user registers trigger and the Add a row to a spreadsheet action, you keep a running record of sign-ups without exporting anything. For forms, see logging WPForms submissions to a Google Sheet.

FAQs

Is this free in Zapify?

The trigger is free. The Google Sheets action needs an active Zapify PRO licence and a Connection.

Can I add a header row?

Add it by hand once in the sheet. Zapify only appends new rows beneath what is there.

My connection stopped working. Why?

Google access can be revoked from Google's side. Reconnect it from Settings → Connections. See Connections.

Do I need to write any code?

No. Everything is set up visually.