Simple Event Listing feed from Google Sheets

Simple Event Listing feed from Google Sheets is a plugin designed to fetch event data from a Google Spreadsheet and display it on your website.

Author:	pjaudiomv (profile at wordpress.org)
WordPress version required:
WordPress version tested:	6.8.2
Plugin version:	1.1.0
Added to WordPress repository:	26-07-2024
Last updated:	14-07-2025
Rating, %:	0
Rated by:	0
Plugin URI:	https://wordpress.org/plugins/simple-event-li...
Total downloads:	1 001
Click to start download

Simple Event Listing feed from Google Sheets is a plugin designed to fetch event data from a Google Spreadsheet and display it on your website.

SHORTCODE
– Basic Usage: [simple_event_sheets]
* Ensure your Google Sheet has the row headers: date, name, url, event_info, day_info. The date should be formatted as mm/dd/yyyy. Implement data validation on the date and url rows to prevent errors. Note: This plugin also offers built-in data validation.
* event_info: Additional information about the event, displayed next to the event name.
* day_info: Additional information about the day of the event, displayed next to the date.
* Regarding the Google API Key: You’ll need an API key with Spreadsheet access. The sheet should either be set to “anyone with the link can view” or you should add a service user. If you’re utilizing server-side event loading, restrict the key by server IP. For client-side loading, restrict the key by domain.

You can use this Google Sheet as a template if wanted, it includes data and url validation to help ensure good data quality. https://docs.google.com/spreadsheets/d/18NnmKKU7P6bFOPEHgyUMWeKQWQJnAfYb5gmn0-fne1E/

Third-Party Service Disclosure

This plugin relies on a third-party service, Google Sheets, to function properly. The plugin fetches data from Google Sheets under the following circumstances:

When retrieving event data to display within the application.

Service Information

Service: Google Sheets API
Terms of Use: Google API Terms of Use
Privacy Policy: Google Privacy Policy

Creating a Google API Key with Sheets API Access

Go to the Google Cloud Console:
- Open the Google Cloud Console at console.cloud.google.com.
Create a New Project:
- Click on the project dropdown and select “New Project”.
- Enter a project name and click “Create”.
Enable the Sheets API:
- With your project selected, go to the API Library.
- Search for “Google Sheets API” and click on it.
- Click “Enable” to enable the API for your project.
Create API Credentials:
- Go to the Credentials page.
- Click “Create Credentials” and select “API key”.
- Your API key will be created. Copy it and keep it safe.
Restrict Your API Key:
- Click on the edit icon next to your API key.
- Under “Key restrictions”, select either “HTTP referrers (web sites)” or IP (server).
- Add the referrer(s) for your site, such as https://yourdomain.com/* or Server IP.
- Save your changes.
1. Set Spreadsheet Access:
- Ensure your Google Sheet is either set to “anyone with the link can view” or you should add a service user with the necessary permissions. This step is crucial for the API key to access the data.