You can use Awesome Table Connectors to export data from Notion to Google Sheets by logging in with the Notion connector.
In the Awesome Table add-on Home screen, click Create new request.
The list of available connectors is displayed.
Open the Notion connector.
On the Connect to Notion screen, click Sign in with Notion.
On the Notion login page, choose the login method you want to use.
On the Notion authorization screen, click Select pages.
Select the pages in Notion from which you want to export, and click Allow access.Awesome Table informs you if your connection is successful.