Spreadsheet Reader
Choose Your Plan
Spreadsheet Reader – Google Sheets Table Plugin
Spreadsheet Reader is a powerful and user-friendly WordPress plugin that lets you seamlessly fetch and display data from Google Sheets as dynamic tables on your website. With a simple shortcode, you can integrate live spreadsheet data without the hassle of manual updates.
Effortless Data Management
Tired of making constant website updates for your clients? With Spreadsheet Reader, your clients can simply update a Google Spreadsheet, and the changes will automatically appear on your website—no need for manual edits or deployments. This makes content management easier, faster, and more efficient!
Key Features
- Fetch Data from Google Sheets – Connect to Google Sheets using an API key and display real-time data effortlessly.
- Custom Shortcodes – Easily generate shortcodes to display specific sheet data anywhere on your site.
- Sheet & Cell Selection – Define the sheet name and cell range to fetch only the necessary data.
- Bricks Builder Integration – Seamlessly integrates with Bricks Builder, allowing dynamic spreadsheet data within Bricks’ Query Loop.
- Caching Support – Improve performance with built-in caching and customizable refresh intervals.
How It Works
- Get Your Google Sheets API Key – Set up your API key in the plugin settings.
- Create a Shortcode – Specify the spreadsheet ID, sheet name, and cell range.
- Insert the Shortcode – Use it in posts, pages, or within Bricks’ Query Loop.
- Optimize Performance – Enable caching and set refresh intervals for better speed.
(See the documentation below for a full setup guide.)
Perfect for: business reports, inventory tracking, price lists, schedules, and any live spreadsheet-based content!
API Call Limits & Optimization
Google Sheets API enforces a rate limit of 100 requests per user per second. If too many API calls are made within a short time, you may experience errors or temporary restrictions from Google.
How to Avoid API Limits:
- Enable Caching – Use the built-in caching feature to minimize repeated API requests.
- Optimize Data Requests – Fetch only the necessary data range instead of the entire sheet.
- Limit Page Refreshes – Reduce unnecessary page reloads that trigger multiple API calls.
Exceeding API limits may result in temporary request blocks by Google. Make sure to optimize your API usage for 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.
