Use Bkper add-on for Google Sheets to quickly manage accounts. It's a direct way to import or export an existing chart of accounts between Bkper and Google Sheets. With this solution you can easily create accounts in batch.
Import accounts from Sheets to Bkper (Record)
On your computer, open a Google spreadsheet.
Click Add-ons > Bkper > Open.
Select your book.
Click Record tab.
Choose Accounts.
Highlight the cells you want to import data.
Click Record button.
That's it! Now, the accounts appear on your book.
Note: Observe that the account background on Sheets will have the same color as its Type if the "Highlight" checkbox is selected.