Name: Simple Event Listing feed from Google Sheets
Availability: InStock
Author: pjaudiomv

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.

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 
&#8211; Basic Usage: <code>[simple_event_sheets]</code> 
 * 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. 
 * <code>event_info</code>: Additional information about the event, displayed next to the event name. 
 * <code>day_info</code>: Additional information about the day of the event, displayed next to the date. 
 * Regarding the Google API Key: You&#8217;ll need an API key with Spreadsheet access. The sheet should either be set to &#8220;anyone with the link can view&#8221; or you should add a service user. If you&#8217;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. <a href="https://docs.google.com/spreadsheets/d/18NnmKKU7P6bFOPEHgyUMWeKQWQJnAfYb5gmn0-fne1E/" rel="nofollow ugc">https://docs.google.com/spreadsheets/d/18NnmKKU7P6bFOPEHgyUMWeKQWQJnAfYb5gmn0-fne1E/</a>
<h3>Third-Party Service Disclosure</h3>
This plugin relies on a third-party service, Google Sheets, to function properly. The plugin fetches data from Google Sheets under the following circumstances:
<ul>
<li>When retrieving event data to display within the application.</li>
</ul>
<h3>Service Information</h3>
<ul>
<li>Service: <a href="https://developers.google.com/sheets/api" rel="nofollow ugc">Google Sheets API</a></li>
<li>Terms of Use: <a href="https://developers.google.com/terms/" rel="nofollow ugc">Google API Terms of Use</a></li>
<li>Privacy Policy: <a href="https://policies.google.com/privacy" rel="nofollow ugc">Google Privacy Policy</a></li>
</ul>
<h3>Creating a Google API Key with Sheets API Access</h3>
<ol>
<li>
Go to the Google Cloud Console:
<ul>
<li>Open the Google Cloud Console at <a href="https://console.cloud.google.com/" rel="nofollow ugc">console.cloud.google.com</a>.</li>
</ul>
</li>
<li>
Create a New Project:
<ul>
<li>Click on the project dropdown and select &#8220;New Project&#8221;.</li>
<li>Enter a project name and click &#8220;Create&#8221;.</li>
</ul>
</li>
<li>
Enable the Sheets API:
<ul>
<li>With your project selected, go to the <a href="https://console.cloud.google.com/apis/library" rel="nofollow ugc">API Library</a>.</li>
<li>Search for &#8220;Google Sheets API&#8221; and click on it.</li>
<li>Click &#8220;Enable&#8221; to enable the API for your project.</li>
</ul>
</li>
<li>
Create API Credentials:
<ul>
<li>Go to the <a href="https://console.cloud.google.com/apis/credentials" rel="nofollow ugc">Credentials</a> page.</li>
<li>Click &#8220;Create Credentials&#8221; and select &#8220;API key&#8221;.</li>
<li>Your API key will be created. Copy it and keep it safe.</li>
</ul>
</li>
<li>
Restrict Your API Key:
<ul>
<li>Click on the edit icon next to your API key.</li>
<li>Under &#8220;Key restrictions&#8221;, select either &#8220;HTTP referrers (web sites)&#8221; or IP (server).</li>
<li>Add the referrer(s) for your site, such as <code>https://yourdomain.com/*</code> or Server IP.</li>
<li>Save your changes.</li>
</ul>
<ol>
<li>Set Spreadsheet Access:</li>
</ol>
<ul>
<li>Ensure your Google Sheet is either set to &#8220;anyone with the link can view&#8221; or you should add a service user with the necessary permissions. This step is crucial for the API key to access the data.</li>
</ul>
</li>
</ol>
<h3>MORE INFORMATION</h3>
<a href="https://github.com/pjaudiomv/simple-event-sheets" rel="nofollow ugc">https://github.com/pjaudiomv/simple-event-sheets</a>

Alternative Plugins for

Discover the Lists with Simple Event Listing feed from Google Sheets