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.

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. 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.

• 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.

MORE INFORMATION

com/pjaudiomv/simple-event-sheets