Go to your Dashboard · Opt-in to Plugins > Add New. Search for ‘Sheets to WP Table Live Sync’ Click install and Activate the plugin.
Then go to the create table from Opt-in ‘Sheets to Table’ > ‘Create Table +’ button then select google spreadsheet, put the table name and also put the URL from the spreadsheet. like

After paste the link hit on the ‘Fetch Data’ like

After fetching the data you will see the table and go next with some basic setup and finally hit on the ‘Save & Use Table’ button. Like

- Use table data with shortcode
- Click on Pages > Add New and then write title and hit on the ‘add block’ to search shortcode then paste shortcode that you have copied from table dashboard. Like

Then ‘Publish’ and view the page with a new tab. You will see the table.
- Use table data with Gutenberg:
- Click on Pages > Add New and then write title and hit on the ‘add block’ to search ‘Sheets to WP Live Table Sync’ then click on it to select ‘Choose Table’ and see left middle corner to select the created table. Like

Select the table and ‘Publish’ the page and see with a new tab.
- Use Create New Table on Gutenberg
- Click on the Pages > Add New and then write title and hit on the ‘add block’ to search ‘Sheets to WP Live Table Sync’ then click on it to get the ‘Create New +’ then set the table name and put the spreadsheet URL and Fetch Data. Like

After fetching data click on ‘Publish’ and see a new page.