Hello @Prajakta, in regards to your exact expectation of exporting directly to google sheets, that may not work exactly as anticipated. You may be able to create a function internally to make that happen, but I do know there has been some added functionality to export data programmatically. I’ll link the blog post from AWS on those update.
There is another option as well to manually export tables and pivot tables as an Excel File or CSV that you could then import into google sheets.
I will mark this response as a solution for now, but if you run into issues implementing this please let me know!