Connected Sheets has some limitations, including a limit of 25,000 rows for data extraction and the highest refresh frequency being every hour. Additionally, stakeholders must have access to the connected BigQuery project in order to be able to manipulate the data in Google Sheets.