Did you enable the Google Sheets API for your custom Google Cloud project?
Basically do this, but also enable the Google Sheets API: https://www.make.com/en/help/apps/file-and-document-management/google-drive
Try deleting your current connection and set a new one up with your custom Google Cloud project, that has Google Drive/Sheets API enabled.