SEO and indexable content

anyone, anyone?

anyone, anyone?

Have you considered searching for previous postings on this very same forum where your question has been asked and answered before?

will the content of the spreadsheet be searchable and indexable for external search?

https://www.ads-software.com/support/topic/google-indexing-of-spreadsheet-seo/

can this be integrated with the wordpress built in search

https://www.ads-software.com/support/topic/include-table-in-search/

I did just that but wasn’t able to find what I was looking for. I can confirm google is indexing but wordpress native is not. There appears to be some search plugins that support doing shortcode expansion for indexing which is what I need but I haven’t found one that works with the other plugins I require. Guess I will keep hunting or evaluating search engine replacement for the site.

You could also consider writing your own solution; this plugin provides all the hooks you need to insert the data from the Google Sheet into your post natively.

PHP pseudocode might be something like:

/**
 * Inserts the Google Sheet data as received into the post in which the shortcode
 * is placed.
 */
function gdoc_table_html_save_to_database ( $html ) {
    $post = get_post(); // Get current post.
    // Set up array to modify post content.
    $new  = array(
        'ID' => $post->ID,
        // Append the HTML table with data from Google into an HTML comment at the
        // end of the existing post.
        'post_content' => $post->post_content . "<!-- $html -->"
    );
    wp_update_post( $new ); // Update the current post in the database.
    return $html; // Return the original HTML, unfiltered.
}

Do not use this as-is in your web site; this is just an example to show that you can modify the content of the post in which the shortcode was invoked with data produced by the shortcode itself, which means you can relatively easily create a situation where the data from the Google Sheet is available to the built-in WordPress search functions.

I would love to be able to do that, unfortunately it is a bit outside my skillset. I can understand a bit of the php code but I’m not familiar enough with the wordpress codebase itself to feel comfortable enough to take this on.