hey, sorry - I was away on vacation for a while and so I missed your last reply.
As long as the Google Account that was used to connect the sheets in the first place is a member of the new team, then everything should continue to work fine.
- Go to your Projects Dashboard and identify the Project that you want to transfer
- Click the 3 dots in the upper right
- Select “Transfer to…” and select the team