Is there any way through which I can directly pull the data from google sheets into my content manager?

What exactly do you mean by “connect Google Sheets to the Content Manager”? The Google Sheets Integration package provides a way to access Google sheets. You then will need to develop the code for the rest of the functionality - reading and writing data from the sheets, etc.