WPSyncSheets For Core

WordPress Google Spreadsheet Addon

How to Import Users?

This block will give you information on how to import users.

To perform import user operations you must have to enable the import users option from the user settings tab.

Once you have enabled the import users option then there are 3 new options. Insert User, Update User, and Delete User.

Insert User, Update User, and Delete User will automatically add insert, update and delete sheet headers.

After saving settings, Our plugin code will auto-add sheet headers respectively.

1. Update User

    If you want to update any user row then add 1 in the update column from a spreadsheet.

    Here is an example to show you how you can update users. In this example, we changed the user with 2 user Id.

    Original Sheet

    • User FirstName test to Testing
    • User LastName testing to Last
    • User Nickname test testing to TestingLast
    • User Biographical Info test to Biographical Info
    • Update to 1

    For example, you can make changes as per your need. You must have to add 1 within the Update column of the spreadsheet.

    Whenever you try to update any user data from a spreadsheet keep in mind that User Username and User Profile Image values can not be changed from the spreadsheet so if you want to change User Profile Image then you have to edit it from the backend. Username , EmailID, and Nickname are mandatory fields for updating user data so it can not be passed blank.

    Once you have made changes within your spreadsheet with your need, you need to click on Import User and follow the below steps.

    Updated Spreadsheet

    2. Insert User

    If a user wants to add a new user via spreadsheet then the user must add 1 within the Insert column of the spreadsheet. Please make sure you have added the User Username within the row as the user wants to insert it. Username and EmailID are mandatory for a new user and they must be unique values.

    Updated Spreadsheet

    3. Delete User

    To perform the delete user operation then need to add 1 in the delete column of that User Id row within the spreadsheet.

    Please ensure you have added 1 to the correct User ID row as you want to delete that user.

    Updated Spreadsheet

    Get the best support while using WPSyncSheets For Core
    to sync posts with Google Spreadsheet.
    Copyright © 2021 WPSyncSheets. All Rights Reserved.
    Disclaimer: WPSyncSheets is an independent product by Creative Werk Designs. It does not represent WooCommerce, Elementor, Contact Form 7, Gravity Forms, Fluent Forms, Formidable Forms and WPForms websites.