I have more than one Account connected in Integration Services Connections, but when I try to use the ‘Use Google Spreadsheet’ activity and select one of the accounts, my only option is ever the ‘Default’ account.
Currently, my only resolution is to change which account is marked Default in Integration Service, but for the Google Sheet connection(s) to be scalable and usable, that is a prohibitive long term solution.