Support » Plugin: Inline Google Spreadsheet Viewer » SEO and indexable content

  • Resolved jfrancais

    (@jfrancais)


    I have my data table showing and working pretty much how I want but one big question I have is can this be integrated with the wordpress built in search and will the content of the spreadsheet be searchable and indexable for external search? I have a bunch of content in their that I want to be found when someone is searching using the standard wordpress search and it is also important that my website is found via google/bing/etc for content within this spreadsheet.

    Thanks in advance,
    J

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • anyone, anyone?

    Plugin Author Meitar

    (@meitar)

    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://wordpress.org/support/topic/google-indexing-of-spreadsheet-seo/

    can this be integrated with the wordpress built in search

    https://wordpress.org/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.

    Plugin Author Meitar

    (@meitar)

    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.

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.