{"id":405468,"date":"2024-07-26T08:00:00","date_gmt":"2024-07-26T08:00:00","guid":{"rendered":"https:\/\/www.weixiaoduo.com\/plugins\/simple-event-listing-feed-from-google-sheets\/"},"modified":"2025-07-15T02:48:00","modified_gmt":"2025-07-15T02:48:00","slug":"simple-event-listing-feed-from-google-sheets","status":"publish","type":"post","link":"https:\/\/www.weixiaoduo.com\/plugins\/simple-event-listing-feed-from-google-sheets\/","title":{"rendered":"Simple Event Listing feed from Google Sheets"},"content":{"rendered":"

Simple Event Listing feed from Google Sheets<\/strong> is a plugin designed to fetch event data from a Google Spreadsheet and display it on your website.<\/p>\n

SHORTCODE
\n\u2013 Basic Usage: [simple_event_sheets]<\/code>
\n * Ensure your Google Sheet has the row headers: date, name, url, event_info, day_info<\/code>. 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.
\n * event_info<\/code>: Additional information about the event, displayed next to the event name.
\n * day_info<\/code>: Additional information about the day of the event, displayed next to the date.
\n * Regarding the Google API Key: You\u2019ll need an API key with Spreadsheet access. The sheet should either be set to \u201canyone with the link can view\u201d or you should add a service user. If you\u2019re utilizing server-side event loading, restrict the key by server IP. For client-side loading, restrict the key by domain.<\/p>\n

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\/<\/a><\/p>\n

Third-Party Service Disclosure<\/h3>\n

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