Black Friday: 40% off every Pro planGet 40% off

Export WordPress Users to Google Sheets

Available in: Free and Pro (imports, real-time sync and schedules need Pro)

The Users data type exports your WordPress users to Google Sheets.

Fields

User ID, Username, Email, Display Name, First Name, Last Name, Nicename / Slug, Website URL, Registration Date, Role, Bio / Description and Locale.

Filters

  • Role: all roles or one role.
  • Registered from and registered to dates.

Real-time sync (Pro)

Real-time jobs can send a row when a user registers, updates their profile or is deleted.

Import (Pro)

Import jobs create or update users from a sheet, with User ID, Username, Email, Password, Display Name, First Name, Last Name, Nickname, Nicename, Website URL, Bio, Role and Locale.

  • Unique key: User ID, email or username.
  • Settings: default role, how passwords are handled, whether to send a welcome email, whether to update roles of existing users, and whether to delete users whose rows are removed from the sheet.

Imports can change accounts and roles, so test with a copy of your sheet and a few rows first.

Ideas

  • Audit user roles and registration dates.
  • Keep a member list in a shared sheet.

Was this page helpful? If something is unclear or missing, tell the developer.