I recently imported employee data from Google Sheets into ERPNext, and everything worked fine. However, after the initial import, new employees have filled out the form in Google Sheets, and their names now appear in the Data Import Page in ERPNext.
My question: How can I push/import these new employees into the Employee List in ERPNext?
Currently, I can see their names in the import page, but I don’t know how to process them so they appear in the system as new employees.
Is there a way to update only the new entries without affecting the existing records?
Employee data is personally identifiable data and if you used the Google Sheets upload method - which requires that it be public - you are currently sharing that with the entire internet.
Don’t push them into ERPNext from Google sheets on an ongoing basis and enter the data directly into ERPNext instead. Let ERPNext/ HRMS be the source of truth for your HR data instead of Google Sheets.
Hi, you need to set public link at Google sheets, if you upload your data with excel, csv or google sheets you have an ID (unique) for each record and an ID for Employee I setup HR Settings with Employee number, so I use the same ID and Employee Number for each record
I would strongly discourage you from broadcasting your employees’ information on the internet. That’s what a public link to a google sheet means. @friveroll While this will work, it’s bad advice.
