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

1. Go to the Google Cloud Console:

   • Open the Google Cloud Console at console.cloud.google.com.

2. Create a New Project:

   • Click on the project dropdown and select “New Project”.
   • Enter a project name and click “Create”.

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

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

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

MORE INFORMATION

https://github.com/pjaudiomv/simple-event-sheets

Screenshots

Categories