This task can be performed using Sync2Sheets
Give Notion the superpowers of Google Sheets
Best product for this task

Sync2Sheets
productivity
Keep your databases from Notion automatically in sync with Google Sheets. Use Sheets formulas to send data to Notion, sync a sheet to a table and even connect cells with Notion blocks for dynamic dashboards.
What to expect from an ideal product
- Automatically sync data from Notion to Google Sheets.
- Use Google Sheets formulas to update Notion data.
- Sync entire sheets with Notion tables for seamless integration.
- Connect individual cells in Google Sheets with Notion blocks.
- Create interactive and dynamic dashboards by leveraging Notion's flexibility.