Sheet Wise

Sheet Wise is a powerful WordPress plugin that enables seamless data synchronization between WordPress and Google Sheets. By using various hooks, it allows users to automatically send data from WordPress forms, custom posts, and other data sources directly to Google Sheets.

Supported Hooks:
– user_register: Syncs data when a new user registers.
– wp_update_user: Syncs data when a user profile is updated.
– delete_user: Syncs data when a user is deleted.
– wp_login: Syncs data when a user logs in.
– wp_logout: Syncs data when a user logs out.
– save_post: Syncs data when a new post is created.
– edit_post: Syncs data when a post is edited.
– wp_trash_post: Syncs data when a post is deleted (trashed).
– wp_insert_comment: Syncs data when a new comment is added.
– edit_comment: Syncs data when a comment edited.

Key Features:
– Sync WordPress data with Google Sheets.
– Support for different WordPress hooks for customizable data transfer.
– Easy integration with Google API.
– Automate data flow and management.
– User-friendly interface for managing sync settings.

How to create a Google Cloud Service Account

How to create new integration

Step-by-Step Guide to Setting Up Sheet Wise

Step 1: Configure Google Service Account Credentials
1. Navigate to the WordPress Dashboard > Sheet Wise > Settings.
2. Paste the Service Account Credential JSON into the text box provided.
3. Click the Save button to store the credentials.
4. If you’re unsure how to obtain the JSON credentials, click the How to? link for detailed instructions.

Step 2: Add a New Integration
1. Go to the WordPress Dashboard > Sheet Wise and click Add New Integration.
2. Fill out the following fields:
– Integration Title: Enter a title for the integration (e.g., “New User”).
– Data Source: Select when the data should sync to your Google Sheet. Available options include triggers like:
Create, Update, Delete user, Login, Logout, Create, Edit, Trash post, Add, Edit comment.
3. Spreadsheet & Worksheet: Choose the target Google Spreadsheet and Worksheet where the data should be saved.

Step 3: Map Data Fields to Google Sheet Columns
In the Spreadsheet Column Title section, the column names will be automatically retrieved from the spreadsheet you selected.
For each column:
1. Event Code: Use pre-defined placeholders (e.g., [[first_name]], [[user_login]]) to represent WordPress data fields. These placeholders will be automatically populated based on the Data Source Event Name dropdown.
2. Repeat this mapping process for all required fields to ensure the data syncs accurately.

Step 4: Save the Integration
Once all fields are mapped and configured, click the Save button at the bottom of the page.
The integration is now active, and data will sync automatically based on the selected triggers.

Support

For any support requests, please visit our support page or reach out to us through the WordPress support forums.

Tags

Google Sheets, data sync, WordPress plugin, automation, Google API, data management

1. Upload the sheet-wise folder to the /wp-content/plugins/ directory, or install the plugin through the WordPress plugins screen directly.
2. Activate the plugin through the ‘Plugins’ screen in WordPress.
3. Go to the Sheet Wise settings page to configure your Google API and select the hooks for syncing data.

1. 

   Add new integration

2. 

   Settings for Sheet Wise

v1.1.0 (5 Jan, 2025)

• Enhance – Added WooCommerce integration

v1.0.1 (4 Dec, 2024)

• Enhance – How to page added for Google API setup

v1.0.0 (30 Nov, 2024)

• Initial release
• Sync data from WordPress to Google Sheets using various hooks
• User-friendly settings page for API setup and sync management