#
Managing Website Credentials
This guide explains how to set up and manage website credentials to connect Google Sheets with WordPress.
#
Adding a New Website Connection
- Click Extensions > SheetPoet - WordPress Connector > Manage Credentials
- Click Add New Credential
- Enter:
- Name: A friendly name for your site
- Server Root URL: Your WordPress site URL (e.g.,
https://example.com
) - Username: Your WordPress username
- Password: Your API key (generated in the WordPress plugin)
- Click Save
#
Connecting with API Key
- Open the SheetPoet sidebar: Extensions > SheetPoet - WordPress Connector > Operations
- Select the operation you want to use (Import, Update, or Trigger)
- A sidebar with the operation settings will appear
- Select the WordPress site you want to connect to
- The API key is automatically used for authentication
#
Managing Saved Credentials
The Credentials Manager displays all your saved website connections with:
- Name of the website
- URL of the WordPress site
#
Editing a Credential
- Find the credential you want to edit
- Click the Edit button (pencil icon)
- Update the information
- Click Save
#
Deleting a Credential
- Find the credential you want to delete
- Click the Delete button (trash icon)
- Confirm the deletion
#
Security Considerations
- Website credentials (URL, name) are stored in your Google account
- API keys should be kept secure and not shared
- All communication is encrypted using HTTPS
- You can revoke API keys anytime from the WordPress plugin
#
Troubleshooting Connection Issues
#
Cannot Connect to WordPress
- Verify your site URL is correct (include https://)
- Check that your API key is correct
- Ensure your WordPress site is accessible
- Temporarily disable maintenance mode if active
#
Functions Not Loading
- Verify you've created functions in the WordPress plugin
- Check that you're connected to the correct site
- Try reconnecting to refresh the function list
For more help, see our Troubleshooting Guide.