{"id":196396,"date":"2024-07-26T01:41:01","date_gmt":"2024-07-26T01:41:01","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/simple-event-listing-feed-from-google-sheets\/"},"modified":"2025-07-14T18:48:04","modified_gmt":"2025-07-14T18:48:04","slug":"simple-event-listing-feed-from-google-sheets","status":"publish","type":"plugin","link":"https:\/\/oci.wordpress.org\/plugins\/simple-event-listing-feed-from-google-sheets\/","author":15235348,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"1.1.0","stable_tag":"1.1.0","tested":"6.8.5","requires":"","requires_php":"8.0","requires_plugins":null,"header_name":"Simple Event Listing feed from Google Sheets","header_author":"pjaudiomv","header_description":"A plugin that displays Event Listings.","assets_banners_color":"c4d1a5","last_updated":"2025-07-14 18:48:04","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"https:\/\/wordpress.org\/plugins\/simple-event-listing-feed-from-google-sheets\/","header_author_uri":"https:\/\/github.com\/pjaudiomv\/simple-event-sheets\/","rating":0,"author_block_rating":0,"active_installs":0,"downloads":1157,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","changelog"],"tags":{"1.0.0":{"tag":"1.0.0","author":"pjaudiomv","date":"2024-07-26 01:40:43"},"1.0.1":{"tag":"1.0.1","author":"pjaudiomv","date":"2024-07-31 21:47:38"},"1.0.2":{"tag":"1.0.2","author":"pjaudiomv","date":"2025-05-29 04:19:30"},"1.1.0":{"tag":"1.1.0","author":"pjaudiomv","date":"2025-07-14 18:48:04"}},"upgrade_notice":[],"ratings":[],"assets_icons":{"icon-256x256.png":{"filename":"icon-256x256.png","revision":3125599,"resolution":"256x256","location":"assets","locale":""}},"assets_banners":{"banner-772x250.png":{"filename":"banner-772x250.png","revision":3125606,"resolution":"772x250","location":"assets","locale":""}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0.0","1.0.1","1.0.2","1.1.0"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":3126628,"resolution":"1","location":"assets","locale":""},"screenshot-2.png":{"filename":"screenshot-2.png","revision":3126628,"resolution":"2","location":"assets","locale":""},"screenshot-3.png":{"filename":"screenshot-3.png","revision":3126630,"resolution":"3","location":"assets","locale":""}},"screenshots":{"1":"screenshot-1.png","2":"screenshot-2.png","3":"screenshot-3.png"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[31552,1486,25296],"plugin_category":[40],"plugin_contributors":[154957],"plugin_business_model":[],"class_list":["post-196396","plugin","type-plugin","status-publish","hentry","plugin_tags-event-listing","plugin_tags-events","plugin_tags-google-sheets","plugin_category-calendar-and-events","plugin_contributors-pjaudiomv","plugin_committers-pjaudiomv"],"banners":{"banner":"https:\/\/ps.w.org\/simple-event-listing-feed-from-google-sheets\/assets\/banner-772x250.png?rev=3125606","banner_2x":false,"banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/simple-event-listing-feed-from-google-sheets\/assets\/icon-256x256.png?rev=3125599","icon_2x":"https:\/\/ps.w.org\/simple-event-listing-feed-from-google-sheets\/assets\/icon-256x256.png?rev=3125599","generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/simple-event-listing-feed-from-google-sheets\/assets\/screenshot-1.png?rev=3126628","caption":"screenshot-1.png"},{"src":"https:\/\/ps.w.org\/simple-event-listing-feed-from-google-sheets\/assets\/screenshot-2.png?rev=3126628","caption":"screenshot-2.png"},{"src":"https:\/\/ps.w.org\/simple-event-listing-feed-from-google-sheets\/assets\/screenshot-3.png?rev=3126630","caption":"screenshot-3.png"}],"raw_content":"<!--section=description-->\n<p><strong>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\n<p>SHORTCODE\n- Basic Usage: <code>[simple_event_sheets]<\/code>\n    * Ensure your Google Sheet has the row headers: <code>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    * <code>event_info<\/code>: Additional information about the event, displayed next to the event name.\n    * <code>day_info<\/code>: Additional information about the day of the event, displayed next to the date.\n    * 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.<\/p>\n\n<p>You can use this Google Sheet as a template if wanted, it includes data and url validation to help ensure good data quality. <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/18NnmKKU7P6bFOPEHgyUMWeKQWQJnAfYb5gmn0-fne1E\/\">https:\/\/docs.google.com\/spreadsheets\/d\/18NnmKKU7P6bFOPEHgyUMWeKQWQJnAfYb5gmn0-fne1E\/<\/a><\/p>\n\n<h3>Third-Party Service Disclosure<\/h3>\n\n<p>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\n<ul>\n<li>When retrieving event data to display within the application.<\/li>\n<\/ul>\n\n<h3>Service Information<\/h3>\n\n<ul>\n<li><strong>Service:<\/strong> <a href=\"https:\/\/developers.google.com\/sheets\/api\">Google Sheets API<\/a><\/li>\n<li><strong>Terms of Use:<\/strong> <a href=\"https:\/\/developers.google.com\/terms\/\">Google API Terms of Use<\/a><\/li>\n<li><strong>Privacy Policy:<\/strong> <a href=\"https:\/\/policies.google.com\/privacy\">Google Privacy Policy<\/a><\/li>\n<\/ul>\n\n<h3>Creating a Google API Key with Sheets API Access<\/h3>\n\n<ol>\n<li><p><strong>Go to the Google Cloud Console:<\/strong><\/p>\n\n<ul>\n<li>Open the Google Cloud Console at <a href=\"https:\/\/console.cloud.google.com\/\">console.cloud.google.com<\/a>.<\/li>\n<\/ul><\/li>\n<li><p><strong>Create a New Project:<\/strong><\/p>\n\n<ul>\n<li>Click on the project dropdown and select \"New Project\".<\/li>\n<li>Enter a project name and click \"Create\".<\/li>\n<\/ul><\/li>\n<li><p><strong>Enable the Sheets API:<\/strong><\/p>\n\n<ul>\n<li>With your project selected, go to the <a href=\"https:\/\/console.cloud.google.com\/apis\/library\">API Library<\/a>.<\/li>\n<li>Search for \"Google Sheets API\" and click on it.<\/li>\n<li>Click \"Enable\" to enable the API for your project.<\/li>\n<\/ul><\/li>\n<li><p><strong>Create API Credentials:<\/strong><\/p>\n\n<ul>\n<li>Go to the <a href=\"https:\/\/console.cloud.google.com\/apis\/credentials\">Credentials<\/a> page.<\/li>\n<li>Click \"Create Credentials\" and select \"API key\".<\/li>\n<li>Your API key will be created. Copy it and keep it safe.<\/li>\n<\/ul><\/li>\n<li><p><strong>Restrict Your API Key:<\/strong><\/p>\n\n<ul>\n<li>Click on the edit icon next to your API key.<\/li>\n<li>Under \"Key restrictions\", select either \"HTTP referrers (web sites)\" or IP (server).<\/li>\n<li>Add the referrer(s) for your site, such as <code>https:\/\/yourdomain.com\/*<\/code> or Server IP.<\/li>\n<li>Save your changes.<\/li>\n<\/ul>\n\n<ol>\n<li><strong>Set Spreadsheet Access:<\/strong><\/li>\n<\/ol>\n\n<ul>\n<li>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.<\/li>\n<\/ul><\/li>\n<\/ol>\n\n<h3>MORE INFORMATION<\/h3>\n\n<p><a href=\"https:\/\/github.com\/pjaudiomv\/simple-event-sheets\">https:\/\/github.com\/pjaudiomv\/simple-event-sheets<\/a><\/p>\n\n<!--section=installation-->\n<p>This section describes how to install the plugin and get it working.<\/p>\n\n<ol>\n<li>Download and install the plugin via the WordPress dashboard, or upload the entire <strong>Simple Event Listing feed from Google Sheets<\/strong> folder to <code>\/wp-content\/plugins\/<\/code>.<\/li>\n<li>Activate the plugin through the 'Plugins' menu in WordPress.<\/li>\n<li>Insert the <code>[simple_event_sheets]<\/code> shortcode into your WordPress page or post.<\/li>\n<\/ol>\n\n<!--section=changelog-->\n<h4>1.1.0<\/h4>\n\n<ul>\n<li>Added calendar view.<\/li>\n<\/ul>\n\n<h4>1.0.2<\/h4>\n\n<ul>\n<li>Updated release.<\/li>\n<\/ul>\n\n<h4>1.0.1<\/h4>\n\n<ul>\n<li>Updated event and day info.<\/li>\n<\/ul>\n\n<h4>1.0.0<\/h4>\n\n<ul>\n<li>Initial Release<\/li>\n<\/ul>","raw_excerpt":"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.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/oci.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/196396","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oci.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/oci.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/oci.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=196396"}],"author":[{"embeddable":true,"href":"https:\/\/oci.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/pjaudiomv"}],"wp:attachment":[{"href":"https:\/\/oci.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=196396"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/oci.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=196396"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/oci.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=196396"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/oci.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=196396"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/oci.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=196396"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/oci.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=196396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}