I'm here to share some details about the user access for the Spreadsheet Sync feature, @joeyf-createroom.
When accessing the Spreadsheet Sync in QuickBooks Online Advance, only the admin users can open and manage the file. That's the reason why you're unable to pull any data if you don't log in using the admin rights.
To earn about the different options for user roles and access permissions, check out these articles:
I've collected these articles for more tips on how to use the Spreadsheet Sync feature in QBOA:
You can always get back to me here if you have any other questions. We'll be around to lend a helping hand. Have a lovely day, @joeyf-createroom.
