Spreadsheet Reader
Spreadsheet Reader is a WordPress plugin that allows you to fetch and display Google Sheets data effortlessly using shortcodes. Easily integrate tables or specific cell values into your site with caching support for optimized performance.
Choose Your Plan
Spreadsheet Reader – Google Sheets Table Plugin
Spreadsheet Reader is a powerful and easy-to-use WordPress plugin that allows you to fetch and display data from Google Sheets as dynamic tables on your website. With a simple shortcode, you can integrate live spreadsheet data without manual updates.
Features:
- Fetch Data from Google Sheets – Connect your Google Sheets using an API key and display real-time data effortlessly.
- Custom Shortcodes – Easily create and manage shortcodes to display specific sheet data.
- Sheet & Cell Selection – Define the sheet name and cell range to display only the necessary data.
- Bricks Builder Integration – Seamlessly connects Bricks Builder with spreadsheet data, enabling users to dynamically display and manipulate spreadsheet content within Bricks’ Query Loop.
- Caching Support – Improve performance by enabling caching with customizable duration.
How to Use:
- Get Your Google Sheets API Key – Set up your API key in the plugin settings.
- Create a Shortcode – Add a new shortcode by specifying the spreadsheet ID, sheet name, and cell range.
- Use the Shortcode – Insert
[spreadsheet_table id="your_shortcode_name"]in any post or page. - Customize Settings – Enable caching and set refresh intervals for optimized performance.
(See documentation below to setup the plugin.)
Perfect for business reports, inventory tracking, price lists, schedules, and any live spreadsheet-based content!
API Call Limits Warning
Google Sheets API has a rate limit of 100 requests per user per second. If your website makes too many API calls within a short period, you may receive errors or temporary restrictions from Google.
How to Avoid API Limits:
- Enable Caching – Use the caching feature in Spreadsheet Reader to reduce repeated API calls.
- Optimize Data Requests – Fetch only the necessary data range instead of the entire sheet.
- Limit Page Refreshes – Avoid unnecessary page reloads that trigger multiple API requests.
If you exceed the limit, Google may temporarily block further requests. Make sure to optimize your API usage to ensure smooth performance!
Save time and streamline your workflow with Spreadsheet Reader!
Frequently Asked Questions
How do I integrate the Spreadsheet Reader plugin with Bricks Builder?
To integrate the Spreadsheet Reader plugin with Bricks Builder, you need to use the Query Loop feature in Bricks and set the query type to Spreadsheet Reader. After enabling the loop on a Container, DIV, or Block, you can configure options like Shortcode Name and Query By (Row or Column). Then, use the dynamic tag {spreadsheet_get_content:<index>} to retrieve specific data.
For a detailed step-by-step guide, please refer to the full documentation: Bricks Spreadsheet Integration Documentation.
Is my Google API Key and Spreadsheet ID secure when using this plugin?
Yes, the Spreadsheet Reader plugin is designed with security in mind. Your Google API Key and Spreadsheet ID are stored securely in the WordPress database and are only accessible to administrators. Additionally:
-
API calls are made server-side, meaning your API Key is never exposed to frontend.
-
The plugin restricts access to sensitive settings using WordPress capabilities, ensuring that only users with administrator privileges can view or modify the API Key and spreadsheet configurations.
However, to enhance security further, we recommend restricting your API Key in the Google Cloud Console to only allow access from your website’s server IP or domain. This helps prevent unauthorized use of your key in case it ever gets leaked.
Is there a limit to how many times I can fetch data?
Yes, Google API has a limit of 100 requests per user per second. If you exceed this limit, Google may temporarily block your API requests. Enabling caching can help reduce excessive API calls.
Does this plugin work with private Google Sheets?
No, your Google Sheet must be set to “Anyone with the link can view” for the plugin to fetch data successfully. You can change this setting under File > Share > General Access in Google Sheets.
Can I try this plugin before purchasing?
We do not provide a trial version. However, if the plugin does not work as expected, you can request a refund within 14 days of purchase.
