Freemius

javmah

<h4>This Plugin Integrates, Automates, Sync & displays Google Sheets with WordPress and its most popular plugins.</h4>
WordPress events like new user registration, delete user, new post, update post, new page, user login, user logout, new database table row along with <a href="https://wordpress.org/plugins/advanced-custom-fields/" rel="ugc">Advanced Custom Fields</a> fields. This plugin also integrates <a href="https://wordpress.org/plugins/woocommerce/" rel="ugc">WooCommerce</a>, <a href="https://wordpress.org/plugins/contact-form-7/" rel="ugc">Contact form 7</a>, <a href="https://wordpress.org/plugins/ninja-forms/" rel="ugc">ninja form</a>, <a href="https://wordpress.org/plugins/formidable/" rel="ugc">Formidable</a>, <a href="https://wordpress.org/plugins/fluentform/" rel="ugc">Fluent forms</a>, <a href="https://wordpress.org/plugins/wpforms-lite/" rel="ugc">WPform</a>, <a href="https://www.gravityforms.com/" rel="nofollow ugc">gravity form</a>, <a href="https://wordpress.org/plugins/forminator/" rel="ugc">forminator form</a> submission events with <a href="https://www.google.com/sheets/about/" rel="nofollow ugc">Google Sheets</a>.
This plugin also UPDATES / CREATES WordPress posts, pages, users, WooCommerce products, WooCommerce orders, and Database table rows from Google Sheets. *
<pre><code>Spreadsheet Integration is the First & Only Google service 
account Authenticated plugin in the WordPress plugin 
repository. Now you don't have to give permission to 3rd 
party, More secure & reliable. Just share your Spreadsheet 
with your own service account. No need expensive Zapier or 
ITTF for WordPress Google Spreadsheet Integration.
</code></pre>
<h3>🔝 KEY FEATURES</h3>
<ol>
<li>
Unlimited integrations: Create as many integrations as you want and collect all the data you need with as many fields you want.
</li>
<li>
One click Update WordPress site: Just click your Google Spreadsheets to update WordPress Post and Page ! Awesome !!
</li>
<li>
Privacy and Security: Very Secure, just share your google sheet with service account email address, no 3rd party authentication access, the private sheet only.
</li>
<li>
Drop Down & Select: Build the integrations of your dream with its fully featured Drop Down & Select options.
</li>
<li>
Auto Google Spreadsheet & Worksheet: No need to copy or past sheet name just select more safe.
</li>
<li>
No restrictions on Event fields : There is No restrictions on Event fields, you can pass your won text via fields.
</li>
<li>
One Click Google Spreadsheet Columns title Create : just click to create integrated sheet column titles.
</li>
<li>
Auto-sync : Auto-sync Google sheet data and display data as table content in your post or page.
</li>
<li>
Google <a href="https://cloud.google.com/iam/docs/service-accounts" rel="nofollow ugc">service account</a> Authentication : Spreadsheet Integration is the first & only one service account Authenticated plugin in the WordPress plugin repository .
</li>
</ol>
<blockquote>
‘The professional version of this plugin is also the Best plugin for integrating WooCommerce with Google Sheets. It supports almost all data sources of WooCommerce. You can easily sync WooCommerce event data to Google Sheets and be able to bulk update wooCommerce products from Google Sheets. You can use the professional version for 7 days as a free trial.’
</blockquote>
<h3>🏆 STANDARD INTEGRATIONS EVENTS</h3>
<ul>
<li>
Update WordPress Post & Page from Google Sheets.
</li>
<li>
Contact form 7 forms submission to Google Sheets.
</li>
<li>
WordPress New user registration to Google Sheets.
</li>
<li>
WordPress User Profile Updates to Google Sheets.
</li>
<li>
WordPress User Login to Google Sheets.
</li>
<li>
WordPress User Logout to Google Sheets.
</li>
<li>
WordPress Delete User Profile to Google Sheets.
</li>
<li>
WordPress New post to Google Sheets.
</li>
<li>
WordPress update post to Google Sheets.
</li>
<li>
WordPress New page to Google Sheets.
</li>
<li>
WordPress New Comment to Google Sheets.
</li>
<li>
WordPress Edit Comment to Google Sheets.
</li>
<li>
WooCommerce New order to Google Sheets (not all fields).
</li>
<li>
WooCommerce Order status change to Google Sheets (not all fields ).
</li>
<li>
WooCommerce new product to Google Sheets (most of the Fields not all).
</li>
<li>
Display Google sheet on your WordPress Page and Post as a searchable and sortable table with daily auto sync.
</li>
</ul>
Thanks: 💖 Heartiest Gratitude to all of my users who inspired me and suggest me and compliment me in many ways, you guys are Awesome. Without yours support and love it was impossible to maintain this huge codebase. Please accept my sincere thanks.
<h3>Creating Integration</h3>
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/Cr0D_zU6adw?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe>
<h3>Update / Create WordPress data from Google Sheet</h3>
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/84gTttWN4vo?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe>
<h3>Google API and Service account Creation</h3>
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/ylUE1t3bkqs?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe>
<h3>🔥 ADVANCE PROFESSIONAL INTEGRATIONS</h3>
<ol>
<li>
<a href="https://wordpress.org/plugins/woocommerce/" rel="ugc">WooCommerce Google Sheet Connect[PRO]</a>: This plugin syncs WooCommerce new order, WooCommerce Orders status Change, WooCommerce new Product and Product information update data to google sheet.
</li>
<li>
<a href="https://wordpress.org/plugins/woocommerce/" rel="ugc">WooCommerce Product and Order Update from Google Sheets [PRO]</a>: One click update your WooCommerce Products and Orders from Google Sheet!
</li>
<li>
<a href="https://developer.wordpress.org/plugins/metadata/" rel="nofollow ugc">wordPress Meta data [PRO] </a>: In this plugins Professional version, you can able to integrate WordPress Metadata as an event data source! Wow
</li>
<li>
<a href="https://developer.wordpress.org/plugins/metadata/" rel="nofollow ugc">wordPress Meta data update from Google sheet [PRO] </a>: Professional version supports update Meta data from Google sheet.
</li>
<li>
<a href="https://www.gravityforms.com/" rel="nofollow ugc">Gravity Forms [PRO] </a>: This plugin sync gravity forms form submission data to google sheet.
</li>
<li>
<a href="https://wordpress.org/plugins/advanced-custom-fields/" rel="ugc">ACF- Advanced Custom Fields [PRO]</a>: Spreadsheet integration supports ACF data fields.
</li>
<li>
<a href="https://wordpress.org/plugins/ninja-forms/" rel="ugc">ninja form [PRO]</a>: Spreadsheet Integration supports ninja forms form submission data to google sheet.
</li>
<li>
<a href="https://wordpress.org/plugins/formidable/" rel="ugc">Formidable [PRO]</a>: Spreadsheet Integration supports Formidable forms form submission data to google sheet.
</li>
<li>
<a href="https://wordpress.org/plugins/wpforms-lite/" rel="ugc">WPform [PRO]</a>: Sync WP form submission data to google sheet.
</li>
<li>
<a href="https://wordpress.org/plugins/weforms/" rel="ugc">weForms [PRO]</a>: This plugin also syncs weForm form submission data to google sheet.
</li>
<li>
<a href="https://wordpress.org/plugins/forminator/" rel="ugc">Forminator [PRO]</a>: This plugin also syncs Forminator form submission data to google sheet.
</li>
<li>
<a href="https://wordpress.org/plugins/fluentform/" rel="ugc">Fluent Forms [PRO]</a>: This plugin also syncs Fluent Forms submission data to google sheet.
</li>
<li>
<a href="https://wordpress.org/plugins/custom-post-type-ui/" rel="ugc">Custom Post Type UI [PRO]</a>: This plugin plugin supports custom post type UI as Event source.
</li>
<li>
<a href="https://wordpress.org/plugins/custom-post-type-ui/" rel="ugc">Custom Post Type update from Google sheet [PRO]</a>: One click update your custom post type from connected google sheet.
</li>
<li>
<a href="https://codex.wordpress.org/Database_Description" rel="nofollow ugc">wordPress database table row [PRO] </a>: Professional version supports wordPress database table row sync to Google sheets. One click update / insert your Google sheet data to wordPress database.
</li>
<li>
[wordPress create / update USER [PRO]]: Professional version supports creating / updating user information from google sheet.*
</li>
<li>
[more option on Google sheet sync [PRO]]: Professional version supports More Frequency on google sheet sync and display as a Table in WordPress Page and Post.
</li>
</ol>

WPGSI: Spreadsheet Integration

This would probably be a five star plugin if it wasn't for the upgrade nags in the admin interface. Please don't hijack the admin interface. Put your upgrade notices inside the settings page.

EDIT: Can't reproduce this because I have dismissed the notice already. I will give you the benefit of the doubt. Maybe I just imagined it.

good but has unnecessary admin notifications


This plugin is great. It is so powerful & is very useful for managing a large amount of posts. I had a few issues, and the plugin developer was able to quickly answer and solve my issues for me. I am so thankful for the plugin developers talent. 


Excellent plugin and support!!

Google sheet two-way sync 🔄 WordPress | WooCommerce | Contact form 7 | DB table | Google sheet as a Table.

Dan D

Dan’s Google Sheets Data Embedder was created out of a need for non-technical users to move complex calculations outside WordPress and into a more familiar spreadsheet environment, as well as the ability to share just the pieces of information needed from a spreadsheet rather than sharing the entire document.
Dan’s GSheets allows you to embed the values for either an individual cell, or for ranges directly via shortcode. No need to import data or manage it directly in WordPress. All you need is a public Google Sheets Document (or multiple!) and a free, easy to get API key.
Suggested Uses
<ul>
<li>
Offload all of your complex calculations to Google Sheets! Take data from Google forms, or wherever else you wish, and just display the results
</li>
<li>
Have a non-techinical client or user that needs to be able to update a specific message? Just map that spot to a Google Sheets Cell via shortcode, and share that document with them with edit abilities
</li>
<li>
Create a nice front end in WordPress, and update live scores via Google Sheets as a spreadsheet
</li>
<li>
Did you come up with something else? We’d love to hear about it! Share in your review or via a message on my site.
</li>
</ul>
Features
<ul>
<li>
Displays public Google Sheet Document data in an easy-to-format view
</li>
<li>
Live updates on page load. Just change your data in your sheet, and it’s live on site!
</li>
<li>
Displays cells or ranges of cells from any public Google Sheet
</li>
<li>
Individual cells are displayed as spans
</li>
<li>
Spans of cells displayed as tables, with optional headers
</li>
<li>
Can target any tab within a Google Sheets document
</li>
<li>
Able to use shortcode multiple times per post / page
</li>
<li>
All options are configured via shortcode
</li>
<li>
Ability to store and use unlimited Google Sheet Documents
</li>
</ul>
Shortcodes:
<ul>
<li>
Basic: <code>[dansheet]</code> (defaults to first document, default tab name)
</li>
<li>
Single Cell: <code>[dansheet file=1 sheetname="Sheet1" cell=A1 class="gsheets-special"]</code>
</li>
<li>
Range of Cells: <code>[dansheet file=1 sheetname=Sheet1 cell=A1:C2 theaders="Col 1,Col 2,Col 3" class="gsheets-special2"]</code>
</li>
</ul>
Optional Attributes
<ul>
<li>
file=# (number of the Google Doc you have set in the settings page)
</li>
<li>
sheetname= name of sheet in doc
</li>
<li>
cell (mandatory)= Cell Number or range, with :
</li>
<li>
class=custom class name or names here
</li>
<li>
theaders = Comma seperated list of column headers, in order, for range view (optional)
</li>
</ul>
For help creating an API key to use with this plugin, either check out the settings page in plugin, or the FAQ tab here.
To see other plugins like this, or tips on how these are built, check out <a href="https://blog.dandulaney.com/" rel="nofollow ugc">my blog</a>.
<h3>Dependencies and Liscencing</h3>
Depends on Google Sheets JSON API v4

Dan's GSheets Data Embedder

Dan's GSheets is used to embed Google Sheets data from individual cells or ranges, in a manner that will update on page reload.

WPGSI: Spreadsheet Integration vs Dan's GSheets Data Embedder