Getting started
This documentation will guide you through the setup, structure, and usage of each sheet, ensuring you can effectively leverage the tool’s capabilities. Each sheet serves a specific purpose, and understanding their structure and function is key to maximizing the tool’s potential.
Web Scraper Pro
This script provides a web scraping tool for Google Sheets, allowing users to extract emails, page content, image URLs, and video URLs from websites using the Diffbot API. It includes features for workspace setup, task management, logging, and dashboard statistics.
Features
- Email Extraction: Extracts email addresses from web pages using Diffbot’s API.
- Page Content Extraction: Extracts the main content of web pages, including text, author, and publication date.
- Image URL Extraction: Extracts URLs of images found on web pages.
- Video URL Extraction: Extracts URLs of videos embedded on web pages.
- Dashboard: A summary of scraping activities, including total scrapes, success rate, and recent activity.
- Logging: Logs all scraping activities, including timestamps, status, and any errors.
- Settings: Allows configuration of API keys, rate limits, and timeouts.
Setup Requirements
- Google Sheets: This tool is designed to run within Google Sheets.
- Diffbot API Key: You need a valid Diffbot API key to use the scraping functionalities. Enter this in the “API Settings” sheet.
- Permissions: The script requires permission to access Google Sheets and external URLs. Grant these permissions when prompted.
Sheet Structure
Scraper Tasks Sheet
- Column A (URL/Input): Enter the URLs you want to scrape.
- Column B (Scrape Template): Select the type of data to extract (e.g., “Email Addresses”, “Page Content”, “Image URLs”, “Video URLs”). Use the dropdown menu.
- Column C (Status): Displays the current status of the scraping task (e.g., “Processing”, “Complete”). This column is automatically updated by the script.
- Column D (Last Run): Displays the last time the scraping task was run. This column is automatically updated by the script.
Results Sheet
This results sheet provides a detailed log of the data extraction process, including input URLs, extracted content, metadata, statuses, timestamps, and any errors encountered during the process.
API Settings Sheet
- Column C (Value): Enter your Diffbot API key in the second row. Other settings are pre-filled with default values.
Dashboard Sheet
- Displays key statistics and recent activity. This sheet is automatically updated by the script.
System Logs Sheet
- Logs all script activities, including timestamps, status, and any errors.
Usage Instructions
- Enter API Key: Navigate to the “API Settings” sheet and enter your Diffbot API key in the “Value” column (C2).
- Add URLs: Go to the “Scraper Tasks” sheet and enter the URLs you want to scrape in Column A.
- Select Template: In the “Scraper Tasks” sheet, select the appropriate scrape template from the dropdown in Column B for each URL.
- Run Extraction: Go to the “🌐 Web Scraper Pro” menu and select the type of extraction you want to perform (e.g., “🔍 Extract Emails”, “🔍 Extract Page Content”).
- View Results: The extracted data will be added to the “Scraper Results” sheet.
- Monitor Progress: Check the “Scraper Tasks” sheet for the status of each URL and the “Dashboard” sheet for overall statistics.
- Review Logs: Check the “System Logs” sheet for any errors or issues.
- Resetting Progress: If you need to reset the extraction process, use the “Reset Email Extraction” option in the menu. This will clear the progress and allow you to start a new extraction.
How to Run the Tool
The tool is designed to be run directly from the Google Sheets menu. After setting up the workspace, you can initiate the scraping process by selecting the desired extraction type from the “🌐 Web Scraper Pro” menu. The script will then process the URLs in the “Scraper Tasks” sheet based on the selected template. The results will be added to the “Scraper Results” sheet, and the progress will be tracked in the “Scraper Tasks” sheet. The dashboard will also be updated with the latest statistics.
Woo Smart
Woo Smart is a Google sheets automation tool designed to streamline your WooCommerce product management directly from Google Sheets. This tool allows you to efficiently generate product descriptions, publish products, sync data, and more, all within a familiar spreadsheet environment.
Features
- Product Publishing: Easily publish products to your WooCommerce store directly from Google Sheets.
- Bulk Product Generation: Generate multiple products at once using predefined templates and AI.
- Product Synchronization: Sync product data from your WooCommerce store to Google Sheets.
- AI-Powered Description Generation: Automatically generate product descriptions using various AI models (OpenAI, Claude, Gemini, OpenRouter).
- Image Generation: Generate product images using AI models.
Setup Requirements
Before using Woo Smart, ensure you have the following:
- Google Account: A Google account with access to Google Sheets.
- WooCommerce Store: A working WooCommerce store.
- WooCommerce API Keys: Consumer Key and Consumer Secret from your WooCommerce REST API settings.
- AI API Keys (Optional): API keys for OpenAI, Claude, Gemini, or OpenRouter if you plan to use AI-powered features.
Configuration Steps:
- Run the Setup: In the Google Sheet, a new menu “🛍️ Woo Smart” will appear. Click on “🛠️ Tools” > “📊 Setup Workspace” to create the necessary sheets.
- Configure API Keys: Navigate to the “WooSettings” sheet and enter your WooCommerce API keys, and any AI API keys you plan to use.
Sheet Structure
Woo Smart uses several sheets to manage your WooCommerce data. Here’s a breakdown of each sheet:
WooDashboard
Provides an overview of your WooCommerce operations, including key statistics and recent activity.
WooProducts
This sheet is where you manage your product data.
WooSettings
This sheet contains all the settings for the tool, including:
- WooCommerce API Settings: Consumer Key, Consumer Secret, and Store URL.
- AI Settings: API keys for OpenAI, Claude, Gemini, and OpenRouter, along with model selection and temperature settings.
- Templates: Customizable templates for product descriptions, short descriptions, product types, tags, SEO titles, and meta descriptions.
WooHistory
Logs all actions performed by the tool, including timestamps, operations, statuses, and messages.
WooAnalytics
This sheet is reserved for future analytics features.
WooTemplates
This sheet is reserved for future template management features.
Usage Instructions
Follow these steps to use Woo Smart:
- Configure Settings:
- Navigate to the “WooSettings” sheet.
- Enter your WooCommerce API keys (Consumer Key and Consumer Secret) and store URL.
- If using AI features, enter your API keys for OpenAI, Claude, Gemini, or OpenRouter.
- Customize the templates for product descriptions, short descriptions, and other fields as needed.
- Add Products:
- Go to the “WooProducts” sheet.
- Fill in the product details in the respective columns.
- For new products, leave the “Product ID” column blank.
- Generate Descriptions (Optional):
- Go to “🛍️ Woo Smart” > “🤖 AI Tools” > “✨ Generate Description”.
- Confirm the number of products you want to generate descriptions for.
- The tool will use the AI provider and templates you configured in the settings to generate descriptions and update the “Short Description”, “Description”, and “Category” columns.
- Publish Products:
- Go to “🛍️ Woo Smart” > “🚀 Publish Products to Woocommerce”.
- The tool will publish all products in the “WooProducts” sheet to your WooCommerce store.
- Sync Products:
- Go to “🛍️ Woo Smart” > “📝 Product Management” > “🔄 Sync Products from WooCommerce”.
- The tool will sync all products from your WooCommerce store to the “WooProducts” sheet.
- Clear Products Sheet:
- Go to “🛍️ Woo Smart” > “🛠️ Tools” > “🗑️ Clear WooProducts Sheet”.
- This will clear all data from the “WooProducts” sheet.
How to Run the Tool
The tool is designed to be run directly from the Google Sheets menu. After setting up the script and the workspace, you will see a new menu item called “🛍️ Woo Smart”. This menu contains all the actions you can perform with the tool. To run any of the tool’s functions, simply click on the corresponding menu item. For example, to publish products, click on “🛍️ Woo Smart” > “🚀 Publish Products to Woocommerce”. The tool will then execute the selected action based on the data in your Google Sheet and the settings you have configured.
WhatsApp Bulk Messaging Turbo
This tool allows you to send personalized WhatsApp messages to multiple recipients directly from Google Sheets.
Features
- Bulk Messaging: Send WhatsApp messages to multiple phone numbers at once.
- Personalized Messages: Use message templates with dynamic variables to personalize each message.
- Scheduled Sending: Option to send messages only during specified time windows.
- Progress Tracking: Track which messages have been sent and save progress to avoid resending messages.
- Message Queuing: Implements a buffer time between message batches to avoid rate limits.
- Contact Management: Automatically updates a contact sheet with sent messages.
- Flexible Timers: Set custom delays between messages.
- Error Handling: Logs errors and provides user-friendly alerts.
Setup Requirements
Before using the WhatsApp Bulk Messaging Turbo tool, ensure you have the following:
- WhatsApp Business API: You need access to the WhatsApp Business API and a permanent token.
- Google Sheet: A Google Sheet with the following structure:
- Dashboard Sheet:
- Phone Number ID (B3): Your WhatsApp Business Account ID.
- Permanent Token (B4): Your WhatsApp Business API permanent token.
- Template Name (B5): The name of the WhatsApp template you will use.
- Schedule Option (B7): Set to “Yes” to enable scheduled sending, or “No” to send messages immediately.
- Timer Option (B8): Set the delay between messages (e.g., “2 Seconds”, “4 Seconds”, “8 Seconds”, “20 Seconds”).
- Buffer Time (B9): Set the buffer time between message batches (e.g., “1 Minute”, “2 Minutes”, “3 Minutes”, “5 Minutes”, “10 Minutes”).
- Message Templates Sheet:
- Column A: Phone numbers (without country code).
- Column B: Names of the recipients.
- Column C: Status of the message (will be updated by the script).
- Column D: Language code for the template (e.g., “en” for English).
- Columns E-J: Variables for the message template (Header, Variable 1, Variable 2, Variable 3, Variable 4, Variable 5).
- Contacts Sheet:
- This sheet will be automatically updated by the script with the phone numbers, names, status, and timestamps of sent messages.
- Dashboard Sheet:
Sheet Structure
Dashboard Sheet
The Dashboard sheet contains the main settings for the script:
- B3: WhatsApp Business Account ID.
- B4: WhatsApp Business API permanent token.
- B5: Name of the WhatsApp template.
- B7: Schedule option (“Yes” or “No”).
- B8: Timer option for message delays.
- B9: Buffer time between message batches.
Message Templates Sheet
The Message Templates sheet contains the phone numbers and message variables:
- Column A: Phone numbers (without country code).
- Column B: Names of the recipients.
- Column C: Status of the message (will be updated by the script).
- Column D: Language code for the template (e.g., “en” for English).
- Columns E-J: Variables for the message template (Header, Variable 1, Variable 2, Variable 3, Variable 4, Variable 5).
Contacts Sheet
The Contacts sheet is automatically updated by the script and contains:
- Column A: Phone numbers.
- Column B: Names of the recipients.
- Column C: Status of the message (“Message Sent”).
- Column D: Timestamp of when the message was sent.
Usage Instructions
- Set Up Dashboard: In the “Dashboard” sheet, enter your WhatsApp Business Account ID, permanent token, template name, schedule option, timer option, and buffer time.
- Prepare Message Templates: In the “Message Templates” sheet, enter the phone numbers (without country code) in Column A, names in Column B, language code in Column D, and the message variables in Columns E-J.
- Run the Script: Go back to your Google Sheet. A new menu item “⚡ WhatsApp Bulk Messaging” should appear. Click on “⚡ WhatsApp Bulk Messaging” > “🔔 Start Sending Messages” to start sending messages.
- Monitor Progress: The script will update the “Contacts” sheet with the status and timestamps of sent messages.
- Reset Progress: If you need to reset the script’s progress, go to “⚡ WhatsApp Bulk Messaging” > “🔧 Tools” > “🔄 Reset Progress”. This will clear the saved progress and allow you to resend messages.
- Clear Data: If you need to clear the message templates or contacts, use the options under “⚡ WhatsApp Bulk Messaging” > “🔧 Tools” to clear the respective sheets.
How to Run the Tool
To run the WhatsApp Bulk Messaging Turbo tool, follow these steps:
- Open your Google Sheet where the script is installed.
- Look for the custom menu named “⚡ WhatsApp Bulk Messaging” in the menu bar.
- Click on “⚡ WhatsApp Bulk Messaging” > “🔔 Start Sending Messages” to start sending messages.
- The script will then process the phone numbers in the “Message Templates” sheet and send messages according to your settings.
- You can monitor the progress in the “Contacts” sheet.
By following these instructions, you can effectively use the WhatsApp Bulk Messaging Turbo tool to send personalized messages to your contacts.
Social Media Pro
Social Media Pro is a Google sheets automation tool designed to streamline your social media content creation. It leverages AI to generate engaging content based on your specifications and marketing framework.
Features
- AI-Powered Content Generation: Automatically generate social media posts using OpenRouter AI based on specified topics, platforms, and post types.
- Bulk Post Generation: Generate multiple posts at once using a marketing framework, including personas, angles, and templates.
- Dynamic Post Type Validation: Automatically updates available post types based on the selected platform.
- Customizable Templates: Use predefined or custom templates for different platforms and post types.
- Settings Management: Configure API keys, AI model settings, and other preferences directly within the Google Sheet.
- Dashboard Overview: Track key metrics such as total posts, platforms used, and AI generations.
- Data Logging: Automatically save generated posts and track API usage.
Setup Requirements
Before using Social Media Pro, ensure you have the following:
- Google Account: You need a Google account to access Google Sheets.
- OpenRouter API Key: Obtain an API key from OpenRouter.ai. This key is required to use the AI content generation features.
- Google Sheets Permissions: The script requires permissions to access and modify your Google Sheet. You will be prompted to grant these permissions when you run the script for the first time.
- API Key Configuration: Enter your OpenRouter API key in the “API Settings” sheet under the “Value” column for the “OpenRouter API Key” setting.
- AI Model Selection: Choose your preferred AI model in the “API Settings” sheet under the “Value” column for the “AI Model” setting.
Sheet Structure
Social Media Pro uses several sheets within your Google Sheet. Here’s how each sheet should be structured:
Dashboard Sheet
The dashboard provides an overview of your social media activities. It includes:
- Main Header: “📱 Social Media Pro Dashboard”
- Stats Section: Displays total posts, platforms used, templates, AI generations, success rate, and API status.
- Platform Stats: Shows platform-wise post distribution.
- Recent Posts: Lists recent posts with time, platform, and status.
- API Usage: Displays API usage statistics.
Content Creation Sheet
This sheet is where you define the content you want to generate:
- Column A (Topic/Idea): Enter the topic or idea for your post.
- Column B (Platform): Select the social media platform from the dropdown (e.g., Facebook, Twitter, LinkedIn).
- Column C (Post Type): Select the post type from the dropdown (e.g., Text, Image, Link). The options will dynamically update based on the selected platform.
- Column D (Generated Content): This column will be populated with the generated content.
- Column E (Status): Displays the status of the post generation.
Post Templates Sheet
This sheet contains predefined and custom templates for different platforms and post types. It includes:
- Column A (Platform): The social media platform.
- Column B (Post Type): The type of post.
- Column C (Template): The template for the post.
- Column D (Post Type Category): The category of the post type.
- Column E (Template Variables): The variables used in the template.
API Settings Sheet
This sheet is used to configure the tool’s settings:
- Column A (Category): The category of the setting (e.g., API Keys, AI Settings).
- Column B (Setting): The specific setting (e.g., OpenRouter API Key, AI Model).
- Column C (Value): The value of the setting.
- Column D (Description): A description of the setting.
Usage Instructions
Follow these steps to use Social Media Pro:
- Configure API Settings:
- Navigate to the “API Settings” sheet.
- Enter your OpenRouter API key in the “Value” column for the “OpenRouter API Key” setting.
- Enter your preferred AI model in the “Value” column for the “AI Model” setting.
- Adjust other settings as needed.
- Create Content:
- Go to the “Content Creation” sheet.
- Enter your topic or idea in the “Topic/Idea” column.
- Select the platform and post type from the dropdowns.
- Generate Posts:
- Click on “📱 Social Media Pro” > “✨ Generate Posts” to generate content for all rows with a platform and post type but no content.
- View Generated Content:
- The generated content will appear in the “Generated Content” column of the “Content Creation” sheet.
- Clear Data:
- Click on “📱 Social Media Pro” > “🧹 Clear All Data” to clear all generated posts and logs.
- View Settings:
- Click on “📱 Social Media Pro” > “⚙️ View Settings” to quickly navigate to the settings sheet.
How to Run the Tool
The tool is designed to be run directly from the Google Sheets menu. After setting up the workspace, you can access the tool’s functionalities through the “📱 Social Media Pro” menu item in the Google Sheets menu bar. The menu provides options to setup the workspace, generate posts, clear data, and view settings. Simply select the desired action from the menu to execute the corresponding function.
Smart YouTube Scraper
This tool allows you to extract various types of data from YouTube using the YouTube Data API directly within Google Sheets.
Features
- Channel Information: Retrieve detailed information about a YouTube channel, including statistics, branding settings, and more.
- Channel Videos: Fetch a list of videos from a channel, with options to sort and filter by date, rating, and view count.
- Video Details: Extract comprehensive details about specific videos, such as view count, likes, comments, and duration.
- Video Comments: Retrieve comments from a video, with options to sort by time or relevance and choose the text format.
- Search Videos: Search for YouTube videos using advanced filters, including duration, quality, and date range.
- Playlists: List playlists from a channel, including details and privacy status.
- Playlist Items: Fetch videos within a playlist, including video details and position in the playlist.
- Video Captions: Retrieve caption tracks for videos in multiple languages.
- Channel Analytics: Gather channel analytics data, such as views, subscriber growth, and engagement metrics.
Setup Requirements
Before using the YouTube Scraper, you need to configure the following:
- Google Sheets: Ensure you have a Google Sheet where you will run the scraper.
- YouTube Data API Key:
- Go to the Google Cloud Console.
- Create a new project or select an existing one.
- Enable the YouTube Data API v3.
- Create credentials (API key).
- Copy the API key.
- Permissions: The script requires authorization to access Google Sheets and the YouTube Data API. Grant these permissions when prompted.
Sheet Structure
The Google Sheet should be structured as follows:
Scraper Tasks Sheet
This sheet is named YouTube Scraper Tasks
and contains the following columns:
- Column A: Input (URL/ID) – Enter the YouTube URL or ID (e.g., channel URL, video ID, playlist URL).
- Column B: Scrape Type – Select the type of data to scrape from the dropdown list (e.g., Channel Information, Video Details).
- Column C: Options – Enter JSON formatted options for the scrape type (e.g.,
{"maxResults": 50}
). Leave empty for default settings. - Column D: Status – Displays the current status of the scraping task (e.g., Pending, In Progress, Completed).
- Column E: Last Updated – Shows the timestamp of the last update for the task.
Results Sheet
This sheet is named YouTube Scraper Results
and will be automatically populated with the scraped data. The columns will vary depending on the scrape type.
Logs Sheet
This sheet is named System Logs
and will contain logs of the scraping process, including timestamps, status, and messages.
Settings Sheet
This sheet is named API Settings
and contains the API key and other settings.
Usage Instructions
Follow these steps to use the YouTube Scraper:
- Configure API Key:
- Click on “📺 YouTube Scraper” > “⚙️ Settings” > “🔑 Configure YouTube API”.
- Enter your YouTube Data API key in the prompt.
- Enter Scraping Tasks:
- Go to the
YouTube Scraper Tasks
sheet. - In Column A, enter the YouTube URLs or IDs you want to scrape.
- In Column B, select the appropriate scrape type from the dropdown.
- In Column C, enter any specific options in JSON format (or leave empty for default).
- Go to the
- Run Scraping Tasks:
- Click on “📺 YouTube Scraper” > “🎯 Run Selected Scraping Tasks”.
- The script will process the tasks and update the status in Column D.
- The results will be added to the
YouTube Scraper Results
sheet.
- View Results:
- Go to the
YouTube Scraper Results
sheet to view the scraped data.
- Go to the
- View Logs:
- Go to the
System Logs
sheet to view the logs of the scraping process.
- Go to the
How to Run the Tool
To run the tool, use the custom menu that appears in your Google Sheet after installing the script. The menu is named “📺 YouTube Scraper”.
To start the scraping process, click on “📺 YouTube Scraper” > “🎯 Run Selected Scraping Tasks”. This will initiate the scraping tasks based on the data you have entered in the YouTube Scraper Tasks
sheet.
The script will then process each row in the YouTube Scraper Tasks
sheet, update the status in the “Status” column, and add the results to the YouTube Scraper Results
sheet.
Smart Pages Generator – Programmatic Seo
This document provides a comprehensive guide to using the Smart Pages Generator, a Google sheets tool designed to automate the creation of WordPress pages from data within a Google Sheet.
Features
- Fetch Pixabay Images: Automatically fetch images from Pixabay based on keywords and insert them into your sheet.
- Copy Data and Create HTML Pages: Copy data from a designated sheet and generate HTML content based on a predefined template.
- Append Internal Links: Automatically append internal links to the generated HTML content.
- Draft HTML Pages to WordPress Site: Create draft pages on your WordPress site using the generated HTML content.
- Clear Options: Includes options to reset script data, delete triggers, clear sheet content, and clear the status column.
Setup Requirements
Before using the Smart Pages Generator, ensure the following requirements are met:
- Google Sheet: You need a Google Sheet with the necessary data and a “Programmatic SEO” sheet for the script to operate.
- WordPress Credentials: You need your WordPress site URL, username, and password.
- Permissions: The script requires permissions to access your Google Sheet and make external API calls to your WordPress site.
Sheet Structure
The Google Sheet should be structured as follows:
Data Set Sheet
This sheet contains the raw data that will be used to generate the HTML content. Each column represents a data point that can be inserted into the HTML template.
Programmatic SEO Sheet
This sheet is used for configuration and output.
Usage Instructions
Follow these steps to use the Smart Pages Generator:
- Configure Settings: In the “Programmatic SEO” sheet, enter your WordPress site URL, username, and password in cells B1, C1, and D1 respectively.
- Set HTML Template: In cell A4 of the “Programmatic SEO” sheet, enter your HTML template. Use placeholders like
{data point 1}
,{data point 2}
, etc., to indicate where data from the “Data Set” sheet should be inserted. - Add Data: Add your data to the “Data Set” sheet. Each column will correspond to a data point in your template.
- Fetch Pixabay Images (Optional): If you want to fetch images from Pixabay, select “🔍 Fetch Pixabay Images” from the menu.
- Copy Data and Create HTML Pages: Select “🔄 Copy Data and Create HTML Pages” from the menu. This will copy data from the “Data Set” sheet, generate HTML content based on your template, and insert it into column B of the “Programmatic SEO” sheet.
- Append Internal Links (Optional): Select “🔗 Append Internal Links to All Cells” to add internal links to the generated HTML content.
- Draft HTML Pages to WordPress Site: Select “🔗 Draft HTML Pages to WordPress Site” to create draft pages on your WordPress site.
- Clear Options: Use the “🧹 Clear Options” submenu to clear data, reset the script, or delete triggers.
How to Run the Tool
The tool is designed to be run directly from the Google Sheets menu. After installing the script, a new menu item called “💡 Smart Pages Generator” will appear in your Google Sheet. Each option in this menu corresponds to a specific function of the tool. Simply select the desired option from the menu to execute it.
Smart Index
Smart Index is a Google sheets automation tool designed to streamline the process of indexing URLs using the Google Indexing API. This tool allows you to manage and monitor your URL indexing directly from Google Sheets.
Features
- Automated URL Indexing: Submit URLs to the Google Indexing API directly from your Google Sheet.
- Batch Processing: Process URLs in batches to manage API rate limits effectively.
- Real-time Status Tracking: Monitor the indexing status of each URL with clear indicators (Success, Error, Pending).
- Detailed Reporting: Generate comprehensive reports on indexing performance, including success rates and error counts.
- Indexing History: Keep a record of all indexing jobs, including timestamps and results.
- Customizable Settings: Configure batch sizes, delays, and API credentials directly within the sheet.
- User-Friendly Interface: Easy-to-use menu options within Google Sheets for all operations.
Setup Requirements
Before using Smart Index, ensure you have the following:
- Google Cloud Project: A Google Cloud Project with the Google Indexing API enabled.
- Service Account Credentials: A service account key file (JSON) with the necessary permissions to use the Google Indexing API.
- Google Sheet: A Google Sheet with the required structure (explained below).
To configure the tool:
- Create a Google Cloud Project: If you don’t have one, create a new project in the Google Cloud Console.
- Enable the Google Indexing API: In your Google Cloud Project, enable the Google Indexing API.
- Create a Service Account: Create a service account in the IAM & Admin section of your Google Cloud Project.
- Grant Permissions: Grant the service account the “Service Account User” role.
- Generate a Private Key: Generate a private key (JSON file) for the service account.
- Copy Credentials: Open the Google Sheet where you will use the tool, and navigate to the “Settings” sheet. Copy the contents of the private key file into the “Private Key” field, and the service account’s client email into the “Client Email” field.
Sheet Structure
Smart Index requires the following sheets with specific column headers:
Dashboard Sheet
This sheet provides an overview of your indexing activities.
- Column A: Total URLs
- Column B: Indexed URLs
- Column C: Pending URLs
- Column D: Failed URLs
- Column E: API Status
URLs Sheet
This sheet contains the list of URLs to be indexed.
- Column A: URL (The URL to be indexed)
- Column B: Status (Indexing status: Success, Error, Pending)
- Column C: API Response (Response from the Google Indexing API)
- Column D: Last Updated (Timestamp of the last update)
Settings Sheet
This sheet contains the settings for the tool.
- Column A: Setting (e.g., Private Key, Client Email, Batch Size, Delay Between Batches)
- Column B: Value (The corresponding value for the setting)
History Sheet
This sheet records the history of indexing jobs.
- Column A: Date (Date and time of the indexing job)
- Column B: URLs Processed (Number of URLs processed in the job)
- Column C: Success Rate (Percentage of successfully indexed URLs)
- Column D: Errors (Number of errors encountered)
- Column E: Duration (Duration of the indexing job in seconds)
Batch Jobs Sheet
This sheet records the details of each batch job.
- Column A: Batch ID (Unique identifier for the batch)
- Column B: Start Time (Timestamp when the batch started)
- Column C: URLs (Number of URLs in the batch)
- Column D: Status (Status of the batch job)
- Column E: Completion Time (Timestamp when the batch completed)
Usage Instructions
Follow these steps to use Smart Index:
- Configure Settings: Navigate to the “Settings” sheet and enter your service account credentials (Private Key and Client Email). Also, configure the “Batch Size” and “Delay Between Batches” as needed.
- Add URLs: Go to the “URLs” sheet and add the URLs you want to index in Column A, starting from row 2.
- Run Indexing: Click on the “🔍 URL Indexing” menu and select “🚀 Index URLs”.
- Monitor Progress: Check the “Dashboard” sheet for real-time updates on the indexing status.
- View Reports: To generate a report, click on the “📈 Reports” menu and select “📊 Generate Report”.
- View History: To view the indexing history, click on the “📈 Reports” menu and select “📜 View History”.
How to Run the Tool
To run the tool, use the custom menu that appears in your Google Sheet. After installing the script, a new menu named “🔍 URL Indexing” will be available in the Google Sheets menu bar. This menu contains all the options to interact with the tool. Simply select the desired action from the menu to execute it.
Smart Spreadsheets Writer
Smart Spreadsheets Writer is a Google sheets automation tool designed to streamline content creation and publishing workflows directly from Google Sheets. This tool allows you to generate, manage, and publish content to various platforms, including WordPress, all within a familiar spreadsheet environment.
Features
- AI-Powered Content Generation: Generate high-quality content using various AI models, including OpenAI, Claude, Gemini, and Grok.
- Customizable Content Templates: Create and use custom content templates to structure your content effectively.
- WordPress Integration: Publish content directly to your WordPress site, including pages and posts, with support for featured images.
- Batch Processing: Process multiple content pieces in batches to manage API rate limits and workflow efficiently.
- Content Management: Manage your content creation process with clear status indicators and history tracking.
- Flexible Settings: Configure AI models, languages, and WordPress settings directly within the sheet.
- User-Friendly Interface: Easy-to-use menu options within Google Sheets for all operations.
- Google Docs Export: Export generated content to Google Docs for further editing and collaboration.
Setup Requirements
Before using Smart Spreadsheets Writer, ensure you have the following:
- API Keys: API keys for the AI models you intend to use (OpenAI, Claude, Gemini, Grok, OpenRouter).
- WordPress Site: A WordPress site with the REST API enabled.
- Google Sheet: A Google Sheet with the required structure (explained below).
To configure the tool:
- Obtain API Keys: Get API keys for the AI models you plan to use.
- Enable WordPress REST API: Ensure the WordPress REST API is enabled on your WordPress site.
- Install the Application Passwords Plugin: Install and activate the Application Passwords plugin on your WordPress site.
- Create an Application Password: Create an application password for the user you will use to publish content.
- Copy Credentials: Open the Google Sheet where you will use the tool, and navigate to the “Global Settings” sheet. Enter your API keys and WordPress credentials in the appropriate fields.
Sheet Structure
Smart Spreadsheets Writer requires the following sheets with specific column headers:
Dashboard Sheet
This sheet provides an overview of your content generation and publishing activities.
- Column A: Total Content Pieces
- Column B: Published Content
- Column C: Pending Content
- Column D: Errors
- Column E: AI Usage
- Column F: WordPress Usage
Content Generator Sheet
This sheet is where you define the content you want to generate. The columns in this sheet are dynamic and depend on the content types you define in the “Global Settings” sheet. However, the following columns are always present:
- Content Type: The type of content to generate (e.g., Blog Post, Article).
- Keywords: Keywords to guide the AI content generation.
- Content: The generated content (will be populated by the script).
- Title: The title of the content (will be populated by the script).
- Status: The status of the content (e.g., Draft, Published).
- Featured Image: URL of the featured image (optional).
- WordPress URL: URL of the published content on WordPress (will be populated by the script).
- Blog URL: The URL of the WordPress blog to publish to.
WordPress Config Sheet
This sheet contains the configuration for your WordPress sites.
- Column A: Blog URL (The URL of your WordPress site)
- Column B: Username (Your WordPress username)
- Column C: Application Password (Your WordPress application password)
Global Settings Sheet
This sheet contains global settings for the tool, including API keys, AI model configurations, and language settings. The sheet is divided into sections:
- AI Systems: Settings for enabling/disabling AI systems (OpenAI, Claude, Gemini, Grok, OpenRouter).
- AI System Models: Settings for selecting specific AI models for each system.
- Languages: Settings for selecting the default language for content generation.
- Content Templates: Settings for defining custom content templates.
- API Keys: Settings for entering API keys for various services.
History Sheet
This sheet records the history of content generation and publishing jobs.
- Column A: Date (Date and time of the job)
- Column B: Content Pieces (Number of content pieces processed)
- Column C: Success Rate (Percentage of successfully generated/published content)
- Column D: Errors (Number of errors encountered)
- Column E: Duration (Duration of the job in seconds)
Usage Instructions
Follow these steps to use Smart Spreadsheets Writer:
- Configure Global Settings: Navigate to the “Global Settings” sheet and enter your API keys, AI model preferences, and language settings.
- Configure WordPress Settings: Navigate to the “WordPress Config” sheet and add your WordPress site URLs, usernames, and application passwords.
- Add Content Details: Go to the “Content Generator” sheet and add the details for the content you want to generate, including content type, keywords, and any other relevant information.
- Generate Content: Click on the “✍️ Content Writer” menu and select “✨ Generate Content”.
- Export to Google Docs: To export the generated content to Google Docs, click on the “✍️ Content Writer” menu and select “📄 Export to Google Docs”.
- Publish to WordPress: To publish the generated content to WordPress, click on the “🚀 WordPress Publisher” menu and select “🚀 Publish Pages”.
- Monitor Progress: Check the “Dashboard” sheet for real-time updates on the content generation and publishing status.
- View History: To view the history of content generation and publishing jobs, click on the “📈 Reports” menu and select “📜 View History”.
How to Run the Tool
To run the tool, use the custom menu that appears in your Google Sheet. After installing the script, new menus named “✍️ Content Writer”, “🚀 WordPress Publisher”, and “📈 Reports” will be available in the Google Sheets menu bar. These menus contain all the options to interact with the tool. Simply select the desired action from the menu to execute it.
ShopifyExpress
Shopify Express is a Google Sheets automation tool designed to streamline your Shopify store management directly from Google Sheets. It allows you to generate product content, manage SEO metadata, and publish content to your Shopify store, all within a familiar spreadsheet environment.
Features
- AI-Powered Content Generation: Generate product descriptions, titles, and SEO metadata using OpenAI.
- Bulk Operations: Perform actions on multiple products or content items simultaneously.
- Shopify API Integration: Directly interact with your Shopify store to create, update, and publish products and content.
- SEO Management: Generate and manage SEO titles, descriptions, and tags for products and content.
- Content Management: Create and manage pages and blog posts directly from Google Sheets.
- Data Synchronization: Import existing products and content from Shopify to Google Sheets.
- Customizable Settings: Configure API keys, AI models, and other settings to tailor the tool to your needs.
Shopify API Credentials
You will need to configure your Shopify API credentials in the “Settings” sheet:
- Private App: Create a private app in your Shopify store to obtain the API key and password.
- API Key: Enter your Shopify API key in the “Value” column of the “Settings” sheet.
- API Password: Enter your Shopify API password in the “Value” column of the “Settings” sheet.
- Store URL: Enter your Shopify store URL (e.g.,
your-store.myshopify.com
) in the “Value” column of the “Settings” sheet.
OpenAI API Key
To use the AI-powered content generation features, you need an OpenAI API key:
- Obtain API Key: Get your OpenAI API key from the OpenAI platform.
- Enter API Key: Enter your OpenAI API key in the “Value” column of the “Settings” sheet.
Permissions
The script requires the following permissions:
- Authorization: Grant the script the necessary permissions to access Google Sheets and external APIs.
Sheet Structure
Products Sheet
The “Products” sheet is used to manage your Shopify products. It should contain the following columns:
- ID: Shopify Product ID (auto-generated when creating a new product).
- Title: Product title.
- Description: Product description.
- Vendor: Product vendor.
- Product Type: Product type.
- Tags: Product tags (comma-separated).
- Published: Whether the product is published (
true
orfalse
). - SEO Title: SEO title for the product.
- SEO Description: SEO description for the product.
- AI Prompt: Prompt for AI-generated content.
- Generation Status: Status of content generation (Pending, Processing, Completed, Error).
- …and other Shopify product fields.
Content Sheet
The “Content” sheet is used to manage your Shopify pages and blog posts.
Settings Sheet
The “Settings” sheet is used to configure the tool. It should contain the following columns:
- Category: Category of the setting (e.g., API Keys, AI Settings).
- Setting: Name of the setting (e.g., Shopify API Key, OpenAI API Key).
- Value: Value of the setting.
- Description: Description of the setting.
History Sheet
The “History” sheet is used to log all actions performed by the tool. It should contain the following columns:
- Timestamp: Date and time of the action.
- Operation: Type of operation performed (e.g., Generate Product, Publish Product).
- Status: Status of the operation (Success, Error).
- Details: Details of the operation.
Running the Tool
After installation, you can access the tool through the custom menu in Google Sheets:
- Access the Menu: You will see a new menu item called “Shopify Smart” in the menu bar.
- Select an Action: Click on the “Shopify Smart” menu to see the available actions.
- Choose an Action: Select the desired action from the menu (e.g., “Setup Workspace”, “Sync from Shopify”, “Generate Single Product”, “Publish to Shopify”).
- Follow Prompts: Follow any prompts or instructions that appear in the dialog boxes.
Usage Instructions
- Configure Settings: Enter your Shopify API credentials and OpenAI API key in the “Settings” sheet.
- Import Products: Use “Sync from Shopify” to import existing products into the “Products” sheet.
- Generate Content: Add prompts in the “AI Prompt” column of the “Products” or “Content” sheet and use “Generate Single Product” or “Generate Content” to generate content.
- Review Content: Review the generated content in the sheet.
- Publish Content: Use “Quick Publish” or “Publish to Shopify” to publish the content to your Shopify store.
- Manage SEO: Use “Generate SEO Metadata” to generate SEO titles and descriptions.
Additional Notes
- Review Content: Always review the generated content before publishing to ensure accuracy and quality.
- Error Handling: The script includes error handling and logging. Check the “History” sheet for any issues.
- Rate Limits: Be mindful of API rate limits. The script includes delays to avoid exceeding these limits.
Smart Affiliate Writer
Smart Affiliate Writer is a Google Sheets automation tool designed to streamline the creation of affiliate content directly within Google Sheets. It leverages AI to generate high-quality articles, product reviews, and comparison posts, complete with affiliate links and SEO optimization.
Features
- AI-Powered Content Generation: Generate articles, reviews, and comparison posts using OpenAI, Claude, or OpenRouter.
- Customizable Templates: Use predefined templates or create your own to control the structure and style of your content.
- Affiliate Link Integration: Automatically insert affiliate links into your content.
- SEO Optimization: Generate SEO-friendly content with proper heading structures and keyword usage.
- Bulk Content Generation: Generate multiple articles at once.
- Product Data Integration: Pull product information directly from your Google Sheet.
- HTML Formatting: Generate content in WordPress-compatible HTML format.
- Content Tracking: Track the status of content generation and view history.
Setup Requirements
AI API Credentials
You will need to configure at least one AI API key in the “Settings” sheet:
- OpenAI API Key: Enter your OpenAI API key in the “Value” column of the “Settings” sheet.
- Claude API Key: Enter your Claude API key in the “Value” column of the “Settings” sheet.
- OpenRouter API Key: Enter your OpenRouter API key in the “Value” column of the “Settings” sheet.
Permissions
The script requires the following permissions:
- Authorization: Grant the script the necessary permissions to access Google Sheets and external APIs.
Sheet Structure
Content Sheet
The “Content” sheet is used to manage your affiliate content. It should contain the following columns:
- Article Title: Title of the article.
- Content Type: Type of content (e.g., “Product Review”, “Comparison Post”). This should match a template name in the Templates sheet.
- Product IDs: Comma-separated list of product IDs from the Products sheet.
- Content: Generated content (will be populated by the script).
- Status: Status of content generation (Pending, Processing, Complete, Error).
- Last Updated: Date and time the content was last updated.
Products Sheet
The “Products” sheet is used to manage product data. It should contain the following columns:
- Product ID: Unique ID for the product.
- Original URL: Original URL of the product.
- Affiliate URL: Your affiliate link for the product.
- Product Name: Name of the product.
- Brand: Brand of the product.
- Current Price: Current price of the product.
- Average Rating: Average rating of the product.
- Number of Reviews: Number of reviews for the product.
- Key Features: Key features of the product.
- Target Audience: Target audience for the product.
- Recommendation Reason: Reason for recommending the product.
- Features List: List of features for the product.
- Use Cases: Use cases for the product.
- Pricing Details: Pricing details for the product.
- Product Images: URLs of product images (comma-separated).
- Category Name: Category name for the product.
- Category Overview: Overview of the category.
Templates Sheet
The “Templates” sheet is used to manage content templates. It should contain the following columns:
- Template Name: Name of the template (e.g., “Product Review”, “Comparison Post”). This should match the “Content Type” in the Content sheet.
- Description: Description of the template.
- Template Content: The template structure with placeholders for product data.
- Example Data: Example data for the template.
- Required Fields: Comma-separated list of required fields for the template.
Settings Sheet
The “Settings” sheet is used to configure the tool. It should contain the following columns:
- Setting: Name of the setting (e.g., OpenAI API Key, Claude API Key).
- Value: Value of the setting.
History Sheet
The “History” sheet is used to log all actions performed by the tool. It should contain the following columns:
- Timestamp: Date and time of the action.
- Operation: Type of operation performed (e.g., Generate Content).
- Status: Status of the operation (Success, Error).
- Details: Details of the operation.
- Word Count: Word count of the generated content.
Dashboard Sheet
The “Dashboard” sheet provides an overview of the tool’s usage. It should contain the following:
- Total Articles Generated: Total number of articles generated.
- Total Words Generated: Total number of words generated.
- Average Word Count: Average word count per article.
- Recent Activity: List of recent content generation activities.
Usage Instructions
Running the Tool
After installation, you can access the tool through the custom menu in Google Sheets:
- Access the Menu: You will see a new menu item called “Smart Affiliate Writer” in the menu bar.
- Select an Action: Click on the “Smart Affiliate Writer” menu to see the available actions.
- Choose “Generate Content”: Select the “Generate Content” option from the menu.
- Follow Prompts: The script will process all rows in the “Content” sheet where the status is “Pending” or empty.
Usage Instructions
- Configure Settings: Enter your AI API keys in the “Settings” sheet.
- Add Products: Add product data to the “Products” sheet.
- Add Templates: Add content templates to the “Templates” sheet.
- Add Content: Add article titles, content types, and product IDs to the “Content” sheet.
- Generate Content: Run “Generate Content” from the menu to generate content for all pending rows.
- Review Content: Review the generated content in the “Content” sheet.
- Track Progress: Monitor the status of content generation in the “Content” sheet and view history in the “History” sheet.
Imp: Once the content is generated, you can use smart spreadsheets writer to publish them on WordPress.
Additional Notes
- Review Content: Always review the generated content before publishing to ensure accuracy and quality.
- Error Handling: The script includes error handling and logging. Check the “History” sheet for any issues.
- Rate Limits: Be mindful of API rate limits. The script includes delays to avoid exceeding these limits.
- Template Placeholders: Use placeholders in your templates to dynamically insert product data.
- Affiliate Links: Ensure your affiliate links are correctly formatted in the “Products” sheet.
SERP Data Scraper
This tool automates the process of extracting search engine results page (SERP) data from Google using various providers.
Features
- Automated SERP Data Extraction: Scrapes search results from Google based on provided keywords.
- Multiple Provider Support: Integrates with ScrapingBee, Serper, and Apify for data retrieval.
- Customizable Settings: Allows users to configure parameters such as country code, language, number of results, and retry attempts.
- Batch Processing: Supports delays between batches to respect API rate limits.
- Data Logging: Records scraping history, including success rates and errors.
- User-Friendly Interface: Provides a simple menu within Google Sheets for easy access to all features.
Setup Requirements
Before using the SERP Data Scraper, ensure you have the following:
- Google Account: Access to Google Sheets.
- API Keys:
- ScrapingBee API Key: Required if using ScrapingBee as a provider.
- Serper API Key: Required if using Serper as a provider.
- Apify API Key: Required if using Apify as a provider.
- Google Sheets Setup:
- Create a new Google Sheet or use an existing one.
- The script will create the necessary sheets if they don’t exist.
Sheet Structure
The Google Sheet should contain the following sheets with the specified structure:
Dashboard Sheet
This sheet provides a summary of the scraping activity. It is automatically created and updated by the script.
Keywords Sheet
This sheet contains the keywords to be scraped. The structure is as follows:
- Column A: Keywords (one keyword per row, starting from row 2).
Results Sheet
This sheet stores the scraped data. The structure is as follows:
- Column A: Keyword
- Column B: Result Position
- Column C: Result URL
- Column D: Result Title
- Column E: Timestamp
- Column F: Status
Settings Sheet
This sheet contains the configuration settings for the scraper. The structure is as follows:
- Column A: Setting Name
- Column B: Setting Value
- Column C: Description
The following settings are available:
- ScrapingBee API Key: Your ScrapingBee API key.
- Serper API Key: Your Serper API key.
- Apify API Key: Your Apify API key.
- Country Code: The country code for the search (e.g., ‘US’, ‘GB’).
- Language: The language code for the search (e.g., ‘en’, ‘fr’).
- Search Type: The type of search (e.g., ‘web’, ‘image’, ‘news’).
- Device: The device type (e.g., ‘desktop’, ‘mobile’).
- Number of Results: The maximum number of results to scrape per keyword.
- Delay Between Batches (seconds): The delay in seconds between batches.
- Retry Attempts: The number of retry attempts on failure.
History Sheet
This sheet logs the history of scraping runs. The structure is as follows:
- Column A: Date
- Column B: Keywords Processed
- Column C: Success Rate
- Column D: Errors
- Column E: Duration (seconds)
Usage Instructions
Follow these steps to use the SERP Data Scraper:
- Enter API Keys: Go to the “Settings” sheet and enter your API keys for the providers you intend to use.
- Enter Keywords: Go to the “Keywords” sheet and enter the keywords you want to scrape, one per row starting from row 2.
- Configure Settings: Go to the “Settings” sheet and adjust the settings as needed.
- Start Scraping: Go to “🔍 SERP Scraper” and select the provider you want to use:
- “🚀 Start Scraping Using ScrapingBee”
- “🚀 Start Scraping Using Serper”
- “🚀 Start Scraping Using Apify”
- View Results: The scraped data will be added to the “Results” sheet.
- View History: The scraping history will be recorded in the “History” sheet.
Note: The script will automatically create the necessary sheets if they do not exist. Ensure you have the correct API keys and settings before running the scraper.
How to Run the Tool:
The tool is run directly from the Google Sheets interface. After setting up the script and refreshing the sheet, you will see a custom menu named “🔍 SERP Scraper”. This menu contains all the options to run the tool. To start a scrape, simply select the desired provider from the menu. The script will then process the keywords and populate the results sheet.
SEO Rank Tracker
SEO Rank Tracker allows users to track keyword rankings on Google, using various APIs (Apify, Serper, ScrapingBee).
Features
- Automated Keyword Rank Tracking: Monitors keyword positions in search engine results pages (SERPs).
- Multiple API Support: Integrates with various SEO APIs (Apify, Serper, ScrapingBee) for data retrieval.
- Historical Data Storage: Saves historical ranking data for trend analysis.
- Automated Reporting: Generates and sends SEO reports via email on a scheduled basis.
- Dashboard Overview: Provides a summary of key metrics, including total keywords tracked, average position, and ranking changes.
- Customizable Settings: Allows users to configure API keys, email settings, and report frequency.
- Mobile vs Desktop Tracking: Tracks keyword rankings on both mobile and desktop devices.
Setup Requirements
- API Keys: API keys for the SEO APIs you intend to use (Apify, Serper, ScrapingBee). These keys need to be entered in the “API Settings” sheet.
- Permissions: The script requires permissions to access Google Sheets, send emails, and use external APIs.
- Email Configuration: The email address to receive reports must be configured in the “API Settings” sheet.
Sheet Structure
The Google Sheet should contain the following sheets with the specified column headers:
Dashboard Sheet
This sheet provides a visual overview of your SEO tracking data. It includes key metrics and charts. No specific data entry is required on this sheet.
Keywords Sheet
- Keyword (Column A): The keyword you want to track.
- URL (Column B): The URL of the page you want to track for the keyword.
- Device (Column C): The device type to track (“Desktop” or “Mobile”).
- Notes (Column D): Any notes or comments about the keyword.
History Sheet
This sheet stores historical ranking data. The script automatically populates this sheet. It includes the following columns:
- Timestamp (Column A): The date and time of the ranking check.
- Keyword (Column B): The keyword being tracked.
- Position (Column C): The ranking position of the keyword.
- Change (Column D): The change in position compared to the previous check.
- Source API (Column E): The API used to retrieve the ranking data.
- URL (Column F): The URL of the page being tracked.
- Device (Column G): The device type (“Desktop” or “Mobile”).
- Notes (Column H): Any notes or comments about the keyword.
API Settings Sheet
This sheet is used to configure API keys and other settings. It includes the following columns:
- Category (Column A): The category of the setting (e.g., “API Keys”, “Email Settings”).
- Setting (Column B): The specific setting (e.g., “Apify API Key”, “Report Email”).
- Value (Column C): The value of the setting (e.g., your API key, email address).
- Description (Column D): A description of the setting.
Logs Sheet
This sheet stores system logs. The script automatically populates this sheet. It includes the following columns:
- Timestamp (Column A): The date and time of the log entry.
- Component (Column B): The component of the script that generated the log.
- Status (Column C): The status of the log entry (e.g., “Info”, “Error”).
- Message (Column D): The log message.
Usage Instructions
- Configure API Settings: Navigate to the “API Settings” sheet and enter your API keys for the services you want to use (Apify, Serper, ScrapingBee). Also, enter the email address where you want to receive reports.
- Add Keywords: Go to the “Keywords” sheet and add the keywords you want to track, along with their corresponding URLs and device types.
- Check Rankings: To manually check rankings, select “🎯 SEO Tracker” > “🔄 Check Rankings” from the Google Sheets menu.
- Send Instant Report: To send an immediate report, select “🎯 SEO Tracker” > “📈 Reports” > “📊 Send Instant Report”.
- Configure Automated Reports: To set up automated reports, select “🎯 SEO Tracker” > “📈 Reports” > “⚙️ Configure Reports”. This will prompt you to set the frequency of the reports.
- View Dashboard: Navigate to the “Dashboard” sheet to view a summary of your SEO tracking data.
- Review History: Check the “History” sheet for detailed historical ranking data.
- Monitor Logs: Review the “Logs” sheet for any system messages or errors.
How to Run the Tool
The tool can be run in the following ways:
- Manually: By using the custom menu items in Google Sheets under “🎯 SEO Tracker”. This includes options to check rankings, send instant reports, and configure automated reports.
- Automatically: By setting up a time-based trigger for automated reports. This is done through the “Configure Reports” menu option, which will prompt you to set the frequency of the reports.
Doc2WP Publisher
This tool automates the process of publishing content from Google Docs to WordPress, streamlining your workflow and saving you valuable time. It is designed to be used within Google Sheets, providing a user-friendly interface for managing your content.
Features
- Automated Publishing: Converts Google Docs content into WordPress posts or pages.
- Featured Images: Supports setting featured images from URLs or the first image in the document.
- Category Management: Automatically creates or uses existing categories in WordPress.
- Scheduled Publishing: Allows scheduling posts for future publication.
- Real-time Status Tracking: Provides a dashboard to monitor the status of each post.
- Image Handling: Uploads images from Google Docs to WordPress media library.
- Formatting Preservation: Retains text formatting, including headings, bold, italics, and links.
- Pixabay Integration: Fetches images from Pixabay based on keywords.
- Blog Management: Manages multiple WordPress sites with different credentials.
Setup Requirements
- Google Account: You need a Google account to use Google Sheets and Google Apps Script.
- WordPress Site: You need a self-hosted WordPress site with the REST API enabled.
- Application Password: Create an application password for your WordPress user.
- Pixabay API Key: Obtain a free API key from Pixabay if you want to use the image fetching feature.
Sheet Structure
The Google Sheet should be structured with the following columns:
- Column A: Google Doc URL – The URL of the Google Doc you want to publish.
- Column B: Blog – The base URL of your WordPress site (e.g.,
https://yourwebsite.com
). This should match the Blog URL in the “Blog Manager” sheet. - Column C: Category – The category you want to assign to the post. If the category doesn’t exist, it will be created.
- Column D: Publish – Choose “Draft” or “Immediately” to set the post status.
- Column E: Featured Image – Optional URL of the featured image. If left blank, the first image in the document will be used.
- Column F: Date – Optional date for scheduled publishing.
- Column G: WordPress Live URL – This column will be automatically populated with the URL of the published post or page.
Additionally, you need a “Blog Manager” sheet with the following columns:
- Column A: Blog URL – The base URL of your WordPress site.
- Column B: Username – Your WordPress username.
- Column C: Application Password – The application password for your WordPress user.
And a “Featured Images(Pixabay)” sheet with the following columns:
- Column A: Keyword – The keyword to search for images on Pixabay.
- Column B: Image Link – The URL of the image fetched from Pixabay. This column is automatically populated.
Usage Instructions
- Configure Blog Manager:
- Navigate to the “Blog Manager” sheet.
- Enter your WordPress site URLs, usernames, and application passwords in the respective columns.
- Prepare Your Content:
- In the “Dashboard” sheet, enter the Google Doc URLs in Column A, the corresponding Blog URL in Column B, and other details as needed.
- Fetch Images from Pixabay (Optional):
- Navigate to the “Featured Images(Pixabay)” sheet.
- Enter keywords in Column A to search for images.
- Go to “WordPress Tools” menu and select “📷 Fetch images from Pixabay”. The image links will be populated in Column B.
- Set Pixabay API Key (Optional):
- Go to “WordPress Tools” menu, then “⚙️ Settings”, and select “🖼️ Enter Pixabay API”.
- Enter your Pixabay API key when prompted.
- Publish to WordPress:
- Go to “WordPress Tools” menu and select “📑 Post to WordPress” to publish as posts or “📑 Post to WordPress(as Pages)” to publish as pages.
- The script will process each row, upload images, and create posts or pages in WordPress.
- The “WordPress Live URL” column will be updated with the link to the published content.
- Monitor Status:
- Track the status of your posts in the dashboard at the top of the “Dashboard” sheet.
- Resetting the Dashboard or Blog Manager:
- If you need to clear the content from the Dashboard or Blog Manager, go to “WordPress Tools” menu, then “🛠️ Tools”, and select “🗑️ Reset Dashboard” or “🗑️ Reset Blog Manager”.
How to Run the Tool
The tool is designed to be run directly from the Google Sheets interface. After setting up the spreadsheet and configuring the necessary settings, you can execute the main functions through the custom menu:
- WordPress Tools Menu: Once the script is installed, a custom menu named “🌿 WordPress Tools” will appear in your Google Sheets menu bar.
- Menu Options:
- Post to WordPress: Publishes Google Docs as WordPress posts.
- Post to WordPress(as Pages): Publishes Google Docs as WordPress pages.
- Fetch images from Pixabay: Fetches images from Pixabay based on keywords in the “Featured Images(Pixabay)” sheet.
- Settings:
- Test Connection: Tests the connection to your WordPress site.
- Enter Pixabay API: Allows you to enter your Pixabay API key.
- Tools:
- Setup Workspace: Sets up the necessary sheets and dashboard.
- Reset Dashboard: Clears the content from the “Dashboard” sheet.
- Reset Blog Manager: Clears the content from the “Blog Manager” sheet.
- Help:
- Quick Start Guide: Opens a quick start guide in a new tab.
- Documentation: Opens the documentation in a new tab.
- Troubleshooting: Opens the troubleshooting guide in a new tab.
- Report Issue: Opens a contact form to report an issue.
- Execution: To run the tool, simply select the desired option from the “🌿 WordPress Tools” menu. The script will then execute the corresponding function.
AI Keyword Clustering Tool
This tool is a Google sheet designed to automate keyword clustering directly within Google Sheets. It leverages the OpenAI API to group keywords based on semantic similarity and search intent, helping you organize your SEO efforts more effectively.
Features
- Automated Keyword Clustering: Uses the OpenAI API to intelligently group keywords.
- Customizable Settings: Allows you to set your OpenAI API key and choose the model.
- Clear Spreadsheet Integration: Organizes keywords, clusters, and settings within a single Google Sheet.
- Dashboard Overview: Provides a summary of total keywords, clusters, and API status.
- Easy to Use: Simple menu options and clear instructions for all users.
Setup Requirements
- Google Account: You need a Google account to use Google Sheets and Google Apps Script.
- OpenAI API Key: You must have an active OpenAI API key. You can obtain one from the OpenAI website.
Sheet Structure
Dashboard Sheet
The Dashboard sheet provides an overview of your keyword clustering process. It includes:
- Total Keywords: The total number of keywords you’ve entered.
- Total Clusters: The number of keyword clusters generated.
- Avg. Keywords/Cluster: The average number of keywords per cluster.
- Last Updated: The timestamp of the last clustering operation.
- API Status: Indicates whether the API key is configured.
Keywords Sheet
The Keywords sheet is where you input your keywords and their search volumes. It has two columns:
- Column A (Keywords): Enter your keywords here, one per row.
- Column B (Search Volume): Enter the monthly search volume for each keyword. This is optional but recommended.
Clusters Sheet
The Clusters sheet displays the results of the keyword clustering. It has three columns:
- Column A (Cluster Name): The name of the generated cluster.
- Column B (Keywords): A comma-separated list of keywords belonging to the cluster.
- Column C (Combined Search Volume): The total search volume for all keywords in the cluster.
Settings Sheet
The Settings sheet is where you configure the tool. It includes:
- OpenAI API Key: Enter your OpenAI API key here.
- OpenAI Model: Select the OpenAI model you want to use for clustering.
Usage Instructions
- Enter API Key: Go to the “Settings” sheet and enter your OpenAI API key in the “Value” column next to “OpenAI API Key”.
- Enter Keywords: Go to the “Keywords” sheet and enter your keywords in Column A and their search volumes in Column B (optional).
- Start Clustering: Click on “🎯 Keyword Clustering” > “🚀 Start Clustering” to begin the clustering process.
- View Results: Once the clustering is complete, go to the “Clusters” sheet to view the results.
- Dashboard: Check the “Dashboard” sheet for a summary of the clustering process.
How to Run the Tool
The tool is designed to be run directly from the Google Sheets interface. After installing the script and setting up the workspace, you can access the tool’s functions through the custom menu named “🎯 Keyword Clustering” that appears in the menu bar. This menu provides options to start the clustering process, update your API key, and manage the sheets. Simply select the desired action from the menu to execute the tool’s functions.
SmartSheetMailer
This Google Apps Sheets tool automates email sending and contact management directly within Google Sheets. It allows you to send personalized emails, schedule follow-ups, and track your interactions with leads.
Features
- Bulk Email Sending: Send personalized emails to multiple recipients based on data in your Google Sheet.
- Scheduled Emails: Schedule emails to be sent at a specific date and time.
- Follow-Up Management: Track and manage follow-up emails with different templates.
- Contact Management: Automatically record sent emails and their timestamps in a dedicated sheet.
- Template Variables: Use placeholders in email templates that are replaced with data from your sheet.
- Time-Based Delays: Add delays between sending emails to avoid hitting Google’s sending limits.
- Error Handling: Includes basic error handling and logging for troubleshooting.
Setup Requirements
- Google Account: You need a Google account to use Google Sheets.
- Google Sheet: A Google Sheet with the required structure (see “Sheet Structure” below).
- Permissions: The script requires permissions to send emails and access your Google Sheet data. You will be prompted to grant these permissions when you run the script for the first time.
Sheet Structure
Leads Sheet
This sheet contains your lead data. It should include the following columns:
- Email Column: A column containing the email addresses of your leads. The header of this column should match the value in cell B3 of the “Email Sender” sheet.
- Campaign Name Column: A column that identifies the campaign for each lead. The header of this column should match the value in cell B5 of the “Email Sender” sheet.
- Status Column: A column to track the status of each lead. This column will be automatically updated by the script.
- Additional Columns: Any other columns you need for your email templates (e.g., name, company, etc.). These columns will be referenced as {{Field1}}, {{Field2}}, etc. in your email templates.
Email Sender Sheet
This sheet contains the settings for sending emails. It should include the following:
- B3: The header of the email column in the “Leads” sheet.
- B4: The name of the email template to use (must match a template name in the “Templates” sheet).
- B5: The header of the campaign name column in the “Leads” sheet.
- B6: “Yes” or “No” to enable or disable scheduled emails.
- B7: The date and time to schedule the email (only if scheduled emails are enabled).
- B8: The delay between sending emails (e.g., “2 Seconds”, “8 Seconds”, “20 Seconds”, “1 Minute”, “5 Minutes”).
Templates Sheet
This sheet contains your email templates. It should include the following columns:
- Column A: Template names.
- Column B: Email subjects.
- Column C: Email bodies. Use placeholders like {{Field1}}, {{Field2}}, etc., to insert data from the “Leads” sheet.
Contact Management Sheet
This sheet will automatically record sent emails and their timestamps. The script will create this sheet if it doesn’t exist. It will copy the headers from the “Leads” sheet and add a “Status” column.
Usage Instructions
- Add Main Columns: Click “⚡ Smart Menu” > “🔗 Add Main Columns to Sheets” to add the “Status”, “Follow Up 1”, “Follow Up 2”, and “Follow Up 3” columns to your “Leads” sheet and copy the headers to the “Contact Management” sheet.
- Configure Sheets: Ensure your “Leads”, “Email Sender”, and “Templates” sheets are set up correctly as described in the “Sheet Structure” section.
- Send Emails: To send emails, click “⚡ Smart Menu” > “⚡ Send Bulk Emails” > “🔔 Send Initial Email”. The script will process each row in the “Leads” sheet and send emails based on your settings.
- Follow Up Emails: To send follow up emails, click “⚡ Smart Menu” > “⚡ Send Bulk Emails” > “🔔 Follow Up #1”, “🔔 Follow Up #2”, or “🔔 Follow Up #3”.
- Troubleshooting: If you encounter issues, use the “🔧 Troubleshoot” menu to delete all triggers. You can also find help in the “❓ Help” menu.
How to Run the Tool
The tool is run through the custom menu that is added to your Google Sheet. After you have installed the script, you will see a menu called “⚡ Smart Menu”. This menu contains all the options for running the tool. To run the tool, simply select the desired option from the menu. For example, to send the initial email, you would select “⚡ Smart Menu” > “⚡ Send Bulk Emails” > “🔔 Send Initial Email”.
Sheet2Wp WordPress Builder
Support Resources
Quick Start Guide, Documentation, and Troubleshooting are available through the “❓ Help” menu.