The Users provider in SyncSheets allows you to export your WordPress user data to Google Sheets. This is useful for auditing, reporting, and managing your site members.
Available Fields
- User ID — The unique WordPress user ID.
- Username — The login username.
- Email — The user’s email address.
- First Name — User’s first name from their profile.
- Last Name — User’s last name from their profile.
- Display Name — The publicly displayed name.
- Role — The user’s WordPress role (administrator, editor, subscriber, etc.).
- Registration Date — When the user registered.
- Website — The user’s website URL.
- Bio — The user’s biographical description.
Filtering Options
Filter users by role to export specific groups (e.g., only subscribers, or only customers).
Real-time Sync
Enable real-time sync to automatically add new users to your Google Sheet as they register. Updates to user profiles are also synced in real time.
Export Only
For security reasons, the Users provider supports export only. User data cannot be imported from Google Sheets to prevent unauthorized account creation.
Example Use Cases
- Export a list of all subscribers for newsletter management.
- Create a member directory in Google Sheets.
- Audit user roles and registration dates.
- Track new user signups in real time.