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.