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 syncs Notion databases with Google Sheets.
- Utilizes Sheets formulas to send and manage data in Notion.
- Enables syncing a Google Sheet to a Notion table effortlessly.
- Connects specific cells in Sheets with Notion blocks for dynamic interaction.
- Maintains a seamless, real-time link between Google Sheets and Notion data.