In this guide, we will show you how to install and configure the helper plugin for WP Sheet Editor – Google Sheets service.
WP Sheet Editor – Google Sheets Sync is a service provided by wpsheeteditor.com, that allows you to export, import, and synchronize content between WordPress and Google Sheets.
You can schedule automatic exports to Google Sheets. These automatic exports can run once or in recurring intervals (every X minutes, hours, days, weeks or months). You can also add real-time sync between WordPress and Google Sheets.
Besides, you can automatically import WordPress content from Google Sheets. These automatic imports can run once or in recurring intervals. You can also import data and then monitor changes on the Google Sheet to automatically import the changes into WordPress.
When you sign up for the Google Sheets Sync service, you’ll get a helper plugin that will allow you to securely connect your WordPress sites with the WP Sheet Editor API and Google API.
You need to follow these steps to install and set up both the Automations add-on and the WP Sheet Editor – Google Sheets helper plugin:
1- Install and set up the WP Sheet Editor – Automations add-on
The WP Sheet Editor – Google Sheets helper plugin needs the WP Sheet Editor – Automations add-on, you received this plugin when you signed up to the Google Sheets Sync service.
You can read the installation and setup guide for the Automations add-on by clicking here.
2- Install the “WP Sheet Editor – Google Sheets” helper plugin
Follow these steps to install the WP Sheet Editor – Google Sheets helper plugin on your WordPress website:
- On your wp-admin dashboard, go to Plugins > Add New > Upload plugin.
- Upload the wp-sheet-editor-google-sheets-premium.zip file that you received after your purchase.
- Once installed, click on Activate.
3- Activate your WP Sheet Editor – Google Sheets service license
You need to enter your license and click on Activate License.
You’ll see a welcome page, which means you’re ready to connect your WordPress site to the WP Sheet Editor API and the Google API.
4- Connect to your Google Sheets account and the WP Sheet Editor API
For this you need to open any WP Sheet Editor spreadsheet.
You’ll see the Google Sheets button on the top toolbar.
Once you click the Google Sheets button, click on Connect with Google and WP Sheet Editor API.
Here are some important things on how we care about your privacy:
- WP Sheet Editor needs access to your Google Sheets account. This is in order to export data from your WordPress site to Google Sheets and/or import data from Google Sheets to WordPress.
- Your privacy is very important for us. Therefore, our app only requests permission to read/edit files created by our app. We won’t have permission to access other files in your Google account.
- We do not store any spreadsheet content on our server. Your spreadsheet contents are saved only in your WordPress site and Google Sheets.
Select the account you want to connect to WP Sheet Editor.
Now tick the following checkbox: See, edit, create, and delete only the specific Google Drive files you use with this app and click on Continue.
After that, you’ll have successfully connected this WordPress website to your Google account and the WP Sheet Editor API.
Since you can connect multiple WordPress websites to WP Sheet Editor and Google Sheets, the popup will show you options to manage the status of all your websites and the current website:
- Disconnect all sites. This will remove the access of WP Sheet Editor to your Google Sheets account, and it will disconnect all your websites from WP Sheet Editor.
- Disconnect current site. This will disconnect this website from WP Sheet Editor. If this is the only website connected to WP Sheet Editor, the access to Google Sheets will be revoked too. If you have more websites connected to WP Sheet Editor, the other websites will still be connected to WP Sheet Editor and to Google Sheets.
Now that you have set up the Google Sheets service on your WordPress website, you’re ready to start exporting and importing content between WordPress and Google Sheets. Just click on the “export” or “import” options in the WP Sheet Editor toolbar.