{"id":414512,"date":"2024-11-30T08:00:00","date_gmt":"2024-11-30T08:00:00","guid":{"rendered":"https:\/\/www.weixiaoduo.com\/plugins\/sheet-wise\/"},"modified":"2025-01-08T01:13:00","modified_gmt":"2025-01-08T01:13:00","slug":"sheet-wise","status":"publish","type":"post","link":"https:\/\/www.weixiaoduo.com\/plugins\/sheet-wise\/","title":{"rendered":"Sheet Wise"},"content":{"rendered":"<p><strong>Sheet Wise<\/strong> 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.<\/p>\n<p><strong>Supported Hooks:<\/strong><br \/>\n\u2013 <strong>user_register<\/strong>: Syncs data when a new user registers.<br \/>\n\u2013 <strong>wp_update_user<\/strong>: Syncs data when a user profile is updated.<br \/>\n\u2013 <strong>delete_user<\/strong>: Syncs data when a user is deleted.<br \/>\n\u2013 <strong>wp_login<\/strong>: Syncs data when a user logs in.<br \/>\n\u2013 <strong>wp_logout<\/strong>: Syncs data when a user logs out.<br \/>\n\u2013 <strong>save_post<\/strong>: Syncs data when a new post is created.<br \/>\n\u2013 <strong>edit_post<\/strong>: Syncs data when a post is edited.<br \/>\n\u2013 <strong>wp_trash_post<\/strong>: Syncs data when a post is deleted (trashed).<br \/>\n\u2013 <strong>wp_insert_comment<\/strong>: Syncs data when a new comment is added.<br \/>\n\u2013 <strong>edit_comment<\/strong>: Syncs data when a comment edited.<\/p>\n<p><strong>Key Features:<\/strong><br \/>\n\u2013 Sync WordPress data with Google Sheets.<br \/>\n\u2013 Support for different WordPress hooks for customizable data transfer.<br \/>\n\u2013 Easy integration with Google API.<br \/>\n\u2013 Automate data flow and management.<br \/>\n\u2013 User-friendly interface for managing sync settings.<\/p>\n<h3>How to create a Google Cloud Service Account<\/h3>\n<p><iframe loading=\"lazy\" title=\"How to create a Google Cloud Service Account to use w Google Sheets API\" width=\"750\" height=\"422\" src=\"https:\/\/www.youtube.com\/embed\/fxGeppjO0Mg?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h3>How to create new integration<\/h3>\n<p><iframe loading=\"lazy\" title=\"SheetWise - New integration\" width=\"750\" height=\"563\" src=\"https:\/\/www.youtube.com\/embed\/JA3ZUBUQ8CE?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h3>Step-by-Step Guide to Setting Up Sheet Wise<\/h3>\n<p><strong>Step 1: Configure Google Service Account Credentials<\/strong><br \/>\n1. Navigate to the WordPress Dashboard > Sheet Wise > Settings.<br \/>\n2. Paste the Service Account Credential JSON into the text box provided.<br \/>\n3. Click the Save button to store the credentials.<br \/>\n4. If you\u2019re unsure how to obtain the JSON credentials, click the <code>How to?<\/code> link for detailed instructions.<\/p>\n<p><strong>Step 2: Add a New Integration<\/strong><br \/>\n1. Go to the WordPress Dashboard > Sheet Wise and click Add New Integration.<br \/>\n2. Fill out the following fields:<br \/>\n    \u2013 Integration Title: Enter a title for the integration (e.g., \u201cNew User\u201d).<br \/>\n    \u2013 Data Source: Select when the data should sync to your Google Sheet. Available options include triggers like:<br \/>\n        Create, Update, Delete user, Login, Logout, Create, Edit, Trash post, Add, Edit comment.<br \/>\n3. Spreadsheet & Worksheet: Choose the target Google Spreadsheet and Worksheet where the data should be saved.<\/p>\n<p><strong>Step 3: Map Data Fields to Google Sheet Columns<\/strong><br \/>\nIn the Spreadsheet Column Title section, the column names will be automatically retrieved from the spreadsheet you selected.<br \/>\nFor each column:<br \/>\n1. 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.<br \/>\n2. Repeat this mapping process for all required fields to ensure the data syncs accurately.<\/p>\n<p><strong>Step 4: Save the Integration<\/strong><br \/>\nOnce all fields are mapped and configured, click the Save button at the bottom of the page.<br \/>\nThe integration is now active, and data will sync automatically based on the selected triggers.<\/p>\n<h3><\/h3>\n<h3>Support<\/h3>\n<p>For any support requests, please visit our support page or reach out to us through the WordPress support forums.<\/p>\n<h3>Tags<\/h3>\n<p>Google Sheets, data sync, WordPress plugin, automation, Google API, data management<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sync WordPress data to Google Sheets seamlessly with Sheet Wise. Automate forms, posts, &#038; more using powerful hooks. Perfect for effortless workflows!<\/p>\n","protected":false},"author":65,"featured_media":414758,"comment_status":"open","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"slim_seo":{"title":"Sheet Wise - \u8587\u6653\u6735\u63d2\u4ef6\u76ee\u5f55","description":"Sync WordPress data to Google Sheets seamlessly with Sheet Wise. Automate forms, posts, & more using powerful hooks. Perfect for effortless workflows!"},"footnotes":""},"categories":[1],"tags":[1471,16565,26369,3218,2828],"class_list":["post-414512","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-automation","tag-data-sync","tag-google-api","tag-google-sheets","tag-hooks"],"_links":{"self":[{"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/posts\/414512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/users\/65"}],"replies":[{"embeddable":true,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/comments?post=414512"}],"version-history":[{"count":0,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/posts\/414512\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/media\/414758"}],"wp:attachment":[{"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/media?parent=414512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/categories?post=414512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.weixiaoduo.com\/plugins\/wp-json\/wp\/v2\/tags?post=414512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}