Yes. It can be automated, abdqbo1.
We can connect the bank account that has your Shopify transactions. Once connected, the transactions will automatically be downloaded on your QuickBooks Online account.
I've added these references that have detailed information in connecting your bank account:
As always, I've got your back if ever you need help in connecting your bank. Have a great day!