@brandonscottgardner, once you have the account connected with the automated feeds open your Balance History sheet and turn on the filter and filter it by both the automated instance of the account and the manual instance.
Make sure the Account ID column is unhidden and then replace the manual Account ID with the automated Account ID for ALL balance history entries. This will merge the manual account with the automated account and retain your net worth history.