Google Integration Setup

Overview #

The Google Integration feature allows you to connect your WordPress site with Google services, enabling functionalities like Google Sheets data export and Google Drive file storage. This is a prerequisite for using any Google-related features in your workflows.

Initial Setup Process #

Step 1: Create Google Cloud Project #

  1. Go to Google Cloud Console
  2. Create a new project or select an existing one
  3. Enable the following APIs:
  • Google Sheets API
  • Google Drive API
  • Google OAuth 2.0

Step 2: Configure OAuth Consent Screen #

  1. Navigate to “OAuth consent screen”
  2. Choose “External” user type
  3. Fill in required application information:
  • App name
  • User support email
  • Developer contact information
  1. Add necessary scopes:
  • https://www.googleapis.com/auth/drive.readonly
  • https://www.googleapis.com/auth/spreadsheets.readonly

Step 3: Create OAuth Credentials #

  1. Go to “Credentials” section
  2. Click “Create Credentials” → “OAuth 2.0 Client ID”
  3. Select “Web application”
  4. Add authorized redirect URIs:
  • Copy the redirect URI from plugin settings
  • Add it to the authorized redirect URIs list

Plugin Configuration #

Step 1: Enter Google Credentials #

  1. Navigate to WordPress Admin → AI Workflow Automation → Settings
  2. Click on “Google Integration” section
  3. Follow the step by step setup guide.
Step 1: Create a Project
Step 2: Enable APIs
Step 3: Create your own credentials and use them to connect AI Workflow Automation to Google
  1. Enter the following:
  • Client ID (from Google Cloud Console)
  • Client Secret (from Google Cloud Console)
  • Redirect URI will be automatically generated

Step 2: Authenticate #

  1. Click “Sign in with Google” button
  2. Sign in to your Google account
  3. Review and accept permissions
  4. Wait for redirect back to WordPress
Step 4: Signing in with your own Google account to your own application
Integration Successful Screen. You can check your integration status here, and reset it if needed.

Features #

  • Secure OAuth 2.0 authentication
  • Automatic token refresh
  • Scope-based permissions
  • No need to store sensitive credentials
  • Easy reconnection process

Managing Integration #

Token Management #

  • Access tokens automatically refresh
  • Manual refresh available if needed
  • Clear visual indicators of connection status
  • Easy reset option for troubleshooting

Security Features #

  • Encrypted token storage
  • Secure communication channels
  • Regular authentication checks
  • Automated session management

Troubleshooting #

Common Issues #

  1. Connection Failures:
  • Verify credentials are entered correctly
  • Check redirect URI matches exactly
  • Confirm APIs are enabled
  • Verify OAuth consent screen configuration
  1. Permission Issues:
  • Review requested scopes
  • Check OAuth consent screen configuration
  • Verify user has necessary permissions
  • Confirm API restrictions
  1. Token Problems:
  • Try manual token refresh
  • Reset integration and reconnect
  • Check for expired credentials
  • Verify OAuth consent screen validity

Best Practices #

  1. Security:
  • Regular audit of connected applications
  • Monitor API usage
  • Review authorized access regularly
  • Keep credentials secure
  1. Maintenance:
  • Periodic connection testing
  • Regular verification of API quotas
  • Monitor token refresh status
  • Keep OAuth consent screen updated

Additional Information #

API Quotas #

  • Google Sheets API: 500 requests per 100 seconds per project
  • Google Drive API: 1,000 requests per 100 seconds per project
  • Daily quota limits apply

Support Resources #

Updates and Maintenance #

  • Regular updates to API integrations
  • Automatic handling of API changes
  • Backward compatibility support
  • Security patches and updates
What are your feelings
Updated on October 29, 2024