To use the Spreadsheet Reader plugin, you need to obtain your Spreadsheet ID from Google Sheets. Follow these simple steps:

Step 1: Open Your Google Sheet

1. Go to Google Sheets.
2. Open the spreadsheet that you want to display on your website.

Step 2: Change Sharing Settings

1. Click File > Share > Share with others.
2. Under the General Access section, select Anyone with the link.
3. Click Copy link, then click Done.

Step 3: Extract the Spreadsheet ID

The Spreadsheet ID is a unique string found in your Google Sheets URL. After copying the link, look for a format like this:

https://docs.google.com/spreadsheets/d/1iC0pIm3FBsjOtIACrcKtPS2BejOQ62Re9Ftk1M2bRZ8/edit?gid=0#gid=0

Here, the Spreadsheet ID is the long string between /d/ and /edit:

1iC0pIm3FBsjOtIACrcKtPS2BejOQ62Re9Ftk1M2bRZ8

Step 4: Paste the Spreadsheet ID into the Plugin

Now, return to your WordPress site and go to Settings > Spreadsheet Reader. Paste the Spreadsheet ID in the appropriate field when creating a shortcode.

Done! You can now use this ID to fetch and display spreadsheet data on your website using shortcodes.