1. Introduction

This guide is designed to help you quickly diagnose and resolve common issues across the Smart Spreadsheets suite. Whether you’re facing connection errors, configuration issues, or unexpected tool behavior, you’ll find step-by-step solutions and best practices to get you back on track.

2. General Troubleshooting Guidelines

2.1. Preliminary Checks

  • Internet and Connectivity:
    Ensure you have a stable internet connection and that any firewalls or network settings aren’t blocking the tool’s API requests.
  • Browser & Compatibility:
    Use an up-to-date browser (Chrome, Firefox, or Edge) and clear your cache and cookies if you encounter unexpected behavior.
  • API Keys and Credentials:
    Many tools require API keys (for AI-powered features, YouTube, Shopify, etc.). Confirm that these are correctly entered and active.
  • Check for Platform Updates:
    Occasionally, updates from third-party platforms (e.g., OpenAI, Google, WhatsApp, Shopify, YouTube) can affect tool functionality. Keep an eye on service status pages and update your tool configurations accordingly.
  • Review Documentation & Changelogs:
    Regularly consult the official documentation and changelogs for each tool. These resources often contain additional troubleshooting advice and recent fixes.
  • Always Use updated Sheets
    Always ensure you’re working with the most updated sheet. Updated versions are available with your orders, and using them guarantees compatibility with the current automation scripts.
  • Preserve the Sheet Structure:
    Do not alter or change any headers or fields in the sheet. The automation code is designed to read data based on the specific structure, and any modifications may cause errors or unexpected behavior.

3. Tool-Specific Troubleshooting

For each tool in the suite, include sections that list typical error messages, their likely causes, and actionable solutions.

3.1. SmartSheetMailer

  • Common Error:
    “Authentication Failed” or “Emails are not being sent“
  • Possible Causes:
    • Authorization Scope: The script may lack the necessary permissions to send emails on behalf of other users.
    • Quotas and Limits: Exceeding Google’s API usage quotas can prevent the script from sending emails.
  • Solutions:
    • Verify Authorization Scopes: Ensure that the script has the appropriate authorization scopes to send emails on behalf of other users. This may involve updating the OAuth consent screen and reauthorizing the script.
    • Monitor API Quotas: Check your API usage to ensure you’re not exceeding Google’s limits. If necessary, request an increase in your quota.

3.2. Whatsapp Bulk Messaging Turbo

  • Common Error:
    “Connection Error” or “API Request Timed Out.”
  • Possible Causes:
    • Issues with the WhatsApp API integration
    • Incorrect formatting of recipient numbers
  • Solutions:
    • Ensure that your WhatsApp API credentials are current and correctly entered.
    • Double-check that phone numbers adhere to international formats.
    • If problems persist, consider reducing the messaging rate to avoid being blocked by the API provider.

3.3. Smart Pages Generator – Programmatic SEO Tool

  • Common Error:
    “Page Generation Failed” or “Invalid Data Format.”
  • Possible Causes:
    • Missing or malformed data in the Google Sheets input
    • Connection issues with your website or API errors
  • Solutions:
    • Confirm that all required data fields are properly filled in your spreadsheet.
    • Validate the data format (e.g., URLs, meta tags) before generating pages.
    • Reauthenticate your connection to your website if needed.

3.4. Doc2WP Publisher – Google Docs to WordPress

  • Common Error:
    “Publishing Error” or “Formatting Issue Detected.”
  • Possible Causes:
    • Mismatches in document formatting or unsupported elements
    • Incorrect WordPress credentials or plugin configuration
  • Solutions:
    • Check that your Google Doc is properly formatted according to the tool’s guidelines.
    • Verify your WordPress login credentials and ensure the required plugins are installed.
    • Use the provided troubleshooting tips in the documentation for formatting errors.

  • Error: “Document is inaccessible”
  • Possible Causes: The document is in Word format.
  • Solution: Go to the file in the document and click “Save as Google Docs” and then once converted, use the new link.
  • Ensure to always use native Google Docs links.

3.5. AI Keyword Clustering Tool

  • Common Error:
    “Clustering Failed” or “No Results Returned.”
  • Possible Causes:
    • Input keywords not meeting the expected format or missing data
    • Issues with the OpenAI API key or request limits
  • Solutions:
    • Reformat and verify your list of keywords to match the recommended guidelines.
    • Confirm that your OpenAI API key is valid and has sufficient usage quota.
    • Adjust clustering parameters if the tool offers configuration options.

3.6. Smart Index – Google Indexing Tool

  • Common Error:
    “Submission Failed” or “URL Format Error.”
  • Possible Causes:
    • URLs are not properly formatted or are inaccessible
    • Exceeded API limits or Google indexing delays
  • Solutions:
    • Ensure all URLs follow proper formatting and are publicly accessible.
    • Check your API quota and wait a few minutes if Google is experiencing delays.
    • Retry the submission and monitor the indexing status.

3.7. SERP Data Scraper

  • Common Error:
    “Data Extraction Error” or “Incomplete Data Returned.”
  • Possible Causes:
    • IP blocking due to high-frequency scraping
  • Solutions:
    • Slow down the request frequency to avoid IP bans.

3.8. Smart Youtube Scraper

  • Common Error:
    “Unable to Retrieve Video Data” or “YouTube API Error.”
  • Possible Causes:
    • Invalid or expired YouTube API key
    • Quota limits reached on the YouTube Data API
  • Solutions:
    • Confirm that your YouTube API key is correctly configured and active.
    • Monitor your API usage and ensure that you have not exceeded the daily quota.
    • Consider applying for increased limits if your usage is consistently high.

3.9. SEO Rank Tracker

  • Common Error:
    “Ranking Data Not Updating” or “Incorrect Domain/Keyword Input.”
  • Possible Causes:
    • Incorrect domain or keyword entry
    • Temporary Google algorithm changes affecting ranking data
  • Solutions:
    • Double-check that your domains and keywords are entered correctly in the spreadsheet.
    • Verify that your scheduling settings for data updates are properly configured.
    • Allow time for changes to propagate and check again later.

3.10. Smart SpreadSheets Writer & Smart Affiliate Writer & Social Post Pro

  • Common Errors:
    “Content Generation Error” or “Incomplete Output.”
  • Possible Causes:
    • Issues with the AI API key (e.g., OpenAI)
    • Misconfigured content templates or prompt formatting
  • Solutions:
    • Verify your AI API key and ensure it has not reached its usage limits.
    • Review the template settings in your spreadsheet and adjust prompt configurations as needed.
    • Refresh the tool if incomplete content is returned and check for any formatting warnings.

3.11. WooSmart & ShopifyExpress

  • Common Errors (WooSmart):
    “WooCommerce API Connection Failed” or “Data Sync Error.”
  • Possible Causes:
    • Invalid WooCommerce API credentials
    • Data mapping errors between Google Sheets and WooCommerce
  • Solutions:
    • Verify your WooCommerce API keys and update them if necessary.
    • Ensure that your spreadsheet columns correctly correspond to WooCommerce product fields.
  • Common Errors (ShopifyExpress):
    “Shopify API Error” or “Bulk Update Failure.”
  • Possible Causes:
    • Incorrect Shopify store URL or API credentials
    • Improper data format in your bulk upload file
  • Solutions:
    • Confirm that your Shopify API credentials and store URL are correct.
    • Validate your CSV or data input file against the required format.

3.12. Web Scraper Pro

  • Common Error:
    “Selector Error” or “No Data Found.”
  • Possible Causes:
    • The structure of the target website has changed
    • Request rate too high causing temporary blocks
  • Solutions:
    • Update your scraping selectors to match the current website layout.
    • Use proxy settings or slow the scraping rate to avoid triggering security measures.

3.13. Sheet2Wp WordPress Builder

  • Common Error:
    “Website Generation Failed” or “Formatting Issues on Publish.”
  • Possible Causes:
    • Incorrect WordPress credentials or insufficient permissions
    • Improperly structured Google Sheets data
  • Solutions:
    • Verify your WordPress login and API keys.
    • Check that your Google Sheets data is formatted as required (with proper headers and data types).
    • Ensure all necessary plugins and themes are active on your WordPress site.

4. Contact Support

  • Contact Support:
    If you’ve exhausted these steps and the issue persists, contact our support team. Provide detailed error messages, screenshots, and the steps you’ve already tried so that we can assist you efficiently.

We continuously update this guide as new issues are identified and resolved. If you encounter an error that isn’t listed here or have suggestions for additional troubleshooting tips, please contact our support team. Your feedback helps us improve our tools and provide a smoother experience for all users.