Stakeholders can gain access to the connected BigQuery project by being granted access by the project owner. This will allow them to manipulate the data in Google Sheets.