Spreadsheet Integration – Connect Google Sheets With WordPress, WooCommerce & Most Popular Form Plugins.

ਵੇਰਵਾ

WordPress Google Sheets Integration, Connects WordPress events and it’s most popular plugin with Google Spreadsheet via Google API and
Service Account. WordPress events like new user registration, Delete user, New post, Update post, a New page, a user log in, and
user logout along with Advanced Custom Fields fields. It also Integrates
WooCommerce, Contact form 7, ninja form, Formidable & WPform submission events.

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.

Key Features

  • Unlimited integrations: Create as many integrations as you want and collect all the data you need with as many fields you want.
  • Drop Down & Select: Build the integrations of your dream with its fully featured Drop Down & Select options.
  • Auto Google Spreadsheet & Worksheet: No need to copy or past sheet name just select more safe.
  • No restrictions on Event fields : There is No restrictions on Event fields, you can pass your won text via fields.
  • One Click Google Spreadsheet Columns title Create : just click to create integrated sheet column titles.
  • Google service account Authentication : Spreadsheet Integration is the first & only one service account Authenticated plugin in the WordPress plugin repository .
  • Privacy and Security: Very Secure, just share your google sheet with service account email address, no 3rd party authentication access, the private sheet only.

Creating Integration

Google API and Service account Creation

Standard integrations events & Data Fields are:

  • WordPress New user registration, User Profile Updates, User Login, User Logout ,Delete User Profile to Google Sheets Integration events are:

    • User ID
    • User Name
    • User First Name
    • User Last Name
    • User Nickname
    • User Display Name
    • Event Name
    • User Description
    • User Email
    • User Last Login
    • User Registration Date
    • User Role
  • WordPress New post, update post & New page to Google Spreadsheet Integration events are:

    • Post ID
    • Post Author ID
    • Post Author User name
    • Post Author Display Name
    • Post Author Email
    • Post Title
    • Post Date
    • Post Date GMT
    • Post Content
    • Post Excerpt
    • Post Status
    • Event Name
    • Comment Status
    • Ping Status
    • Post Password
    • Post Name
    • To Ping
    • Pinged
    • Post Modified
    • Post Modified GMT
    • Post Parent
    • Guid
    • Menu Order
    • Post Type
    • Post Mime Type
    • Comment Count
    • Filter
  • WordPress Comment to Google Spreadsheet Integration events are:

    • Comment ID
    • Comment Date
    • Comment Author
    • Comment Author Email
    • Comment Author Url
    • Comment Content
    • Comment Type
    • Comment User ID
    • Comment Author IP
    • Comment Agent
    • Comment Date
    • Comment Date GMT
    • Filtered
    • Comment Approved

3rd Party plugin integrations is NOT Free, supported plugin events are

  • WooCommerce New product to Google Spreadsheet Integration events are:

    • Product ID
    • Type
    • Name
    • Slug
    • Date created
    • Date modified
    • Status
    • Event name
    • Featured
    • Catalog visibility
    • Description
    • Short description
    • SKU
    • Menu order
    • Virtual
    • Permalink
    • Price (professional version)
    • Regular price (professional version)
    • Sale price (professional version)
    • Date on sale from (professional version)
    • Date on sale to (professional version)
    • Total sales (professional version)
    • Tax status (professional version)
    • Tax class (professional version)
    • Manage stock (professional version)
    • Stock quantity (professional version)
    • Stock status (professional version)
    • Back orders (professional version)
    • Sold individually (professional version)
    • Purchase note (professional version)
    • Shipping class id (professional version)
    • Weight (professional version)
    • Length (professional version)
    • Width (professional version)
    • Height (professional version)
    • Dimensions (professional version)
    • Attributes (professional version)
    • Default attributes (professional version)
    • Categories (professional version)
    • Category ids (professional version)
    • Tag ids (professional version)
    • Image id (professional version)
    • Image (professional version)
    • Gallery image ids (professional version)
  • WooCommerce New Order & Order Status Change to Google Spreadsheet Integration events are:

    • Order ID
    • Cart tax (professional version)
    • Currency (professional version)
    • Discount tax (professional version)
    • Discount total (professional version)
    • Fees (professional version)
    • Shipping tax (professional version)
    • Shipping total (professional version)
    • Subtotal (professional version)
    • Subtotal to display (professional version)
    • Tax totals (professional version)
    • Taxes (professional version)
    • Total (professional version)
    • Total discount (professional version)
    • Total tax (professional version)
    • Total refunded (professional version)
    • Total tax refunded (professional version)
    • Total shipping refunded (professional version)
    • Item count refunded (professional version)
    • Total qty refunded (professional version)
    • Remaining refund amount (professional version)

    • Items (professional version)

    • Item count (professional version)
    • Downloadable items (professional version)

    • Customer id (professional version)

    • User id (professional version)
    • User (professional version)
    • Customer ip address (professional version)
    • Customer user agent (professional version)
    • Created via (professional version)
    • Customer note (professional version)

    • Date created (professional version)

    • Date modified (professional version)
    • Date completed (professional version)
    • Date paid (professional version)

    • Billing first name

    • Billing last name
    • Billing company
    • Billing address 1
    • Billing address 2
    • Billing city
    • Billing state
    • Billing postcode
    • Billing country
    • Billing email
    • Billing phone

    • Shipping method

    • Shipping first name

    • Shipping last name
    • Shipping company
    • Shipping address 1
    • Shipping address 2
    • Shipping city
    • Shipping state
    • Shipping postcode
    • Shipping country
    • Address
    • Shipping address map url
    • Formatted billing full name
    • Formatted shipping full name
    • Formatted billing address
    • Formatted shipping address

    • Payment method (professional version)

    • Payment method title (professional version)
    • Transaction id (professional version)

    • Checkout payment url (professional version)

    • Checkout order received url (professional version)
    • Cancel order url (professional version)
    • Cancel order url raw (professional version)
    • Cancel endpoint (professional version)
    • View order url (professional version)
    • Edit order url (professional version)

    • Status

    • Event name
  • Contact form 7 form Submission to Google Spreadsheet

    • Text fields
    • Text Area fields (professional version)
    • Number (professional version)
    • tel (professional version)
  • ninja form Submission to Google Spreadsheet
    • Text fields
    • Text Area fields (professional version)
    • Number (professional version)
    • tel (professional version)
  • Formidable form Submission to Google Spreadsheet
    • Text fields
    • Text Area fields (professional version)
    • Number (professional version)
    • tel (professional version)
  • WPform Submission to Google Spreadsheet
    • Text fields
    • Text Area fields (professional version)
    • Number (professional version)
    • tel (professional version)
  • weForms Submission to Google Spreadsheet

    • Text fields
    • Text Area fields (professional version)
    • Number (professional version)
    • tel (professional version)
  • ACF- Advanced Custom Fields Advanced Custom Fields to Google Spreadsheet

    • All Custom Fields (professional version)
  • Upcoming integration are

    • Option Monster.
    • More From Plugins.

ਸਕਰੀਨਸ਼ਾਟ

  • Integration list.
  • Create new integration.
  • Settings page
  • Google Service Account Create new Api project
  • Google Service Account API list
  • Google Service Account Create Credentials

ਸਥਾਪਤੀਕਰਨ

This section describes how to install the plugin and get it working.

e.g.

  1. Upload wpgsi folder to the /wp-content/plugins/ directory
  2. Activate the plugin through the ‘Plugins’ menu in WordPress

ਅਕਸਰ ਪੁੱਛੇ ਜਾਂਦੇ ਸਵਾਲ

Where does it save logs and service account credentials?

It saves those data in the installed site database.

How to Get more help?

If you need more help, please open a help ticket for this plugin menu.

ਸਮੀਖਿਆਵਾਂ

Read all 2 reviews

ਯੋਗਦਾਨੀ ਤੇ ਵਿਕਾਸਕਾਰ

“Spreadsheet Integration – Connect Google Sheets With WordPress, WooCommerce & Most Popular Form Plugins.” is open source software. The following people have contributed to this plugin.

ਯੋਗਦਾਨੀ

ਤਬਦੀਲੀ-ਚਿੱਠਾ

v3.2.0 (31 Oct, 2020)

  • ACF fix
  • WooCommerce fix
  • ACF Fields Added to Login and Logout

v3.1.0 (21 Oct, 2020)

  • CF7 Bug fix
  • CF7 New Regex

v3.0.0 (4 Aug, 2020)

  • User Bug fix
  • More readable code
  • Google First Sheet Bug fix
  • Banner & Icon Change
  • Contact form 7 bug fix

v2.0.0 (6 July, 2020)

  • weForm added
  • ACF bug fix

v1.0.0-beta.1 (21 May, 2020)

  • Initial Release version.